Free Excel templates

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

Technician hours and jobs, prices for lockouts, rekeys, automotive keys and commercial accounts, parts and markup, on-call nights paid as hours worked, a P&L with adjusted EBITDA and SDE, contribution and break-even with tests, six worked jobs, quarters and the cash floor, a three-year plan and two offers for the company.

The file follows Larkmoor Lock & Key, a fictional company with 6 technicians, a storefront counter, 1,212 active repeat customers and 106 commercial accounts. Revenue is $1,749,458 from 5,301 jobs, adjusted EBITDA $326,429 (18.7%), and the company breaks even at 3,786 jobs a year. Every figure in the book comes from this model; replace the inputs with yours and the whole 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.

Locksmith_Business_Model_Larkmoor.xlsx (32 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 Locksmith Business Owner. The book explains every assumption and every tab: why the whole price is said on the first call, why a night lockout earns less than its price suggests, how markup differs from margin, what a programmer costs per car key, why a master key bid needs a change order, and how two buyers would value the company.

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

What is in the file

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

Inputs
Technicians, wages, burden, paid hours and the use of the day; prices for the four kinds of work; vans and equipment; on-call stipend, call pay and night hours; the counter; marketing, close rate and repeat customers; overhead; cash; tests, plan and the two offers.
Jobs and Revenue
Technician hours available, jobs (5,301 in the case), night lockouts worked outside the daytime week, and for each kind of work the labor billed, parts billed, ticket and revenue.
Direct Costs and Gross Profit
Technicians, on-call nights, parts, fuel, leased vans and programmers; gross margin (45.5%).
Overhead and EBITDA
Overhead with the owner at market pay, adjusted EBITDA, reported EBITDA and SDE ($421,429); new calls needed and the repeat file.
Contribution and Break-Even
Variable cost and contribution per job ($215.47), fixed costs, break-even and margin of safety; tests on the use of the day, lost days, the trip charge, the burden, the close rate and the repeat share.
Worked Jobs
The night lockout, the daytime car lockout, the new homeowner rekey, all keys lost with a spare, the master key system as bid and with an overrun, and the turnover day grouped and scattered.
Cash
Quarterly revenue and EBITDA, receivables, stock, payables, the biweekly payroll and the cash floor.
Plan 2027 to 2029
Technicians, jobs, revenue, new calls, EBITDA, margin and commercial accounts needed.
Value
A regional security services company's offer on adjusted EBITDA with an earnout, an individual buyer's offer on SDE with an SBA loan and a seller note, the loan payment and its coverage, and the equipment value.
Checks
Internal checks (shares, quarters, gross profit, SDE, break-even) and a comparison with the figures printed in the book.

Three things to try

Price your night lockout. Enter your own after-hours charge, hours and call pay in the inputs; the Worked Jobs tab shows what the night call leaves per technician hour once the hours are paid at the overtime rate.

Raise the trip charge $10. The model shows $42,406 more profit a year if the same jobs stay, and that up to 5.4% of those jobs could be lost before the increase stops paying.

Use 78% of daytime hours on jobs instead of 72%. The Contribution and Break-Even tab shows $84,187 more contribution a year with the same technicians and vans.

Questions

Can it price a locksmith job?

Yes. In the case, a night house lockout quoted at $275 leaves $83.14 after overtime, fuel, card fee, lead cost and call pay; a daytime car lockout for a repeat customer at $190 leaves $143.12.

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 locksmith company?

Yes: replace every blue input, starting with your technicians, your wages and the prices your dispatcher quotes. Larkmoor and every figure in it are fictional case assumptions, not market data.

Related reading