Companion files · The Private Markets Career Guides
How Mines Get Financed: Resources and Reserves, Feasibility Studies, Project Debt, Streams and Royalties, Offtakes, Hedging and the Career.
These are the companion files of the book. One workbook rebuilds the Kestrelmoor case: Quillan’s payable copper and all-in sustaining cost with and without the stream, the silver stream’s deliveries, uncredited deposit and value, a concentrate shipment settled twice, Fenwick Hill’s resources and reserves, its feasibility economics, the overrun and the delay, the royalty’s value, Harland’s gold collar, Brannock’s facility, interest and fees, its ramp-up and offtake floor, the completion test and the projected DSCR before and after the amendment, and the Fund’s portfolio. A toolkit holds the sixteen 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 2 to 15
One Inputs sheet holds every case assumption: metal prices and decks, Quillan’s quarters, recoveries, payabilities, reserves and costs, Fenwick Hill’s resources, studies, revision, royalty and collar, Brannock’s facility, drawdowns, ramp-up and offtake. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook68 KBAppendix B
Technical report review checklist, resource and reserve statement checklist, study review checklist, mine plan and AISC checklist, valuation and price deck checklist, construction monitoring checklist, project finance term sheet checklist, completion test checklist, standstill and amendment checklist, royalty agreement checklist, stream agreement checklist, concentrate offtake checklist, hedging program checklist, closure and tailings checklist, environmental and social due diligence checklist and fund valuation and reporting checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me4 KB| The silver stream | A $250,000,000 deposit; 2,517,387 ounces delivered by 30 September 2026; the Fund keeps $81,938,168 of net cash and $168,061,832 of the deposit is still uncredited |
| The gold royalty | A $90,000,000 overrun and a six-month delay cut the project’s NPV from $463,697,937 to $324,696,000; the royalty holder loses only the delay, $1,977,304 (all rounded) |
| The lithium loan | 72.0 percent of nameplate and a projected DSCR of 1.27x (rounded) at the long-stop: completion missed, a standstill, then an amendment; the Fund has received $12,471,146 (rounded) |
The files are provided as they are, without warranty of any kind. The model is illustrative: Kestrelmoor, Quillan, Harland, Fenwick Hill, Brannock and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the prices and figures are the book’s assumptions, not market data or benchmarks. Nothing here is investment, legal, tax, engineering or accounting advice.
More in infrastructure and energy, 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.