Companion files · The Private Markets Career Guides

The Mining Finance Professional

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 workbook, the toolkit and the read-me, in one archive105 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

The silver streamA $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 royaltyA $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 loan72.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.

Also by Julian R. Sterling

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.