Articles

How do you calculate the Kaplan-Schoar PME?

The Kaplan-Schoar public market equivalent worked on an eight-year fund, with the Excel formula, the sensitivity to the index, and the price index trap.

Grow every distribution and the final NAV to the measurement date at the public index's total return, grow every capital call the same way, and divide the first sum by the second. On an illustrative eight-year fund with a 12.09 per cent IRR and a 1.75x TVPI, the future value of what it returned is 191.57 against 156.18 for what it called: a Kaplan-Schoar PME of 1.227. The fund returned 22.7 per cent more than the same cash invested in the index would have.

Worked in full in Private Markets Performance by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →

A fund's IRR on its own says nothing about whether private equity was worth the illiquidity. The Kaplan-Schoar public market equivalent answers that question with a single ratio: above 1.0 the fund beat the index on the same cash flow timing, below 1.0 it did not. It is the standard first test in a limited partner's benchmarking pack, and it takes one column of index levels to compute.

The fund and the index

Illustrative fund cash flows, per 100 of commitment, and a total return index. Flows assumed at year end.
YearCallsDistributionsIndex returnIndex levelGrowth factor to year 8
0300100.01.706
125012%112.01.523
2200−8%103.01.656
315518%121.61.403
4101510%133.71.276
50306%141.81.203
603515%163.01.046
7030−4%156.51.090
80209%170.61.000
Total100135

The fund also holds a NAV of 40.0 at year 8. Its DPI is 1.35x, its TVPI 1.75x and its IRR 12.09 per cent. The index compounds at 6.90 per cent a year over the eight years.

The calculation, step by step

KS-PME = [Σ Dt × (IT ÷ It) + NAVT] ÷ Σ Ct × (IT ÷ It)

Future value of distributions: 5 × 1.403 + 15 × 1.276 + … + 20 × 1.000 = 151.57. Add the NAV: 191.57.

Future value of calls: 30 × 1.706 + 25 × 1.523 + 20 × 1.656 + 15 × 1.403 + 10 × 1.276 = 156.18.

KS-PME = 191.57 ÷ 156.18 = 1.227.

In Excel, with calls in B, distributions in C and index levels in E, rows 2 to 10, and the NAV in F10: =(SUMPRODUCT(C2:C10,$E$10/E2:E10)+F10)/SUMPRODUCT(B2:B10,$E$10/E2:E10).

The growth factor is the only new column. It converts every flow into money at the measurement date, as if each call had been taken out of the index and each distribution put back into it. Once everything is in the same date's money, the ratio needs no discount rate and no IRR, which is why early distributions cannot inflate it the way they inflate an IRR.

Reading the result

A KS-PME of 1.227 means that for every unit of index-equivalent value the calls would have produced, the fund produced 1.227. In money, the fund created 35.40 more than an index investment with the same timing, measured at year 8. It is a multiple, not a rate: it does not say how fast the outperformance accrued, and a 1.227 earned over four years is a far better result than the same figure over twelve.

The NAV is 20.9 per cent of the numerator, so the result still depends on an unrealised mark. If the 40.0 NAV were marked down 20 per cent, to 32.0, the PME would be 1.175, not 1.227. Report the share of the PME that is realised alongside the number.

What if the index had done better

KS-PME with every annual index return shifted by the same amount.
Shift in index returnIndex CAGRKS-PME
−4 points2.89%1.479
−2 points4.90%1.345
None6.90%1.227
+2 points8.91%1.121
+4 points10.92%1.025

The fund stops beating the index at a shift of 4.58 points, an index CAGR of 11.49 per cent, below its own 12.09 per cent IRR. The path matters as well as the average: an index compounding smoothly at 6.90 per cent gives a PME of 1.261, not 1.227, because the real index rose fastest in the years when the fund's calls were still invested in it. An index growing at a constant rate equal to the fund's IRR gives exactly 1.000, by construction. Comparing the IRR with the index CAGR is therefore not a substitute for the PME.

The common mistake

Using a price index instead of a total return index. Private equity distributions are cash returned to the investor, so the public alternative has to include its dividends too. With a dividend yield of 2 per cent left out, the index ends at 146.6 instead of 170.6 and the PME comes out at 1.345, overstating the fund by 0.119. Check the index ticker before checking anything else: a price index is the default series in most data terminals.

Match the timing. Annual buckets are used here for readability. On real data use the actual flow dates and daily or monthly index levels; a call booked at year end that was drawn in January is grown at the wrong factor.

Takeaway

Future value of distributions plus NAV, over future value of calls, both at the index's total return: 1.227 here. Read it with its realised share and its period, and always against a total return series. The free PME calculator for this book computes Kaplan-Schoar alongside Long-Nickels, PME+ and Direct Alpha on one set of flows, the PME calculator template does the same for your own fund, and a companion article on Direct Alpha turns the ratio into an annual rate.

Questions readers ask

What is a good Kaplan-Schoar PME?

Anything above 1.0 means the fund beat the index on the same cash flow timing; the size that counts as good depends on the period. An illustrative fund at 1.227 over eight years produced 35.40 more than the index per 100 committed. Read the PME together with its realised share, since an unrealised NAV of 40.0 here is 20.9 per cent of the numerator.

Why is my PME below 1 when the fund IRR beats the index return?

Because the index CAGR ignores the fund's timing. The PME grows each call at the index return earned while it was invested. In this example the fund's IRR is 12.09 per cent, yet it stops beating the index at an index CAGR of 11.49 per cent, because the index path, not just its average, decides the result.

Should PME use a price index or a total return index?

A total return index, because fund distributions are cash returned and the public alternative must include its dividends. Leaving out a 2 per cent dividend yield here lowers the index's end level from 170.6 to 146.6 and inflates the PME from 1.227 to 1.345.

Read the whole case

This article is one calculation from Private Markets Performance. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.

Get the book on Amazon →Free companion files

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

Also on this site

Reading guide: private equity and private markets → · All 324 articles →

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.