Trusted by 25,000+ startup founders, investors and CPAs
Blank Page To Structure
Megan Foster, NY
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.
Hours Back On The Clock
Daniel Reed, IL
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.
Cleaner Numbers, Less Stress
Lauren Bennett, TX
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.
MODEL OVERVIEW
What Is the Financial Model of Waterside Economic Installation?
Waterside Economic Installation Financial Model is a five-year Excel and Google Sheets workbook that combines customer cohorts, hours paid, hourly rates, scenarios and financial statements.
Use your planning workbook, such as marketing customer acquisition, installation and service combination, retained customer cohorts, accountable workload, hourly prices, costs and staff translate into financial results.
Editable assumptions are the source of monthly calculations that are included in annual forecasts, comparisons of low/core/high scenarios, integrated financial statements and management reporting.
Built around the economy of servicesThe revenue engine follows the purchased customers through the allocation of installations and services, customer duration, paid hours, hourly rates and total revenue from the services.
CLIENT-COHORT INCOME ENGINE
How Does the Economizer Waterside Model Installation Calculate Revenue?
The model converts marketing spending into new customers, maintains life-long service level cohorts, calculates hours settled by the active client and uses hourly rates to obtain revenue.
01
Buy Clients
New customers are equally spending marketing expenditure divided into the costs of purchasing the customer.
02
Horizontal
Assign new customers at different service levels and maintain each cohort for the period specified.
03
Active Clients Track
The start-up customers and cohorts are still active in the monthly active customers at the level.
04
Build Pay Hours
We multiply active customers for average hours paid for active customers each month.
05
Calculate Income
Multiple hourly cost by hourly rate and then the sum of revenue per level and month.
FORM OF CORRECTIONRevenue = Hours Paid × Hourly Rate
01 / REVENUE
How to Set Income Drivers?
The revenue card combines the time of launch, marketing, CAC, allocation of installation and service level, customer duration, hours payable and hourly rates with the forecast of customer-hort revenue.
REVENUE
The revenue view shows a mix of purchases, installations and services, active customers, accountable hours and price inputs.
02 / COGS & OPEX
How to Structure Operational Costs?
The COGS & OPEX card separates direct costs, variable operating costs and fixed costs, so that the cost assumptions flow into the forecast.
COGS & OPEX
View COGS & OPEX separates direct, variable and fixed assumptions of operating costs.
03 / SCENARIOS
What Can You Compare in Scenarios?
The Scenarios compared the low, base and high cases in terms of revenue, gross margin, premium margin and EBITDA in the five-year forecast.
SCENARIOS
The scenarios show Low, Base and High Cases Charts for Large Financial Funds.
04 / DASHBOARD
What Does the Distribution Board Have in Common?
The table shows the results of scenarios, basic finances, revenue mix, profitability, cash flow and return information in one management view.
DASHBOARD
The data table consolidates scenario checks, financial results, revenue mix, cash flow and returns charts.
FIT OF PRODUCTS
Is Waterside Economics Financial Model Installing Suitable for You?
The ready model fits service companies using customer cohorts, billable hours and hourly prices; much different revenue logic may require a custom structure.
MODEL BY MADA READY
Good Example
Your income is driven by buyers, retained cohorts, billable hours and hourly rates.
You want to plan assembly or service level with different customer assignments, service life, hours and prices.
You need editable assumptions for marketing expenses, CAC, seasonality, customers starting and a basket of services.
You want five-year statements, low-Base/High scenarios, and reporting on the dashboard related to operational assumptions.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your income model is not based on customer cohorts, billing hours and hourly rates.
You require significant differences in economic services, contractual logic, transaction structures or settlement schedules.
You need operational schedules that differ significantly from the revenue and cost structure of the workbook.
You need reporting results or a calculation architecture tailored to requirements outside the ready model.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
Lab financial models can build or adjust a model when you need a different revenue logic, operating schedules or financial statements from a ready-made template.
You will receive an editable financial model for Waterside Economizer, which immediately downloads to Excel and Google Sheets with five-year forecasts, scenarios and financial reports.
01
Editable workbook
Update of assumptions on revenue, costs, staff, capital and finance as set out in the model.
02
Five-year forecast
The review forecasts over a five-year period with monthly and annual financial details.
03
Analysis of scenarios
Compare low, base and high cases with views from the scenario and related results.
04
Financial statements
Use profit and loss account, cash flow account, balance sheet, dashboard and related reporting views.
BEFORE BUYING IMPORTANT INFORMATION
Installation Waterside Economics Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate the revenue from the installation using economists?
It converts marketing expenses into new customers through CAC, allocates service level cohorts, tracks active customers, calculates hours paid and applies hourly rates.
02
What are the assumptions I can change?
You can edit the launch date, start of customers, marketing budget and seasonality, CAC, level allocation, customer life, hours payable and hourly rates.
03
What can I compare in Low, Base and High scenarios?
Alternative cases for revenues, gross margin, premium premium and EBITDA in the five-year forecast can be compared.
04
What financial results are taken into account?
The model includes a statement of revenue, a statement of cash flows, a balance sheet, a dashboard, a summary, graphs and additional analytical views.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. Financial Models Lab offers a custom financial modelling when revenue logic, operating schedules, or reporting needs require a different structure.
06
Is the workbook a forecast or a guarantee?
This is a forecast based on assumptions for editing, not guaranteeing the results of business activity or financial results.
What Does the Waterside Economizer Installation Financial Model Contain?
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.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
REVENUE
COGS & OPEX
SCENARIOS
DASHBOARD
