# The Real Estate Brokerage Owner: companion files

Julian R. Sterling

## What is here

- **REBO_1_Splits_and_Caps.xlsx** (Chapters 3 and 4; Splits and Caps workbook of Appendix A): sheets Inputs, GCI per side, Cap, Agent year, then Checks. GCI per side from the price and the rates ($10,275.28 then $10,066.11), where the $24,000 cap falls (side 8), and one agent of each tier for a year on the standard plan (tier B: $25,890 of company revenue).
- **REBO_2_Unit_Economics.xlsx** (Chapters 5 and 10; Unit Economics workbook): sheets Inputs, Per side, Break-even, then Checks. Contribution per side for both years ($1,966.87 then $1,730.48), the break-even in sides (389 then 442) and revenue and cost per agent.
- **REBO_3_Recruiting_and_Retention.xlsx** (Chapters 6 and 7; Recruiting and Retention workbook): sheets Inputs, Turnover, Tier C year, then Checks. Turnover measured against the average roster (26.2 then 25.9 percent) and a tier C agent's year ($10,432.37 left to cover the office).
- **REBO_4_Plan_Change.xlsx** (Chapter 8; Plan Change workbook): sheets Inputs, One agent, Whole tier, then Checks. One tier A agent on both plans ($12,275 given up a year), the whole tier ($70,486 given up in FY2026) and the 2.4 agents the plan must keep to pay for itself.
- **REBO_5_Ancillary_and_Franchise.xlsx** (Chapters 13 and 14; Ancillary and Franchise workbook): sheets Inputs, Franchise, Title venture, then Checks. The franchise fees on FY2026 production ($184,649 a year, 107 more sides) and the title venture share ($17,980.00 a year, a projection).
- **REBO_6_Cash_and_Valuation.xlsx** (Chapters 12 and 16; Cash and Valuation workbook): sheets Inputs, SDE, Trust, then Checks. Seller's discretionary earnings ($267,388 then $198,925), the fictional buyer's indication, and the earnest money reconciliation of 30 September 2026 in three columns ($171,500.00, no difference).
- **REBO_Broker_Owner_Checklists.docx**: the 8 checklists of Appendix B, editable (Recruiting checklist; Buyer agreement before the first tour; Transaction file checklist; Monthly file review; Earnest money and trust reconciliation; Before any affiliated business arrangement; Before signing a franchise agreement; The monthly review page).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two columns: 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. 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 13 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.

Two inputs to try first:

1. In REBO_1_Splits_and_Caps.xlsx, on Inputs, type 25,000 in the yellow cell beside the cap: the side of the cap moves and the company revenue of tiers A and B rises, while tier C does not move, because it never reaches the cap.
2. In REBO_5_Ancillary_and_Franchise.xlsx, on Inputs, type your own contribution per side in the yellow cell: the number of sides the franchise fees would cost you moves at once.

To use a workbook on your own brokerage, fill the yellow column from the transaction records, the ledger and the roster, in the order Appendix A gives, and keep a copy with the case column for comparison. The workbooks are separate files with no link between them.

## A word of caution

Haddlemere Realty, LLC, the city of Ellisvane, Tollivant Home Group, the franchisor, the title partners, the buyer and every party in the case are fictional. Prices, commission rates, splits, caps, fees, costs, counts of sides and multiples are teaching assumptions, not market norms or recommendations. Rules on buyer agreements, supervision, independent contractors, trust accounts, referral fees and franchises change and differ by state: read them in their current text, with your outside CPA and your counsel. No software, brand or franchise is described or recommended. Nothing here is legal, tax or accounting advice.
