Companion files · The Private Markets Career Guides
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 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 5 to 16
One Inputs sheet holds every case assumption: the fund terms, the Herons revenue and costs by season, team debt and the entry and exit multiples, the Meridale club figures and the Ashcombe scenarios, and the Larkspur capital, trade and plan. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook44 KBAppendix 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 and investor reporting checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me4 KB| 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 club | A 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.
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.