# The HVAC Contractor Business Owner: companion files

Julian R. Sterling

## What is here

- **HVAC_Contractor_1_Labor_Rate.xlsx** (Chapter 3; Labor Rate workbook of Appendix A): sheets Rates, Efficiency, then Checks. The burdened cost per paid hour of every role for FY2025 and FY2026, the service composite ($43.41 then $45.07 an hour), efficiency and the cost per billable hour ($73.74 then $85.62).
- **HVAC_Contractor_2_Pricing.xlsx** (Chapters 4 and 5; Pricing workbook): sheets Selling Rate, Price Book, then Checks. The selling hourly rate built from the FY2026 budget ($163.81, rounded up to $164), the eight flat-rate tasks against FY2025 time and material, and the average repair ticket.
- **HVAC_Contractor_3_Replacement.xlsx** (Chapters 7 and 8; Replacement workbook): sheets Tiers, Deal, Lag, then Checks. The three tiers on the three price lists, what the company keeps on one financed system, and the price list lag of $43,100 on 66 systems.
- **HVAC_Contractor_4_Agreements.xlsx** (Chapter 9; Agreements workbook): sheets Base, then Checks. Members, renewals and new agreements: 1,302 then 1,502 members.
- **HVAC_Contractor_5_Season_and_Cash.xlsx** (Chapter 11; Season and Cash workbook): sheets Hires, then Checks. The February 2026 hires: $141,634 brought in against a cost of $143,250 in their first season.
- **HVAC_Contractor_6_Valuation.xlsx** (Chapter 16; Valuation workbook): sheets EBITDA, then Checks. Adjusted EBITDA of $768,854, the buyer's value of $3,459,843 and the earn-out of $691,969.
- **HVAC_Contractor_Toolkit.docx**: the 10 check-lists of Appendix B, editable (The maintenance visit; The repair call; The replacement proposal; Installation day and handover; The monthly review; Preparing for the season; Hiring and onboarding a technician; Updating the price book and the price list; Refrigerant handling and records; The weekly cash review).

## How to use the workbooks

Blue type on a light blue background is an input, black type a formula, green type a figure read from another sheet of the same workbook. Change one input at a time, note the result, and set the input back before the next test: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK at the base case. Each of the 9 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, multiply, divide, round and round up. No date function, workday count or lookup formula is used. When a figure is rounded, the note at the top of the sheet says which way.

Two inputs to try first:

1. In HVAC_Contractor_1_Labor_Rate.xlsx, on Efficiency, change the FY2026 hours billed on calls by a few hundred: the cost per billable hour moves far more than a wage increase would move it.
2. In HVAC_Contractor_3_Replacement.xlsx, on Deal, set the system as sold by the owner (0) and not financed (0): the sheet shows how much of the margin goes to the sale and how much to the loan.

The workbooks are separate files with no link between them: a figure another workbook produces (the installers' cost per person-hour, the renewal rate) is typed again where it is used.

## A word of caution

Dunmaren Heating & Air, Inc., the city of Askelby, Brisvane Supply, Kettlemoor Property Group and every party in the case are fictional. Wages, benefits, burden rates, book hours, parts multipliers, equipment costs, prices, renewal rates, the dealer fee, overhead and the valuation multiple are teaching assumptions, not market norms or recommendations. Federal rules change: read them in their current text, with your state and city rules, your outside CPA and your counsel. No software, manufacturer, distributor or lender is described or recommended. Nothing here is legal, tax or accounting advice.
