About Services Tools Blog Contact us

Copper Price Sensitivity Calculator

A slider over a ready-made table that shows how a copper project's NPV, IRR, EBITDA and payback move with the metal price, for two development stages.

  • Market Data & Share Prices
  • Mining and exploration
  • Tool
  • Productised
  • Cloud
  • 2023

The problem

Investors want to see project returns at different copper prices during a call. Rebuilding a spreadsheet while everyone waits stops the conversation.

What it does

The page loads a table of price points and results. The viewer moves a slider, and the page picks the nearest price row, in pounds and dollars per tonne, and shows NPV, IRR, EBITDA and payback from it. A toggle switches between two project stages. The figures are looked up from the table and not recalculated, and the host page must supply its own labels.

Outcomes

  • Four return measures move with the copper price during a meeting.
  • Two development stages share the same slider.
  • Nobody rebuilds a spreadsheet on the call.
  • The page looks up a table and does not recalculate the financial model.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Copper price sensitivity

Metal price Study case
9,000 USD/t
£6,871/t at desk rate 0.7634

Build at this price: NPV £67m

6,000Nearest row, not a smooth curve12,000
NPV
£42m
IRR
17.6%
EBITDA
£44m
Payback
4.9 yr
NPV against copper price
6k 9k 12k
Study NPV Build NPV Marker sits on the nearest row

Lookup, not a live cash-flow model.

Precomputed returns

No interpolation
Study column
USD/tNPVIRREBITDAYears
6,000£8m9.2%£18m7.4
7,000£18m11.4%£24m6.6
8,000£29m14.1%£33m5.8
9,000£42m17.6%£44m4.9
10,000£58m21.4%£57m4.1
11,000£76m25.8%£71m3.4
12,000£97m30.5%£88m2.8
Build column
USD/tNPVIRREBITDAYears
6,000£14m11.0%£22m6.8
7,000£28m13.6%£31m6.0
8,000£46m16.8%£42m5.2
9,000£67m20.4%£58m4.4
10,000£91m24.6%£74m3.7
11,000£118m29.1%£93m3.2
12,000£149m34.0%£116m2.7

The highlighted row is the nearest price on the slider. A price between rows does not blend the two results.

Call brief

What you can say without opening the spreadsheet

East Lode, study case, at 9,000 USD per tonne: NPV £42m, IRR 17.6%, EBITDA £44m, payback 4.9 years. The other stage at the same price is NPV £67m. Read from the table, not recomputed.

Pin for the pack
Ready to pin the row on screen
  1. Nearest price row
  2. Active stage
  3. Four return metrics
  4. Model left in the table

How it works

  1. Load the ready-made table of prices and returns.
  2. Match the slider position to the nearest price row.
  3. Fill NPV, IRR, EBITDA and payback from that row.
  4. Switch to the other set of figures when the stage toggle changes.
  5. Keep the financial model in the table and out of the page.

Pipeline

flowchart LR
  Table[Precomputed table] --> Slider[Metal price]
  Slider --> Row[Nearest row]
  Stage[Stage toggle] --> Row
  Row --> Npv[NPV and IRR]
  Row --> Pay[EBITDA and payback]