Free Excel templates

A free roofing business model in Excel, with a full worked case

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.

Get the template

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.

The book behind this model

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

What is in the file

Ten sheets, in the order the calculation runs. Blue type on a yellow fill is an input; black type is a formula.

Inputs
Jobs, squares and price per square for retail and insurance work; repairs, commercial and gutters; materials, crew rate, disposal, commission and warranty; leads and cost per lead; overhead, owner pay, crews, collection days, plan and offer assumptions.
Job Costing
The average retail and insurance job per job and per square: direct cost $381.14 a square, gross profit $203.86 a square on retail, and the commission-plan comparison on a discount.
Funnel
Leads, inspections, close rate (23.3%), lead cost per job ($982.14), contribution after lead cost, and the price-increase test.
P&L
Revenue and direct costs by line, gross margin (34.6%), SG&A, adjusted EBITDA, the EBITDA in the owner's books and SDE ($1,274,161).
Capacity
Squares per crew, capacity and utilization (79.8%).
Cash and Break-even
Insurance and retail receivables, materials payables, net working capital ($247,393) and break-even in replacement jobs (139).
Normalization
The storm-year insurance jobs removed: normalized revenue, adjusted EBITDA and SDE.
Plan
2027 to 2029 in a normal insurance year: jobs, revenue, EBITDA and margin, crews added above 85% utilization.
Valuation
A platform's offer on normalized EBITDA with rollover equity, an individual buyer's offer on normalized SDE with an SBA loan and a seller note.
Checks
Revenue ties, gross profit ties, SDE ties to EBITDA, and a comparison with the figures printed in the book.

Three things to try

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.

Questions

Why does the model normalize the storm year?

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.

Does it use macros?

No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.

Can I use it for my own roofing company?

Yes: replace every blue input. Summit Ridge and every figure in it are fictional case assumptions, not market data.

Related reading