Companion files · The GP Stakes Investor

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 workbook and the read-me, in one archive136 KB

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.

Get an email if these files are corrected

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 list

Run by MailerLite, off this site. How your address is used.

The files

Three numbers to reproduce first

Fees and FREYear-1 management fees of $67.44 million and FRE of $28.58 million, a margin of 42.4 percent
Sum of the partsThe 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 priceAt $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.

Free: the Private Markets Interview Cheat Sheet

Forty private markets interview questions with model answers and the arithmetic worked out. Direct download, no sign-up.

Get the cheat sheet

Explore the full companion library

Discover more of Julian R. Sterling's practical library of models, checklists and worked cases.

Browse Julian R. Sterling's books Browse all companion files

Also by Julian R. Sterling

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