Acquire Customers
New customers equal marketing spend divided by customer acquisition cost.

It is an editable Excel and Google Sheets workbook that models recurring customer cohorts across a five-year forecast and produces financial statements and management reports.
Use the workbook to plan customer acquisition, service-tier mix, customer retention, recurring monthly fees, operating costs, staffing, capital spending, financing, and cash needs in one linked forecast.
Editable assumptions feed the monthly calculation engine, while scenario multipliers and linked reports show how changes in operating drivers flow through profitability, cash flow, financial position, and investment metrics.
The model converts marketing spend into new customers, allocates them across service tiers, retains active cohorts, applies monthly fees, and sums revenue across tiers.
New customers equal marketing spend divided by customer acquisition cost.
New customers are distributed across service tiers using editable allocation percentages.
Starting customers and unexpired acquisition cohorts determine active customers each month.
Each tier multiplies active customers by its monthly fee per customer.
The model sums monthly tier revenue to produce total revenue over time.
The Revenue Assumptions sheet links marketing budgets, acquisition cost, tier allocation, customer lifetimes, starting customers, and monthly fees to active-customer revenue.
The COGS & OPEX sheet organizes cost-of-goods assumptions, variable operating expenses, and fixed spending into time-based inputs linked to the forecast.
The Scenario Analysis view compares Low, Base, and High revenue, gross margin, contribution margin, and EBITDA trajectories across the five-year forecast.
The Dashboard combines model setup, scenario multipliers, headline financials, revenue mix, profitability, cash flow, payback, and key investment metrics in one view.
It fits businesses using recurring customer cohorts and monthly tier fees; structurally different revenue logic or reporting needs may call for custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your business requires different revenue logic, operating schedules, or financial and management reporting.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the fully editable Waterless Car Wash workbook for Excel and Google Sheets with a five-year forecast and linked financial reports.
Edit the workbook inputs in Excel or Google Sheets to reflect your plan.
Project revenue, costs, staffing, capital spending, financing, and cash across five years.
Compare Low, Base, and High cases through the workbook’s scenario analysis view.
Review linked income statement, cash flow, balance sheet, dashboard, summary, and analysis outputs.
The essential answers are visible in full, with no accordion clicks required.
It converts marketing spend and CAC into new customers, allocates them by tier, retains active cohorts, applies monthly fees, and sums tier revenue.
You can change the launch date, starting customers, annual marketing budget, monthly seasonality, CAC, tier allocation, customer lifetime or churn convention, and monthly fees.
The Scenario Analysis view compares Low, Base, and High trajectories for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The product gallery confirms an income statement, cash flow statement, balance sheet, dashboard, summary, break-even, ROIC, valuation, charts, KPIs, ratios, and other management reports.
Yes. Financial Models Lab offers custom financial modeling for businesses that need different revenue logic, operating schedules, or reporting structures.
It is a planning forecast based on editable assumptions, not a guarantee of business performance, profitability, funding, or returns.
You receive a comprehensive, easy-to-use Excel and Google Sheets template to create a complete financial model for a waterless car wash.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
I finally knew what investors expected to see, so I stopped guessing and built the model faster. It gave me a clean structure I could explain in one meeting.
My statements and charts were all over the place before, and this pulled them into one workbook. I saved about 6 hours and had something I could send without cleaning it up first.
The runway and shortfalls were hard to judge by hand, but this made the cash picture clear month by month. I caught a funding gap early and adjusted the plan before it became a problem.