Companion files
Sourcing, Underwriting, Structuring and Building a Career in Growth Equity
These are the companion files of The Growth Equity Investor by Julian R. Sterling.The book on Amazon →
One Excel workbook that writes down the numbers Chapter 12 leaves in words. Around it, a blank version for your own fund, five working documents to print, forty questions that mark themselves, and three cases the book does not work. All free. Nothing is gated behind a sign-up, and no email address is asked for.
Six workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 22 September 2026.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? The Private Equity Career Pack: five PDF editions, from buyouts to venture capital, this book included, $59.99. See the pack →
The working models behind the books, built out for live deals: the Pro models →
Optional. When a 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.
Appendix C · Chapter 12
Chapter 12 states seven quantities in words — fifteen to twenty positions, a double-digit stake, an equal amount reserved alongside every initial dollar, two follow-on rounds — and not one figure in digits. The file runs those quantities, and four things come out that the chapter does not say.
A pro rata cheque costs less than the original one, not more. The chapter says exercising pro rata “costs real capital — often more than the original check, because the company is now more valuable”. On its own parameters round C costs half the initial cheque and round D three quarters. The explanation is the wrong half of the identity: a pro rata is your ownership times the round size, and size is dilution times valuation. Companies that get more valuable sell less. The sheet tabulates the break-even — at a twenty per cent round the company must be worth five times its entry valuation before the chapter’s sentence becomes true.
A one-to-one reserve is too tight and too loose at once. Defending one winner through both rounds costs 1.25× its cheque, against one times held back — so it does not stretch to the “lean in” promised in the same sentence. Across fifteen positions, where five never raise again, pure defence uses 48 per cent of the pool and leaves 155 idle. Both are true, and they point opposite ways.
Defending always costs you multiple. Same company, same exit: 7.65× undefended against 5.00× defended, while the internal rate of return barely moves — 40.4 against 40.8 per cent. That is mechanical, not incidental. Follow-on dollars are bought above the entry price by construction, so there is no exit value at which defending improves the multiple. Reserves buy profit dollars and scale; they do not buy multiple.
And there is a band where defending loses money outright. Below an exit of about 520 the follow-on dollars come back worth less than they cost — and at that exit the company is worth nearly four times its entry valuation and the original cheque is still returning 2.66×. The ordinary good-but-not-great outcome, in which defending converts a solid winner into a worse one.
The last sheet tests the sentence at the centre of the chapter, that reserves shape returns “as much as picking winners does”. Like for like, a fund with no reserve owns 36 per cent more of the identical company set — and the one-to-one fund’s idle reserve closes that gap at 1.02× what it has left. Break-even, almost exactly. Which makes it not a parallel claim but the same claim: a reserve is worth the selection quality of the follow-on decision and nothing else. Twenty-four checks.
Download the workbook26 KBChange the round C dilution from twenty per cent to thirty and watch the break-even step-up fall from five times to three and a third — the only condition under which the chapter’s sentence about pro rata is true is a company selling a lot of itself at a high price, which is a distressed round, not a good one. Then drop the exit to four hundred and read the last two columns of the band sheet: the follow-on dollars return seventy-seven cents while the original cheque returns two times, and nothing about the company has gone wrong.
It cannot tell you which names will raise again, which is the input the whole reserve question turns on and the one nobody knows at fund formation. It cannot price access — a fund may defend its ownership to keep a seat rather than to make money on the marginal dollar, and that can be right for reasons no multiple captures. And it deliberately gives neither fund any selection skill, because the moment you assume an edge on follow-ons you have assumed the answer. The point of the like-for-like is to show what a reserve is worth before the edge, so that the edge has to be argued rather than presumed.
The workbook with every input emptied. Enter your own fund and company; the checks sheet counts what is still missing and runs eight tests that hold for any inputs.
Chapter 12 and Appendix C
Fund size, positions, reserve ratio, entry ownership, two follow-on rounds, the exit. The file gives the initial cheque, the pro rata cheques, the defended and undefended multiples, the exit below which the follow-on dollars lose money, and what the reserve is worth against picking winners. One line tells you whether the pro rata is below the initial cheque on your inputs: the chapter says it is often above.
The book’s inputs are listed in a text file inside the archive. Type them back in and the file returns 7.65 against 5.00, and a break-even exit of 520.8.
Download the blank set23 KBFive pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Appendix B · Chapters 4, 7, 9, 10, 11 and 15
The checklist of Appendix B, question by question. The six-test readiness screen of Chapter 4 with every Chapter 7 metric, reported against rebuilt. A return model that gives the walk-away price in two divisions, with a waterfall at three exits. A diligence plan in five workstreams, each with a hypothesis and a dealbreaker named in advance. And the first ninety days on a growth team.
Download the PDF15 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Eight on the foundations and the return identity, seven on unit economics, seven on valuation, five on structure, six on reserves and seven on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book18 KBNew material, not a restatement. Three situations the chapters name in passing and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Chapters 10 and 14 · Case one
You own 21.25 per cent after a series C at 400 million, marked at 2.83 times your money. The company sells for 150 and you get your money back, 1.00x. A 1x non-participating round converts exactly at its own post-money, so every sale below the last round’s price is decided by the stack, not by ownership. A participating series C would take another 7 to 13 million from you.
Chapters 7 and 11 · Case two
Chapter 11’s company, in numbers. Net retention is 120 per cent blended and 101 per cent for everyone but three accounts, which produce 96 per cent of the base’s net growth. If they simply stop expanding, next year’s growth falls from 50 per cent to 21. The chapter 7 company is recomputed too: its Rule of 40 score is 15, not the 30 the chapter prints, and its conclusion holds more strongly.
Chapter 9 · Case three
The chapter asks for the walk-away price and never solves it. With a 2.5x base bar and money back in the bear case, it is 346.8 million, and both bars bind at once. The chapter is right to decline the 360 ask, by 13 million, not 60. Raise the base bar to 3.0x and its own 300 fails.
Download the three cases36 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | twenty-four controls, each stating its own verdict — three of them structural |
Every figure is illustrative, as everything in the book is. The fund, the company, the rounds and the exit are invented. The arithmetic is not — and one of the checks exists precisely because it disagrees with the chapter.
The workbook opens in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. It uses no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 22 Sep 2026 | A blank version of the reserves model, five working documents on five pages, forty questions that mark themselves and three new cases. The book’s workbook can now also be downloaded on its own; its content has not changed. |
More in private equity and funds, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: pro rata and dilution calculator.
The Growth Equity Investor develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books · Google Play ยท DRM-free PDF edition ($19.99).
These files accompany The Growth Equity Investor. The book is on Amazon.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.