
Car Wash, Retail |
Cash Flow Projections, Cash on Cash Yield, Cash-on-Cash Multiple, CFO, Excel, Financial Feasibility, Financial Projections, IRR (Internal Rate of Return), Pro-Forma |
Video Tutorial:
The goal here is to give the user all the placeholders and descriptions of costs, revenues, and on-going 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!