Acquire Customers
New customers equal marketing spend divided by customer acquisition cost for each modeled period.
The editable five-year Excel and Google Sheets workbook models customer acquisition, cohort retention, billable hours, hourly pricing, and linked financial statements, scenarios, and dashboard outputs.
Use the workbook to plan how marketing spend creates new customers, how long service cohorts remain active, and how billable hours and hourly rates shape revenue.
Editable launch timing, starting customers, marketing budgets, seasonality, CAC, tier allocation, customer lifetime, billable hours, hourly rates, costs, staffing, and capital assumptions feed the forecast.
The model converts marketing spend into customer cohorts, retains active customers by tier, calculates billable hours, and applies hourly rates to produce monthly revenue.
New customers equal marketing spend divided by customer acquisition cost for each modeled period.
Allocate new customers across service tiers and retain each cohort for its stated lifetime.
Add starting customers and all still-active customer cohorts to determine the active customer base.
Multiply active customers by average billable hours per active customer per month for each tier.
Multiply billable hours by hourly rates and sum revenue across tiers and months.
The Revenue worksheet links marketing budgets and CAC to customer cohorts, then sets tier allocation, customer lifetime, billable hours, and hourly rates.
REVENUE
The COGS & OPEX worksheet separates direct cost assumptions, variable expenses, and fixed operating costs so their monthly impact flows into profitability.
COGS & OPEX
The Scenarios view compares Low, Base, and High cases across five-year revenue, gross margin, contribution margin, and EBITDA trends.
SCENARIOS
The Dashboard combines model setup, scenario controls, headline financial outputs, revenue mix, profitability, cash flow, and investment payback in one view.
DASHBOARD
This ready-made model fits businesses using customer cohorts and billable-hour service revenue; structurally different revenue or reporting logic 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 you need different revenue logic, operating schedules, or reporting for your requirements.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the fully editable Excel and Google Sheets financial model as an instant download with five-year monthly and annual projections.
Edit launch timing, customers, marketing, CAC, allocation, lifetime, billable hours, hourly rates, costs, staffing, capital, and financing assumptions.
Review five-year monthly and annual projections for revenue, costs, profitability, cash flow, and financial position.
Compare Low, Base, and High cases across revenue, margins, EBITDA, and other linked outputs.
Review P&L, cash flow, balance sheet, Dashboard, Summary, and supporting management reports.
The essential answers are visible in full, with no accordion clicks required.
It derives new customers from marketing spend and CAC, retains service-tier cohorts, calculates active customers and billable hours, then applies hourly rates and sums monthly revenue.
You can change launch date, starting customers, marketing budget and seasonality, CAC, tier allocation, customer lifetime, billable hours per active customer, and hourly rates.
The Scenarios view compares five-year revenue, gross margin, contribution margin, and EBITDA across Low, Base, and High cases.
The workbook includes P&L, cash flow, balance sheet, Dashboard, Summary, Scenarios, Valuation, Break-Even, ROIC, Charts, KPIs, Ratios, Top Revenue, Top Expenses, Sources & Uses, and DuPont views.
Yes. Financial Models Lab can adapt revenue logic, operating schedules, and reporting when the ready-made structure does not match your requirements.
It is an editable forecast built from planning assumptions, not a guarantee of business performance or financial results.
Your purchase includes a downloadable financial plan for a radon reduction business, complete with a user-friendly dashboard, 5-year projections, and all essential financial statements.
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 stopped digging through scattered spreadsheets and charts, so everything for this project is finally in one place. It made monthly updates much easier to review and share.
Building the financials by hand was eating up too much time, and this template cut that down fast. I finished the first pass in a few hours instead of losing a full weekend.
I didn’t know which outputs investors would expect, but the layout made it obvious. That clarity helped me pull together a clean model for a meeting without second-guessing the structure.