About Services Tools Blog Contact us

Project Returns Calculator

A calculator for a web page that shows how project returns change with the commodity price, using figures worked out in advance and not a live financial model.

  • Web Tools
  • Mining and exploration
  • Tool
  • Productised
  • Cloud
  • 2023

The problem

A study update quoted its economics at a single price. Visitors could not see how returns moved when the price changed. The company did not want to publish the full model.

What it does

The study results for each price step are copied into tables inside one small piece of page code. A visitor moves a slider to set the price, and the calculator picks the nearest step in the tables and shows the return, rate, earnings and payback. A switch selects a second development case. The calculator can be added to the company website.

Outcomes

  • Visitors can see how returns move across a price range.
  • The full financial model stays unpublished.
  • Two development cases share one control.
  • The calculator is a small addition to the page and not a separate program.

Simplified mockup

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

Returns at a price

Not a live model
Development case
Metal price
£8,000/t
Nearest study step £8,000/t
£6,400£9,600
The slider can sit between steps. The figures always come from the nearest row in the table. Nothing is interpolated, and the workbook is not on the page.
NPV
£120m
IRR
18%
EBITDA
£40m
Payback
6 years

Copied study steps

The highlighted row is the step in use
Starter pit
PriceNPVIRREBITDAPayback
£6,400429%1811.0
£7,2008114%298.0
£8,00012018%406.0
£8,80016423%524.5
£9,60021028%663.5
Expanded plant
PriceNPVIRREBITDAPayback
£6,400187%2213.0
£7,2007012%369.0
£8,00018615%618.0
£8,80025021%785.5
£9,60034026%984.0
NPV by price step · starter pit
Bars are £m of NPV. Labels are the metal price in thousands of pounds per tonne.

Drop-in snippet

Study update
How returns move with the metal price
Visitors can drag the price. The page reads a small table of study steps for the starter pit. The workbook is not published.
NPV£120m
IRR18%
EBITDA£40m
Payback6 years
Asked price £8,000/t · Nearest study step £8,000/t

How it works

  1. Take the study results at each price step for each development case.
  2. Copy those rows into tables inside the calculator.
  3. Set the commodity price with a slider.
  4. Pick the nearest price step and show the four figures.
  5. Load the second development case when the switch is used.
  6. Style the calculator to match the company page.

Pipeline

flowchart LR
  A[Price steps] --> B[Lookup tables]
  B --> C[Price slider]
  C --> D[Nearest step]
  D --> E[Four figures]
  F[Case switch] --> D