Companion files · The Private Markets Career Guides
Franchise Investing in Multi-Unit Franchise Platforms: Unit Economics, the Franchise Disclosure Document, Development Agreements, SBA Financing and Valuation.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. One workbook rebuilds the case of Brannockfield Capital, a fictional fund, buying control of Calderwick Restaurant Group, a fictional franchisee running 24 units of the fictional brand Vantrell Chicken: adjusted EBITDA of $3,892,000, a purchase at 6.0x and a 12-unit development agreement. It follows the prototype unit and its ramp, Calderwick tier by tier, the disclosure document read as an investor, the operator’s SBA 7(a) loan, the purchase, five years of units, debt and cash, the exit, and the franchisor’s side of the same units. A toolkit holds the checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 3 to 15, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the plan: Unit Economics, Calderwick Today, FDD Reader, SBA Loan, Deal, Platform, Cash and Debt, Exit and Returns, Franchisor. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 12 exercises of Appendix A run on it.
Download the workbook44 KBAppendix B
First look at a franchise system; Reading the FDD; Testing Item 19; Items 20 and 21; Unit-level diligence; Leases; Development agreement and transfer approval; The operator's SBA loan file.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The unit | A prototype costing $1,250,000 earns $240,500 of unit EBITDA when mature: a cash-on-cash return of 19.2 percent, 14.6 percent in its first year |
| The tight year | Three openings and four remodels in year 2 take year-end cash down to $413,921, below the $500,000 left at closing |
| The exit | At 6.0x year 5 EBITDA of $7,447,156, equity proceeds of $33,683,300: 2.58x and 20.9 percent on $13,056,560 of equity, before taxes and fund fees |
The files are provided as they are, without warranty of any kind. The model is illustrative: Brannockfield Capital, Calderwick Restaurant Group, Vantrell Chicken and its disclosure document are fictional, every unit has the same cost structure as a share of sales, and sales levels, costs, fees, multiples, rates and dates are the book’s assumptions, not market data, the terms or results of any real brand or a forecast. Nothing here is legal, tax, accounting, lending or investment advice.