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