Acquire Customers
New customers equal marketing spend divided by customer acquisition cost.
An editable five-year Excel workbook connects customer acquisition, client cohorts, billable hours, and hourly rates to integrated statements, scenarios, and management reports.
Plan a slate roof restoration service by connecting acquisition spending, client tiers, retained customer cohorts, billable workload, pricing, operating costs, staffing, and capital needs in one forecast.
Editable inputs flow through monthly calculations into revenue, expenses, cash flow, balance-sheet positions, scenario comparisons, and management reporting.
Marketing spend and CAC create new customers, cohorts remain active for their lifetimes, and active clients generate billable hours priced by service tier.
New customers equal marketing spend divided by customer acquisition cost.
New customers are allocated across service tiers and retained for each stated lifetime.
Starting customers and all still-active cohorts form the monthly active customer base.
Active customers multiply by average monthly billable hours for each service tier.
Billable hours multiply by hourly rates, then revenue is combined across tiers and months.
The Revenue worksheet connects marketing spend and CAC to client cohorts, active customers, billable hours, and hourly rates for each service tier.
REVENUE
The COGS & OPEX worksheet separates direct costs, variable expenses, and fixed operating expenses across the five-year forecast.
COGS & OPEX
The Scenarios view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across the forecast.
SCENARIOS
The Dashboard combines setup controls, scenario multipliers, key metrics, revenue mix, profitability, cash flow, and payback information in one management view.
DASHBOARD
The ready-made model fits client-cohort, billable-hour planning, while materially different revenue logic, operating schedules, or reporting 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 an editable Excel financial model with five-year monthly and annual projections, scenario analysis, and integrated financial reports.
Change revenue, cost, staffing, capital, and financing inputs to reflect your plan.
Review monthly and annual projections across the model’s five-year planning horizon.
Compare Low, Base, and High cases using the workbook’s scenario views.
Inspect the Income Statement, Cash Flow Statement, Balance Sheet, summary views, and dashboard.
The essential answers are visible in full, with no accordion clicks required.
Revenue comes from active clients by service tier, their monthly billable hours, and the matching hourly rates. New customers are created from marketing spend and CAC, allocated by tier, and retained by cohort lifetime.
You can change the launch date, starting customers, marketing budget and seasonality, CAC, tier allocation, customer lifetime, billable hours, and hourly rates.
You can compare how alternative cases change revenue, gross margin, contribution margin, and EBITDA over the forecast horizon.
The workbook includes the Income Statement, Cash Flow Statement, Balance Sheet, Dashboard, Scenarios, Summary, and additional analysis reports shown in the gallery.
Yes. Financial Models Lab offers custom modeling when you need different revenue logic, operating schedules, or reporting.
It is a planning forecast, not a guarantee of business performance. Results depend on the assumptions you enter.
This Excel financial model for slate roof repair business includes everything you need to build a comprehensive financial plan, from detailed revenue projections and cost breakdowns to automated financial statements and an investor-ready dashboard.
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 worrying about one broken formula throwing off the whole file. The checks made it easy to spot issues fast, so I spent less time tracing cells and more time reviewing the numbers.
The monthly cash flow view made runway and shortfalls much clearer. I could see where we’d need funding weeks sooner, which helped me plan a lender call without scrambling.
All the pricing, cost, and growth inputs were in one place instead of scattered across tabs. I cleaned up our assumptions in under an hour and had a model I could actually explain.