Companion files
Accounting, NAV, Capital Calls, Valuation, Investor Reporting
These are the companion files of The Private Equity Fund Controller Playbook by Julian R. Sterling.The book on Amazon →
Also as an ebook on Apple Books.
These are the workbooks and documents that go with the book. The five original workbooks reproduce every figure the book publishes, and the fifth computes the figures it defines and never publishes. Around them: three of the models with the inputs emptied, four printable working documents, a question book that marks itself, 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 22 September 2026.
Read the book already? An honest review on Amazon, good or bad, is what the next reader goes on: write a review. The files stay free either way.
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 →
Practise the controller's job on one fund, step by step: the Private Fund Finance & Controllership course →
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. Download these five97 KB
Chapter 30
The whole-of-fund waterfall on $160m of proceeds against $100m of contributed capital, through all four tiers, landing at $148m to the LP interests and $12m to carry. All fifteen published figures reproduce exactly. The catch-up is the part worth opening the file for: the chapter solves C ÷ ($10m + C) = 20% by hand and gets $2.5m, and the cell contains that solution rather than the answer — change the carry rate to 25 percent and the catch-up moves to $3.3m on its own. A separate sheet prices what the chapter says but does not model: on the pre-filled profile an 8 percent preferred accrues $37.2m against a flat $10m.
Chapter 31
It is 30 September, the administrator's draft trial balance has arrived, and five things are wrong with it. The file finds each one, carries its journal entry, and bridges from a draft partner capital of $125m to a corrected NAV of $128.5m — cross-checked against the balance sheet, which agrees. Both routes are computed independently and the sheet states out loud whether they agree. Every correction is an input you can zero out.
Chapters 5 and 10
Enter the investor register once. The file allocates a call on participation percentages, tracks unfunded commitments, allocates a distribution with its recallable treatment, and rolls every investor capital account. Three reconciliations run automatically and each says so out loud when it fails — including the tie of the investor subledger to net asset value, which is the one that stops a bad quarter becoming a restatement.
Appendix B
All ten checklists and their 125 items: capital calls, distributions, management fee, expense review, investment closing, valuation, NAV review, quarter-end close, audit readiness and the first ninety days. Status dropdown, notes column, and a progress sheet that counts what is still open by section.
Chapters 5, 12, 14, 27, 28 and 29
Chapter 14 defines IRR, DPI, RVPI, TVPI and MOIC. Chapter 29, step 7, tells the controller to update all of them at the exit. The book prints no value for any of them, anywhere — and chapters 27 to 29 are one continuous case with every input needed. This file joins them up. Atlas returns 1.833 times, 22.4 percent a year; the fund that owns it ends the case at a TVPI of 0.892 and an IRR of −5.6 percent, because 2 percent of $500m charges $32.5m of fee against a single $42m investment. Atlas's whole gain pays for 10.1 of the thirteen quarters the case runs, and the fund would have had to be $389.5m, not $500m, to leave investors whole.
Then the part worth opening the file for. The book says three times — twice in chapter 14 and again in answer C9 — that a subscription facility increases investor-level IRR. Its own case does the opposite, and sheet 6 separates the two reasons: timing alone costs half a point, and the $5.48m of interest costs 4.21 more. The condition the book omits is a threshold — the facility helps only above a $96.68m sale, and the book sells at $78.0m. Thirty-two live controls, twenty-five of which reproduce a figure the book prints.
The waterfall, the quarter-end close and the investor register, with the same formulas and every input emptied. Type your own fund into the blue cells and the model runs.
Blank set · three workbooks
The waterfall takes proceeds, capital, the preferred return, the carry rate and the catch-up, and a dated profile for the timing of the pref. The close takes the draft rollforward, the trial balance and each correction with its journal. The register takes each investor’s commitment, fee rate, class and exclusions, then a call and a distribution. Each workbook closes on a checks sheet that counts the inputs still empty and runs the controls that hold on any fund: allocations that total the proceeds, a catch-up that leaves carry at its rate, two routes to NAV that agree, participation that totals 100 per cent, no call above an unfunded commitment.
Put the book’s inputs back, listed in the archive, and the book’s figures come back with them: 148 and 12 on the Chapter 30 waterfall, 128.5 by both routes in the Chapter 31 close.
Download the blank set54 KBEight pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Chapters 5, 10, 30 and 31 · Appendix B
The ten operational checklists of Appendix B, 125 items with a box for the evidence. A waterfall review: the four tiers and the nine controls, signed as tested or as judgement. A quarter-end close sheet: the findings log with each journal and the control that was missing, and both routes to NAV side by side. And a capital call notice review: the build of the amount, and the allocation checked three ways.
Download the PDF20 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
The numerical questions work the book’s own figures: the register, the call and the distribution of Chapters 5 and 10, the Chapter 30 waterfall and its catch-up, the Chapter 31 close by both routes, the currency translation of Chapter 12, and the performance figures and facility effect of Appendix F. They are marked against a tolerance, so a reasonable rounding passes. The score sheet counts the wrong answers by part of the book.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book16 KBNew material, not a restatement. Three situations the chapters name in passing 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.
Case one · extends subsequent closings in Chapter 3
A new investor commits 50 when 80 is already invested for the first-close investors. It pays 16 at cost, 0.96 of interest and a fee true-up, and every investor ends at 32 per cent paid in. But the investments have risen 15 per cent: the new investor gets 18.40 of value for 16.96. Equalisation at cost plus 8 per cent is fair only at a 6 per cent rise.
Case two · extends fee step-downs in Chapter 7
One agreement, three readings of the base after the investment period. On net invested capital the fee is 8.53 over five years, on NAV 12.01, on invested cost never reduced 15.80. The largest error is invisible in the first year, when the readings agree, and grows as the portfolio is sold.
Case three · extends unfunded commitment in Chapter 5
A distribution of 30, 12 of it recallable. The fund can still ask for 42, not 30; the investor pays in 112 on a commitment of 100; the interim DPI falls from 0.43 to 0.29 when the recall comes, with no change in the portfolio. Until the right lapses, a recallable distribution belongs on the unfunded line.
Download the three cases31 KB| 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 |
Two routes to the same NAV is not redundancy; it is the control. A close that agrees with itself only one way has not been checked. None of the five findings in Chapter 31 was a modelling error — every one came from a control that did not exist, and every one was found by connecting two records that should have agreed and did not.
The entries and allocations are simplified illustrations, exactly as in the text. Account names, treatment and waterfall mechanics vary by accounting framework, legal structure and governing document. These files model the arithmetic; they do not model your documents.
The Private Equity Fund Controller Playbook develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on AmazonThe workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. 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.
| 22 Sep 2026 | Blank model set, four printable working documents, the question book and three new cases added. Read-me rewritten. |
9 of the calculations in these workbooks, worked out in full. All articles.
More in private equity and funds, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: capital call and distribution template.
These files accompany The Private Equity Fund Controller Playbook. 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.