Laundromat Feasibility Model

Description
This model runs for a period of up to 10 years. It has all the relevant revenue and cost assumption configurations for specifically operating a laundromat. It runs off purchase cohorts of waching machines and dryers. The relevant inputs for each include cost per unit, maximum capacity per month (in hours), price charged per wash / dry use, average minutes per full use, and a seasonality matrix to define the percentage of maximum capacity for each month of the year and over the 10 year period.

To account for variable costs, which will be dependent mainly on utility costs and machine counts, you can define the average monthly cost for water, electric, and repairs / maintenance per machine type across 10 years.

Output Reports:
 - Monthly and Annual 3-Statement Model - Income Statement, Balance Sheet, Statement of Cash Flows are all dynamically connected to the assumptions.
 - Monthly and Annual ProForma detail - these tabs are a more granular view of the various soures of revenue, expenses, debt service capex, and other cash flow items that let the user dive into monthly operations and the unit economics.
 - DCF Analysis with IRR / NPV
 - Cap Table with options for inside and outside investors
 - Annual Executive Summary - Displays a high level view of all key financial line items
 - Lots of visualizations

In order to conduct a proper valuation, there is the option to show an exit value. It will drive off the trailing 12-month revenue from whatever exit month is chosen and a defined multiple.

This financial model accounts of depreciation of the machines and has a set of inputs for other capital asset purchases. Each machine type has 5 slots (5 washer types and 5 dryer types) all with their own configuration for costs, pricing, length of wash/dry period, and maximum capacity.

The debt schedule is relevant if you are getting an SBA loan and want to test out the feasibility of various  utilizations over time or if you want to account for a leveraged buyout of an existing laundromat and make sure the operations can cover all debt service.

Note, the template comes with each input blank, and you can use the video to follow along an enter your assumptions along with me so you understand how everything flows.

This template is also included in two bundles:
- All Models Bundle: https://www.eloquens.com/tool/P8Y4TX4v/finance/financial-forecasting-models/financial-models-120-useful-and-usable-logic
- Industry-Specific: https://www.eloquens.com/tool/lrNGt2jL/strategy/business-plans/business-sector-bundle-35-bottom-up-financial-models