# The Freight Brokerage Owner: companion files

Julian R. Sterling

## What is here

- **Freight_Broker_1_Load_Margin.xlsx** (Chapter 2; Load Margin workbook of Appendix A): sheets Inputs, Margin, then Checks. One shipper group in one month: revenue, carrier cost, gross margin and gross margin per $100 of revenue (Calvessen in September 2026: $35,650, $13.60 per $100).
- **Freight_Broker_2_Quick_Pay.xlsx** (Chapter 6; Quick Pay workbook): sheets Inputs, Fees and Cash, then Checks. One month of quick pay: the fee kept ($6,473 in September 2026) and the amount paid to those carriers in the month ($317,167).
- **Freight_Broker_3_Receivables.xlsx** (Chapter 7; Receivables workbook): sheets Inputs, Roll-Forward, Days, then Checks. Receivables rolled forward over a period (FY2026: $1,277,900 at the end) and the days of revenue in receivables (44.9 days).
- **Freight_Broker_4_Line_and_Factoring.xlsx** (Chapter 8; Line and Factoring workbook): sheets Inputs, Borrowing Base, Factoring Comparison, then Checks. The borrowing base, the amount available and the room on the line at a month end ($200,000 in April 2026), and a factoring fee ($63,383) set beside the line's cost on the same invoices ($26,122).
- **Freight_Broker_5_Agent.xlsx** (Chapter 11; Agent workbook): sheets Inputs, Split, then Checks. The agent's split of gross margin and what the brokerage keeps ($74,700 and $49,800 from January to September 2026).
- **Freight_Broker_6_Overhead_and_Breakeven.xlsx** (Chapter 13; Overhead and Breakeven workbook): sheets Inputs, Breakeven, then Checks. Fixed costs, contribution per load and breakeven loads (4,199 in FY2026, 3,509 in FY2025).
- **Freight_Broker_7_Valuation.xlsx** (Chapter 16; Valuation workbook): sheets Inputs, Bridge, Letter, Closing, then Checks. The bridge to an adjusted EBITDA of $239,551, the letter's price ($1,077,980), cash at closing and earn-out, and an illustration of closing ($302,563 to the owner, before taxes and fees).
- **Freight_Broker_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (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).

## How to use the workbooks

Every workbook opens on its Inputs sheet: blue type on a light blue background is an input, and nothing else is typed by hand. Each subject has its own sheet, read top to bottom, one line per step. Black type is a formula, green type a figure read from another sheet of the same workbook. The Checks sheet tests the controls of Appendix A: OK on green when a check holds, red with the line to look at when it fails. Every check is a test your own inputs could fail. A comparison set beside a result (the factoring fee beside the line's cost, the share of loads on quick pay) is a reading aid on the subject sheet, never green or red. The default inputs are the case figures, so a workbook opened for the first time shows the numbers of the chapter it serves, and each of the 7 exercises of Appendix A is done in its own workbook.

The arithmetic is plain: add, subtract, multiply, divide and round. No date function, workday count or lookup formula is used: a month or a fiscal year is a label you type, and every count of loads or months is an input.

To use a workbook on your own brokerage, replace every blue input, all of them, from the document that owns each figure (the transportation management software's report, the aging report, the commission statement, the income statement), keep the checks green, and compare the result only with the same brokerage's own earlier months and years.

The workbooks are separate files with no link between them: a figure two workbooks share (the advance rate, the payroll taxes and benefits rate, interest) is typed again where it is used.

## A word of caution

Brindlewade Freight, LLC, the town of Torvanley, Calvessen Building Supply, Wexmarren Foods, Cobbleshaw National Bank, Strannick Funding, Ulvermond Logistics Group and every party in the case are fictional. Shipper rates, carrier rates, fees, payment terms, line terms, splits, salaries, overhead lines, prices and multiples are teaching assumptions, not market norms or recommendations. Federal rules change: read them in their current text, with FMCSA, your surety, your outside CPA and counsel in your state. No software, bank, factor, carrier or real company is described or recommended. Nothing here is legal, tax, accounting or regulatory advice.
