Companion files · The Private Markets Career Guides
How Fund Managers Measure and Control Risk: Leverage under AIFMD, Liquidity Stress Tests and Gates, Valuation and Concentration Limits, Escalation, Form PF and the Career.
These are the companion files of the book. One workbook rebuilds the Calderwick Partners case: the limits table, Fund IV’s leverage under both methods, its subscription facility, NAV loan, valuation scenarios and breaking points, concentration, currency and counterparty exposure, the Lending Fund’s liquidity, stress tests and gate, REF II’s loan-to-value breach, cure and sale, and the quarterly risk dashboard. A toolkit holds the fifteen checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 4 to 16
One Inputs sheet holds every case assumption: the limits and alerts, Fund IV’s balances, company fair values, facilities and forwards, the Lending Fund’s assets, requests, gate, buffer and haircuts, and REF II’s property values, loans, cure and sale. One sheet per question, a Risk Dashboard that colors every reading, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook54 KBAppendix B
Risk function independence checklist, risk policy annual review checklist, limits and alerts design checklist, leverage calculation checklist, subscription facility monitoring checklist, NAV loan monitoring checklist, loan-originating fund checklist, liquidity profile checklist, liquidity stress test checklist, gate and liquidity management tool decision checklist, valuation challenge checklist, concentration and currency checklist, counterparty and incident register checklist, limit breach escalation and remediation checklist and quarterly dashboard and board pack checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me4 KB| Fund IV, a buyout fund | Gross leverage of 130.7 percent and commitment leverage of 113.7 percent at 30 September 2026; a 20 percent fall in fair value would cut NAV by 23.7 percent, and the NAV loan covenant would break only after a 55.1 percent fall |
| The Lending Fund, semi-liquid credit | Requests of 9.0 percent of NAV on 30 September 2026, 55.6 percent of each request paid behind the 5.0 percent gate, a redemption coverage ratio of 1.36x and a reverse stress point at 12.3 percent of NAV |
| REF II, real estate | 57.1 percent loan-to-value against a 55.0 percent limit at 30 June 2026; a €6.50 million cure and a €118.0 million sale bring it to 52.7 percent at 30 September 2026, still amber |
The files are provided as they are, without warranty of any kind. The model is illustrative: Calderwick Partners, its three funds, the companies, the properties and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the figures are the book’s assumptions, not benchmarks. Nothing here is investment, legal, regulatory or tax advice.
More in fund operations, with free companion files. The full list of titles is on the author page.
Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.