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

It is an editable five-year Excel and Google Sheets workbook that links client cohorts, billable hours, hourly rates, scenarios, and financial statements.
Use the workbook to translate acquisition spending, client mix, case duration, billable workload, and service pricing into a structured forecast for your firm.
Editable assumptions feed the revenue engine, operating costs, payroll, capital spending, scenarios, and the linked financial reports shown in the workbook.
The model acquires clients from marketing spend, retains cohorts by service tier, converts active clients into billable hours, and applies hourly rates.
New customers equal marketing spend divided by customer acquisition cost.
Allocate new customers by service tier and retain each cohort for its stated lifetime.
Active customers combine starting customers with every new cohort that remains active.
Billable hours equal active customers times average monthly billable hours per active customer.
Multiply billable hours by each tier’s hourly rate, then total revenue across tiers and months.
The Revenue Assumptions sheet connects marketing spend, CAC, service allocation, client lifetime, billable hours, and hourly rates to the cohort-based forecast.
The COGS & OPEX sheet separates direct case costs, variable operating expenses, and fixed overhead for monthly and annual expense planning.
The Scenario Analysis view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The Dashboard combines setup controls, scenario multipliers, headline KPIs, revenue mix, profitability, cash flow, and investment payback in one management view.
It fits firms planning revenue from active-client cohorts and billable hours; structurally different fee, case-timing, or reporting 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 you need different revenue logic, operating schedules, or reporting requirements.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive an editable Excel and Google Sheets financial model for five-year forecasting, scenario analysis, and linked financial reporting.
Update the model inputs to reflect your firm’s operating assumptions and planning case.
Review the five-year projection with monthly and annual schedules visible across the workbook.
Compare Low, Base, and High cases using the model’s scenario framework.
Use the linked income statement, cash flow statement, balance sheet, and management reports.
The essential answers are visible in full, with no accordion clicks required.
It converts marketing spend into new clients through CAC, retains client cohorts, calculates active-client billable hours, and applies service-specific hourly rates.
You can edit launch timing, starting customers, marketing budget and seasonality, CAC, tier allocation, customer lifetime, billable hours, and hourly rates.
You can compare Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
The workbook includes an income statement, cash flow statement, balance sheet, Dashboard, Summary, break-even, ROIC, charts, KPIs, and other linked reports.
Yes. Financial Models Lab offers custom financial modeling for different revenue logic, operating schedules, or reporting requirements.
It is a planning forecast driven by the assumptions entered into the workbook, not a guarantee of financial or business performance.
This pre-written financial model for personal injury lawyers provides everything you need to build a comprehensive financial plan, from initial startup costs to a five-year profit and loss forecast.
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 made runway planning much easier, so I could spot shortfalls before they turned into a problem and adjust timing on expenses. It saved me hours of guessing every month.
I used to have P&L, cash flow, and charts scattered across different files. Now everything is in one workbook, and I cut report prep by about 6 hours a week.
I wasn’t sure what investors wanted to see, but this model gave me the right structure and output. It helped me build a cleaner deck and book a meeting faster.