A tunnel car was is the type of wash where cars drive up and select a wash type and then based on their chosen type they are hooked onto a track and pulled through the various stages of the tunnel and receive a nice cleaning.
There are many ways to go about developing startup cost, running cost, and revenue assumptions. I have researched some of the industry standard metrics and built a nice flow of back-end structures so that you can get a nice five year financial forecast of operations and returns.
The Assumption Tabs Include:
- Startup costs / financing %
- On-going costs (variable per car and fixed)
- Revenue (car count per month by year and % of each car falling into each pricing ticket)
- Include sale of business or not / 2 valuation techniques to choose (EBITDA multiple or % of annual sales)
You also get a nice set of charts to visualize running cash position of the business itself, revenue, expenses, profit, and other metrics such as margin %'s and car count per wash type by year.
The other use you can achieve with this car wash financial model is using it as a sort of budget / goal. This is the main reason why a monthly and annual P&L summary was included. The monthly allows you to better track what you actually end up doing per month and how close/off your assumptions were. Based on that you can start setting monthly goals / annual goals and track actual progress.
The best way to use this for budgeting is simply creating a copy of the template. You use one for actuals and one with your forecasts.