Companion files · The Private Markets Career Guides
How to Run a Profitable Real Estate Brokerage Business: Splits, Caps and Company Dollar, Recruiting and Retention, Buyer Agreements After the 2024 Settlement, RESPA, Franchise Choices and Valuation.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. Six workbooks follow Haddlemere Realty, the fictional residential brokerage of the case, across two fiscal years: splits and caps, unit economics, recruiting and retention, the plan change, the franchise offer and the title venture, and cash and valuation. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the checklists 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 3 and 4
GCI per side from the price and the rates, where the cap falls, and one agent of each tier for a year. Sheets: Inputs, GCI per side, Cap, Agent year. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 114 KBChapters 5 and 10
Contribution per side, the break-even in sides for both years, and revenue and cost per agent. Sheets: Inputs, Per side, Break-even. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 214 KBChapters 6 and 7
Turnover against the average roster, and what a newer agent’s year is worth to the company. Sheets: Inputs, Turnover, Tier C year. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 313 KBChapter 8
What the 100 percent plan gives up per agent and for the whole tier, and how many agents it must keep. Sheets: Inputs, One agent, Whole tier. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 412 KBChapters 13 and 14
A franchise offer’s fees expressed in sides, and the share of a title venture paid on ownership. Sheets: Inputs, Franchise, Title venture. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 513 KBChapters 12 and 16
Seller’s discretionary earnings, a buyer’s indication, and the earnest money reconciliation in three columns. Sheets: Inputs, SDE, Trust. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 612 KBAppendix B
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.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me4 KB| GCI per side | $421,000 x (0.47 x 2.55 percent + 0.53 x 2.25 percent) = $10,066.11 in FY2026 |
| The break-even | $764,621 / $1,730.48 per side: 442 sides against 484 closed |
| The franchise offer | $184,649 of fees a year, or 107 more sides just to pay them |
The files are provided as they are, without warranty of any kind. The model is illustrative: Haddlemere Realty, Ellisvane, Tollivant Home Group, the franchisor and every party are fictional, and the prices, rates, splits, caps, fees, costs and multiples are the book’s assumptions, not market terms or the practice of any real brokerage. Rules change and differ by state: check the current texts, your outside CPA and your counsel.