Acquire Customers
New customers equal marketing spend divided by customer acquisition cost.
This editable five-year workbook forecasts client-cohort billable-hours revenue from acquisition, retention, hours, and rates, with monthly and annual statements plus scenario analysis.
Plan an art provenance research service around customer acquisition, retained client cohorts, billable research hours, service-tier pricing, costs, staffing, and cash requirements.
Editable assumptions flow through the revenue schedule and operating model into the income statement, cash flow statement, balance sheet, and management views.
Marketing spend and CAC create new customers, tier allocation and lifetime determine active cohorts, then monthly billable hours and hourly rates calculate revenue.
New customers equal marketing spend divided by customer acquisition cost.
New customers are distributed across service tiers using the selected allocation.
Starting customers and unexpired cohorts determine active customers by tier.
Active customers multiply by average monthly billable hours for each tier.
Billable hours multiply by hourly rates, then revenue is summed across tiers and months.
The Revenue Assumptions view connects launch timing, marketing, CAC, customer allocation, cohort lifetime, billable hours, and hourly pricing to active-client revenue.
REVENUE ASSUMPTIONS
The COGS & OPEX worksheet separates revenue-linked research costs, variable operating expenses, and fixed spending for monthly forecast calculations.
COGS & OPEX
The Scenarios view compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
SCENARIOS
The Dashboard brings model setup, scenario controls, financial KPIs, revenue mix, profitability, cash flow, and investment payback into one management view.
DASHBOARD
The ready-made model fits client-cohort, billable-hours services; structural custom work is more appropriate when your revenue or operating logic differs materially.
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 financial and management reporting.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable Excel financial model for five-year monthly and annual forecasting, scenario analysis, and financial reporting.
Update client acquisition, tier allocation, lifetimes, billable hours, pricing, costs, staffing, and funding assumptions.
Review detailed monthly and annual projections across the model's five-year planning horizon.
Compare Low, Base, and High cases across revenue, margins, contribution, and EBITDA.
Use the income statement, cash flow statement, balance sheet, summary, dashboard, and supporting reports.
The essential answers are visible in full, with no accordion clicks required.
Revenue comes from active client cohorts multiplied by average monthly billable hours and hourly rates by tier. New clients originate from marketing spend divided by CAC and are retained for their stated lifetimes.
You can edit the launch date, starting customers, annual marketing budget, monthly seasonality, CAC, tier allocation, customer lifetime, billable hours, and hourly rates.
You can compare alternative five-year outcomes for revenue, gross margin, contribution margin, and EBITDA across Low, Base, and High cases.
The product shows an income statement, cash flow statement, balance sheet, Dashboard, Summary, Scenarios, Valuation, break-even, ROIC, Charts, KPIs, and other supporting reports.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structures.
It is a planning forecast based on the assumptions entered into the workbook, not a guarantee of business performance or financial results.
This art research business financial model includes everything you need to build a robust financial plan, from detailed revenue modeling and expense tracking to comprehensive valuation analysis.
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 profitability much easier to read, with break-even and margin assumptions laid out clearly instead of buried in formulas. I saved hours of guessing and could explain the numbers to our team in one meeting.
I used to spend half a day building projections by hand, but this got the model done fast. The pre-built tabs saved me about 8 hours and let me focus on the actual research plan.
I wasn’t sure what investors expected, but the structure made it simple to present the numbers the right way. We booked a meeting faster because the outputs were already organized for a pitch.