Mining model: copper-gold mine NAV
Mine plan, payable metal, C1 and AISC, NAV per share. Build a single open-pit mine from its reserve: ore mined and milled against the mill’s throughput, waste from the strip ratio, a head grade that declines and reconciles to the reserve, recovery and smelter terms to payable copper and gold, prices on a deck, C1 cash cost and all-in sustaining cost per pound, depletion on units of production, a closure provision settled at the end, tax with losses carried forward and a project loan, then NAV per share and P/NAV in real terms.
By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.
On this subject: mining model: copper-gold mine nav.Updated 11 November 2026
Who builds it, and for whatThe model a metals and mining analyst keeps for every mine a company owns, and the one a natural resources banker or a mining private equity fund rebuilds before advising on, lending to or buying an asset. Equity research uses it to set a price target as a multiple of net asset value and to say where a mine sits on the cost curve; project lenders read the same life-of-mine cash flows for cover ratios and the reserve left when the loan is repaid; a buyer tests what a lower price deck or a disappointing grade does to the value of the reserve.
Every sheet below, in your browser, with its outputs and checks
Starter workbook free with an account. Worked model: one a month with Plus, every one with Pro. Downloads
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Assumptions | ||||||||||||||||
| 2 | $m unless stated, in real terms (constant FY0 dollars). Ore in million tonnes (Mt), copper in million pounds (Mlb), gold in thousand ounces (koz). All figures are illustrative. | ||||||||||||||||
| 4 | Year | Unit | FY0 | FY1 | FY2 | FY3 | FY4 | FY5 | FY6 | FY7 | FY8 | FY9 | FY10 | FY11 | FY12 | Notes | |
| 5 | Year number | # | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | FY0 = 0, the valuation date. Drives the grade profile, discounting and the closure provision. | |
| 7 | Scenario | ||||||||||||||||
| 8 | Scenario | # | 1 | 1 = base, 2 = price fall, 3 = grade and recovery shortfall. From FY1. | |||||||||||||
| 9 | Head grade, % of plan, shortfall case | % | 92.0% | The mill is fed less metal than the reserve model predicted. Applies to copper and gold. | |||||||||||||
| 10 | Recovery, change from plan, shortfall case | pp | -3.0% | Percentage points off the copper and the gold recovery. | |||||||||||||
| 12 | Price deck | ||||||||||||||||
| 13 | Copper price, base deck | $ per lb | 4.60 | 4.50 | 4.40 | 4.30 | 4.25 | One price per year, in real terms. | |||||||||
| 14 | Copper price, price fall | $ per lb | 3.60 | 3.40 | 3.40 | 3.50 | 3.60 | ||||||||||
| 15 | Copper price, selected scenario | $ per lb | 4.60 | 4.50 | 4.40 | 4.30 | 4.25 | 4.25 | 4.25 | 4.25 | 4.25 | 4.25 | 4.25 | 4.25 | Held flat after FY5. The shortfall case keeps the base deck. | ||
| 16 | Gold price, base deck | $ per oz | 3400 | 3200 | 3000 | 2800 | 2700 | ||||||||||
| 17 | Gold price, price fall | $ per oz | 2700 | 2500 | 2400 | 2400 | 2400 | ||||||||||
| 18 | Gold price, selected scenario | $ per oz | 3400 | 3200 | 3000 | 2800 | 2700 | 2700 | 2700 | 2700 | 2700 | 2700 | 2700 | 2700 | Held flat after FY5. | ||
| 20 | Ore reserve and mine plan | ||||||||||||||||
| 21 | Ore reserves, FY0 | Mt | 270.0 | Proven and probable: the ore that can be mined at a profit under the plan. | |||||||||||||
| 22 | Reserve grade, copper | % Cu | 0.45 | Tonnes of copper per 100 tonnes of ore. | |||||||||||||
| 23 | Reserve grade, gold | g/t Au | 0.25 | Grams of gold per tonne of ore. | |||||||||||||
| 24 | Mill throughput | Mt a year | 20.0 | 20.0 | 20.0 | 24.0 | 24.0 | 24.0 | 24.0 | 24.0 | 24.0 | 24.0 | 24.0 | 24.0 | What the concentrator can process. The expansion lifts it from FY4. | ||
| 25 | Strip ratio | t waste per t ore | 2.60 | 2.60 | 2.50 | 2.40 | 2.30 | 2.20 | 2.00 | 1.80 | 1.60 | 1.40 | 1.20 | 1.00 | Waste moved to expose a tonne of ore. It falls as the pit reaches its final walls. | ||
| 26 | Decline in head grade, annual | % | 3.0% | The pit reaches its best ore first. The profile is scaled to the reserve grade. | |||||||||||||
| 27 | Copper recovery, plan | % | 88.0% | Share of the copper in the ore that reaches the concentrate. | |||||||||||||
| 28 | Gold recovery, plan | % | 62.0% | Gold follows the copper into the concentrate, less completely. | |||||||||||||
| 29 | Pounds per tonne | lb | 2,204.62 | ||||||||||||||
| 30 | Grams per troy ounce | g | 31.10 | ||||||||||||||
| 32 | Smelter terms and royalty | ||||||||||||||||
| 33 | Concentrate grade | % Cu | 26.00 | Copper in a dry tonne of concentrate. | |||||||||||||
| 34 | Payable copper | % | 96.5% | The share of copper in the concentrate the smelter pays for. | |||||||||||||
| 35 | Payable gold | % | 95.0% | ||||||||||||||
| 36 | Treatment charge | $ per dmt | 80 | Per dry tonne of concentrate smelted. | |||||||||||||
| 37 | Copper refining charge | $ per lb | 0.08 | Per pound of payable copper. | |||||||||||||
| 38 | Gold refining charge | $ per oz | 5 | Per ounce of payable gold. | |||||||||||||
| 39 | Concentrate freight | $ per dmt | 65 | Trucking to the port and the voyage to the smelter. | |||||||||||||
| 40 | Royalty, % of net smelter return | % | 3.0% | Paid to the state on revenue after smelter charges and freight. | |||||||||||||
| 42 | Operating costs | ||||||||||||||||
| 43 | Mining cost | $ per t mined | 2.80 | Drilling, blasting, loading and hauling, on every tonne moved, ore or waste. | |||||||||||||
| 44 | Processing cost | $ per t milled | 10.50 | Crushing, grinding, flotation and tailings. | |||||||||||||
| 45 | Site general and administrative | $m | 60.0 | Camp, site management and services. Fixed while the mill runs. | |||||||||||||
| 46 | Corporate general and administrative | $m | 18.0 | Head office. Inside all-in sustaining cost, outside C1. | |||||||||||||
| 48 | Capital spending and the mine property | ||||||||||||||||
| 49 | Sustaining capital | $m | 55.0 | 55.0 | 55.0 | 60.0 | 60.0 | 60.0 | 60.0 | 60.0 | 55.0 | 45.0 | 30.0 | 10.0 | Tailings dam lifts, haul truck replacement and plant rebuilds: what keeps the mine at its present rate. | ||
| 50 | Expansion capital | $m | - | 90.0 | 110.0 | - | - | - | - | - | - | - | - | - | The mill expansion that lifts throughput from FY4. Throughput above is an input of its own: to test the mine without the expansion, set this to nil and hold throughput at 20 Mt. | ||
| 51 | Net book value of the mine, FY0 | $m | 1,400.0 | Mine development, plant and equipment, net of depletion to date. | |||||||||||||
| 53 | Closure and rehabilitation | ||||||||||||||||
| 54 | Closure and rehabilitation cost | $m | 300.0 | In FY0 dollars, paid at the end of the final year of the plan. | |||||||||||||
| 55 | Discount rate for the provision, real | % | 2.0% | A risk-free real rate, as the accounting standard requires. | |||||||||||||
| 57 | Tax | ||||||||||||||||
| 58 | Tax rate | % | 30.0% | ||||||||||||||
| 59 | Tax losses brought forward, FY0 | $m | 250.0 | From the construction years. Carried forward without limit. | |||||||||||||
| 61 | Project loan | ||||||||||||||||
| 62 | Project loan, FY0 | $m | 450.0 | ||||||||||||||
| 63 | Years to repay | years | 5 | Equal instalments from FY1. | |||||||||||||
| 64 | Interest rate, real | % | 5.0% | On the opening balance. | |||||||||||||
| 65 | Cash, FY0 | $m | 150.0 | ||||||||||||||
| 67 | Valuation | ||||||||||||||||
| 68 | Discount rate, real | % | 8.0% | The rate usually applied to copper mines. After tax, year-end discounting. | |||||||||||||
| 69 | Second discount rate, real | % | 5.0% | The rate gold miners are usually quoted at, for comparison. | |||||||||||||
| 70 | Shares outstanding | m shares | 200.0 | ||||||||||||||
| 71 | Share price, assumed | $ per share | 9.50 | Illustrative input, for P/NAV. | |||||||||||||
Select a cell to see its row, its schedule and the type of cell. Font colours: blue for inputs, black for formulas, green for links to other sheets. Scroll sideways to see every period.
Download
Mining model: copper-gold mine NAV: the workbook
An Excel workbook with working formulas, no macros and no external links: the same model you can work with on this page.
- Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
- Free accountWork with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.
- L3VLUP Plus$4.99/monthEverything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.
- L3VLUP Pro$25/monthEverything in Plus, every worked model in the library, and the Pro applications.
- The worked model
- 11 sheets and 1,377 live formulas, all 9 schedules built and linked, every check reading zero. Change an input in Excel and the whole model moves.
- The starter
- The same inputs and layout with the mine plan: from ore reserve to payable metal left blank for you to build, each blank cell marked. The worked model is its answer.
What the base case says
- NAV per share ($)
- 11.87
- Net asset value
- $2,374.3m
- Value of the mine
- $2,674.3m
- Price / NAV (x)
- 0.80
- NAV per share at the second discount rate ($)
- 13.96
- Mine life in the plan (years)
- 12
- Payable copper, FY1 (Mlb)
- 198.67
- Payable gold, FY1 (koz)
- 111.64
- Net smelter return, FY1
- $1,224.9m
- C1 cash cost, FY1 ($ per lb)
- 0.81
- All-in sustaining cost, FY1 ($ per lb)
- 1.36
- All-in sustaining cost, life of mine ($ per lb)
- 1.83
- EBITDA, FY1
- $698.6m
- Unlevered free cash flow, FY1
- $541.3m
- Debt service cover ratio, lowest year
- 2.6x
Read from the workbook as served, every input at its default. Periods: FY0, FY1, FY2, FY3, FY4, FY5, FY6, FY7, FY8, FY9, FY10, FY11, FY12. The figures are invented and move with whatever you type in.
What this model is
A life-of-mine model of an invented open-pit copper-gold mine and the single-asset company that owns it: twelve years of mining (FY1 to FY12) from a reserve of 270 million tonnes, valued at the end of FY0.
The mine plan runs from ore to payable metal. Ore mined and milled is the lesser of the mill’s throughput and the reserve left; waste follows the strip ratio; head grade declines through the life and is scaled to the reserve grade; the concentrator recovers part of the metal and the smelter pays for part of that, after treatment and refining charges.
Costs are built per tonne mined and per tonne milled and then quoted the way the industry quotes them: C1 cash cost per pound of payable copper, net of the gold credit, and all-in sustaining cost, which adds royalties, sustaining capital and corporate overhead. Expansion capital is kept apart.
The mine is depleted on units of production, its closure cost is provided for and paid in the final year, tax carries losses forward, and a project loan is read on its cover ratios and reserve tail.
The value is a net asset value: after-tax cash flows over the life of the mine at a real discount rate, less net debt, per share, with P/NAV. Three scenarios (base, a price fall, and a grade and recovery shortfall) and two board-style sensitivity tables.
Seats: Equity research and hedge funds, Investment banking, Private equity.
Careers that do this work: infrastructure & real assets, debt capital markets, private credit.
How the schedules connect
Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.
Mine plan: from ore reserve to payable metal
Ore and waste, head grade, recovery, smelter payables
Assumptions, rows 21–30 · Mine Plan, rows 6–14 · Mine Plan, rows 17–23 · Mine Plan, rows 26–35
Revenue build
Where the top line comes from
Assumptions, rows 13–18 · Assumptions, rows 33–40 · Revenue, rows 6–11 · Revenue, rows 14–19
C1 cash cost and all-in sustaining cost
Site costs, by-product credit, royalties, sustaining capital
Assumptions, rows 43–46 · Costs, rows 6–10 · Costs, rows 13–16 · Costs, rows 19–26 · Costs, rows 29–31
Capex and depreciation (PP&E roll-forward)
Opening, plus capex, less depreciation, closing
Assumptions, rows 49–51 · Capital, rows 6–8 · Capital, rows 11–14
Mine closure and rehabilitation provision
A cost at the end of life, discounted, unwound, settled
Assumptions, rows 54–55 · Capital, rows 17–21
Tax
Tax on profit, and tax on operating profit
Assumptions, rows 58–59 · Cash Flow, rows 11–17
Debt schedule
Tranches, interest, amortisation and the sweep
Assumptions, rows 62–65 · Debt, rows 6–10 · Debt, rows 13–19
Discounting and terminal value
Discount factors, two terminal methods, reconciled
Assumptions, rows 68–71 · NAV, rows 6–8 · NAV, rows 11–19
Sensitivity tables
Two assumptions at once, without a data table
Sensitivity, rows 5–8 · Sensitivity, rows 11–16 · Sensitivity, rows 19–24 · Sensitivity, rows 28–33 · Sensitivity, rows 36–53
What you should be able to explain
- How a reserve in tonnes and grade becomes a mine plan, and why the reserve and the mill’s throughput together set the mine life.
- Why the strip ratio drives mining cost: waste costs as much to move as ore and earns nothing.
- How head grade, recovery and the smelter’s payable terms each take a share of the metal between the ground and the invoice, and what treatment and refining charges are.
- What C1 cash cost and all-in sustaining cost include, why gold is credited against the cost of copper, and why expansion capital sits outside both.
- Why a mine is depleted on units of production and how a closure provision is built up and then paid when there is no profit left to deduct it from.
- How a life-of-mine NAV is discounted in real terms with no terminal value, and what a share trading below or above 1.0 times NAV is saying.
What a reviewer looks for
- Production grown at a rate rather than scheduled from the reserve and the mill, so the mine never runs out of ore.
- A head grade held at the reserve average every year, or a plan that mills more metal than the reserve holds.
- Mining cost charged on ore alone, so the strip ratio costs nothing.
- Contained metal sold at the full price, with no recovery loss, payable share or smelter charges.
- Expansion capital inside all-in sustaining cost, or sustaining capital left out of the cash flow because it is not in C1.
- Nominal prices discounted at a real rate, a terminal value on an asset that ends, or the closure cost left out because it falls in the last year.
Conventions this workbook uses
Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.
- Real terms. Prices and every cost are in constant FY0 dollars, nothing is inflated, and the discount rates are real. Annual periods; FY0 is the valuation date and carries balances only. Every scenario changes FY1 onwards.
- Ore mined = ore milled = the lesser of mill throughput and the opening reserve: there is no stockpile, and the reserve sets the mine life. Waste = ore x strip ratio. The plan must exhaust the reserve within twelve years, and a check says so if it does not.
- Head grade follows a profile that declines by a fixed percentage a year, scaled so that the ore milled over the plan averages the reserve grade for copper and for gold. The shortfall case multiplies both grades by a factor and lowers both recoveries.
- Copper: ore x grade x recovery gives copper in concentrate; x the payable share gives payable copper, in pounds at 2,204.62 to the tonne. Gold: ore x grams per tonne x recovery x the payable share, in troy ounces of 31.1035 grams.
- Net smelter return = payable metal at the price deck - treatment charges per dry tonne of concentrate - refining charges - freight. The royalty is a share of it and is shown as a cost. Copper and gold prices are held flat after FY5.
- C1 cash cost = site costs + treatment, refining and freight - gold revenue, per pound of payable copper. All-in sustaining cost = C1 + royalty + sustaining capital + corporate overhead. Expansion capital is in neither.
- Depletion on units of production: (opening net book value + capital spending in the year) / opening ore reserves x ore milled. The mine property is nil when the reserve is.
- The closure provision at FY0 is the closure cost discounted at a real risk-free rate over the mine life; it unwinds each year and is settled in cash at the end of the final year. The cost is deductible when paid.
- Tax is charged on operating profit less closure cost paid, after losses carried forward without limit, and is worked before interest: the cash flow valued is unlevered. No working capital is modelled.
- Interest is on the opening loan balance and the loan is repaid in equal instalments. Cover ratios use unlevered free cash flow. NAV = life-of-mine free cash flow discounted to the end of FY0 with year-end discounting, less net debt at FY0. There is no terminal value.
- The NAV table moves the whole copper deck in parallel and recomputes tax with its losses for each price; the cost table restates FY1. The centre of each equals the model.
What this model does not cover
Where its answer stops, so you know what to add before relying on it.
- A cut-off grade. The reserve is fixed, so a lower price does not shrink it or shorten the mine life, as it would in practice.
- Stockpiles, a ramp-up, and several pits or ore types. One pit feeds one mill and every tonne mined is milled in the year.
- Resources outside the reserve, exploration upside and any value beyond the mine plan.
- Streams, offtake prepayments, hedging and the quotational period on concentrate sales.
- Inflation and exchange rates. The model is in real US dollars; a mine with costs in a local currency needs both.
- A closure fund or bond. The cost is paid from cash in the final year.
- A real company. Freeport-McMoRan and Newmont are candidates for a case built from their filings and technical reports; this model uses invented figures.
Build it yourself
The starter workbook
The Mine Plan sheet has been cleared: the reserve rolled forward as ore is mined and milled, waste and material moved, reserve life, the head grade profile scaled to the reserve grade, recovery, concentrate, and payable copper and gold. Rebuild it from the Assumptions sheet, then switch to the grade and recovery shortfall and watch payable metal, the all-in sustaining cost and NAV per share move.
Blanks: Mine plan: from ore reserve to payable metal. Download it beside the worked model.
The path around this model
Understand it, drill it, read the build, then apply it to a real company.
Build · Lab · ~15 min
DCF Builder
Build a DCF by hand from revenue to a share price, know how much of it sits in the terminal value, and name the one assumption the answer hinges on.
Build · Lab · ~12 min
WACC Builder
Build a discount rate you can defend line by line: beta, equity risk premium and cost of debt, each from a source you can name.
Build · Lab · ~12 min
DSCR Sculpting
Sculpt debt service to CFADS at a target DSCR, size the loan as its present value, split a payment into interest and principal, and explain why a level repayment profile fails a project lender.
Read · Guide · 7 min
Equity Research Interview Questions: The Coverage Mindset
Read · Guide · 16 min
How to Build a DCF Model: From Operating Assumptions to a Defensible Valuation
Read · Guide · 10 min
Scenario and Sensitivity Architecture: Building a Model That Can Be Stress-Tested
Apply · Skill
Company Profile
Build a banker-grade one-pager on any company, fast.
Apply · Skill
Model Audit
Find the errors in a financial model before someone senior does.
Vocabulary: All-In Sustaining Cost (AISC), Strip Ratio, Price to NAV (P/NAV), DSCR (Debt Service Coverage Ratio), LLCR (Loan Life Coverage Ratio), Depreciation & Amortisation (D&A), Net Debt, Free Cash Flow (FCF).
Questions about this model
How does the mine plan turn ore into payable metal?
In FY1 the mine mills 20.0 million tonnes of ore and moves 52.0 million tonnes of waste at a strip ratio of 2.6. The ore grades 0.53% copper and 0.29 grams of gold a tonne, above the reserve average of 0.45% and 0.25, because the pit reaches its best ore first. The concentrator recovers 88% of the copper and 62% of the gold, and the smelter pays for 96.5% and 95% of what arrives: 198.7 million pounds of copper and 111.6 thousand ounces of gold. At $4.60 a pound and $3,400 an ounce, less $68.5 million of treatment, refining and freight, the net smelter return is $1,224.9 million.
What are the C1 cash cost and the all-in sustaining cost here?
FY1 site costs are $471.6 million. Adding the smelter charges and freight and crediting $379.6 million of gold revenue leaves $160.6 million, a C1 cash cost of $0.81 a pound of payable copper. Royalties of $36.7 million, $55.0 million of sustaining capital and $18.0 million of corporate overhead take it to an all-in sustaining cost of $1.36. Over the life of the mine the two average $1.30 and $1.83 as the grade falls to 0.38% copper in FY12.
What is the NAV, and what is P/NAV?
The after-tax cash flows of the twelve-year mine life, in real terms and discounted at 8%, are worth $2,674.3 million. Less $300.0 million of net debt that is a net asset value of $2,374.3 million, or $11.87 a share on 200 million shares. At an assumed share price of $9.50 the shares trade on 0.80 times NAV. At a 5% discount rate, the rate gold miners are usually quoted at, NAV is $13.96 a share.
What do the two downside scenarios do?
In the price fall copper drops to $3.60 and then $3.40 a pound and gold to $2,400 an ounce. NAV falls to $6.66 a share, so the same share price is 1.43 times NAV, and in FY3, when $110.0 million of expansion capital is being spent, free cash flow covers only 0.92 times the debt service. Cover here is measured after expansion capital; a lender funding the expansion from equity or a capex facility would leave it out, and the year would then cover about twice. In the grade and recovery shortfall the mill sees 92% of the planned grade and recovers three points less: FY1 payable copper falls to 176.5 million pounds, the all-in sustaining cost rises from $1.36 to $1.73 a pound, and NAV is $8.63 a share.
How is closure treated?
Closing and rehabilitating the site costs $300.0 million in FY0 dollars, paid at the end of FY12. The provision starts at $236.5 million, the cost discounted at a 2% real rate, and unwinds each year until it is settled. The cost is deductible when paid, but by then the mine earns too little to use it: $196.5 million of tax losses are left unused at the end of the plan.
Related models
Infrastructure and project finance · Advanced
Upstream oil and gas model: E&P
Type curves, reserves, netbacks, PV-10 and NAV per share
Infrastructure and project finance · Advanced
Project finance model
Sculpted debt, reserves, lock-up, coverage ratios
Core modelling · Core
Discounted cash flow model
Unlevered free cash flow to a share price
Questions about this model
Discussions open here soon.