HVAC Services Rollup Model
Operating Businesses Financial Model (Free Excel Download)
Forecast HVAC-services growth from installations, maintenance agreements, service calls, technician capacity, parts, seasonality, pricing, hiring, and branch-level profitability.
professionals from Deloitte
Used by professionals from
About this model
This model helps you assess an HVAC and home services business across maintenance, repairs, replacements, and related work. It connects customer demand, recurring service plans, job pricing, and parts sales to the technicians, vehicles, branches, and support teams needed to deliver the service.
Use it to evaluate an acquisition, a new branch, or a broader growth plan. Test customer growth, crew capacity, service mix, and pricing to see how they affect profitability, cash flow, and value.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the HVAC Services Rollup Model
- Branch inputs: Year-1 branches, new branches per year, jobs per branch, technicians per branch, average job ticket
- Utilisation: Year-1 crew utilisation with an annual ramp and a practical ceiling
- Service mix: maintenance, service repair, system replacement and plumbing-and-IAQ shares, per-tier price indices and net margins
- Ancillary: members per branch and annual plan fee, parts and accessory attach per job, price escalation
- Cost structure: technician and dispatch comp and wage with benefits and wage growth; facilities and fleet, marketing, technology and SG&A as % of gross profit; depreciation (% of revenue); tax
- Capital and working capital: maintenance capex %, branch build-out cost per branch, NWC % of revenue growth, base-year revenue
- Valuation: WACC, terminal growth, net debt, shares outstanding
- Operations sheet: branch roll-forward, utilisation ramp, jobs per branch, total service jobs, staff headcount, jobs per technician
HVAC Services Rollup Model: How the Financial Model Works
This hvac financial model projects a multi-branch HVAC and plumbing rollup, covering branch expansion, membership programs, job pricing, technician capacity, and cash flow. It is designed for evaluating acquisitions, new branches, or growth plans by testing customer growth, crew capacity, service mix, and pricing to see how they affect profitability and value.
Branch Roll-Forward and Capacity Ramp
The model rolls the branch estate forward, adding new branches each year with a mid-year convention and first-year vintage ramp to reflect lower volume and plan sales for de novo locations. It computes average and effective branches, reporting portfolio utilisation net of dilution from new openings.
- Job volume is sized off effective branches multiplied by mature jobs per branch, then adjusted by a seasoned crew-utilisation ramp that increases over time. This ramp gradually lifts throughput per branch, while a route-density ceiling caps membership growth.
- The interplay of new branch additions and utilisation improvements creates operating leverage as fixed costs spread over rising revenue per branch.
Membership Book and Recurring Revenue
A membership book is modeled as a roll-forward with opening, renewed, lapsed, and gross adds based on the effective branch base, constrained by a route-density ceiling. Plan fees are treated as a prepaid service obligation: they buy technician visits that are carved out of the maintenance tier, with labour and consumables charged as membership fulfilment cost.
- The plan runs at a modest direct margin, but its strategic value lies in member-to-replacement conversions. These conversions generate incremental install demand at the highest ticket in the model, and the membership book also absorbs shoulder-season capacity.
- Renewals and gross adds drive average members and recurring revenue over the forecast.
Pricing, Job Mix, and Technician Staffing
Job volume is split across four service tiers—maintenance, repairs, replacements, and plumbing/IAQ—each with its own ticket index, wrench hours, material percentage, and true contribution. Pricing is mix-normalised so the blended menu ticket ties to the input, and menu prices escalate annually.
- Jobs are converted into wrench hours, and technician headcount is solved from billable capacity, making labour a binding constraint. Technicians are staffed to avoid exceeding a 2,080-hour year, with overtime used at peak.
- This ensures volume growth is paid for at a real loaded rate, making operating leverage genuine and driven by fixed overhead absorption as utilisation rises.
Financial Statements and Valuation Outputs
The model flows from revenue through direct costs—materials, field labour, membership fulfilment, attach cost of goods, and financing dealer fees—to gross profit, then deducts per-branch and per-truck overhead to reach EBITDA, EBIT, NOPAT, and net income after interest.
- Free cash flow is derived from NOPAT, depreciation, capital expenditures, and working capital changes, with a net-debt roll including a cash sweep.
- Valuation uses an unlevered DCF with a normalised terminal year, producing enterprise value, equity value, and value per share.
- Entry and terminal multiples are calculated, and PV of terminal value as a percentage of EV is shown, providing a structured view of the platform's worth under the operating assumptions.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is an HVAC financial model?+
An HVAC financial model captures the seven-year operating economics and intrinsic value of a multi-branch HVAC and plumbing home-services platform that runs maintenance and tune-ups alongside service repairs, system replacement and install, adjacent plumbing and indoor-air-quality work, recurring maintenance memberships and a parts and accessory attach. It rolls a branch count forward, converts a crew-utilisation ramp into total service jobs, prices jobs across a four-tier service mix at a blended average ticket and price index, runs the technician-heavy cost stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share.
How is HVAC services revenue built?+
Revenue is driven by the branch estate and its utilisation: total service jobs equal closing branches times jobs per branch times a crew-utilisation factor that ramps to a ceiling, and service revenue splits those jobs across a maintenance, service repair, system replacement and plumbing-and-IAQ mix, each priced at a blended average job ticket times a per-tier price index. Branch-driven maintenance memberships and job-driven parts and accessory attach layer on to total revenue.
Why does the EBITDA margin expand over the forecast?+
Field technician and dispatch labour scales with the branch footprint, but revenue per branch climbs as the crew-utilisation ramp lifts job throughput toward its ceiling. Because labour is broadly fixed to the branch count while utilisation compounds, EBITDA margin expands across the horizon even at a flat menu price, the operating-leverage story at the heart of every home-services roll-up.
Why an unlevered DCF instead of an EBITDA multiple?+
A home-services platform still builds out and equips each branch with a capital-intensive service-truck fleet, tools and inventory, so EBITDA overstates cash. The model bridges to unlevered free cash flow, NOPAT plus depreciation, less maintenance and build-out capex, less the change in working capital, and discounts it at a WACC, then adds a Gordon-growth terminal value. The implied EV/EBITDA falls out as a sanity check rather than as the valuation input.
Have more financial modelling questions? Contact us
Related templates
Pest Control Services Model
Plan and value a pest-control services operator using recurring customer retention, route density, service tiers, and a DCF.
Franchise Unit Economics Model
Economics template for franchise systems modeling unit-level P&L, franchise fees, royalties, and multi-unit growth scenarios.
Car Wash Roll-Up Model
5-year express car-wash roll-up: membership economics, multi-site EBITDA, sponsor IRR and exit multiple arbitrage.
Food Manufacturing Model
Operating model for food production and processing businesses with ingredient sourcing, production scheduling, and margin analysis.
