Companion files · The Private Markets Career Guides
How to Run a Profitable Small Truckload Fleet: Revenue and Cost per Mile, Empty Miles, Driver Pay, Factoring, Tractor Financing, Dedicated Contracts and Selling the Company.
These are the companion files of the book. Six workbooks follow Brackenhew Carriers, the fictional carrier of the case, across two fiscal years: miles and rates, cost per mile, driver pay, cash and factoring, fleet decisions, and profit and value. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 4 and 5
A blank load log, loaded and empty miles by payer, line-haul and surcharge per loaded mile, revenue per total mile, the empty share by payer and the fuel surcharge schedule month by month. Sheets: Inputs, Load log, Per mile, By payer, Surcharge. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 123 KBChapters 6, 7 and 12
Every cost line per total mile, fuel per mile tractor by tractor, utilization of the fleet and of each tractor, and miles per tractor-week. Sheets: Inputs, Cost per mile, Fuel per tractor, Days. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 220 KBChapters 9 to 11
Per-mile pay against a percentage plan, a full dispatch week of a hired driver, and the contribution lost while a seat stood empty. Sheets: Inputs, Pay plans, Empty seat. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 316 KBChapter 8
What factoring would have cost, days to collect, and the line of credit carried month by month. Sheets: Inputs, Factoring, Days to collect, Line. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 416 KBChapters 14 and 15
The costs per mile and the weekly fixed cost of a new tractor, break-even in miles a week on broker freight and under a dedicated contract, and the yearly saving of a replacement, all projections. Sheets: Inputs, New tractor, Break-even, Replacement. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 518 KBChapters 13 and 16
Both income statements and the bridge between them, seller’s discretionary earnings and EBITDA, the founder’s planning range and the tractors against their loans. Sheets: Inputs, Income statement, SDE, Planning range. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 618 KBAppendix B
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.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| A mile earned | $1,442,059 / 617,400 = $2.34 of revenue per total mile in FY2026 |
| A mile spent | $1,339,065 / 617,400 = $2.17 of cost per total mile in FY2026 |
| The company’s earnings | $102,994 + $60,000 + $6,990 + $94,917 + $44,927 = $309,828 of SDE in FY2026 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Brackenhew Carriers, Corrabay, the founder, the dispatcher, the drivers, the bank, the truck lender, the direct shipper, the regional carrier and every party are fictional, and the rates, diesel prices, miles, shares, wages, costs, fees and multiples are the book’s assumptions, not market terms or the practice of any real carrier. A load here is loaded miles, empty miles, a rate, a fuel surcharge, a payer and a date. Authority, pay plans, worker classification, leases and customer agreements depend on federal and state rules and on your contracts: ask counsel and your outside CPA.