Companion files · The Private Markets Career Guides
Running a Profitable Heating and Air Conditioning Company: Labor Rates, Flat-Rate Pricing, Service Calls, Replacements, Maintenance Agreements, Seasonality, Cash and What the Business Is Worth.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. Six workbooks follow Dunmaren Heating & Air, the fictional HVAC contractor of the case, across two fiscal years: the labor rate, pricing, replacements, the agreement base, a hiring decision before the season and the buyer’s value. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapter 3
The burdened cost per paid hour by role, the service composite, efficiency and the cost per billable hour, FY2025 and FY2026. Sheets: Rates, Efficiency. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 114 KBChapters 4 and 5
The selling hourly rate built from the budget and tested against the year, the eight flat-rate tasks against time and material, and the average ticket. Sheets: Selling Rate, Price Book. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 215 KBChapters 7 and 8
The three tiers on three price lists and the pricing rule, commission, dealer fee and reserve on one system, and the price list lag. Sheets: Tiers, Deal, Lag. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 317 KBChapter 9
Members at the start, renewals and new agreements, members at year end and the renewal rate. Sheets: Base. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 410 KBChapter 11
Two technicians hired before the season: the calls and replacements they brought in against their pay and their vans. Sheets: Hires. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 510 KBChapter 16
From net income to adjusted EBITDA, the buyer's multiple, the value and the earn-out tied to renewals. Sheets: EBITDA. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 610 KBAppendix B
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.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me4 KB| The cost per billable hour | The FY2026 service composite over efficiency: $85.62, against $73.74 the year before |
| The selling rate | Built from the FY2026 budget: $163.81, rounded up to $164 an hour |
| The buyer’s value | Adjusted EBITDA $768,854 x 4.5: $3,459,843, of which $691,969 as an earn-out |
The files are provided as they are, without warranty of any kind. The model is illustrative: Dunmaren Heating & Air, Askelby and every party are fictional, and the wages, book hours, equipment costs, prices, renewal rates, the dealer fee and the multiple are the book’s assumptions, not market terms or the practice of any real contractor, manufacturer, lender or buyer. Rules change: check the current texts, your state and city rules, your outside CPA and your counsel.