I had a customer request to add a whole bunch of financing toggles and configurations to the Laundromat financial model. These were really cool so I decided to produce a second advanced version that had these items included. In order to understand them, a strong finance background is going to be required. It is easy to use the Excel template, but it is hard to understand the concepts if you've never heard of them before. See more below.
Download the template here (advanced version near bottom).
Template Updates Overview:
- On/Off toggle for Sale Leaseback (all balance sheet logic updates accordingly)
- On/Off toggle for renting building or buying building, if renting, inputs for rent per square foot and escalations.
- On/Off toggle for bonus depreciation of equipment purchases.
- Added three separate loan types
- Mortgage (if purchasing)
- Construction Loan (option for PiK)
- Equipment Loan
- Each loan shows up on the balance sheet and cash flow statement separately.
- Added option for net loss carryforward option on the Income Statement, which will effect after-tax cash flow.
- Added a cash flow reconciliation to account for quarterly tax payments.
