Companion files · The Private Markets Career Guides
Water Damage Restoration Business by the Numbers: Mitigation Jobs, Insurance Payers and Deductibles, Supplements, Reconstruction, Crews and Overtime, Equipment, Storms, Cash and What It Is Worth.
These are the companion files of the book. Seven workbooks follow Felmarrow Restoration, the fictional restoration contractor of the case, across two fiscal years: the water job estimate, the equipment day cost, crew hours and overtime, the insurer payment, the rebuild job margin, receivables and the line of credit, and the sale price. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the seven workbooks, the toolkit and 00_START_HERE.md. No macros, no date functions, no links between files, no password; the only functions are SUM, ROUND, MIN, MAX, IF and AND. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 2, 4 and 5
One water job from the price list to who pays: labor, equipment, materials billed, the list amount, the approved amount and the deductible. Sheets: Inputs, Estimate. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 112 KBChapter 10
What one owned unit of equipment costs per day on jobs, and the days at which owning costs what renting costs. Sheets: Inputs, Day Cost. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 211 KBChapters 8 and 9
One week of one crew pool: straight time, overtime under a cap, overflow labor, burden and the week’s labor cost. Sheets: Inputs, Crew. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 311 KBChapters 5 and 6
One job from the approved amount to what is received: the deductible, the program fee and the supplement. Sheets: Inputs, Payment. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 411 KBChapters 7 and 8
The job contribution of one reconstruction job: materials, subcontractors, carpenter hours, permit, lead-safe costs and fee. Sheets: Inputs, Rebuild. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 512 KBChapters 14 and 15
Receivables by age, the borrowing base, availability on the line of credit and interest. Sheets: Inputs, Line. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 611 KBChapter 16
A letter of intent’s price: adjusted EBITDA, enterprise value, the earnout, the working capital peg and the owner’s proceeds at closing. Sheets: Inputs, Price. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 711 KBAppendix B
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).
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and how to use the workbooks on your own business.
Download the read-me5 KB| The water job | A medium water job, FY2026: list $6,087 x 96 percent = approved $5,844; the insurer pays $4,844, the homeowner the $1,000 deductible |
| The storm week | The mitigation pool, week 99: 200 overtime hours, 660 overflow hours, $57,883 of labor |
| The sale price | Adjusted EBITDA $606,810 x 4.5 = $2,730,645; owner’s proceeds at closing $2,529,827, before taxes, fees and the earnout |
The files are provided as they are, without warranty of any kind. The model is illustrative: Felmarrow Restoration, Corvanton and every party are fictional, and the prices, approval shares, deductibles, wages, fleet costs, payment terms, fees, line terms and multiples are the book’s assumptions, not market terms or the practice of any real business, insurer, program, bank or buyer. Rules change: check the current texts, the policy and the program agreement, counsel in the business’s state, the insurance agent and the outside CPA before relying on any of them.