Companion files · The Private Markets Career Guides
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 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 12 and 14, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the book: 13-Week, Line, Life of Fund, LP, FX, Cash, NAV Facility, Rate Hedge, Management Company. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 16 exercises of Appendix A run on it.
Download the workbook54 KBAppendix B
Opening a fund bank account, the weekly 13-week forecast routine, a capital call from the cash side, a line draw and repayment, releasing a payment, an FX hedge roll and a margin call, the counterparty and placement review, and the monthly treasury report.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| Capital call | Line 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 call | Net 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 stress | A 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 →