DEFAULT VALUESPush from Commercial Parameters to update|

Mining Economics Calculators

RPM Training — 18 interactive workshops | Source: RPM Mining Economics Templates v2.11

Inputs auto-saved to project

Inputs — Simple DCF

Revenue/unit$/oz
Cost/unit$/oz
Capital$
Depreciationdec.bal
Tax Rate
Discount Rate
Production: Y1:42,000Y2:45,000Y3:60,000Y4:50,000Y5:40,000
NPV
$1.08M
IRR
15.5%
Payback
3.5yr

Year-by-Year Cash Flow

ItemY0Y1Y2Y3Y4Y5
Production (units)42,00045,00060,00050,00040,000
Operating Revenue$58.80M$63.00M$84.00M$70.00M$56.00M
Operating Cost-$32.76M-$35.10M-$46.80M-$39.00M-$31.20M
Operating Profit$26.04M$27.90M$37.20M$31.00M$24.80M
Capital Expenditure$90.15M
Tax Depreciation$24.79M$17.97M$13.03M$9.45M$6.85M
EOY Written Down Value$90.15M$65.36M$47.39M$34.35M$24.91M$18.06M
Salvage Value$18.06M
Taxable Profit$1.25M$9.93M$24.17M$21.55M$17.95M
Tax Payable-$437.1K-$3.47M-$8.46M-$7.54M-$6.28M
After Tax Profit$811.7K$6.45M$15.71M$14.01M$11.67M
Net Cash Flow-$90.15M$25.60M$24.43M$28.74M$23.46M$36.57M
Discount Factor @ 15%1.00000.86960.75610.65750.57180.4972
Discounted Cash Flow-$90.15M$22.26M$18.47M$18.90M$13.41M$18.18M
NPV$1.08M

NCF Waterfall

Y0
Y1
Y2
Y3
Y4
Y5

Cumulative Cash Flow

-90M
-65M
-40M
-11M
12M
49M

NPV Sensitivity (±20%)

NPV
+20%
-20%
Revenue
Cost
CapEx
Discount
100%