# The Private Markets Risk Manager: companion files

Julian R. Sterling

## What is here

- **Private_Markets_Risk_Manager_Model.xlsx**: the workbook that rebuilds the Calderwick Partners case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Limits and Alerts, Fund IV Leverage, Fund IV NAV Loan and Scenarios, Fund IV Concentration and FX, Lending Fund Liquidity, Lending Fund Stress Tests, Lending Fund Redemptions & Gate, REF II LTV and Covenants, REF II Remediation, Risk Dashboard, Checks.
- **Private_Markets_Risk_Manager_Toolkit.docx**: the fifteen checklists of Appendix 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, quarterly dashboard and board pack checklist), in editable form.

## Which sheet answers which chapter

- Chapter 4: Limits and Alerts (fifteen metrics with a limit and an alert; Arvenne Software at 16.8, 17.2, 17.9 and 17.3 percent of Fund IV's NAV against a 15.0 percent alert and a 20.0 percent limit)
- Chapters 5 and 6: Fund IV Leverage (gross 130.7 percent and commitment 113.7 percent at 30 September 2026, 138.7 and 121.7 percent before excluding the drawn subscription facility; coverage of 3.00x)
- Chapters 7 and 12: Fund IV NAV Loan and Scenarios (loan-to-value of 11.2 percent; a 20 percent fall in fair value would cut NAV by 23.7 percent; the covenant would break only after a fall of 55.1 percent)
- Chapters 13 and 14: Fund IV Concentration and FX (three largest companies at 47.0 percent of NAV; 5.0 percent of NAV unhedged in US dollars; largest counterparty exposure 0.4 percent of NAV)
- Chapter 9: Lending Fund Liquidity (liquid assets of 15.0 percent of NAV; commitment leverage of 107.5 percent)
- Chapter 10: Lending Fund Stress Tests (a redemption coverage ratio of 1.36x on requests of 9.0 percent of NAV; reverse stress point at 12.3 percent of NAV)
- Chapter 11: Lending Fund Redemptions & Gate (73.5 and 55.6 percent of each request paid behind the 5.0 percent gate; €32.00 million lapsed on 30 September 2026)
- Chapter 15: REF II LTV and Covenants and REF II Remediation (57.1 percent against the 55.0 percent limit and 67.2 percent against the 65.0 percent covenant at 30 June 2026; a €6.50 million cure and a €118.0 million sale; 52.7 and 65.0 percent at 30 September 2026)
- Chapter 16: Risk Dashboard (0, 0, 2 and 0 red readings over the four quarter ends)

## Two inputs to change first

1. On Inputs, raise the 30 June 2026 valuation of the Frankfurt office building: watch the cure on REF II Remediation shrink, and the office loan reading on the Risk Dashboard change color.
2. On Inputs, raise the Lending Fund's redemption requests for 30 September 2026: watch the amount paid stay at the gate, the share of each request paid fall and the redemption coverage ratio move on the Risk Dashboard. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Calderwick Partners, its three funds, the portfolio companies, the properties and every other name in the case are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case figures are illustrative assumptions, not benchmarks. Provided as is, without warranty. Not investment, legal, regulatory or tax advice.
