A free evergreen vs drawdown fund return calculator in Excel
The liquidity sleeve drag, two share classes, a closed-ended fund's IRR on called and on committed capital, the point where the comparison reverses, PME and unsmoothed volatility: eight sheets, every figure a formula.
A drawdown fund that reports a 16.99% IRR on called capital earns 10.42% a year on the capital an investor had to commit, because the uncalled money waits in cash. Against an evergreen fund netting 8.64%, 79% of the apparent advantage disappears. A drawdown fund advertising 13.25% only ties.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This model goes with The Evergreen Fund Handbook, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
8 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
Sleeve drag
What the liquidity option costs, and how it decomposes.
Share classes
The same portfolio, two fee loads, and the gap between them.
Drawdown fund
The call and distribution schedule, the headline IRR, and the multiple.
Committed capital
The year-by-year run that turns the headline into an honest number.
Sensitivity
Where the comparison reverses, and the point of indifference.
PME
Public market equivalent on called and on committed capital.
Volatility
What unsmoothing does to a standard deviation built on appraisals.
Checks
Every figure in Appendix K, tested against the sheets above.
What the worked case returns
Measure
Value
Sleeve drag (bps)
164
Blended gross return
10.76%
Evergreen, institutional class, net
8.64%
Evergreen, retail class, net
7.55%
Gap between the classes (bps)
109
Drawdown fund TVPI
2.30x
Drawdown IRR on called capital
16.99%
Rate on committed capital
10.42%
Drawdown IRR that ties with the evergreen
13.25%
PME on called capital
1.45x
PME on committed capital
1.14x
Unsmoothed volatility
10.55%
The headline gap compares a rate earned on called capital with a rate earned on all of the investor's money. Put both on committed capital and the drawdown fund's lead shrinks from 8.35% to 1.78%.
How to use it on your own case
Enter the private portfolio return, the liquidity sleeve return and its weight on Sleeve drag.
Set the fee loads of each share class on Share classes.
Enter the drawdown fund's calls and distributions and the cash rate earned by uncalled capital.
Read the honest gap on Committed capital and the point of indifference on Sensitivity.
Questions people ask about it
Can you compare an evergreen fund's return with a private equity IRR?
Not directly. The evergreen return is earned on all the money invested; the drawdown IRR is earned only on capital called. The file restates the drawdown fund on committed capital so the two can be compared.
What is the sleeve drag of an evergreen fund?
The return given up by holding part of the fund in liquid assets to meet redemptions: the sleeve weight times the difference between the private portfolio return and the sleeve return.
Why unsmooth the volatility?
Returns built on appraisals move less than the assets beneath them. Unsmoothing for the correlation of each return with the previous one gives a volatility closer to the economic risk.
Is this template really free?
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Go further
The free workbooks of The Evergreen Fund Handbook go further: the full companion set, blank models and the worked cases of the book.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
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 template stays free either way.