# The Trucking Company Owner: companion files

Julian R. Sterling

## What is here

- TCO_1_Miles_and_Rates.xlsx (Chapters 4 and 5; Miles and Rates workbook of Appendix A): sheets Inputs, Load log, Per mile, By payer, Surcharge, then Checks. A blank load log, loaded and empty miles by payer, line-haul and surcharge per loaded mile, revenue per total mile ($2.16 then $2.34), the empty share by payer (13.0 percent on broker loads in FY2026) and the surcharge schedule month by month.
- TCO_2_Cost_per_Mile.xlsx (Chapters 6, 7 and 12; Cost per Mile workbook): sheets Inputs, Cost per mile, Fuel per tractor, Days, then Checks. Every cost line per total mile ($2.14 then $2.17 in all), fuel per mile tractor by tractor, utilization (88.1 percent then 92.3 percent), utilization by tractor and miles per tractor-week (2,127 in FY2026).
- TCO_3_Driver_Pay.xlsx (Chapters 9 to 11; Driver Pay workbook): sheets Inputs, Pay plans, Empty seat, then Checks. Per-mile pay ($349,066 in FY2026) against a percentage plan ($354,798), a full dispatch week of a hired driver, and the empty seat of March 2026 ($9,114 of contribution lost).
- TCO_4_Cash_and_Factoring.xlsx (Chapter 8; Cash and Factoring workbook): sheets Inputs, Factoring, Days to collect, Line, then Checks. What factoring would have cost from October 2025 ($24,844), days to collect at 30 June 2026 (33), and the line of credit month by month (at most $90,996).
- TCO_5_Fleet_Decisions.xlsx (Chapters 14 and 15; Fleet Decisions workbook): sheets Inputs, New tractor, Break-even, Replacement, then Checks. The costs per mile and the weekly fixed cost of a new tractor ($1,310.51), break-even in miles a week on broker freight (1,456) and under a dedicated contract (1,160), and the yearly saving of replacing T1 ($29,238), all projections.
- TCO_6_Profit_and_Value.xlsx (Chapters 13 and 16; Profit and Value workbook): sheets Inputs, Income statement, SDE, Planning range, then Checks. Both income statements ($4,265 then $102,994 of net income) and the bridge between them, seller's discretionary earnings ($100,057 then $309,828), the founder's planning range ($607,095 to $849,933) and the tractors against their loans.
- TCO_Trucking_Company_Owner_Checklists.docx: the 8 check-lists of Appendix B, editable (Getting the authority and starting; Accepting a load; The weekly review of miles and cost per mile; Hiring and onboarding a driver; Buying or replacing a tractor; After an incident or an accident (company procedure only); The founder's monthly review; Preparing a sale).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Every cell that divides shows a dash or a blank, never an error, until its divisor is entered. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 18 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how, and which chapter explains it.

Two inputs to try first:

1. In TCO_1_Miles_and_Rates.xlsx, on Inputs, type your own diesel price for one month: the surcharge per loaded mile of that month moves at once.
2. In TCO_2_Cost_per_Mile.xlsx, on Inputs, type your own dispatch days available and days worked: utilization shows how many of the days a tractor could have worked it did work.

To use a workbook on your own carrier, fill the yellow column from your rate confirmations, invoices, fuel receipts, the payroll register, the loan statements and the dispatch record, in the order Appendix A gives, and keep a copy with the case column for comparison. Keep the fiscal year aligned: the case runs from 1 July to 30 June. Date every input. The workbooks are separate files with no link between them.

## A word of caution

Brackenhew Carriers, the town of Corrabay, its founder, dispatcher and drivers, the bank, the truck lender, the direct shipper and the regional carrier are fictional. Rates, diesel prices, miles, shares, wages, costs, fees and multiples are teaching assumptions, not market norms or recommendations. A load in these files is loaded miles, empty miles, a rate, a fuel surcharge, a payer and a date. Operating authority, pay plans, worker classification, leases, customer agreements, factoring offers, loans and insurance are questions for counsel, your outside CPA, the lender and your insurance broker. No real carrier, broker, load board, shipper, truck maker, software, bank, lender or buyer is described or recommended. Nothing here is legal, tax, insurance or accounting advice.
