Companion files
A Practitioner’s Guide to Commitments, Cash Flows, and the Return That Reaches the Investor
These are the companion files of Alternative Investments by Julian R. Sterling.The book on Amazon →
The four Excel workbooks that go with the book, with their checks tightened until they can catch something: every figure the book prints is reproduced by a live formula, and 254 controls, each to half a unit of the last printed digit, end on ALL OK. Around them: the same four 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. 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 24 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. Each now closes on a checks sheet that passes only to the last printed digit, and gains a sheet computing what the chapters state without showing the working. Download these four109 KB
Chapters 1, 4, 8 and 11
The fund's internal rate of return of 13.2935 per cent, the sleeve with the uncalled commitment held in the listed index at 9.1878, the sleeve with it held in cash at 6.2571, and the index itself at 7.1312 — all four computed from one call and distribution schedule. The apparent advantage of 6.1624 points, the real one of 2.0567, the 33.3744 per cent that reached the foundation and the ratio of 3.00 are live cells.
Underneath sits the engine the other three workbooks share: the fund's net flows, the sleeve account on both idle policies year by year, the cumulative capital at work, and the compounding factors. Set the cash row equal to the index row and watch the fund's return refuse to move while the sleeve returns converge — the whole of Chapter 9 in one edit, and worth 2.9307 points a year.
New: the residual on one date. The IRR puts it beside the last distribution; the sleeve and the PME put it a year later. On one date throughout the IRR is 12.9426 and the apparent advantage is 2.83 times the real one, not 3.00. And the 21.00 advisory layer the fee chapter counts, which the sleeve account never charges: net of it, the sleeves return 8.9657 and 6.0248.
Download the workbook24 KBChapters 3, 5 and 10
The shape of the programme rather than its return. TVPI 1.6560x, DPI 1.4025x, RVPI 0.2535x, and the share of the multiple already banked. Then the J-curve as a computed row rather than a picture: 90, 240, 349, 383, 306, 154, 21, −74, −160, −227.
And the arithmetic that belongs in every allocation paper and appears in almost none. A commitment of 600 never put more than 383 to work, so 36.1667 per cent of it was never invested at any moment, and holding the target genuinely invested would have required committing 939.95 — an over-commitment of 56.6580 per cent. The ratio is a property of your own schedule, and the sheet recomputes it when you type one in.
New: the rates a multiple implies (1.6560x stops beating the index at 7.32 years, not a shade under seven), the slow-exit peak of 535, the 939.95 schedule and the denominator effect (40.90 per cent if no distribution arrives with the Year 5 call, 27.87 if they do), and the timing experiments of Chapter 4. Corrected: 258 had come back by the end of Year 5, not 291.
Download the workbook29 KBChapters 6 and 7
Every capital call treated as a purchase of the index and every distribution as a sale, both compounded to the same date: 979.96 against 1,230.20, a Kaplan-Schoar ratio of 1.2554x and a direct alpha of 5.8628 per cent. The manager did beat the index on the capital it used, and the workbook says so.
Then the comparison that is usually skipped. A private equity portfolio is a levered equity portfolio, so the sheet builds an index levered to a beta you set — at 1.15 it returned 7.8203 per cent a year rather than 7.1312 — and the ratio falls to 1.2255x. Change the index series entirely and watch the answer move: the choice of benchmark is a decision, and this is where it becomes visible.
New: the benchmark at a beta of 1.30 computed year by year (8.4883 per cent, PME 1.1976), the leverage funded at the cash row and at 3.00 per cent (the PME moves by 0.0070), and the direct alpha against the levered index that Chapter 7 declines to compute: 5.2448 per cent.
Download the workbook25 KBChapters 13, 14 and 15
The first-order autocorrelation measured from the reported series — 0.5245, which a listed index does not do and an appraisal series does — and the standard correction reversed across the whole range of coefficients. The sleeve's volatility goes from 3.1547 to 5.4849 per cent, its correlation with the index from 0.0707 to 0.3098, and its beta from 0.0215 to 0.1639: seven and a half times, on the number an allocation model is solved on. Portfolio volatility barely moves, so the diversification case survives; the sheet shows both so you can say which is which.
Then the load in money — management fees 55.56, carried interest 92.50, the advisory layer 21.00, 169.06 against a net gain of 370.00, which is 45.6926 per cent — and the secondary market: what a discount on the residual does to the sleeve's ten-year return, run from nothing to giving it away.
New: the smoothing table across coefficients 0.00 to 0.60, with the printed 5.4849 and 81.9603 traced to the measured coefficient before rounding, and a roll-forward showing the ten reported returns are a series of marks rather than the fund’s own path (they leave 64.44, not 143). Corrected: 94.49 per cent of the management fee falls in the first five years, not two thirds; a 30 per cent discount costs 0.3286 points a year.
Download the workbook33 KBThe four workbooks with every input emptied. The checks count what is still missing and test what holds for any inputs.
Chapters 1 to 15
The three returns, the cash-flow engine, the public market equivalent and the smoothing, fee and exit workbook, with the same formulas and every blue input emptied. Cell B3 of the Inputs sheet counts what is still missing, and every result stays empty until nothing is.
The book’s inputs are listed in a text file inside the archive. Type them back in and the book’s figures come back with them: 13.2935 per cent for the fund, 9.1878 and 6.2571 for the sleeve, 1.2554x for the PME.
Download the blank set85 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 2 to 18
The commitment minute, with the three decisions a vote contains. The drawdown and liquidity schedule, with the slow-exit test. The sleeve account in ten lines. The three returns on one page, with the ladder of gaps. Where the uncalled commitment lives, as the paragraph for the investment policy statement. Over-commitment and the denominator stress. Reading a fund’s numbers, from DPI to the PME worksheet. The benchmark and its gearing. The valuation tests and the risk page. The fee load in money, with the three meanings of invested capital. A secondary indication, priced. Choosing a manager. And the ninety-second test for a commitment paper, with the five pages of a board pack.
Each page carries the Thornbury figures in a footnote, so that a filled-in page can be checked against the book.
Download the documents36 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on the commitment and its cash flows, eight on measuring the fund, seven on the return that reaches the investor, eight on valuation, smoothing, fees and the exit, four on practice, and six 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: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
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 9 · Case one
Chapter 9 prices cash and the listed index and stops. The liquid proxy, the index levered to 1.15, returns 9.6425 per cent; a credit facility at the chapter’s own cash plus 150 basis points returns 9.9603, but its balance, once the interest is counted, peaks at 407.38, not the 383 the chapter says, and ties with the index policy only at about 5.19 points over cash. And the chapter’s worst case, the -11.20 year moved into the heaviest call year, raises the index-policy sleeve to 9.7777: the balance it hit in Year 8 was larger.
Chapters 3 and 10 · Case two
Chapter 10 sizes the over-commitment on the book’s schedule; Chapter 3 builds the slower one. Together: two years of delay put 838.12 to work at the peak, 41.9 per cent of the endowment against a target of 30, and a 20 per cent listed fall that year reports the sleeve at 47.4 per cent. The commitment that would have been right on the slow schedule, 672.90, holds only 71.6 per cent of the target if the distributions come on time after all. The ratio is a bet on the overlap.
Chapter 14 · Case three
Chapter 14 says the fee base after the investment period has three current meanings and computes one. On the cost of unrealised investments the management fee is 69.03; on called capital never reduced, 101.85, against the book’s 55.56. Carry falls a fifth of the difference, and the index-policy sleeve falls to 8.8252 per cent: 0.36 of a point a year from one definition in one clause.
Download the three cases47 KB| Blue text | a hardcoded input — you may edit these |
| Yellow fill | an input cell; everything else on the sheet is a formula |
| Black text | a formula — do not overtype these |
| Checks sheet | the printed figure beside the computed one, to half a unit of the last printed digit; the sheet ends ALL OK |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
A workbook that agrees with a book proves nothing on its own — the author wrote both. What the Checks sheets do is different: they force the model to reproduce a number that was printed before the model existed, from a formula rather than from the number itself.
On this book the discipline caught a timing convention rather than an arithmetic slip, which is the harder kind to find. The fund's internal rate of return depends on when the residual value is struck: at the last reporting date it is 13.2935 per cent, and dated a year later it is 12.9426. Neither is wrong and the difference is not small. The convention is now stated once in the fact pattern, carried in the appendix of the printed book, and reproduced in the workbooks so that a reader can switch it and see the effect.
The first checks allowed half a percentage point of error on a return, which is enough to pass almost anything. At half a unit of the last printed digit they find what the book states and does not show: that the 3.00 mixes the two dates for the residual (2.83 on one date), that the sleeve account leaves out a fee the book counts, and a handful of figures computed from rounded inputs. The Checks sheets name each one beside the book’s figure.
Where a shortcut and the full computation disagree, both are shown. The apparent advantage is 6.1624 points on the unrounded series and 6.1623 if you subtract the printed returns; the risk reduction is 2.9836 points as claimed and 2.4454 once the valuations are unsmoothed. Neither gap is smoothed away.
Alternative Investments 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.
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.
| 24 Sep 2026 | The four workbooks’ checks tightened from half a point to the last printed digit: 254 controls, each workbook ALL OK. On one date for the residual the apparent advantage is 2.83 times the real one, not 3.00; net of the advisory layer the book counts, the sleeves return 8.9657 and 6.0248. Corrected: the TVPI crosses the index at 7.32 years, not under seven; 258 returned by Year 5, not 291; 94.49 per cent of the management fee in the first five years, not two thirds. Added: a blank set, thirteen working documents, forty questions that mark themselves, and three cases. |
| 8 Nov 2026 | The fees workbook realigned on the corrected book: the gross gain is 518.06 (the 349.00 the foundation kept plus the 169.06 of fees), not 539.06, which counted the 21.00 advisory layer twice; the load on it is 32.6336 per cent. |
More in private equity and funds, with free companion files. The full list of titles is on the author page.
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: private equity fund cash flow model.