Companion files · The Private Markets COO
Fund operations, service providers, valuation governance, data and controls at a growing private markets firm.
These are the companion files of The Private Markets COO by Julian R. Sterling.The book on Amazon →
Also as a DRM-free PDF edition ($19.99).
The four workbooks that accompany the book, rechecked from scratch, corrected where they were wrong and given more controls. Around them: the same 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. No sign-up, no email address, nothing locked. Northbridge Private Capital is the fictional firm the book follows; blue cells are inputs, everything else is a formula.
The book’s own files. Every figure in workbooks 2 to 4 was recomputed outside them in September 2026; the call, the fee and the capacity figures held, the scorecard average did not.
Workbook 1 · Appendices A to E
Editable templates for the whole platform: entity map, RACI matrix, control library, operating calendar, close, cash, valuation, obligations, vendors, incidents, capacity and the COO dashboard. Thirteen tabs, 358 formulas. Revised: the sample row of the calendar, close, cash and capacity tabs now carries the formulas of the rows below it.
Download the workbook64 KBWorkbook 2 · Chapter 5 and the introduction
The Fund II call of 6.8 million allocated component by component, with an excuse right and the rounding shown; the ten business days’ notice counted against the funding date; the borrowing base with and without the investor whose transfer was pending, 7,077,000 available against 5,842,000; and the 24.6 million distribution with and without the 600,000 designated recallable. Rechecked: every figure holds; 25 checks, all OK, both facility figures among them.
Download the workbook29 KBWorkbook 3 · Chapter 9
A quarter’s management fee across a step-down that falls mid-quarter, with a side-letter rate and a transaction-fee offset, and one investor’s waiver applied at the fund level as well as on its own record. The invoice is 462,834.23 both ways. Only the check against the unmodified base finds the difference. Rechecked: the waiver investor underpays 1,636.38, its share of gross fee times its own waiver; 18 checks, all OK.
Download the workbook25 KBWorkbook 4 · Appendices D and E
The fourteen scorecard fields on the book’s 1 to 5 scale, with the three critical fields (NAV adjustments, cash-processing errors, open incidents) kept out of the average, and the capacity model under its five scenarios: a team at 69 per cent of practical capacity across the year is 18 per cent over it in April. Revised: the average used to take all fourteen fields, whatever the book said; it now takes the eleven others (June, 4.55, still escalates). New column: the year on the peak basis, 73.3 per cent. 21 checks, all OK.
Download the workbook33 KBEleven workbooks (the four of the book, their blank twins, the three cases and the question book), the printable documents, the read-me and the start-here file. Workbooks 2 to 4 end on a Checks sheet: 64 checks, all OK. No macros, no external links. 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.
| Facility available, pending transfer excluded | 5,842,000 against 6,260,000 needed |
| Management fee invoiced, both designs | 462,834.23 |
| Capacity used in April, current run rate | 118% |
Workbooks 2 to 4 with every blue input emptied, and workbook 1 with its sample rows cleared. The Checks sheets count what is still missing and test what holds for any inputs.
Chapters 5 and 9 · Appendices D and E
The same formulas, every input empty. Investors and activities fill row by row: an incomplete row stays empty and out of every total, so the models work for three investors as well as for eight. Rounding residuals go to the first largest holder, never to two. The holiday calendar, the scorecard fields and their critical flags, the timing profiles and the current-run-rate scenario stay: they are the structure, not the data.
The book’s inputs are listed in a text file inside the archive. Type them back in and its figures come back: 5,842,000 of facility against 6,260,000, an invoice of 462,834.23, April at 118 per cent.
Download the blank set124 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 1 to 14 · Appendices A to G
The mandate on one page, with its exclusions and decision levels. The entity record and the authoritative source by field. The control design card. The payment pack and the cash-control certificate. The capital call and its event certificate. The distribution, classified before it is calculated. The close gates and the open-item log. The valuation memorandum and minutes. The administrator’s operating schedule and scorecard. The economics certificate. The reporting release gate. The obligation record and the next-fund readiness review. The incident record and post-incident review.
Download the PDF38 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 mandate, the map and controls, eight on cash and capital events, seven on the close, valuation and the administrator, six on fees and capital accounts, six from reporting to capacity, 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 question book18 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 6 · Case one
The close signed on day 18 with data three days late, questions two days without an owner and fourteen items at the final review, then on day 15. Built as a network of thirteen tasks (ADDED durations), the two middle paths tie on day 13: data on time alone gives day 18, owned questions alone day 18, the items moved to their gates day 17. Together, day 15. No team can fix the close on its own.
Chapter 8 · Case two
A challenger 80,000 cheaper on the invoice, right first time 80 per cent of the time against 92 (ADDED). With rework, reissues, data transformation and audit support at 95 an hour, it is only 17,488 cheaper to run, the move costs 188,000 and takes 10.7 years to pay back; in three years only at 93.7 per cent right first time, better than the incumbent. And April goes from 118 to 132 per cent of capacity.
Chapter 13 · Case three
By count, 25 per cent more work; weighted by the subscription line, two currencies, a European feeder, a waterfall and negotiated reporting (ADDED increments on workbook 4’s drivers), 45.8 per cent, the feeder first. The count says no hire and 630 hours of temporary help; the weighted view says one hire before first close and still 690 hours over 6 peak months. Workbook 4’s own scenario gives 34.9.
Download the three cases41 KB| Amounts | in fund currency; Northbridge Private Capital and every figure attached to it are fictional |
| Days | business days, counted on the holiday calendar the workbook names; the close counts days after quarter-end |
| Blue cells | the inputs; every other number is a formula |
| Checks sheet | the last word of every model: each control states its own verdict, and the file ends ALL OK |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
| 24 Sep 2026 | Every figure in workbooks 2 to 4 recomputed independently. Corrected: the scorecard average, which took all fourteen fields although the book, the Read Me and this page said the critical ones stayed out, now takes the eleven others (no month changes status); workbook 1’s sample rows, which carried no formulas (352 formulas become 358). Added: the year’s utilisation on the peak basis (73.3 per cent beside the baseline 69); checks raised from 18 to 25, 14 to 18 and 15 to 21, all OK; 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.
Discover more of Julian R. Sterling's practical library of models, checklists and worked cases.
Read the related analysis Browse Julian R. Sterling's books Browse all companion filesIf 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.