Free Excel templates

A free security guard bill rate calculator in Excel

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.

Get the calculator

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.

The book behind this calculator

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

What is in the file

Four sheets. Blue type is an input; black type is a formula.

Inputs
Billable hours a month; the pay rate; the overtime share of paid hours; the nonbillable share; turnover a year; paid hours per officer; training hours and cost of a hire; FICA, workers comp, unemployment cost per employee, health cost per paid hour, liability insurance; the quoted bill rate and the target contribution margin.
Calculator
Per billable hour: wages at straight time, overtime premium, payroll taxes and workers comp, health coverage, unemployment taxes and hiring costs, liability insurance and the direct cost; the bill rate for the target margin; the contribution and the margin at the quoted rate; the month of the contract; the bill rate needed for margins from 10 to 30 percent. Each line has a one-line definition beside it.
Read Me
How to replace the case with your own figures, and why the result is an estimate, not a quote.
Checks
The calculator compared with the figures printed in the book.

Three things to try

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.

Related reading