Free Excel templates

A free garage door job profit and break-even calculator in Excel

What each job type leaves after parts, commission, burden, card fees and its share of fixed costs; break-even in calls a month from a closed year; and a check of one technician's commission week against the minimum wage and the overtime premium.

The file opens on the book's fictional company, Corlanby Overhead Door, in FY2026. Fixed costs of $670,692 over 8,911 billable technician hours make $75.27 an hour. A spring job at $395 leaves $214.67 after parts, commission, burden and card fee, and $101.77 after its 1.5 hours of fixed costs; an opener job at $465 leaves $40.21. The year needed 362.3 calls a month to break even and ran 549.5.

Get the calculator

One Excel file, no macros, nothing locked on the Inputs tab. Free: enter your email address and the download opens at once, along with the other free models.

Garage_Door_Job_Profit_and_Break_Even_Calculator.xlsx (12 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 drawn from workbooks 1, 2 and 3 of The Garage Door Company Owner, which follows one fictional garage door company through two fiscal years: four technicians paid by the hour, then seven on commission with a weekly guarantee, an install crew, a home builder, financing on new doors, a maintenance plan, three new vans, break-even in calls a month and a letter of intent from an SBA-backed buyer.

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

What is in the file

Three sheets. Blue type on a yellow fill is an input; black type is a formula, protected against overtyping with no password.

Inputs
For five job types (spring job, cable and roller job, opener job, tune-up, commercial service job) the ticket, the parts and the technician hours; the commission on the ticket, the payroll burden, the card fee and the share of residential tickets paid by card; the year's fixed costs and billable technician hours; the four totals of two closed years (calls, revenue, variable costs, fixed costs); and one technician's week: credited tickets, commission, hours worked and the minimum wage.
Calculator
The fixed cost per billable hour; for each job type its commission, burden, card fee, margin before fixed costs and margin after them; the contribution per call, break-even calls a month, actual calls a month and margin of safety of each closed year (263.8 against 319.9 in FY2025, 362.3 against 549.5 in FY2026); and the week's commission, weekly guarantee, top-up, regular rate, overtime premium rounded up to the cent, pay rounded up to the dollar, with a pay alert.
Checks
Every ticket above its parts, a burden factor from 0 to 0.5, billable hours above zero, calls and revenue above variable costs, pay at least the minimum wage for every hour, and an overtime premium of at least half the regular rate above 40 hours, with an All checks cell.

Three things to try

Raise the commission from 24 to 25 percent. The burden moves with it; the card fee and the fixed cost an hour do not. The spring job falls from $101.77 to $97.24 after fixed costs, and the opener job, at $34.89, drops below the tune-up's $35.86: a commission on the ticket weighs most on the job with the most expensive parts.

Add $40,000 a year to the FY2026 fixed costs of the closed year. Break-even moves from 362.3 to 383.9 calls a month, and the margin of safety from 34.1 to 30.1 percent.

Type the credited tickets of a median week, $5,381.43. The file opens on a new technician's ride-along week, when a commission of $248.80 needs a top-up of $77.45 to reach the guarantee. On the median week the commission is $1,291.54, no top-up is due, the regular rate is $28.70, the overtime premium for the 5 hours above 40 is $71.76 and the week's pay is $1,364.

Questions

Why does a commission week need a minimum wage check?

Because a commission is pay for the hours worked. Under federal rules as in force in November 2026, the week's pay divided by every hour worked must reach the minimum wage, and the hours above 40 earn an overtime premium of half the regular rate on top of the commission. A state or city may set a higher floor; the calculator lets you type it.

Does the calculator include lead costs?

Not in the margin per job: in the book's split, paid calls and referral gifts are variable costs of the year, and they sit in the closed year's totals that drive break-even. The book's workbook 4 sets each lead channel's cost against the jobs it brings.

Related reading