Companion files
Sourcing, Underwriting, Structuring and Living With Co-Investments
These are the companion files of The Co-Investment Practitioner by Julian R. Sterling.The book on Amazon →
One Excel workbook that prices what Chapter 11 leaves as a warning, now corrected. Around it, a blank version for your own programme, ten 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? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
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 F · Chapter 11
Chapter 11 tells you to “build a reserve policy into your program before the first deal, not after the first painful round”, and never says how much. This file says how much — and the answer turns out to depend on one clause, not on your portfolio.
First, dilution is not the loss the chapter says it is. You own 2.50 per cent of a company at 400. It misses plan and raises at a 200 pre-money. Don’t follow, and you hold 1.667 per cent. The chapter calls that a stake “heavily eroded”. Compute it: 2.50 per cent of 200 is 5, and 1.667 per cent of 300 is 5. Nothing was taken from you. The markdown did the damage, and it hit the investors who wrote follow-on cheques just as hard.
What you give up is an option, and it has a price. The follow-on dollars return 2.33× at a 700 exit — but that money could go into another co-investment at Chapter 3’s 2.00×. Measured against that, following on wins only above an exit equity of 600: twice the mark the rescue round just set, in a company that missed plan badly enough to need rescuing.
Then change one clause. Add a 1× participating preference on the new money and halve non-participants’ units, and the non-participant goes from 1.17× to 0.50×, the marginal return jumps to 5.00×, and the break-even collapses to 250 — below the round’s own post-money. Same asset, same exit. Nothing about the company changed.
And that is the trap. Across a ten-deal programme with no reserve, the clause costs a quarter of a turn of multiple — 1.667× falls to 1.400× — while making every individual follow-on look more obviously correct. The marginal-dollar test cannot see it. Only the programme number can, and by then the money is spent.
The last sheet sizes the reserve properly, as an expectation over the binomial distribution of how many companies come back. Under plain dilution the optimum is 9.1 per cent, exactly enough to fund four raisers, and worth 0.04×; fifteen per cent is worth half that and twenty per cent loses money, because past the optimum a reserve moves capital out of a 2.00× sleeve into a 1.09× one. Under pay-to-play the optimum is 13.0 per cent, six raisers, and worth 0.29× — about Chapter 3’s entire fee-and-carry saving of 0.28×. Fifteen times the value, same portfolio, one clause. Twenty-four checks.
Download the workbook26 KBSet the probability of a follow-on to zero and check that the programme returns exactly 2.00×. That is Chapter 3’s headline for a no-fee co-investment, and it is the control on the whole file — if it does not hold, nothing else in the workbook should be believed. Then walk the reserve policy from five per cent to twenty-five and watch the value of the reserve rise, peak and go negative under plain dilution while staying comfortably positive under pay-to-play. The two curves are the argument.
It cannot tell you the probability that a given company comes back for money, which is the input the whole reserve question turns on and the one nobody knows at programme design. It assumes the rescued companies exit worse than the ones that never needed rescuing — change that and the case for following on strengthens sharply, so the exit assumption is worth stressing in both directions. And it gives you no edge in choosing which follow-ons to fund; the moment you assume one, you have assumed the answer. The point of the sizing sheet is what a reserve is worth before any edge, so that the edge has to be argued rather than presumed.
The workbook with every input emptied. Enter your own cheque, round and exit, and the clause in your own shareholders’ agreement; the checks sheet counts what is still missing and tests what holds for any inputs.
Chapter 11 and Appendix F
Your cheque and the entry equity value, the programme, the chance a deal comes back for money, the round’s pre-money and new money, the exits, the idle return, your alternative use of a dollar, the clause and the reserve policy. The file gives what dilution does on the day, the break-even exit for following on under both regimes, the cost of the clause to the programme and what your reserve is worth.
The book’s inputs are listed in a text file inside the archive. Type them back in and the file returns the 600 and 250 break-evens and a fifteen per cent reserve worth +0.019 and +0.285 turns.
Download the blank set25 KBTen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 4 to 7, 10 to 15 · Appendices A and B
The readiness assessment of Chapter 4, with its five questions and three verdicts. The mandate with numbers in it, and the limit grid measured look-through. The governance ladder with its service levels and exception log. The first-48-hour early read with the signals that tell excess from a deal nobody wanted. The Appendix A checklist. The Appendix B timeline and the decision memo. The return bridge with the eight modelling traps. The terms that move the return, led by the pay-to-play question. The position file. And the pipeline log with the deal journal.
Download the PDF28 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, seven on building the machine, seven on underwriting and the return bridge, seven on terms, the portfolio and Appendix F, five on life after the close through to the career, and six 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 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.
Chapter 3 · Case one
Chapter 3 says a co-investment can be a somewhat worse asset than the fund’s average and still come out ahead, “but only up to a limit”, and never gives it. On its own deal the limit is 0.28× of gross multiple, the whole fee and carry. At most about 19 per cent of accepted deals can be the 0.5× ones nobody wanted. The cushion shrinks with the deal, to 0.10× at a 1.00× gross, and halves on reduced-fee terms.
Chapters 3 and 12 · Case two
Chapter 3’s LP who drew four ordinary results and lagged its fund book, priced. With outcomes spread the way the chapter describes and an average of 2.00×, one no-fee deal lags the fund’s 1.72× one time in five; four deals lag 28.6 per cent of the time, more often than one. Ten deals still lag 22 per cent of the time, thirty 11. Diversification removes the chance of losing money fast and the chance of lagging slowly.
Chapters 4, 10 and 12 · Case three
Chapter 4 says one impaired co-investment can erase the fee savings of a dozen good ones. At standard size a zero erases 3.6 deals’ savings counted on capital, 7.1 counted on expected value. A dozen needs a cheque 1.68 to 3.36 times the standard: the claim describes a maximum-sized check. Counting what you already own through the fund adds a quarter, and a loss budget written in deals’ savings turns “size to the downside” into a cheque.
Download the three cases123 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 company, the round, the clause and the exit are invented. The arithmetic is not — and two of the checks exist precisely because they disagree 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 | The book’s workbook corrected: the preference on the new money is labelled participating, as the arithmetic always assumed, and the optimum reserves are 9.1 and 13.0 per cent, the points that fund exactly four and six raisers. Added: a blank version, ten working documents, forty questions that mark themselves and three new cases. The workbook can now also be downloaded on its own. |
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: co-investment follow-on and reserve model.
The Co-Investment Practitioner 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 Co-Investment Practitioner. 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.