Note: Upgraded to include seasonality, executive summary, distributions, DCF analysis, visuals, and capacity utilization. Also added key performance indicator: Average Profit per Car and visualization therein.
The goal here is to give the user all the placeholders and descriptions of costs, revenues, and ongoing expenses that relate to the car wash industry (tunnel car wash specifically).
This model goes out for a full 5 years (60 months) and includes dynamic financing integration, cost per car metrics and explanations, startup cost categories, and a unique revenue assumption builder.
The revenue assumption first allows you to enter an expected monthly car count per year. You then build in pricing packages from 1-6 titled whatever you want) and assign a price to each. There will then be boxes to fill in the % of your total monthly car count that you expect to fall into each pricing level.
You will get a monthly P&L / cash flow / running cash position tab and an annual.
Charts and visuals have been built to highlight some of the key metrics.
Make a copy of the template and track your actuals against projections to see how you perform!