Acquire Customers
Calculate new customers from marketing spend divided by customer acquisition cost.
This editable five-year workbook forecasts consulting revenue from active clients, billable hours, and hourly rates into monthly and annual financial outputs.
Use it to plan marketing, customer acquisition, service-tier activity, billable workload, pricing, operating costs, staffing, capital spending, financing, and cash needs.
Edit the core assumptions, and the workbook carries them through customer cohorts, revenue calculations, statements, scenario comparisons, and management reporting.
New customers come from marketing spend divided by CAC, remain active by cohort lifetime, generate billable hours, and produce revenue at each tier’s hourly rate.
Calculate new customers from marketing spend divided by customer acquisition cost.
Allocate new customers across service tiers and retain each cohort for its stated lifetime.
Add starting customers to every new-customer cohort that remains active.
Multiply active customers by average billable hours per customer each month.
Multiply billable hours by each tier’s hourly rate, then sum revenue across tiers and months.
The Revenue worksheet combines marketing spend, CAC, customer allocation, cohort lifetime, billable hours, hourly rates, and seasonality for the consulting forecast.
REVENUE
The COGS & OPEX worksheet organizes direct costs, variable expenses, and fixed operating expenses that feed the monthly consulting forecast.
COGS & OPEX
The Scenarios view compares alternative five-year paths for revenue, gross margin, contribution margin, and EBITDA under Low, Base, and High cases.
SCENARIOS
The Dashboard combines global setup, scenario multipliers, core financials, revenue mix, profitability, cash flow, and investment payback in one management view.
DASHBOARD
The ready-made model fits billable consulting businesses driven by client cohorts, hours, and rates; materially different revenue or operating logic may need customization.
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 business requirements.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you can instantly download an editable five-year financial model with monthly and annual projections, scenario analysis, linked statements, and management reporting.
Change marketing, CAC, client allocation, lifetimes, billable hours, hourly rates, costs, staffing, capital spending, and other inputs.
Plan five fiscal years with detailed monthly projections and annual financial views.
Compare Low, Base, and High cases through the dedicated Scenarios view.
Review Income Statement, Cash Flow, Balance Sheet, Summary, Dashboard, and other product reports.
The essential answers are visible in full, with no accordion clicks required.
New customers equal marketing spend divided by CAC, then remain active by cohort lifetime. Revenue equals active customers’ billable hours multiplied by each service tier’s hourly rate.
You can change launch date, starting customers, marketing budget, monthly seasonality, CAC, customer allocation, customer lifetime, billable hours, and hourly rates by tier.
The Scenarios view compares alternative five-year paths for revenue, gross margin, contribution margin, and EBITDA under Low, Base, and High cases.
The workbook includes the Income Statement, Cash Flow, Balance Sheet, Summary, Dashboard, Scenarios, Charts, KPIs, Break-Even, ROIC, Valuation, Ratios, DuPont, Top Revenue, Top Expenses, and Sources & Uses.
Yes. Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting.
It is a forecast built from editable assumptions, not a guarantee of business performance, profitability, funding, or returns.
You receive a comprehensive, easy-to-use financial model template designed specifically for a commercial site selection service, complete with detailed projections and a visual 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 didn’t know where to start, and this template gave me a clean structure fast. I built a first draft in under 2 hours instead of spending days staring at an empty spreadsheet.
My statements and charts were all over the place before this. Now everything sits in one file, and I could pull a clean update for our meeting without hunting through tabs.
I’m not strong with advanced Excel, so this saved me a lot of stress. The layout made it simple to fill in assumptions and get a usable model the same day.