Companion files
Perpetual Capital, Liquidity and the Semi-Liquid Fund
These are the companion files of The Evergreen Fund Handbook by Julian R. Sterling.The book on Amazon →
One Excel workbook that settles an argument the industry has been having without arithmetic, now corrected. Around it, a blank version for your own fund, eleven 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.
Chapter 20, and Appendix K
Chapter 20 says a closed-ended fund reporting 17 per cent and an evergreen fund reporting 10 may be delivering identical outcomes, and that comparing them on committed capital narrows the gap substantially and sometimes reverses it. That is right, and it is the evergreen manager’s strongest argument. It is also almost never made with numbers attached.
Here are the numbers. A closed-ended fund at 2.30× reports a 16.99 per cent internal rate of return. Run the same fund against the investor’s whole commitment — uncalled capital in cash at the same rate the evergreen sleeve earns — and it delivered 10.42 per cent. Against an evergreen fund netting 8.64, the gap falls from 8.35 points to 1.78. Four fifths of the apparent advantage was never an advantage; it was the arithmetic of measuring one fund on the money it happened to be using and the other on all the money the investor had to set aside.
Solve for the point of indifference and you get the sentence worth carrying out of the whole exercise. A closed-ended fund advertising 13.25 per cent does not beat an evergreen fund netting 8.64. It ties with it. Every point below that is a loss to the evergreen fund, measured on the capital the investor actually committed.
Download the workbook30 KBWhat the sleeve costs. A 20 per cent sleeve earning 4.20 against a private portfolio earning 12.40 drags 164 basis points a year. Nobody collects it, it appears in no expense ratio, and it costs more than the management fee. It is the price of the redemption option, and Chapter 20 is right that it is the figure investors most want and most rarely receive.
What the share class costs. The same portfolio, on the same day: the institutional class nets 8.64 per cent and the retail class 7.55. A gap of 109 basis points, and 22 units of terminal wealth on a stake of 100 over ten years. Note the trap in the fee table — the retail class pays a smaller performance fee, precisely because it earned less.
What the PME hides. The conventional Kaplan-Schoar public market equivalent is 1.45×. Computed on committed capital, where the uncalled drag is visible, it is 1.14×. The standard measure overstates by 0.31 turns — a larger distortion than most of the methodological arguments it gets deployed to settle.
What the volatility hides. A 6.50 per cent standard deviation computed from appraised NAVs, with a first-order autocorrelation of 0.45, unsmooths to 10.55 per cent. The reported figure understates variability by nearly two fifths, and every Sharpe ratio built on it is 1.62 times what it should be: 0.683 reported, 0.421 unsmoothed. The first edition of the workbook said 12.96 and “twice”; its factor squared the autocorrelation where it should not have.
Change the cash rate. It moves both sides of the comparison at once — the evergreen sleeve earns it, and the closed-ended investor’s uncalled capital earns it. Drop it to one per cent and the committed-capital argument swings hard back toward the closed-ended fund. Which is exactly what happened to this argument through the 2010s, and why it is a better argument now than it was then. Worth knowing which way the wind is blowing before building a pitch on it.
Two caveats, both of which cut against the evergreen fund, and both of which anyone using this argument will be asked about. A mature allocator does not leave uncalled capital in cash — distributions from earlier vintages fund later calls, and once a programme is self-funding the drag largely disappears; the comparison here describes an investor with one commitment, not a running allocation. And all of it assumes the evergreen fund’s gross return is the same asset return as the closed-ended fund’s. If the need for liquidity pushes it toward larger, more intermediated deals, the comparison shifts before any of the arithmetic begins. Case one below takes the second caveat to a number: to pay 2.30× net, the appendix’s closed-ended fund must earn about 21.3 per cent gross, not 12.40.
The workbook with every input emptied. Enter your own fund and the drawdown fund you are compared with; the checks sheet counts what is still missing and tests what holds for any inputs.
Chapter 20 and Appendix K
The private portfolio’s gross return, the sleeve and its cash rate, the fees of each share class, the comparator’s calls and distributions, the index for the public market equivalent, and the appraisal series’ volatility and autocorrelation. The file gives the sleeve drag, the class gap, the headline and committed-capital returns, the IRR at which the drawdown fund merely ties, both PMEs and the unsmoothed volatility.
The book’s inputs are listed in a text file inside the archive. Type them back in and the file returns 8.64 and 7.55 per cent, 164 basis points of drag, the tie at 13.25 per cent and an unsmoothed volatility of 10.55 per cent.
Download the blank set31 KBEleven pages to print and use. A4, with margins wide enough for US Letter.
Chapters 4, 6, 9 to 11, 13, 14, 16, 18, 19, 21 · Appendices A to H
The Appendix A product design decision sheet, a reason on every row. The liquidity plan, quarter by quarter, base and stressed, from each of the four sources. The sleeve sized three ways, with its composition and the facility treated as a bridge. The Appendix B stress test with its three outputs and the gap to the gate. The monthly board dashboard. Valuation governance, where the mark is the price. The redemption processing runbook for an oversubscribed quarter. The investor letter for the quarter the cap binds. The allocation record. The operational due diligence question set. And the five fair-treatment numbers with the total cost, class by class.
Download the PDF30 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on the structure, eight on the engineering of the sleeve and the gate, seven on fairness, tools and leverage, six on allocation through operations and the board, six on assessment, performance, what goes wrong and Appendix K, 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 book17 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 20 and Appendix K · Case one
Appendix K’s own caveat, priced. Put a plain drawdown fund, 1.5 per cent a year and 20 per cent carry, around the evergreen fund’s own 12.40 per cent asset: it headlines 8.90 per cent and delivers 6.52 on the whole commitment. The evergreen fund wins by 2.12 points in the institutional class and 1.03 in the retail class. To pay the appendix’s 2.30× net, the drawdown fund needs about 21.3 per cent gross: the appendix compared two assets, not two wrappers.
Chapter 22 · Case two
Brookvale’s first difficult quarter, checked before it is extended. Its figures describe three different funds: the payment implies a NAV of €2,380 million, the levy €3,000 million, the fall in the sleeve about €1,027 million. At a NAV of €1.2 billion the fund pays €60 million without touching the sleeve, which ends three quarters at 21.6 per cent. If none of the amortisation is free, the sleeve carries everything and falls to 7.7 per cent after the second quarter, through its floor: the quarter the chapter should have modelled.
Chapters 4, 11 and 18 · Appendix B · Case three
The gap between the reverse stress level and the gate, the metric the book calls the most informative a board can see, computed for two funds. In the severe case, credit supports 4.9 per cent a quarter and buyout 3.2, against a 5 per cent cap: gaps of -0.1 and -1.8 points. At the cap for four severe quarters, the buyout fund falls through its floor in the third. The credit fund’s cap has no margin for its assumptions being wrong; the buyout fund must choose its answer in advance.
Download the three cases94 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | twenty-seven controls, each stating its own verdict |
Every figure is illustrative, as everything in the book is. What is not illustrative is the shape of the result, which holds for any plausible set of inputs. The workbook was verified by headless recalculation rather than by trusting the formulas as written; all twenty-seven checks pass.
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 unsmoothing factor is √(1+ρ)/√(1−ρ), 1.6237 at an autocorrelation of 0.45, so the unsmoothed volatility is 10.55 per cent, not 12.96, and the Sharpe ratio falls to 0.421, not 0.343; the tie multiple on the committed-capital sheet is now a formula. Added: a blank version, eleven working documents, forty questions that mark themselves and three new cases. The workbook can now also be downloaded on its own. |
9 of the calculations in this workbook, worked out in full. All articles.
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: evergreen vs drawdown fund calculator.
The Evergreen Fund Handbook develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on AmazonAlso as an ebook on Apple Books · Google Play ยท DRM-free PDF edition ($19.99).
These files accompany The Evergreen Fund Handbook. 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.