# The Home Inspection Business Owner: companion files

Julian R. Sterling

## What is here

- **HIBO_1_Pricing_and_Attach.xlsx** (Chapters 4 and 9; Pricing and Attach workbook of Appendix A): sheets Inputs, Ticket, Attach rates, then Checks. Revenue from the price list and the jobs sold, the average ticket ($513.01 then $550.07) and the attach rate of each ancillary (radon 26.0 percent then 29.9 percent).
- **HIBO_2_Capacity_and_Hiring.xlsx** (Chapters 5 and 7; Capacity and Hiring workbook): sheets Inputs, Roster, Utilization, New inspector, then Checks. Each employed inspector's capacity month by month under the ramp rule (1,620 then 1,908 inspections), utilization (86.0 percent then 91.7 percent) and the cost of a new inspector ($17,240, 1.6 fully booked months to cover it).
- **HIBO_3_Pay_Plan.xlsx** (Chapter 8; Pay Plan workbook): sheets Inputs, Per job, Salary, then Checks. The FY2026 jobs priced under the FY2025 per-job plan ($458,538) and under salary ($394,440): $64,098 less under salary at that volume.
- **HIBO_4_Unit_Economics.xlsx** (Chapter 14; Unit Economics workbook): sheets Inputs, Contribution, Break-even, then Checks. Contribution per inspection ($231.83 then $476.96), the break-even (1,349 then 1,553 inspections) and net income for both years.
- **HIBO_5_Quality_and_Claims.xlsx** (Chapter 12; Quality and Claims workbook): sheets Inputs, Complaints, Claims, then Checks. Written complaints per 1,000 inspections (5.9 then 7.6) and the payments on claims set against the $5,000 deductible.
- **HIBO_6_Cash_and_Valuation.xlsx** (Chapter 16; Cash and Valuation workbook): sheets Inputs, SDE, Indication, then Checks. Seller's discretionary earnings ($160,881 then $260,023) and the fictional buyer's indication.
- **HIBO_Inspection_Owner_Checklists.docx**: the 7 checklists of Appendix B, editable (Pre-inspection agreement checklist; Day of the inspection checklist; Report quality checklist; Radon test checklist; Complaint and claim checklist; Hiring an inspector checklist; The monthly review page).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 10 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In HIBO_3_Pay_Plan.xlsx, on Inputs, type a lower number of inspections above 24 in a month and fewer inspections done: the per-job cost falls faster than the salary cost, and the saving shrinks. A pay plan that wins only at the busy volume is a bet on the busy volume.
2. In HIBO_2_Capacity_and_Hiring.xlsx, on Inputs, move the first month of inspector 6 two months earlier: the Roster fills before the spring, and capacity and utilization move at once.

To use a workbook on your own company, fill the yellow column from the scheduling system, the payroll register, the income statement and the complaint log, in the order Appendix A gives, and keep a copy with the case column for comparison. The workbooks are separate files with no link between them.

## A word of caution

Pendlecott Home Inspections, LLC, the city of Wendlecombe, the regional inspection company that gave an indication and every party in the case are fictional. Prices, fees, pay rates, salaries, costs, capacities, attach rates, counts of inspections and multiples are teaching assumptions, not market norms or recommendations. Licensing, standards of practice, radon, wage and insurance rules change and differ by state: read them in their current text, with your outside CPA, your insurance broker and your counsel. No software, device, laboratory, insurer or association brand is described or recommended. Nothing here is legal, tax, insurance or accounting advice.
