Eight years of one fund's calls and distributions turned into DPI, RVPI, TVPI, the net IRR with the valuation and on realised cash alone, a point-to-point IRR, a public market equivalent and the effect of a subscription line: six sheets, no macros.
The fund called 255 million of a 300 million commitment, returned 310 million and still carries 145 million at NAV. TVPI is 1.78x, DPI 1.22x. Treat the NAV as a sale and the net IRR is 18.04%; on realised cash alone it is 7.12%. The gap is the question every limited partner is really asking.
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.
Fund_Performance_DPI_TVPI_IRR.xlsx (21 KB)
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 Private Equity Investor Relations, 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
6 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
Cash flows
The eight years. Amber cells are yours.
Multiples
DPI, RVPI, TVPI, and what each one answers.
The two rates
With the valuation, and on realised cash alone.
Other lenses
Point to point, public market equivalent, undrawn commitment.
Subscription line
The rate it buys and the multiple it costs.
Checks
Thirteen controls that test themselves and say so.
What the worked case returns
Measure
Value
Paid-in capital (millions)
255
Distributions (millions)
310
Net asset value (millions)
145
DPI
1.216x
RVPI
0.569x
TVPI
1.784x
Net IRR, NAV treated as a sale
18.04%
Net IRR on realised cash alone
7.12%
Point-to-point IRR over the last three years
20.14%
Public market equivalent (KS-PME)
1.323x
Net IRR with a six-month subscription line
19.20%
TVPI with the line
1.770x
31.9% of total value rests on the manager's own marks. That is why the two IRRs sit 10.9 points apart, and why a subscription line can add 1.2 points of IRR while it takes value away: the interest on the line is real money.
How to use it on your own case
Enter each year's calls and distributions, the commitment and the latest NAV on the Cash flows sheet.
Read DPI, RVPI and TVPI on Multiples, and the share of value that is still a mark.
Compare the two IRRs on The two rates: with the NAV as a sale, and on realised cash alone.
Enter an index return to get the public market equivalent, then a call deferral to see what a subscription line does to IRR and TVPI.
Questions people ask about it
What is the difference between DPI and TVPI?
DPI counts only the cash a fund has paid back, divided by the capital called. TVPI adds the remaining net asset value, so it mixes realised cash with the manager's own valuation.
Why compute the IRR without the NAV?
Because the closing valuation is an estimate. The IRR on realised cash alone shows how much of the reported return has actually been paid out; the gap between the two is a measure of how much depends on the marks.
Does a subscription line improve fund performance?
It raises the IRR by delaying capital calls, but it lowers the multiple because the line's interest is a cost. The file shows both effects on the same fund.
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 Private Equity Investor Relations 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.