Acquire Clients
Monthly marketing spend divided by CAC produces new customers for the period.

This editable five-year model forecasts restoration-service revenue from acquired customer cohorts, billable hours, and hourly rates, with financial statements and scenario reporting.
Use the workbook to plan how customer acquisition, service mix, client retention, billable workload, pricing, staffing, costs, and funding choices flow through the business forecast.
Editable assumptions feed the operating calculations, which connect the revenue schedule with costs and the model’s financial statements, scenario views, and management reports.
The model converts marketing spend into new customers, retains tiered cohorts, calculates their billable hours, applies hourly rates, and totals revenue across tiers and months.
Monthly marketing spend divided by CAC produces new customers for the period.
New customers are allocated across service tiers and retained for each tier’s lifetime.
Starting customers plus all still-active customer cohorts determine active customers by tier.
Active customers multiplied by average monthly billable hours produce billable hours by tier.
Billable hours multiplied by hourly rates are summed across service tiers and months.
The Revenue worksheet organizes acquisition budgets, CAC, tier allocation, customer lifetimes, active customers, billable hours, and hourly pricing for the service forecast.
The COGS & OPEX worksheet separates direct restoration costs, variable operating expenses, and fixed overhead assumptions used throughout the financial forecast.
The Scenarios report compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
The Dashboard combines setup controls, scenario multipliers, key metrics, core financials, revenue mix, profitability, cash flow, and investment payback views.
The ready-made structure fits billable-hour restoration services using acquired client cohorts; materially different revenue logic or operating schedules may warrant 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 reporting structures.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the fully editable five-year financial model for Excel and Google Sheets as an instant download.
Edit business assumptions directly in the Excel or Google Sheets model.
Review projected operating and financial performance across the model’s five-year horizon.
Compare Low, Base, and High cases through the dedicated scenario reporting view.
Use the projected P&L, cash flow, balance sheet, and management reports.
The essential answers are visible in full, with no accordion clicks required.
Revenue is calculated from active customer cohorts, average monthly billable hours, and hourly rates by service tier. New customers come from marketing spend divided by CAC before allocation and retention.
You can change the launch date, starting customers, marketing budget and seasonality, CAC, tier allocation, customer lifetimes, billable hours, and hourly rates.
The Scenarios view compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over five years.
The product includes projected P&L, cash flow, and balance sheet outputs, plus dashboard, summary, scenario, and other management reporting views shown in the workbook gallery.
Yes. Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting.
It is an editable planning forecast based on the assumptions entered into the workbook, not a guarantee of business performance.
This downloadable financial plan for heritage rail operations includes everything you need to build a comprehensive financial strategy for your business.
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 cash flow gaps obvious before they turned into surprises, and I could spot shortfalls months ahead instead of guessing. It saved me hours of spreadsheet work each week.
I liked having a model that stayed tidy and easy to check, so one wrong cell didn’t send me down a rabbit hole. It cut my review time by about half before a meeting.
I used to waste time rebuilding low, base, and high cases by hand, but this layout made them quick to compare. I booked a planning call the same day because the assumptions were finally clear.