Free Excel templates

A free DPI, TVPI and net IRR template in Excel

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.

Get the book on Amazon → Or the DRM-free PDF edition, $19.99

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada.

Want every model at once?

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).

Get the Library, $79 →

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

MeasureValue
Paid-in capital (millions)255
Distributions (millions)310
Net asset value (millions)145
DPI1.216x
RVPI0.569x
TVPI1.784x
Net IRR, NAV treated as a sale18.04%
Net IRR on realised cash alone7.12%
Point-to-point IRR over the last three years20.14%
Public market equivalent (KS-PME)1.323x
Net IRR with a six-month subscription line19.20%
TVPI with the line1.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

  1. Enter each year's calls and distributions, the commitment and the latest NAV on the Cash flows sheet.
  2. Read DPI, RVPI and TVPI on Multiples, and the share of value that is still a mark.
  3. Compare the two IRRs on The two rates: with the NAV as a sale, and on realised cash alone.
  4. 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.

See the book and its free files →

Other free templates

This template goes with Private Equity Investor Relations. 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 template stays free either way.