Companion files · The Private Markets Career Guides
Freight Broker Business by the Numbers: Loads, Gross Margin per Load, Carriers, Quick Pay, Receivables, the Line of Credit, Agents, Claims, Fraud and What Your Brokerage Is Worth.
These are the companion files of the book. Seven workbooks follow Brindlewade Freight, the fictional freight brokerage of the case, across two fiscal years: gross margin per load, quick pay, receivables, the line of credit and a factoring offer, an independent agent, overhead and breakeven, and a buyer’s letter of intent. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the seven workbooks, the toolkit and 00_START_HERE.md. No macros, no date functions, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapter 2
One shipper group in one month: loads, the shipper rate and the carrier rate, revenue, carrier cost, gross margin and gross margin per $100 of revenue. Sheets: Inputs, Margin. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 111 KBChapter 6
One month of quick pay: the fee kept on the carriers paid early and the amount paid to them in the month. Sheets: Inputs, Fees and Cash. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 211 KBChapter 7
Receivables from shippers rolled forward over a period, and the days of revenue they represent. Sheets: Inputs, Roll-Forward, Days. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 312 KBChapter 8
The line of credit at a month end (borrowing base, amount available, room) and a factoring fee set beside the line’s cost on the same invoices. Sheets: Inputs, Borrowing Base, Factoring Comparison. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 413 KBChapter 11
An independent agent’s split of gross margin and what the brokerage keeps. Sheets: Inputs, Split. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 511 KBChapter 13
Fixed costs line by line, contribution per load, breakeven loads and the loads above breakeven. Sheets: Inputs, Breakeven. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 611 KBChapter 16
Net income to EBITDA to adjusted EBITDA, a buyer’s letter of intent with its earn-out, and the working capital adjustment at closing. Sheets: Inputs, Bridge, Letter, Closing. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 715 KBAppendix B
The monthly numbers review; The broker file; Checking a new carrier; Opening a new shipper; A contract renewal; Paying carriers; An agent's or account manager's agreement; Preparing for a sale.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and how to use the workbooks on your own brokerage.
Download the read-me4 KB| The margin per load | FY2026 gross margin $1,278,650 over 4,855 loads: $263.37 a load, lower than FY2025’s $268.29 although revenue rose |
| The breakeven | FY2026 fixed costs $1,019,056 over a contribution of $242.71 a load: 4,199 loads, 656 below the year’s 4,855 |
| The adjusted EBITDA | EBITDA $209,041, the owner’s salary added back, a general manager’s pay deducted, the fraud loss treated as one-time: $239,551 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Brindlewade Freight, Torvanley and every party are fictional, and the shipper rates, carrier rates, fees, payment terms, line terms, splits, prices and multiples are the book’s assumptions, not market terms or the practice of any real brokerage, carrier, shipper, bank, factor or buyer. Rules change: check the current texts, FMCSA, your outside CPA and counsel in your state.