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

It is an editable five-year workbook that models recurring service customers, monthly fees, costs, scenarios, and linked financial statements.
Use the workbook to plan how customer acquisition, retention, service-tier mix, and monthly fees translate into revenue and financial performance over time.
Editable assumptions feed the model’s monthly calculations, scenario views, financial statements, and management reports so operating changes flow through the forecast.
The model acquires customers from marketing spend, allocates them by tier, retains cohorts, applies monthly fees, and totals recurring revenue.
New customers equal marketing spend divided by customer acquisition cost.
New customers are distributed across the selected service tiers.
Starting customers and unexpired cohorts determine active customers each month.
Active customers in each tier are multiplied by that tier’s monthly fee.
Tier revenue is summed across customers, tiers, and forecast months.
The Revenue Assumptions sheet connects marketing budgets, acquisition cost, tier allocation, customer lifetime, starting customers, and monthly fees to recurring revenue.
The COGS & OPEX sheet organizes direct parts costs, variable operating expenses, and fixed overhead across the forecast.
The Scenarios view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across five years.
The Dashboard combines model setup, scenario outputs, core financials, revenue mix, profitability, cash flow, and investment payback in one view.
The ready-made model fits recurring customer-fee operations; materially different revenue logic or reporting structures 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 revenue logic, operating schedules, or reporting requirements differ from the ready-made structure.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the fully editable financial model for immediate download and use in Excel or Google Sheets.
Change the model inputs to reflect your own service operation and assumptions.
Review monthly and annual projections across the five-year planning horizon.
Compare Low, Base, and High cases using the model’s scenario structure.
Use linked statements and management reports to review projected performance.
The essential answers are visible in full, with no accordion clicks required.
Revenue comes from active customers in each service tier multiplied by that tier’s monthly fee. New customers are acquired from marketing spend and CAC, allocated by tier, and retained through cohort lifetime or churn logic.
You can edit the launch date, starting customers, annual marketing budget, monthly seasonality, CAC, tier allocation, customer lifetime or churn convention, and monthly fee by tier.
The Scenarios view compares Low, Base, and High cases for revenue, gross margin, contribution margin, and EBITDA across the forecast.
The workbook includes Income Statement, Cash Flow, Balance Sheet, Dashboard, Summary, Break-Even, ROIC, Charts, KPIs, and Valuation views shown in the current model.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structures.
It is a planning forecast based on the assumptions entered into the workbook, not a guarantee of business performance.
This downloadable financial model for an equipment repair company includes a comprehensive suite of tools to help you create a complete business plan, secure funding, and manage your finances effectively.
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
This template showed me exactly what to include, so I stopped second-guessing the structure and got the model ready for my pitch in one afternoon. It made the whole investor conversation feel much clearer.
I’m not an advanced Excel user, and this file kept the formulas and tabs easy to follow. I saved about 6 hours because I didn’t have to rebuild anything from scratch.
The low, base, and high cases were already set up in a way that made sense, so I could compare them fast instead of juggling separate sheets. That cut my scenario work from a full day to about an hour.