Companion files
Policy, Pacing, Manager Selection and Portfolio Management
These are the companion files of The Private Markets Limited Partner by Julian R. Sterling.The book on Amazon →
Also as an ebook on Apple Books · Google Play, and as a DRM-free PDF edition ($19.99).
One Excel workbook that closes the loop Chapter 14 leaves open, on the book’s own figures. Around it, a blank version for your own programme, ten working documents to print, forty questions that mark themselves, and three cases the book does not work. All free. Nothing is gated behind a sign-up, and no email address is asked for.
Six workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 22 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.
Appendix F · Chapter 14
This book computes almost everything it asserts — the gross-to-net bridge, the pacing multiplier, the build-up path, fourteen tables. Chapter 14 is the exception, and it is the chapter about moving money between instruments. It contains one price, one budget percentage and one per-deal cap, and no arithmetic.
The saving is 37 basis points. On the chapter’s own fifteen per cent budget the blended cost falls from 2.54 to 2.17 per cent of net asset value — about 4.4 a year against a cost line of 38, a ninth of it, bought with a decision process, two staff, a five-day standard and under three executions a year. Real, and some distance from “meaningfully lowers the blended cost of the whole portfolio”. Halving the cost line would take 53 per cent of commitments in co-investment and 58 per cent of net asset value in single assets — what the chapter warns against two paragraphs earlier.
And “of any scale” points the wrong way. Most of the incremental cost is fixed, so below roughly 20 a year of budget the overhead eats the saving. There is a minimum viable scale; the chapter asserts the opposite.
Priced as risk, the whole fee advantage is a 22.8 per cent loss rate. A primary dollar returns 1.544× net; a free co-investment at the same gross returns 2.000×. Break-even is a 1.544× gross multiple — 9.08 per cent a year against 14.87. One deal in four going to zero erases it, and the chapter itself warns twice about adverse selection in syndicated deals.
Which makes deal count the binding constraint, not the budget and not the cap. At a cap of one third of a fund commitment, a 15 per cent budget buys 2.7 deals a year, so one total loss is 37 per cent of the cohort — well above break-even, and about three and a half years of the entire saving. You need at least 4.4 deals, so a cap near 8 rather than 13. Meanwhile the chapter warns about deals sized at “three or four times a typical fund commitment” — 120 to 160 — against an annual budget of 35.7. It is warning about a failure its own policy cannot fund.
The last sheet is the one the book most needed. A co-investment is drawn in full at close, so it carries 7.73 NAV-years per dollar committed against 6.30 for a primary — 23 per cent more. An investor running Chapter 14’s policy and Chapter 5’s commitment budget lands 3.4 per cent over target without a single new decision, and 15 per cent over if the holds run to seven years. Two policies from the same book, unreconciled. Twenty-two checks, four of which test the file against the book rather than against the appendix.
Download the workbook26 KBChange the co-investment hold period from five years to seven and watch the overshoot against Chapter 5’s target go from 3.4 per cent to 15. The investor does not choose that input — the sponsor does — which is what makes it an exposure rather than a dial. Then set the per-deal cap to a fifth of a fund commitment instead of a third and watch the deal count cross the break-even line. Same budget, same staff, a programme that can absorb a failure.
The whole risk argument rests on co-investments having a loss rate no better than the fund deals they sit beside. If a manager’s syndicated deals show a total-loss rate under ten per cent and gross multiples within a tenth of the retained book, the concentration objection collapses, break-even is never approached, and the chapter’s sentence stands as written. That test is worth running before this appendix is believed, and it is the one that could show it to be wrong. It also cannot price access — a co-investment sometimes buys a seat rather than a return, and no multiple captures that.
The workbook with every input emptied. Enter your own plan and programme; the checks sheet counts what is still missing and tests what holds for any inputs.
Chapter 14 and Appendix F
Plan size, target, your own pacing multiplier, the fund's gross and net multiples, the fee load, the budget, the per-deal cap, the hold period and the running costs. The file gives the saving at six programme sizes, the break-even loss rate, the deals a year your cap allows, the cap that survives one total loss, and the drift against your pacing target. One line tells you whether a single loss puts your sleeve under water.
The book’s inputs are listed in a text file inside the archive. Type them back in and the file returns 37 basis points, 22.8 per cent, 2.68 deals a year and a 3.4 per cent overshoot.
Download the blank set22 KBTen pages to print and use. A4, with margins wide enough for US Letter.
Appendices A to D · Chapters 5, 7 and 11 to 14
The manager selection checklist of Appendix A, stage by stage. The committee memo in its fixed order, each section with the way it usually goes wrong. The question bank of Appendix C on three pages, with room for the answer as given. The operational sign-off and the red line, condition and monitorable log. The terms worth real leverage and the five clawback questions. The capital account rebuilt line by line, with the watch list. The stressed liquidity forecast with its indicators and the breach protocol. And the re-up checklist with the annual calendar.
Download the PDF27 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Five on the seat and its governance, seven on the economics, eight on portfolio construction, seven on manager selection, seven on oversight and the levers, 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 5 · Case one
Chapter 5 says to present the commitment budget as a range and never runs the scenarios. Run on its own fund, its sensitivities hold: a year longer to exit cuts the budget by a fifth, a year shorter raises it by a third. Then the finding. Held at 238, the budget takes the program to 19.2 per cent if exits slow and 11.4 if they quicken: both outside the band. The ceiling needs at most 223, the floor at least 250. No fixed budget survives both, which is why the decision rule does the work.
Chapter 7 · Case two
The chapter’s foundation needs 112 in its stressed year. The policy buffer of 120 pays for itself against a thin one of 40 if that year comes once in 10 years, secondary route, or once in 13 if equities are sold at the bottom. Tiered, 40 in cash and 80 in short-duration paper, it costs 2.0 a year instead of 3.6 and pays if the stressed year comes once in 30.
Chapter 5 · Case three
Chapter 5’s denominator shock takes the private share to 18.3 per cent. Holding the pace, it is back inside the band within a year as public markets recover. Cutting the next two budgets to 70 per cent stays inside the band from the first year, 13.4 per cent at the lowest. Skipping two vintages, the reflex the chapter warns against, keeps the program below the floor for four years.
Download the three cases50 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | in every workbook; in the book’s, twenty-two controls, four of them testing the file against the book rather than the appendix |
Every figure is illustrative. The plan, the funds, the deals and the hold periods are invented; the parameters are chosen so the arithmetic ties back to Chapters 3, 5 and 6 rather than because they describe any particular market.
The workbook opens in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. It uses 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 | A blank version of the co-investment model, ten working documents, forty questions that mark themselves and three new cases. The book’s workbook can now also be downloaded on its own; its content has not changed. |
More in private equity and funds, with free companion files. The full list of titles is on the author page.
The Private Markets Limited Partner 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 analysisThese files accompany The Private Markets Limited Partner. 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: Co-investment fee savings model.