# The Sports Team Investor: companion files

Julian R. Sterling

## What is here

- **Sports_Team_Investor_Model.xlsx**: the workbook that rebuilds the Corrandale Sports Fund I case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Herons Revenue, Herons Costs and Distributions, Franchise Valuation and Bridge, Debt Sensitivity, Fund Cash Flows and Fees, Squad Cost Ratio, Promotion and Relegation, Larkspur Valuation, Exit and Returns, Checks.
- **Sports_Team_Investor_Toolkit.docx**: the fourteen checklists of Appendix B (league eligibility checklist, approval and vetting file checklist, shareholder agreement checklist, revenue file checklist, media rights checklist, cost and payroll checklist, valuation checklist, debt and leverage checklist, arena and real estate checklist, european football checklist, women's sports checklist, quarterly valuation checklist, exit checklist, investor reporting checklist), in editable form.

## Which sheet answers which chapter

- Chapters 5 and 6: Herons Revenue (revenue from $330.0 million in 2021-22 to $465.0 million in 2025-26; national media and league distributions 34.8 percent of revenue, then 44.1 percent; local media down from $45.0 million to $18.0 million)
- Chapter 7: Herons Costs and Distributions (EBITDA margin from 12.7 percent to 19.6 percent; $3.45 million of distributions to the fund in four years; a cash yield of 0.40 percent on cost)
- Chapter 8: Franchise Valuation and Bridge (entry at 10.0x revenue and 78.6x EBITDA, exit at 12.5x revenue; revenue growth added $1,350.0 million and the multiple $1,162.5 million)
- Chapter 11: Debt Sensitivity (had team debt been $475.0 million at the sale, proceeds of $396.31 million, $12.99 million less, and an IRR of 14.6 percent)
- Chapter 12: Fund Cash Flows and Fees ($5.25 million of management fees a quarter; $1,053.30 million called at 30 September 2026)
- Chapter 13: Squad Cost Ratio (Ashcombe at 120.0 percent; Vestrand at 68.2 percent against a 70.0 percent limit, 85.7 percent without player sales)
- Chapter 14: Promotion and Relegation (Meridale marked at $82.0 million, 0.91x; the stake at $168.0 million if Ashcombe is promoted, $52.2 million if relegated)
- Chapter 15: Larkspur Valuation (marked at $51.0 million, 1.70x and an IRR of 22.8 percent; the trade price at 7.1x 2026 revenue and 3.8x 2029 plan revenue)
- Chapter 16: Exit and Returns (Herons proceeds of $409.30 million, MOIC 1.83x, IRR 15.4 percent; fund gross IRR 11.8 percent, net IRR 8.0 percent, net TVPI 1.28x)

## Two inputs to change first

1. On Inputs, change the Herons exit multiple: watch the value bridge, the proceeds, the MOIC and the IRR move, then the fund's DPI and net IRR on Exit and Returns.
2. On Inputs, change the probability of Ashcombe's promotion (and the Championship probability so that they still add to 100 percent): watch the weighted stake move on Promotion and Relegation while the mark stays where it is. 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. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Corrandale Partners, Corrandale Sports Fund I, the Westmarch Herons, Meridale Football Group, Ashcombe Athletic, Vestrand FC, CD Alvarim and Larkspur FC are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case figures are illustrative assumptions, not benchmarks. Provided as is, without warranty. Not investment, legal or tax advice.
