# The Restoration Contractor Business Owner: companion files

Julian R. Sterling

## What is here

- **Restoration_1_Water_Job_Estimate.xlsx** (Chapters 2, 4 and 5; Water Job Estimate workbook of Appendix A): sheets Inputs, Estimate, then Checks. One water job from the price list to who pays: labor, equipment, materials billed, the list amount, the approved amount and the deductible (a medium water job, FY2026: list $6,087, approved $5,844, the insurer paying $4,844).
- **Restoration_2_Equipment_Day_Cost.xlsx** (Chapter 10; Equipment Day Cost workbook): sheets Inputs, Day Cost, then Checks. What one owned unit costs per day on jobs, and the days at which owning costs what renting costs (a dehumidifier: $5.96 a day on jobs, 19.7 days).
- **Restoration_3_Crew_Hours_and_Overtime.xlsx** (Chapters 8 and 9; Crew Hours and Overtime workbook): sheets Inputs, Crew, then Checks. One week of one crew pool: straight time, overtime under a cap, overflow labor, burden and the week's labor cost (the mitigation pool in week 99: 200 overtime hours, 660 overflow hours, $57,883).
- **Restoration_4_Insurer_Payment.xlsx** (Chapters 5 and 6; Insurer Payment workbook): sheets Inputs, Payment, then Checks. One job from the approved amount to what is received, the program fee and the supplement included (a Kelvaine program rebuild: approved $29,328, fee $1,173, $30,311 received in all).
- **Restoration_5_Rebuild_Job_Margin.xlsx** (Chapters 7 and 8; Rebuild Job Margin workbook): sheets Inputs, Rebuild, then Checks. The job contribution of one reconstruction job (a medium water rebuild: $1,373, $10.68 per $100 approved).
- **Restoration_6_Receivables_and_the_Line.xlsx** (Chapters 14 and 15; Receivables and the Line workbook): sheets Inputs, Line, then Checks. Receivables by age, the borrowing base, availability on the line and interest (27 September 2026: base $669,282, availability $639,282).
- **Restoration_7_Sale_Price.xlsx** (Chapter 16; Sale Price workbook): sheets Inputs, Price, then Checks. The letter of intent's price formula, from EBITDA to the owner's proceeds at closing (enterprise value $2,730,645, proceeds $2,529,827 before taxes, fees and the earnout).
- **Restoration_Contractor_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (Check-list 1: the first call (chapters 2 and 5); Check-list 2: the water job file (chapters 2 and 4); Check-list 3: the estimate and supplement review (chapter 4); Check-list 4: the payer and program review (chapters 5 and 6); Check-list 5: the reconstruction start (chapters 7, 8 and 11); Check-list 6: the weekly crew and equipment review (chapters 9 and 10); Check-list 7: the weekly cash and receivables review (chapters 14 and 15); Check-list 8: before a sale (chapter 16)).

## How to use the workbooks

Every workbook opens on its Inputs sheet: blue type on a light blue background is an input, and nothing else is typed by hand. The subject sheet is read top to bottom, one line per step. Black type is a formula, green type a figure read from another sheet of the same workbook. The Checks sheet holds the checks of Appendix A: each one is an IF test on your own inputs that shows OK, or CHECK followed by the input to look at. A comparison shown beside a result (the price list day rate beside the cost per day, the list amount beside what is received) is a reading aid, never a check. An empty input counts as 0, except where a MIN reads it directly: an empty limit on the Line sheet is skipped, as Appendix A explains. Some wrong inputs pass every check (a share typed 0.96, an empty overtime cap, an empty dollars-per-hour cell, an empty limit with no balance): read the result lines too.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No date function is used: a week, a quarter or a fiscal year is a label you type. Rates and shares are typed in percent (96, not 0.96), and every division by an input that can be zero is wrapped in IF and shows 0 instead of an error.

To use a workbook on your own business, start with a copy, replace every blue input from the record that owns each figure (the price list, the job files and the payers' approvals, the program agreement, the payroll register, the fleet records, the bank statements and the signed line agreement, the letter of intent), keep every check at OK, and compare a result only with the same business's own earlier jobs, weeks, quarters and years. Never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share (an approval share, a burden rate, a price) is typed again where it is used.

## A word of caution

Felmarrow Restoration, Inc., the town of Corvanton, Dunmorrow Mutual, the Kelvaine program, Pennaskel Property Management, Brenmoss Community Bank and every party in the case are fictional. Prices, approval shares, deductibles, wages, burden rates, fleet costs, payment terms, fees, line terms and multiples are teaching assumptions, not market norms or recommendations, and not a statement of any policy, program or law. What a policy covers, what a program requires and what a state allows are for the policy, the insurance agent, the program agreement and counsel in the business's state; taxes are for the outside CPA. Nothing here is legal, tax, insurance or accounting advice.
