Free Excel templates

A free fire protection company business model in Excel, with a full worked case

Inspection accounts by kind of agreement, their hours and price per inspector-hour, an agreement priced by the hour, service, monitoring and installation with a worked bid, a P&L with reported and adjusted EBITDA, break-even, working capital, the cash floor and two offers for the company.

The file follows Vellacott Fire Protection, a fictional company with 6 inspectors, 4 service technicians and 3 fitter crews of two. Revenue is $5,052,700, of which 34.1% recurring, reported EBITDA $833,897, adjusted EBITDA $909,381 (18.0%), and the company breaks even at 76.4% of its revenue. The 2026 figures and the two offers of the book come from this model; replace the inputs with yours and the case recalculates.

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.

Fire_Protection_Business_Model_Vellacott.xlsx (24 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 Fire Protection Company Owner. The book explains every assumption and every tab: why the inspector-hour is the unit, why an agreement is priced by its hours and not by the building, how a deficiency becomes a proposal, why monitoring billed in advance is not spare cash, how a bid is built on the loaded crew-day, and how two buyers would value the company.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Eight tabs. Blue cells are inputs; every other cell is a formula.

Inputs
People, wages, burden and paid hours; inspection materials and fuel; service, monitoring and installation; vans and trucks; overhead, including the owner's salary and the social security wage base; working capital; the worked examples; the two offers; and, by kind of agreement, accounts, visits, inspector-hours and annual price.
Inspection
Revenue, inspector-hours and price per inspector-hour by kind, the hours available and a capacity check, and the contribution per inspector-day ($712 in the case, inspection only).
Agreement Price
One agreement priced by the rule of $165 per inspector-hour: a near building at $2,310.00 a year, an outlying one, and the outlying one at the near one's price ($553.28 per inspector-day).
Service and Installation
The service department ($689 per technician-day billed), monitoring, installation in 2026 with subcontracted scope kept apart, and the worked bid as bid ($829.04 per crew-day) and overrun ($563.59).
P&L and Bridge
Cost of sales, gross profit (39.2%), overhead, reported EBITDA, the three add-backs, adjusted EBITDA, SDE and the break-even revenue ($3,859,325).
Cash
Working capital by component ($524,063 in the case) and the cash floor ($160,402).
Value
Offer A at 6.0x adjusted EBITDA with its rollover; offer B at 4.0x with an SBA 7(a) loan, the guaranty fee in the closing costs, the equity injection on total project cost and its debt service coverage (1.48x).
Checks
Every output set against the figure printed in the book.

Three things to try

Add an hour. Add one inspector-hour to each sprinkler-only account without changing its price. The capacity check turns to NO: the book now needs another inspector.

Price the outlying building like the near one. The Agreement Price tab shows the contribution per inspector-day fall from $949.28 at the rule to $553.28.

Remove an add-back. Take out the one-time legal fees as if they could not be documented. Reported EBITDA does not move; adjusted EBITDA and both offers do.

Questions

Can it price a fire sprinkler inspection agreement?

Yes. In the case, a combined agreement of 14 inspector-hours a year, priced at $165 an hour, comes to $2,310.00 a year and leaves $949.28 per inspector-day after the inspector's loaded time and fuel.

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 fire protection company?

Yes: replace every blue input, starting with your accounts, hours per account, prices and wages. Vellacott and every figure in it are fictional case assumptions, not market data.

Related reading