# The Private Fund Treasurer: companion files

Julian R. Sterling

## What is here

- **Private_Fund_Treasury_Model.xlsx**: the workbook that rebuilds the Calvermoor case and reproduces the figures of the book with live formulas. Sheets: Inputs, 13-Week, Line, Life of Fund, LP, FX, Cash, NAV Facility, Rate Hedge, Management Company, Checks.
- **Private_Fund_Treasury_Toolkit.docx**: the 8 checklists of Appendix B (opening a fund bank account, the weekly 13-week forecast routine, a capital call from the cash side, a subscription line draw and repayment, releasing a payment and changing beneficiary details, an FX hedge roll and a margin call, the monthly counterparty and cash placement review, the monthly treasury report to the CFO), in editable form.

## Which sheet answers which chapter

- Chapter 4: 13-Week (the weekly forecast of Fund III, the 31 December draw and the January call of $141.50 million)
- Chapters 5 and 6: Line (terms, borrowing base, availability, the cost of the Aster draw)
- Chapter 6: Life of Fund (net IRR 18.29 percent without the line, 19.04 percent with it)
- Chapter 7: LP (a late partner, a default and an excuse)
- Chapter 8: NAV Facility (the Fund II facility, its cost and its covenant headroom)
- Chapters 9 and 10: FX (the hedge book, the stress, variation margin and the reserve against the line)
- Chapter 11: Rate Hedge (the Credit Fund swap)
- Chapter 12: Cash (yields and the counterparty limit at Bank A)
- Chapter 14: Management Company (the 2027 budget against the minimum liquidity of $4.60 million)
- Appendix A: 16 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, lower the opening cash from $6.40 million to $4.40 million: the 31 December draw grows and the January call rises to $143.50 million, while the lowest cash does not move.
2. On Inputs, raise the USD fall in the stress from 10 to 15 percent: watch the variation margin owed to Bank A and the reserve against the line. 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. Every input is on the Inputs sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Calvermoor Capital Management, its funds, its banks, its investors and its portfolio companies are fictional; rates, yields, exchange rates, facility terms and dates are teaching assumptions, not the terms of any real lender, the quote of any real market or a forecast. Provided as is, without warranty. Not legal, tax, accounting or investment advice.
