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

The editable five-year workbook models client acquisition, retained cohorts, billable hours, hourly rates, and linked financial statements for freelance design planning.
Use the model to translate marketing-driven client growth and service-level billable hours into revenue, costs, cash flow, and profitability over time.
Editable assumptions feed the monthly calculation engine, which rolls business activity into management reports and the income statement, cash flow statement, and balance sheet.
Marketing spend and CAC create client cohorts, retained active clients generate billable hours by tier, and hourly rates convert those hours into monthly revenue.
New customers equal marketing spend divided by customer acquisition cost.
New customers are allocated across the selected client or service tiers.
Starting customers and still-active cohorts remain according to each tier's lifetime.
Active customers multiply by average monthly billable hours for each tier.
Billable hours multiply by hourly rates, then revenue is summed across tiers.
The Revenue Assumptions view connects launch timing, marketing, CAC, service allocation, customer lifetime, billable hours, and hourly pricing to the client-cohort engine.
The COGS & Operational Expenses worksheet separates direct costs, variable expenses, and fixed operating categories so spending assumptions flow into margins and cash planning.
The Scenario Analysis view compares alternative revenue, gross margin, contribution margin, and EBITDA paths across the five-year forecast using the model's case multipliers.
The Dashboard combines scenario controls, financing inputs, working-capital assumptions, core financials, revenue mix, profitability, cash flow, and investment payback in one view.
The ready-made model fits billable-hour, client-cohort service businesses, while structurally different revenue logic or reporting requirements 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 from the ready-made workbook.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive an instantly downloadable, fully editable Excel financial model with five-year projections, scenario analysis, and linked financial reports.
Update the model's assumptions and business inputs directly in the Excel file.
Plan across a five-year forecast with monthly and annual financial detail.
Compare Low, Base, and High cases through the model's scenario view.
Review linked income statement, cash flow, balance sheet, and management outputs.
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 billable hours, and multiplies those hours by hourly rates.
You can edit launch date, starting customers, marketing budget and seasonality, CAC, tier allocation, customer lifetime, billable hours, and hourly rates.
You can compare alternative revenue, gross margin, contribution margin, and EBITDA paths across the five-year projection.
The workbook includes an income statement, cash flow statement, balance sheet, Dashboard, Summary, and additional financial analysis views.
Yes. Financial Models Lab offers custom financial modeling for different revenue logic, operating schedules, or reporting requirements.
It is a planning forecast based on editable assumptions, not a guarantee of future business performance.
This is the definitive budgeting tool for freelance creative professionals, containing everything you need for robust financial planning.
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 the break-even point easy to spot, so I stopped guessing at pricing. I cut my weekly margin review from hours to minutes.
I had statements and charts spread across too many files, and this pulled everything into one place. It saved me about 6 hours a month when I needed to update reports for a client call.
Running low, base, and high cases used to be a mess, but this model made the comparisons straightforward. I booked a planning meeting the same day because the assumptions were finally easy to explain.