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

The Air Conditioning Company Financial Model is an editable five-year workbook linking customer acquisition, service tiers, billable hours, hourly rates, costs, scenarios, and monthly and annual financial statements.
Use it to plan how marketing spend and CAC create customers, how service mix and customer lifetime build active cohorts, and how billable hours and hourly rates shape revenue.
Editable operating assumptions flow through the COGS & OPEX schedule, financial statements, scenario analysis, dashboard, and management reports.
The model converts marketing spend into new customer cohorts, allocates them across service tiers, retains active cohorts by customer lifetime, and prices billable hours by tier.
New customers equal marketing spend divided by customer acquisition cost.
Allocate each new customer cohort across the defined client or service tiers.
Active customers equal starting customers plus every cohort still within its customer lifetime.
Billable hours equal active customers multiplied by average monthly billable hours for each tier.
Monthly tier revenue equals billable hours multiplied by hourly rate, then revenue is summed across tiers and months.
The Revenue worksheet organizes marketing budgets, CAC, customer allocation, customer lifetime, active cohorts, billable hours, hourly rates, and resulting revenue drivers.
The COGS & OPEX worksheet separates direct costs, variable operating expenses, and fixed expenses into editable schedules with timing and monthly projections.
The Scenarios view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The Dashboard combines global model controls, scenario settings, core financials, revenue mix, profitability, cash flow, and investment payback in one management view.
This ready-made model fits client-cohort service businesses using billable hours; custom modeling may suit materially different revenue logic, operating schedules, or reporting structures.
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 around your requirements.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the fully editable Air Conditioning Company model as an instant download for five-year planning in Excel or Google Sheets.
Open and change revenue, cost, staffing, capital, and other planning assumptions.
Review the model's monthly and annual projections across the five-year forecast horizon.
Compare Low, Base, and High cases using the model's scenario framework.
Review income statement, cash flow, balance sheet, summary, dashboard, charts, and other model reports.
The essential answers are visible in full, with no accordion clicks required.
Revenue begins with new customers from marketing spend divided by CAC, then allocates them by service tier and retains each cohort for its customer lifetime. Active customers generate billable hours, which are multiplied by hourly rates and summed across tiers and months.
You can edit launch date, starting customers, annual marketing budget, monthly seasonality, CAC, tier allocation, customer lifetime, billable hours per active customer, and hourly rates.
The Scenarios view compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA. It shows how alternative assumptions change the projected operating path.
The workbook includes income statement, cash flow, balance sheet, Summary, Dashboard, Scenarios, Charts, ROIC, Break-Even, Ratios, Valuation, and KPI views.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting.
It is a forecast built from editable assumptions, not a guarantee of business performance or financial results.
This pre-built financial model for an AC installation company includes everything you need to build a comprehensive financial plan, from revenue modeling to detailed expense forecasting.
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 our margins and break-even point easy to see, so I spent less time digging through formulas and more time planning pricing. It cut our weekly review by about 3 hours.
I used to waste hours comparing low, base, and high cases by hand. With this model, I had all three ready in under an hour, and it made our next lender call much easier.
Starting from scratch always slowed me down, but this model gave me a clean place to begin. I had a full first draft ready the same afternoon instead of losing a day to setup.