Companion files · The GP Stakes Investor
How to Value, Structure and Exit Minority Stakes in Private Markets Managers, With the Model Supplied.
This is the companion file of the book. One workbook follows Vellacott Partners, the book's one manager, through one transaction: a stakes fund buys 20 percent of the management company for $80 million. It rebuilds the firm from its fund terms and reproduces every figure the book prints. No sign-up, no email is asked for, nothing is locked. Amounts are in millions of US dollars; blue type is an input, black type is a formula.
The archive holds the workbook and 00_START_HERE.md. No macros, no circular references, no external links. It recalculates in Excel, LibreOffice or Google Sheets.
Optional. When the workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
Chapters 1 to 17 · Appendix A
Each fund's fees, investments, exits and whole-fund waterfall; the firm's fees, costs and FRE year by year; the firm's share of carry; the balance sheet and its capital calls; the stake's cash flows; the sum of the parts; the bid, the IRR and the maximum price; the protected structure; the exit years and routes; and the Kestrel Lane interview case. A scenario selector switches between seven cases, and the Checks sheet sets each figure the book prints beside the cell that computes it.
Download the workbook150 KBRead first
What the file is, the conventions, how the scenario selector works and how to return to the book's base case.
Download the read-me2 KB| Fees and FRE | Year-1 management fees of $67.44 million and FRE of $28.58 million, a margin of 42.4 percent |
| Sum of the parts | The 20 percent stake is worth $93.13 million at component rates: FRE $59.40 million, carry $24.50 million, balance sheet $9.23 million |
| At the price | At $80 million the base case returns 16.76 percent and 3.24 times the money over ten years |
The file is provided as it is, without warranty of any kind. The model is illustrative: Vellacott Partners, its funds, the stakes fund and Kestrel Lane Credit are fictional, and the figures are the book's assumptions, not market statistics. Nothing here is legal, tax, accounting or investment advice.
Forty private markets interview questions with model answers and the arithmetic worked out. Direct download, no sign-up.
Get the cheat sheetDiscover more of Julian R. Sterling's practical library of models, checklists and worked cases.
Browse Julian R. Sterling's books Browse all companion filesMore in private equity and funds, with free companion files. The full list of titles is on the author page.