Pay rate, overtime, turnover, hiring costs, payroll taxes and insurance in; the direct cost of one billable hour, the bill rate for a target margin and the contribution at a quoted rate out. No macros.
The bill rate a security company needs is the direct cost of one billable hour divided by one minus the target margin. In the worked case of the book, a hospital campus cost $29.67 an hour to deliver in 2025: a 20.0 percent contribution margin needed $37.09 an hour, and the company billed $27.60. The calculator builds that cost line by line for one contract and gives the rate your margin needs.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Security_Guard_Bill_Rate_Calculator.xlsx (16 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 one-page summary of The Security Guard Company Owner. The book explains every line: why the loaded cost of an hour comes before the bill rate, how overtime and turnover leak margin, why a contract is judged on its contribution after the costs it alone causes, how weekly payroll and slow clients push a company onto its line, and how the year is planned to the bank covenant.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Four sheets. Blue type is an input; black type is a formula.
Raise the overtime share. The file opens on the book's repriced campus for 2026: pay of $21.34, overtime at 9.0 percent of paid hours, turnover at 110.0 percent, a direct cost of $27.72 and a 14.4 percent margin at $32.40. Move overtime to 20.0 percent and watch the margin fall.
Double the turnover. Each hire brings screening, training hours and a fresh unemployment tax wage base. Raise turnover and read the hiring line.
Replace the case. Type your own pay rate, tax and insurance rates over the blue cells. If a line does not make sense, the definition beside it says what it measures.