Cashflow Modler App

This Cashflow Modeller App is a simplified version of a DCF and is for entertainment purposes only.   Mining studies apply much more complex DCF models.  This simplification was done in an attempt to reduce the number of User inputs required. Hence some of the limitations of this model are:

• This DCF app can simulate a combined open pit and underground operation, but the UG mine will be added to the end of OP production.   Simultaneous OP & UG mining is not available. 

• The OP strip ratio is applied equally each year.  Early year higher stripping ratios are not available.

• The production grade profile is a flat line average grade per year.   A trending grade profile may be added as an option in the future.

• This DCF app cannot use multiple ore types with different recoveries, payables (e.g. a heap leach + concentrator cannot be modelled).   

• The DCF app does not incorporate concentrate smelter terms.  These additional costs & deductions are addressed by applying a Payable% factor to each metal.

• The DCF economics are shown on an After-Tax basis.  The tax calculation is simple to allow for some cash deduction for taxes.   To see pre-tax results, set the Tax Rate to 0%.

• If you have a very long life mine, to view the entire cashflow model reduce the zoom level on your browser.

The left sidebar on the summary screen is for the data input fields.   There will be an optional download csv template which willl allow offline collection of input data and then uploading that file. 

PROJECT NAME: 

RESOURCE

• Open Pit Reserves (Mt):

• Open Pit Strip Ratio:

• UG Ore Reserves (Mt):

• Mine Life (yrs):   (The production rate will be based on Total Reserves / Years)

METALS (Up to five metals - repeat for each metal)

• Metal Price ($/oz or $/lb):

• Recovery %:

• OP Grade (g/t or %):

• UG Grade (g/t or %):

• Grade Unit (% or g/t):

• Price Unit ($/oz or $/lb):

OPERATING COSTS (OpEx)

• OP Ore Mining cost ($/t ore):

• OP Waste Mining cost ($/t):

• UG Mining cost ($/t ore):

• Processing cost ($/t ore):

• G&A cost ($/t ore):

CAPITAL (CapEx)

• Initial Capital ($M):   (this will be equally spread over construction period)

• Sustaining Capital ($M/year):

• Closure Cost ($M):

• Construction Period (years):

FINANCE

• NSR Royalty (%):

• Discount Rate (%):

• Tax Rate (%):