Companion files
A Practitioner's Guide to Measuring, Benchmarking and Reporting Private Fund Returns
These are the companion files of Private Markets Performance by Julian R. Sterling.The book on Amazon →
The five Excel workbooks that go with the book, corrected where the book was wrong: the complete measurement of Chapter 19, the PME calculator, the practice cases, the measurement checklist and the cohort of twenty-four. Around them: three of the models with the inputs emptied, thirteen working documents to print, forty questions that mark themselves, and three cases the book names and never takes to a number. Every number is a live formula. Nothing is locked, protected or watermarked.
Free to download. No sign-up, no email address, nothing to fill in.
Twelve workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 23 September 2026.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
These carry the book’s own figures, so that every number it prints can be traced to a live formula. Each workbook with figures closes on a checks sheet, and every check passes.
Chapter 19
Eight sheets, from the cash flow series to the reporting line: the multiples, both internal rates of return, the subscription facility test, all four public market equivalent methods, the gross-to-net bridge, the disclosure sentence assembled from the cells above it, and a final sheet that puts every published figure next to what the file computes. Long-Nickels comes out negative here, exactly as the chapter says it will — which is the clearest demonstration available of why PME+ exists. Revised: the subscription facility now follows the mechanism the book describes, the fund paying the interest out of its distributions. That gives the printed TVPI of 1.788× exactly, and a rate of 12.76%, 169 basis points above the actual rather than the 130 printed. Sheet 8 now compares thirty-eight published figures, and all of them match.
Download the workbook37 KBChapters 3, 5 and 9
The same model with the numbers taken out, for a fund of your own. Enter a cash flow series and a total return index and it returns DPI, RVPI, TVPI, the realized share, the since-inception rate, the rate excluding the residual value, Kaplan-Schoar, Long-Nickels, PME+, Direct Alpha and the test against a policy hurdle. Annual, quarterly or monthly rows — set the periods per year and the rate annualizes by compounding. It arrives pre-filled with the Chapter 19 fund so every formula can be seen working before it is trusted. A checks sheet tests five identities that hold for any fund you enter.
Download the workbook26 KBAppendix C
All three cases, each with a blue column for your answer beside the live solution. Case 1 publishes its full cash flow series and is recomputed from first principles. Case 2 states its pattern, Case 1 scaled, and is now computed from it: the three funds earn 11.63%, 10.17% and 19.85%, and pool to 11.88% against a simple average of 13.88% (the book printed 11.52, 10.12, 19.51, 11.78 and 13.72, which do not follow from the pattern it states). Case 3 publishes summaries without timing, so everything derivable is derived and the rest is put through a coherence test. That test is worth a minute: inverting each manager's Direct Alpha in Case 3 recovers the index rate they were measured against, 6.88% and 7.04%, within a basis point of Chapter 19's 7.05%.
Download the workbook24 KBAppendix B
All 51 items across eleven sections — the cash flow series, residual value, the rate, the multiples, distortions, the comparison, peer data, portfolio level, cost, risk and reporting — with a status dropdown, a notes column and a progress sheet that counts what is still open by section.
Download the workbook12 KBAppendix F
Chapter 19 says every number is shown and every number reproducible. Seven of its eight steps deliver numbers; step 7, the peer comparison, delivers none, and Chapter 11 prints the template with N, X and Y still in it. This workbook fills them in and sizes what Chapter 12 says cannot be sized. Nine sheets: the cohort fund by fund; the standard error of a quartile boundary at any cohort size, which is how the “about twenty” threshold turns out to be sixty-three; the three conventions for drawing a boundary, which agree on every fund if and only if the cohort size is a multiple of four; the three biases sized in closed form at 380 basis points for buyout and 563 for venture; and the probability — 0.82 is the threshold — that a median fund can call itself top quartile somewhere. Seventy-four controls, all live: change an input and the controls that depend on it fail, which is how you find out what your change moved.
Download the workbook110 KBThree of the workbooks with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapters 3, 5, 9 and 19 · Appendix F
The complete measurement, the PME calculator and the cohort of twenty-four, with the same formulas and every input emptied: cash flows, residual value, index returns, premium, fee terms and facility assumptions; on the cohort, the funds of your provider’s cell and your own fund. Every sheet stays blank until its inputs are complete. The measurement checklist already arrives empty.
The book’s inputs are listed in a text file inside the archive. Type them back in and the book’s figures come back: 11.07%, a Kaplan-Schoar of 1.239, Direct Alpha of 3.80%, a median of 10.40 and a boundary of 14.02.
Download the blank set134 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 2 to 18 · Appendices B, D and F
The cash flow series, built once, with its seven contribution traps, four distribution traps and the quarterly reconciliation test. Reading someone else’s number: the six questions and the seven conventions. The multiples and the mark, with the exit-to-mark test. The subscription facility test. The public market equivalent worksheet. The peer comparison with N, X, Y, the precision of the boundary and the eight questions for a provider.
The portfolio page, the pacing page with its stress case, the gross-to-net bridge with all three layers, attribution, the risk page, the one-page board report with its four sentences, and the questions worth asking a manager.
Download the PDF36 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on rates and multiples, six on distortions and conventions, seven on public market equivalents, seven on peers, portfolios and Appendix F, six on cost, risk and reporting, and seven on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part. Where a question says revised, the answer is the corrected figure.
Download the questions17 KBNew material, not a restatement. Three situations the chapters name and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Chapter 15 · Case one
The book’s gross 14.29% adds back fees and expenses only. With carried interest of 20% over an 8% preferred return and a full catch-up (ADDED), the fund pays 56.25 of carry, all at year 9, and the whole gap is 483 basis points: 319 of fees and expenses, 164 of carry. The manager takes 31.7% of the value created. The gap does widen on better funds, as chapter 15 says; the manager’s share does not.
Chapters 4, 8 and 14 · Case two
The same fund measured as the allocation that holds it, month by month. From the commitment with nothing earned meanwhile, chapter 8’s second convention, it returns 7.12%, 395 basis points below the fund. With the whole undrawn commitment in cash at 2% (ADDED), 7.58%. The book’s range of 100 to 300 basis points corresponds to holding between 8% and 67% of the undrawn commitment in cash: the gap is a liquidity policy.
Chapters 14 and 17 · Case three
The denominator effect on one board date. From a 10% allocation, a public fall of 18.5% breaches a 12% limit on the day. After a 25% fall, with calls continuing and distributions halved, the board sees 13.35%; the private marks catching up two quarters later do not bring it back, and the calls take it to 14.84% in two years. Exposure was already 16% before anything fell.
| Blue text | a hardcoded input — you may edit these |
| Black text | a formula — do not overtype these |
| Green text | a link to another sheet |
| Yellow fill | the assumptions that carry the answer |
| Checks sheet | the last sheet of every workbook with figures: each control states its own verdict, and the file ends ALL OK |
| Amber fill | an input in the three cases and the blank set’s new sheets |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
Five published figures do not follow from the book’s own inputs. The workbooks show the first edition’s figure beside the corrected one, and a check ties each to its cell.
| Chapters 3, 5, 7, 19 | A one-year facility deferral, interest paid out of distributions: 12.76% and 169 bp, not 12.37% and 130 bp. The multiple falls by 0.045, as printed. |
| Chapter 13, Appendix C | On the stated pattern the three funds pool to 11.88%; the simple average (13.88%) overstates by 200 bp, not 194. |
| Chapter 8 | Multiplying a quarterly rate by four understates 11.07% by 43 bp, not “roughly one hundred”. |
| Chapter 2 | Leaving fee calls of 14% of commitments out of paid-in overstates the fund by 330 bp and 0.34×, not “part of a percentage point” and 0.15. |
| Chapter 15 | The 322 bp are fees and expenses only; distributions are already net of carried interest. Case one prices the missing layer. |
The gross rate of 14.29% remains approximate, as the book says: an even spread of the expenses gives 14.25%, within five basis points.
Private Markets Performance develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books · Google Play · DRM-free PDF edition ($19.99).
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers; the PDF prints on A4 or US Letter. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 23 Sep 2026 | The five workbooks corrected and given checks sheets. The subscription facility follows the book’s own mechanism: 12.76% and 169 bp, not 12.37% and 130. Case 2 computed from the pattern it states: pooled 11.88%, simple average 13.88%, an overstatement of 200 bp, not 11.78, 13.72 and 194. Chapter 8’s annualization error is 43 bp at 11.07%, and chapter 2’s fee exclusion 330 bp and 0.34×. Added: a blank set, thirteen working documents, forty questions that mark themselves, and three cases. |
More in private equity and funds, with free companion files. The full list of titles is on the author page.
These files accompany Private Markets Performance. 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 workbook stays free either way.
Also available as a standalone free template: PME calculator.
Also available as a standalone free template: Dimson beta calculator.