Valuation and returns · in 1 model

Fund performance: TVPI, DPI, RVPI, IRR and the J-curve

Net and gross multiples and IRR by year, gross to net.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: fund performance: tvpi, dpi, rvpi, irr and the j-curve.Updated 11 November 2026

Part of m&a and private equity models, with the models, labs and guides around it.

What it does

How a fund is judged while it is still running and after it ends. The measures are multiples of paid-in capital: DPI is the cash distributed, RVPI the net asset value still held, and TVPI their sum. The IRR to date treats that net asset value as if it were received today. Plotted by year they trace the J-curve: below 1.0x and negative at first, when fees have been paid and investments sit near cost, then rising as value is marked up and finally realised. Gross figures are measured on the investments alone; net figures are the investors’, after the management fee, fund expenses and carry, and a bridge between the two says what each cost.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Private equity fund model: cash flows, J-curve and waterfall
  • Performance, rows 6–9: Capital called from LPs, Distributions to LPs, LP net cash flow, LP net cash flow to date
  • Performance, rows 12–19: Paid-in capital, LPs, Distributions to LPs to date, LP share of net asset value after accrued carry, DPI: distributions / paid-in capital…
  • Performance, rows 22–26: Investment cash flow: proceeds less capital invested, Capital invested to date, Proceeds realised to date, Gross multiple to date: (proceeds + NAV) / capital invested…
  • Performance, rows 29–41: Gross multiple of invested capital, Gross IRR, Net TVPI, Net IRR to LPs…
  • Performance, rows 44–48: Gross multiple of invested capital, Management fee, Fund expenses, Carried interest…
  • Performance, rows 51–58: Investment cash flow after the management fee, And after fund expenses: distributions less calls, Gross IRR, Management fee…

What a reviewer looks for

  • Net multiples on invested and not paid-in capital.
  • An interim IRR quoted without saying how much of it is unrealised.
  • Gross and net IRR compared with no bridge, so the cost of the fee and of the carry cannot be told apart.

Learn it, then build it

Vocabulary: TVPI, DPI and RVPI, J-Curve, IRR, MoIC.

Other valuation and returns