# The Garage Door Company Owner: companion files

Julian R. Sterling

## What is here

- **GarageDoor_1_Margin_per_Job.xlsx** (Chapter 4; Workbook 1 of Appendix A): tabs Inputs, Margin, Checks. What each job type leaves after parts, commission, burden and card fee, then after its share of the year's fixed costs by the technician hour (FY2026: 75.27 dollars of fixed costs a billable hour; a spring job leaves 214.67 dollars before fixed costs and 101.77 after them).
- **GarageDoor_2_Calls_and_Break_Even.xlsx** (Chapter 14; Workbook 2): tabs Inputs, Break-Even, Checks. A closed year's contribution per call and the break-even in calls a month (FY2026: 362.3 against an actual 549.5, a margin of safety of 34.1 percent; FY2025: 263.8 against 319.9).
- **GarageDoor_3_Technician_Pay.xlsx** (Chapter 9; Workbook 3): tabs Inputs, Pay, Checks. One technician's commission week with the weekly guarantee at the minimum wage, the regular rate and the overtime premium, beside the same hours at the FY2025 wage (week 102: 28.70 dollars an hour, a premium of 71.76 dollars, $1,364 for the week against $1,283; a new technician's week 53 needs a top-up of 77.45 dollars).
- **GarageDoor_4_Lead_Cost_by_Channel.xlsx** (Chapter 7; Workbook 4): tabs Inputs, Leads, Checks. Each source of calls on three measures: share booked, cost a call dispatched, cost a job sold (FY2026: paid advertising 115.52 dollars a job sold, all channels 68.47).
- **GarageDoor_5_Service_Van_Payback.xlsx** (Chapter 13; Workbook 5): tabs Inputs, Payback, Checks. What one more service van leaves in a quarter and the months that pay back the cash put in (Q4 FY2026: run-rate $70,884, 3.0 months for the down payment and the stock, 10.9 months for the price and the stock).
- **GarageDoor_6_Deposits_Receivables_and_Stock.xlsx** (Chapter 14; Workbook 6): tabs Inputs, Cash Tied Up, Checks. Receivables and stock less the deposits customers advance ($37,968 of receivables, $19,725 of deposits, $74,243 of cash tied up at run-rate).
- **GarageDoor_7_Value_and_Offer.xlsx** (Chapter 16; Workbook 7): tabs Inputs, Offer, Checks. The letter of intent from EBITDA to the cash at closing (adjusted EBITDA $304,851, price $914,553, SBA loan $731,643, cash at closing $634,803).
- **Garage_Door_Company_Owner_Check_Lists.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (Section 1: Licenses, contracts and the three-day notice (chapter 2); Section 2: The weekly calls and hours review (chapters 3 and 4); Section 3: Prices, options and the diagnostic fee (chapter 5); Section 4: Doors, deposits, the builder and financing (chapter 6); Section 5: Leads and reviews (chapter 7); Section 6: Warranties, callbacks and the plan (chapter 8); Section 7: Pay, overtime and hiring (chapters 9 and 10); Section 8: Before answering an offer (chapters 15 and 16)).

Every workbook opens pre-filled with the exercise of Appendix A, so you can check each result against the book before typing your own figures.

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light yellow background is an input, and nothing else is typed by hand. The subject tab holds formulas only and is protected against overtyping, with no password. The Checks tab holds the three tests of Appendix A: each one shows OK or CHECK, and the cell All checks shows OK only when every test below it does. A comparison line informs and carries no OK or CHECK.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No cell holds a date, and a loan payment is an input copied from the lender's schedule. Percentages are typed as percent (35 percent shows as 35%), and every division by an input that can be zero is wrapped in IF and leaves the line empty instead of an error. An empty input reads as zero in a sum, a product or a comparison, but a MIN or a MAX over a range skips it. The last section of Appendix A lists, workbook by workbook, what the checks do not catch.

To use a workbook on your own company, start with a copy, replace every blue input from the record that owns each figure (the dispatch and billing software's reports, the payroll records, the lead invoices, the statements, the lender's schedule, the letter itself), keep every check at OK, and never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share is typed again where it is used.

## A word of caution

Corlanby Overhead Door, Inc., the town of Mirrowfield, Yarrowdeen Homes, Stellhaven Properties, Ketterdane Community Bank and every party in the case are fictional. Tickets, part costs, hours, call counts, lead costs, commissions, wages, loan terms, offer terms and multiples are teaching assumptions, not market norms, not a price list, not the rule of any state and not recommendations. Spring, cable and opener work belongs to trained technicians, following the makers' instructions; what a state requires is for that state and counsel; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
