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

This editable Excel and Google Sheets workbook forecasts five years of client acquisition, billable hours, service revenue, expenses, cash flow, and financial statements.
Use it to plan how marketing spend converts into new clients, how active cohorts generate billable hours, and how service rates translate activity into revenue.
Editable launch timing, starting customers, seasonality, CAC, tier allocation, customer lifetime, billable hours, and hourly rates flow through the model’s monthly projections.
The model acquires customers through marketing spend and CAC, retains them in service cohorts, converts active customers into billable hours, and applies hourly rates.
New customers equal marketing spend divided by customer acquisition cost.
Split new customers across service tiers and retain each cohort for its stated lifetime.
Starting customers plus all unexpired customer cohorts determine active customers by tier.
Active customers multiplied by monthly billable hours per customer gives billable hours by tier.
Billable hours multiplied by hourly rates produce monthly revenue, summed across service tiers and months.
The Revenue worksheet connects marketing spend, CAC, client allocation, cohort lifetime, billable hours, and hourly rates to service revenue.
The COGS & OPEX worksheet separates direct service costs, variable expenses, and fixed operating expenses across the forecast.
The Scenarios worksheet compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA over five years.
The Dashboard combines model setup, scenario multipliers, core financials, cash flow, revenue mix, profitability, and payback views in one report.
It fits businesses using client acquisition, service tiers, customer lifetimes, billable hours, and hourly rates; materially different revenue logic may require 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 needs different revenue logic, operating schedules, or reporting structure.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the fully editable Excel and Google Sheets financial model as an instant download for five-year planning and reporting.
Change the model assumptions, operating inputs, costs, staffing, financing, and other editable fields.
Review a 60-month projection covering revenue, expenses, cash flow, and financial position.
Compare Low, Base, and High cases to see how alternative assumptions change forecast outcomes.
Use the income statement, cash flow, balance sheet, summary, dashboard, and supporting reports.
The essential answers are visible in full, with no accordion clicks required.
It calculates new customers from marketing spend and CAC, retains them by service-tier lifetime, converts active customers into billable hours, and applies hourly rates.
You can change launch date, starting customers, marketing budget and seasonality, CAC, tier allocation, customer lifetime, billable hours, and hourly rates.
The Scenarios view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
Outputs include the Dashboard, Summary, Income Statement, Cash Flow, Balance Sheet, Scenarios, Valuation, Break-Even, ROIC, Charts, KPIs, and supporting reports.
Yes. Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting.
It is a planning forecast based on the assumptions you enter, not a guarantee of business performance or financial results.
This Excel template for real estate tax analysis provides everything you need to build a comprehensive financial plan for your property tax consulting firm, from initial startup costs to a five-year exit strategy.
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 didn't have to stare at an empty sheet and guess where to begin. The template gave me a clean starting point, and I saved about 6 hours getting the first draft together.
I'm not an Excel power user, so this was a relief. The formulas were already set up in a way I could follow, and I got my forecast done without hiring a modeler.
Having low, base, and high cases laid out side by side made planning much easier. I cleaned up our assumptions in one afternoon and had a clear version ready for the meeting.