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.
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.
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
Ten tabs. Blue cells are inputs; every other cell is a formula.
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.
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.
No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.
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.