Car Wash Tunnel – 5 Year Financial Projection

Car Services, Car Wash, Financial Model, Retail, Service Businesses

5-year Financial Projections, Accounting, Break-Even, Business Valuation, Cap Table, Cash Flow Analysis, Cash Flow Projections, Cash on Cash Yield, Cash-on-Cash Multiple, CFO, Controlling, DCF Model, Debt Amortization, Debt Service Coverage, Discount Rate, Excel, Financial Analysis, Financial Feasibility, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financial Reporting, Financial Statements, Financing, Forecast, Forecasting, Income Statement, Investment Multiple, Investor Cash Flows, Investors, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), NPV (Net Present Value), Pre Money Valuation, Pricing, Private Equity, Pro-Forma, Profitability Analysis, Return on Investment (ROI), Revenue Projections, Scenario Analysis, Sensitivity Analysis, Startup Financial Models, Terminal Value, Three Statement Model | Three Financial Statements, Valuation, Venture Capital

Video Tutorial:

Note: Latest upgrades include full 3-statement integration (Income Statement, Balance Sheet, Cash Flow Statement), cap table, CAPEX with depreciation, improved global assumption controls, formatting conventions, and seasonality/capacity logic. Additionally, dynamic terminal value / end-month configuration. Recently updated to include an option for memberships.

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!

This model template comes in .xlsx file type, which can be opened using MS Excel.

Latest Update: