$45.00 USD
Recent Updates: Rebuilt revenue assumptions and added add-on services, integrated financial statements (3-statement model), added a cap table, capex, and re-built the entire global assumptions tab.
Spreadsheet Tab Structure:
- Global Control - Define launch year, end month of forecast (up to five years), choose if you want to include an exit value and if so the trailing 12 month EBITDA multiple, any debt funding, and tax rates.
- Revenue Assumptions - Define initial starting customers per day, working days per year, and the percentage of customers that purchase dry cleaning services and addon services. Define the price charged for each service as well. Finally, define the annual growth rate per year. There is a daily capacity check to make sure your assumptions are reasonable based on the number of services being provided per day on average for each of the ten years in the forecasted period.
- Costs - Enter fixed ongoing costs per year and the average growth rate of these costs. The types of items included here would be things like rent, utilities, repairs and maintenance, advertising, and other operational expenses. The new logic added to this model is a defined variable cost per unit of service provided for the main dry cleaning service and for each addon service. This helps with an even scaling effect.
- CapEx - Here is where you can enter any capital asset purchases. This would commonly involve buying dry cleaning equipment, machines, and anything that is depreciable. If you are purchasing the building rather than renting, that would be entered here as well.
- Cap Table - This tab shows the user the minimum equity required to cover startup costs. The data entry portion is to put any investments by outside investors and/or the owner/operator. You will also define the percentage of shares given out. Often this will be 100% common shares, but you can adjust cells according to your plan. The IRR of each individual investment line item will be shown here.
- Startup Costs - Enter single costs that need to be accounted for to get the business open and running. These would be expense items that are not included elsewhere such as consulting fees, website creation, and any other items directly related to getting the business going prior to launch.
- Terminal Value - This will show a summary of how the exit value is calculated as well as how much is attributed to capital assets vs. extraordinary income. If taxes are not included in your forecast, then this tab can be set to 100% in the only yellow cell that exists on the tab.
- Debt Schedule - If you choose to finance some of the dry cleaning startup costs / liquid capital requirements, than the resulting amount borrowed will show up here as a loan. It is a full monthly schedule that will populate your annual debt service coverage obligations. Note that on the Pro Forma summary. If you choose 'Yes' to include the exit value, any remaining balance will get paid back and effect cash flow accordingly in the exit year.
- Annual Detail - This is the Pro Forma. All of the revenues and cost items will display here over the amount of years you are running the financial forecast for. This includes all items related to cash flow as well.
- Executive Summary - A high level look at the primary financial line items as well as the resulting IRR and returns of the project as a whole and investors / owners.
- Distributions - This is where you will find the annual cash flow and resulting DCF Analysis for the project and each owner / investor pool.
- IS- A; BS- A; CF- A - These are connected financial statements, also known as a 3 statement model. These items are more formalized and follow accounting logic. You will know them as the Income Statement, Balance Sheet, and Cash Flow Statement. These tabs all auto-update as the assumptions are adjusted.
Learn more about starting a dry cleaning business here.
Note that you will have to use this at your own risk of profit/loss and this is an Excel financial model meant to help give the user an idea of what kind of money they can make in the dry cleaning business if given their own written in assumptions.
More Industry-Specific Bottom-up Financial Models: