Acquire Customers
New customers equal marketing spend divided by customer acquisition cost.
The Waterside Economizer Installation Financial Model is an editable five-year Excel and Google Sheets workbook connecting customer cohorts, billable hours, hourly rates, scenarios, and financial statements.
Use the workbook to plan how marketing-driven customer acquisition, installation and service mix, retained client cohorts, billable workload, hourly pricing, costs, and staffing translate into financial performance.
Editable assumptions feed monthly calculations that roll into annual projections, Low/Base/High scenario comparisons, integrated financial statements, and management reporting.
The model converts marketing spend into new customers, retains service-tier cohorts for their lifetimes, calculates active-customer billable hours, and applies hourly rates to produce revenue.
New customers equal marketing spend divided by customer acquisition cost.
Assign new customers across service tiers and retain each cohort for its stated lifetime.
Starting customers and still-active cohorts combine into monthly active customers by tier.
Multiply active customers by average billable hours per active customer each month.
Multiply billable hours by hourly rates, then sum revenue across tiers and months.
The Revenue sheet connects launch timing, marketing, CAC, installation and service-tier allocation, customer lifetime, billable hours, and hourly rates to the client-cohort revenue forecast.
REVENUE
The COGS & OPEX sheet separates direct costs, variable operating expenses, and fixed expenses so cost assumptions flow into the forecast.
COGS & OPEX
The Scenarios view compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
SCENARIOS
The Dashboard brings scenario outputs, core financials, revenue mix, profitability, cash flow, and payback information into one management view.
DASHBOARD
The ready-made model fits service businesses using customer cohorts, billable hours, and hourly pricing; materially different revenue logic may call for a custom structure.
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 reporting from the ready-made template.
ORDER A CUSTOM FINANCIAL MODELYou receive the editable Waterside Economizer Installation financial model as an instant download for Excel and Google Sheets with five-year projections, scenarios, and financial reports.
Update the business-specific revenue, cost, staffing, capital, and financial assumptions provided in the model.
Review projections across a five-year horizon with monthly and annual financial detail.
Compare Low, Base, and High cases through the workbook’s scenario views and linked outputs.
Use the income statement, cash flow statement, balance sheet, dashboard, and related reporting views.
The essential answers are visible in full, with no accordion clicks required.
It converts marketing spend into new customers through CAC, allocates service-tier cohorts, tracks active customers, calculates billable hours, and applies 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 cases for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The model includes an income statement, cash flow statement, balance sheet, Dashboard, Summary, charts, and additional analysis views.
Yes. Financial Models Lab offers custom financial modeling when your revenue logic, operating schedules, or reporting needs require a different structure.
It is a forecast based on editable assumptions, not a guarantee of business performance or financial results.
This HVAC contractor financial model for economizers provides everything you need to build a comprehensive financial plan, from initial startup costs to a five-year exit strategy.
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 have to start from a blank spreadsheet, which made the first step much easier. I had a working Waterside Economizer model in place in minutes, so I could focus on assumptions instead of layout.
Building the forecast by hand would have taken me days, and this template cut that to a single afternoon. It saved me about 12 hours and let me move on to pricing and funding prep.
One broken formula used to make me second-guess everything, but this model kept the logic organized. I was able to check the assumptions faster and send a cleaner version to my team the same day.