Companion files · The Private Markets Career Guides

The Private Markets Risk Manager

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 workbook, the toolkit and the read-me, in one archive91 KB

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.

The files

Three numbers to reproduce first

Fund IV, a buyout fundGross 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 creditRequests 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 estate57.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.

Also by Julian R. Sterling

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.