Companion files · The Private Markets Career Guides

The Private Fund Treasurer

Liquidity Forecasting, Capital Calls, Credit Facilities, FX Hedging and Cash Controls in Private Equity, Private Credit and Real Estate Funds.

These are the companion files of the book. One workbook rebuilds Calvermoor Capital Management, the fictional manager of the case, and its $1,200.0 million buyout fund: the 13-week forecast and the capital call it sizes, the subscription line and its borrowing base, net IRR with and without the line, a partner who pays late, the FX hedge book and the cash it consumes in a stress, a NAV facility for the older fund, the credit fund's swap, the placement of a large realization within counterparty limits and the management company's budget. A toolkit holds the 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

Capital callLine balance after the 31 December draw $138.00 million, plus the top-up of cash to $5.00 million from $2.42 million, plus $0.45 million of expenses, rounded up: $141.50 million due 6 January 2027
Line or callNet IRR 18.29 percent without the line and 19.04 percent with it; net multiple 1.71x against 1.69x; line cost $14.6 million over the life
FX stressA 10 percent fall in the dollar: $6.67 million of variation margin to Bank A and $9.43 million reserved against the line, on the same day

The files are provided as they are, without warranty of any kind. The model is illustrative: Calvermoor Capital Management, its funds, its banks, its investors and its portfolio companies are fictional, and rates, yields, exchange rates, facility terms and dates are the book’s assumptions, not the terms of any real lender, the quote of any real market or a forecast. Nothing here is legal, tax, accounting or investment advice.

Practise the controller's job on one fund, step by step: the Private Fund Finance & Controllership course →