Infrastructure and project financeAdvanced · ~50 minWorking draft · 11 sheets · 1377 formulas

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

Inspect the workbook
All checks read zero100%
Every value, every sheet, as the workbook holds it.
ABCDEFGHIJKLMNOPQ
1Assumptions
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.
4YearUnitFY0FY1FY2FY3FY4FY5FY6FY7FY8FY9FY10FY11FY12Notes
5Year number#0123456789101112FY0 = 0, the valuation date. Drives the grade profile, discounting and the closure provision.
7Scenario
8Scenario#11 = base, 2 = price fall, 3 = grade and recovery shortfall. From FY1.
9Head grade, % of plan, shortfall case%92.0%The mill is fed less metal than the reserve model predicted. Applies to copper and gold.
10Recovery, change from plan, shortfall casepp-3.0%Percentage points off the copper and the gold recovery.
12Price deck
13Copper price, base deck$ per lb4.604.504.404.304.25One price per year, in real terms.
14Copper price, price fall$ per lb3.603.403.403.503.60
15Copper price, selected scenario$ per lb4.604.504.404.304.254.254.254.254.254.254.254.25Held flat after FY5. The shortfall case keeps the base deck.
16Gold price, base deck$ per oz34003200300028002700
17Gold price, price fall$ per oz27002500240024002400
18Gold price, selected scenario$ per oz340032003000280027002700270027002700270027002700Held flat after FY5.
20Ore reserve and mine plan
21Ore reserves, FY0Mt270.0Proven and probable: the ore that can be mined at a profit under the plan.
22Reserve grade, copper% Cu0.45Tonnes of copper per 100 tonnes of ore.
23Reserve grade, goldg/t Au0.25Grams of gold per tonne of ore.
24Mill throughputMt a year20.020.020.024.024.024.024.024.024.024.024.024.0What the concentrator can process. The expansion lifts it from FY4.
25Strip ratiot waste per t ore2.602.602.502.402.302.202.001.801.601.401.201.00Waste moved to expose a tonne of ore. It falls as the pit reaches its final walls.
26Decline in head grade, annual%3.0%The pit reaches its best ore first. The profile is scaled to the reserve grade.
27Copper recovery, plan%88.0%Share of the copper in the ore that reaches the concentrate.
28Gold recovery, plan%62.0%Gold follows the copper into the concentrate, less completely.
29Pounds per tonnelb2,204.62
30Grams per troy ounceg31.10
32Smelter terms and royalty
33Concentrate grade% Cu26.00Copper in a dry tonne of concentrate.
34Payable copper%96.5%The share of copper in the concentrate the smelter pays for.
35Payable gold%95.0%
36Treatment charge$ per dmt80Per dry tonne of concentrate smelted.
37Copper refining charge$ per lb0.08Per pound of payable copper.
38Gold refining charge$ per oz5Per ounce of payable gold.
39Concentrate freight$ per dmt65Trucking to the port and the voyage to the smelter.
40Royalty, % of net smelter return%3.0%Paid to the state on revenue after smelter charges and freight.
42Operating costs
43Mining cost$ per t mined2.80Drilling, blasting, loading and hauling, on every tonne moved, ore or waste.
44Processing cost$ per t milled10.50Crushing, grinding, flotation and tailings.
45Site general and administrative$m60.0Camp, site management and services. Fixed while the mill runs.
46Corporate general and administrative$m18.0Head office. Inside all-in sustaining cost, outside C1.
48Capital spending and the mine property
49Sustaining capital$m55.055.055.060.060.060.060.060.055.045.030.010.0Tailings dam lifts, haul truck replacement and plant rebuilds: what keeps the mine at its present rate.
50Expansion capital$m-90.0110.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.
51Net book value of the mine, FY0$m1,400.0Mine development, plant and equipment, net of depletion to date.
53Closure and rehabilitation
54Closure and rehabilitation cost$m300.0In FY0 dollars, paid at the end of the final year of the plan.
55Discount rate for the provision, real%2.0%A risk-free real rate, as the accounting standard requires.
57Tax
58Tax rate%30.0%
59Tax losses brought forward, FY0$m250.0From the construction years. Carried forward without limit.
61Project loan
62Project loan, FY0$m450.0
63Years to repayyears5Equal instalments from FY1.
64Interest rate, real%5.0%On the opening balance.
65Cash, FY0$m150.0
67Valuation
68Discount rate, real%8.0%The rate usually applied to copper mines. After tax, year-end discounting.
69Second discount rate, real%5.0%The rate gold miners are usually quoted at, for comparison.
70Shares outstandingm shares200.0
71Share price, assumed$ per share9.50Illustrative 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.

  1. Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
  2. 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.
  3. 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.
  4. 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.

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.

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

Questions about this model

Discussions open here soon.

All discussions

Share your result 📊

𝕏in💬🤖

Instagram and TikTok have no desktop share link, so copy the caption and paste it into the app.