Roofing Financial Model Template

Start with the Assumptions sheet. Set your labor burden rate — workers' comp alone for roofing crews often runs $20–$30 per $100 of wages, so if you're not sure of your fully loaded rate, use 1.5x as a conservative starting point until you can pull the actual number from your payroll reports. Enter your overhead structure using last year's actual numbers as the baseline, your typical job size by work type, and your close rate on estimates. Then fill in the seasonality multipliers based on your market — most northern contractors run 60–70% of average revenue in December through February. With assumptions set, move to the Job Costing sheet and enter your current active jobs with their contract values and initial cost budgets. This first setup takes 45–60 minutes.

Once active jobs are entered, review the Revenue & Backlog sheet. Enter your signed jobs not yet started and your current estimate pipeline by probability. Check the months-of-backlog figure — if it's below 6 weeks, the model is signaling that you need to increase lead generation or estimating activity. Review the Cash Flow sheet closely: roofing cash flow problems are often timing problems, not profitability problems. The cash flow sheet shows months where deposits and ACV insurance payments don't arrive until after you've already committed to crew costs and material purchases. Knowing that gap in advance is what separates contractors who run short and scramble for their line of credit from those who manage it proactively.

Update the model monthly throughout the season. After each job closes, enter the final actual costs in the Job Costing sheet — the variance column will show you immediately whether your material estimates are accurate or whether disposal costs, labor hours, or supplement scope are consistently running over or under. Update the cash flow actuals with your real bank balance each month. Review the KPI Dashboard before any monthly team meeting: gross margin per job trend, average job size, and close rate tell you more about company health than any single bank statement. Roofing contractors who track job-level cost variance consistently — not just annually at tax time — are the ones who can accurately price new work based on what similar jobs have actually cost them.

Roofing is a high-revenue, high-variable-cost business where the spread between a profitable year and a breakeven year often comes down to job cost accuracy. A roofing company doing $2 million in revenue with 30% gross margin earns $600,000 to cover overhead and profit. The same company with 24% gross margin — the result of a few jobs where material quantities were underestimated, disposal ran over, or crews took longer than bid — earns $480,000. That $120,000 gap is larger than most roofing companies' net profit. The financial model matters in roofing not because the business model is complicated, but because small estimating errors compound across dozens of jobs per year and the only way to catch them is to track actual costs at the job level.

The mix of work types also makes roofing financially distinct from other trades. Residential re-roofing is volume-driven with predictable unit economics. Insurance claim work can have higher average job values and includes supplement income — revenue from additional scope approved by the adjuster after initial estimate — but requires a sales process that involves working with adjusters, and cash collection follows the insurance payment cycle rather than customer payment terms. Commercial roofing has larger contracts, longer payment terms, and often retainage, but provides steadier work through the off-season. A roofing company that tracks revenue and margin by work type understands its own business in a way that one tracking only total monthly revenue cannot. When a storm hits and insurance volume spikes, you need to know whether that work type actually earns the margin its volume suggests.

Seasonality creates a cash management challenge that is unique to roofing in northern markets. Peak season cash flow — when deposits and completions stack up — can mask overhead levels that are unsustainable through winter. A roofing company that has 18 employees in October needs to decide by August whether it can afford to keep all of them through February or whether it needs to plan a seasonal reduction. The financial model's overhead sheet and cash flow projection make that calculation concrete: here is your estimated revenue in December and January, here is your fixed overhead run rate, here is the cash burn by month if you maintain summer staffing. That's the decision the model is built to support — not just reporting what happened, but giving operators the numbers to make staffing, marketing, and equipment decisions before the off-season arrives.