# The Towing Company Owner: companion files

Julian R. Sterling

## What is here

- **Towing_1_Cost_per_Tow_and_Truck_Hour.xlsx** (Chapters 4 and 5; Workbook 1 of Appendix A): tabs Inputs, Cost, Checks. Busy truck hours, utilization, the cost per busy truck hour, the floor price of a cash and account tow and its hook fee (the price build of September 2025: 55.38 dollars a busy truck hour, a floor of 187.18 dollars, a hook fee of $135 and a list price of $185).
- **Towing_2_Call_Mix_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: 408.3 against an actual 586.0, a margin of safety of 30.3 percent; FY2025: 494.8 against 515.2).
- **Towing_3_Driver_Pay.xlsx** (Chapter 9; Workbook 3): tabs Inputs, Pay, Checks. One light-duty driver's workweek on commission plus on-call pay: the regular rate and the overtime premium against the FY2025 hourly plan (week 68: 26.92 dollars an hour, a premium of $135, $1,481 for the week against $1,100).
- **Towing_4_Impound_Yard_and_Storage.xlsx** (Chapter 8; Workbook 4): tabs Inputs, Yard, Checks. Storage, release fees and lien sales against the yard's costs (FY2026: yard revenue $232,420, costs $84,225, contribution $148,195).
- **Towing_5_Truck_Payback.xlsx** (Chapter 13; Workbook 5): tabs Inputs, Payback, Checks. A truck's own contribution and the payback of its down payment and of its price (the heavy wrecker on Q4 FY2026: run-rate $151,568, 7.6 months for the down payment, 23.4 months for the price).
- **Towing_6_Receivables_and_the_Cash_Gap.xlsx** (Chapter 14; Workbook 6): tabs Inputs, Cash Gap, Checks. Receivables at a steady pace of billing and the days of revenue waiting ($54,808, 14.4 days).
- **Towing_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 $255,857, price $831,535, seller note $83,154, cash at closing $445,071).
- **Towing_Company_Owner_Check_Lists.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (Licenses, permits and weight lines (chapter 2); The weekly call and truck review (chapters 3, 4 and 11); The price list and contract rates (chapters 5 and 6); The rotation list and nonconsent tows (chapter 7); The yard, storage and lien sales (chapter 8); Pay, overtime and on-call (chapters 9 and 10); Insurance and trucks (chapters 12 and 13); 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 software's reports, the payroll records, the motor club statements, the yard log, 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

Halsprey Towing and Recovery, Inc., the town of Cressomere, Wexholt Land Company, Pelloran Savings Bank and every party in the case are fictional. Truck counts, call counts, call times, miles, rates, fees, storage days, sale proceeds, wages, commission rates, premiums, loan terms, offer terms and multiples are teaching assumptions, not market norms, not the rule of any state, county or city and not recommendations. Storage and towing fees for nonconsent tows are set by local rules; what a state, a city or a police agency requires is for that authority and counsel; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
