# The Franchise Investor: companion files

Julian R. Sterling

## What is here

- **Franchise_Investor_Model.xlsx**: the workbook that rebuilds the Calderwick case and reproduces the figures of the book with live formulas. Sheets: Inputs, Unit Economics, Calderwick Today, FDD Reader, SBA Loan, Deal, Platform, Cash and Debt, Exit and Returns, Franchisor, Checks.
- **Franchise_Investor_Toolkit.docx**: the 8 checklists of Appendix 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), in editable form.

## Which sheet answers which chapter

- Chapters 3 and 4: Unit Economics (the prototype: $240,500 of mature unit EBITDA on $1,250,000 of cost, a cash-on-cash return of 19.2 percent, and the ramp)
- Chapter 3: Calderwick Today (24 units, sales of $44,800,000, adjusted EBITDA of $3,892,000, tier by tier and unit by unit)
- Chapters 5 to 7: FDD Reader (Vantrell's fees, Item 19 against Calderwick's $1,866,667 average, Item 20 openings, exits and transfers)
- Chapter 11: SBA Loan (a loan of $1,170,000, annual debt service of $185,540, coverage of 0.98x in year 1 and 1.30x when mature)
- Chapters 11 and 13: Deal (enterprise value of $23,352,000, total uses of $24,732,560, a senior loan of $11,676,000 and equity of $13,056,560)
- Chapter 14: Platform and Cash and Debt (year 5 EBITDA of $7,447,156; the tight year at $413,921 of year-end cash)
- Chapter 15: Exit and Returns (equity proceeds of $33,683,300: 2.58x and 20.9 percent before taxes and fund fees) and Franchisor (Vantrell's EBITDA of $19,155,000)
- Appendix A: 12 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, set labor at 31 percent of sales: watch mature unit EBITDA on Unit Economics, then the lowest year-end cash on Cash and Debt turn into a funding gap.
2. On Inputs, set same-store sales growth at 0 percent: watch year 5 EBITDA and the return on Exit and Returns. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Every input is on the Inputs sheet, including the figures copied from the disclosure document. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Every unit has the same cost structure as a share of sales, and returns are before taxes and fund fees: simplifications for teaching. Brannockfield Capital, Calderwick Restaurant Group, Vantrell Chicken and its disclosure document are fictional; sales levels, costs, fees, multiples, rates and dates are teaching assumptions, not market data, the terms or results of any real brand or a forecast. Provided as is, without warranty. Not legal, tax, accounting, lending or investment advice.
