Companion files · The Private Markets Career Guides

The Sports Team Investor

How Private Equity Funds and Family Offices Invest in Franchises and Clubs: League Rules, Minority Stakes, Media Rights, Valuation, European Football, Women’s Sports, Exits and the Career.

These are the companion files of the book. One workbook rebuilds the Corrandale Sports Fund I case: the Herons revenue by category, costs, distributions and cash yield, the entry and exit valuations and the value bridge, the debt sensitivity, the fund’s calls and fees, the squad cost ratios of two football clubs, the promotion and relegation scenarios, the Larkspur trade and mark, and the fund’s gross and net returns. A toolkit holds the fourteen checklists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive81 KB

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.

The files

Three numbers to reproduce first

The Herons, an NBA stake$225.0 million for 7.5 percent at 10.0 times revenue, sold at 12.5 times revenue for proceeds of $409.30 million: a MOIC of 1.83x and an IRR of 15.4 percent
Ashcombe, a Championship clubA squad cost ratio of 120.0 percent; the fund’s Meridale stake at $168.0 million if the club is promoted, $82.0 million if it stays and $52.2 million if it is relegated
The fund at 30 September 2026$1,053.30 million called, $412.75 million distributed and $958.0 million of net asset value: a gross IRR of 11.8 percent, a net IRR of 8.0 percent and a net TVPI of 1.28x after accrued carry

The files are provided as they are, without warranty of any kind. The model is illustrative: Corrandale Partners, the Westmarch Herons, Meridale Football Group, Larkspur FC and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the figures are the book’s assumptions, not benchmarks. Nothing here is investment, legal or tax advice.

Also by Julian R. Sterling

More in private equity, with free companion files. The full list of titles is on the author page.

Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.