# The Mining Finance Professional: companion files

Julian R. Sterling

## What is here

- **Mining_Finance_Professional_Model.xlsx**: the workbook that rebuilds the Kestrelmoor case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Quillan Mine and AISC, Silver Stream Deliveries, Stream Value, Concentrate Shipment, Fenwick Resources and Reserves, Fenwick Study Economics, Fenwick Overrun and Delay, Fenwick NSR Royalty, Gold Collar, Brannock Facility, Brannock Interest and Fees, Brannock Ramp-Up and Offtake, Completion and DSCR, Fund Portfolio, Checks.
- **Mining_Finance_Professional_Toolkit.docx**: the sixteen checklists of Appendix 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, fund valuation and reporting checklist), in editable form.

## Which sheet answers which chapter

- Chapter 2: Quillan Mine and AISC (all-in sustaining cost $2.95 a pound with the stream, $2.80 without it, both rounded; margin $1.55, rounded, over $4.50 copper)
- Chapter 4: Fenwick Resources and Reserves (2,514,188 measured and indicated ounces against 1,800,442 reserve ounces, both rounded; 1,656,406 ounces recovered)
- Chapters 5 and 6: Fenwick Study Economics (NPV $463,697,937 at 5.0 percent and $2,000 gold, IRR 19.0 percent, both rounded)
- Chapter 7: Fenwick Overrun and Delay (capital from $520,000,000 to $610,000,000, first gold six months later; NPV $324,696,000, IRR 13.8 percent, both rounded)
- Chapter 8: Brannock Facility, Brannock Interest and Fees (the Fund's 15 percent of a $400,000,000 loan; $12,471,146, rounded, of interest and fees received to 30 September 2026)
- Chapters 9 and 10: Brannock Ramp-Up and Offtake, Completion and DSCR (72.0 percent of nameplate and a projected DSCR of 1.27x, rounded, at the long-stop; 1.59x, rounded, after the amendment)
- Chapter 11: Fenwick NSR Royalty (bought for $40,000,000; the six-month delay costs $1,977,304, rounded; impairment test $50,261,857, rounded, so carried at cost)
- Chapter 12: Silver Stream Deliveries, Stream Value (2,517,387 ounces delivered; uncredited deposit $168,061,832; NPV $246,056,165, rounded, at the $35 deck)
- Chapter 13: Concentrate Shipment (the trader pays Quillan a balance of $3,501,266, rounded); the offtake floor on Brannock Ramp-Up and Offtake ($3,600,000 and $4,920,000 borne by the offtaker)
- Chapter 14: Gold Collar (at $4,350 gold Harland would pay the bank $350 an ounce, $33,600,000 over all expiries, a counterfactual)
- Chapter 15: Fund Portfolio (gross multiple 1.25x, rounded, on $350,000,000 of cost)

## Two inputs to change first

1. On Inputs, change one quarter's silver price in the Quillan table: watch the ongoing payment, the credit against the deposit and the uncredited deposit move on Silver Stream Deliveries, then the silver credit and both AISC figures on Quillan Mine and AISC.
2. On Inputs, move Fenwick Hill's revised first gold date by a further six months: watch the royalty's value and the cost of the delay on Fenwick NSR Royalty, and the collar expiries that fall before production on Gold Collar. 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. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Kestrelmoor, Quillan, Harland, Fenwick Hill, Brannock and every other name in the case are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case prices, grades, costs, rates and figures are illustrative assumptions, not market data or benchmarks. Provided as is, without warranty. Not investment, legal, tax, engineering or accounting advice.
