Alt Text

Get in touch

Would you like to discuss our training courses in more detail?
Call +61 2 8006 1728
or email us today.

Financial Modelling for Mining

This course has been designed for professionals who are responsible for the appraisal, development, management or analysis of mining projects.

This hands-on course covers all key aspects of financial modelling for mining analysis. It focuses on developing a mine evaluation model suitable for senior management, external parties and financiers. With our structured approach, you will learn how to develop more effective and robust models, in less time and with greater accuracy and transparency. You will build your skills with practical exercises and example files, and will take away a comprehensive course book.

Who should attend?

  • Project, transaction and investment analysts
  • Finance managers and financial controllers
  • Commercial managers
  • Strategic and business planners and forecasters
  • Investment bankers
  • Transaction advisers

Why would I choose this course?

  • Learn to develop financial models in a controlled, structured and transparent manner
  • Learn and apply best practice modelling principles and techniques
  • Learn about developing models specifically for mining projects
  • Learn more about what Excel can do for you, as well as useful keyboard shortcuts
  • Flexibly model mine development expenditure
  • Learn how to robustly model debt and understand debt coverage ratios
  • Learn how to increase the effectiveness and efficiency of models whilst reducing errors
  • Use a scenario manager and sensitivity analysis to understand risk

What skills do I need to do the course?

  • Intermediate Excel skills
  • An understanding of basic financial terminology (depreciation, capital expenditure, interest)
  • At least one–five years of relevant work experience

What will I learn from this course?

Learn how to apply a managed model development process:

  • Define the aims of a financial model
  • Incorporate stakeholders’ requirements into financial models
  • Learn why it’s essential to follow a defined model development process
  • Understand the six stages of model development
  • Define model outputs and design a summary dashboard

Use best-practice standards in your financial models:

  • Find out what ‘best practice’ is and why it is important
  • Learn the 10 golden rules for best-practice modelling

Professional and efficient set-up for model construction:

  • Learn file management and naming conventions
  • Learn custom number and date formats, conditional formatting and how to save styles
  • Modify the colour palette and integrate corporate colours
  • Develop a template sheet and timeline
  • Schedule events using timing flags
  • Integrate financial statements
  • Implement model checks

Develop operations calculations:

  • Develop operations calculations, considerations and logic structure
  • Model ROM volumes, waste and saleable product
  • Incorporate processing and transportation volume constraints and stockpiling
  • Include multiple commodities price paths and hedging arrangements
  • Apply indexations and escalations
  • Develop flexible cost driver expenditure calculations and unit cost analysis
  • Model working capital and the cash flow implications
  • Use control accounts for accurate and efficient model construction

Create flexible CAPEX profiles:

  • Create flexible development profiles
  • Analyse the impacts of delays, overspends and phasing changes
  • Apply various depreciation methodologies
  • Understand how to model depreciation efficiently

Efficient modelling of debt facilities and ratios:

  • Model refinancing a construction debt facility
  • Model debt facilities – interest and multiple principal payment mechanisms
  • Model flexible timings, interest only periods, commitment fees
  • Understand the theory and modelling of debt coverage ratios (DCRs)

Incorporating royalties and simplistic tax:

  • Model royalties mechanisms
  • Understand and model simplistic tax

Scenario and sensitivity development and management:

  • Learn how to develop a scenario manager
  • Define and run sensitivity tests
  • Use data tables to assist with multi-scenario and sensitivity presentation

Ensure quality, reduce errors and manage risk:

  • Learn quality control techniques, including final testing and peer review
  • Manage handover and issuing models to third parties
  • Learn about including disclaimers in models

Options for investment appraisal analysis and their application:

  • Calculate project value and internal rate of return
  • Learn the Excel functions for investment analysis and the functions’ potential pitfalls
  • Determine discount rates and WACC
  • Find out other options for investment appraisal analysis and their application

Organisations we have trained

Portfolio Image
Alinta Energy
Portfolio Image
Portfolio Image
Louis Dreyfus

In-house and group courses

We can deliver any of our courses anywhere in the world. We can either travel to you or host the course in the most convenient place for your team.

Why should you consider in-house training?

  • Customised content – we can tailor the agenda to suit your exact needs and even incorporate data from your business into the practical exercises.
  • Locally hosted – we travel to you and present either locally or at your premises, reducing the time you spend out of the office.
  • Group size – as in-house courses are often smaller groups, there is even more one-on-one time with the trainer.
  • Costs saving – an in-house course is delivered for a fixed fee regardless of the number attending, and you benefit from added savings on travel, accommodation and time.

The in-house option is ideal for teams of six or more. To talk about whether an in-house course is right for your business, please contact John Stroud on or +61 2 8006 1728.