Job costing per square, the lead funnel and cost per job, a management P&L with adjusted EBITDA and SDE, crew capacity, working capital and break-even, the storm normalization, a three-year plan and two offers for the company. Ten sheets, no macros.
The file follows Summit Ridge Roofing, a fictional company with five subcontracted crews that replaced 350 roofs in a storm year. Revenue is $6,891,300, adjusted EBITDA $1,134,161 (16.5%), and the average 28-square retail roof leaves $5,708.20 of gross profit. Without the storm, adjusted EBITDA would have been $830,022. Every figure in the book is computed here, and every input can be replaced with your own.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Roofing_Business_Model_Summit_Ridge.xlsx (25 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This file is the worked case of The Roofing Company Owner. The book explains every assumption and every sheet: how to build the cost of a square, what a lead really costs, how to pay reps so they share in their discounts, how an insurance claim pays, when to add a crew, and how two different buyers value the same company.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Ten sheets, in the order the calculation runs. Blue type on a yellow fill is an input; black type is a formula.
Raise retail prices 3%. The model shows $437.35 more gross profit per job, and the close rate (21.7% in the case) below which the increase stops paying.
Collect insurance jobs faster. Lower the 52 collection days: each week saved frees about $46,610 of cash at the case volume.
Set insurance jobs to a normal year. Put your own normal year in the input and see what a buyer will see before you ask a price.
Because buyers will not pay a multiple on hail. In the case, removing 55 insurance jobs above a normal year takes adjusted EBITDA from $1,134,161 to $830,022.
No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.
Yes: replace every blue input. Summit Ridge and every figure in it are fictional case assumptions, not market data.