What you will learn

Fast-track your growth in the field of financial modelling for the mining sector.

  • Structure financial models to tell a complete story of a mining business from input cost to net profit or retained cash.

  • Calculate debt capacity, determine the optimal capital structure for a mining company, and sculp debt repayment profiles optimally.

  • Perform stress testing and downside analysis on models to test the robustness of a capital structure (credit risk analysis).

Get the Edge!

Sign-up to fast-track your learning and development, and increase your confidence in the area of mining finance today.

Course curriculum

  • 1

    Let's get started!

    • A Message From Your Instructor

    • How to use this course

    • Desired Learning Outcomes Survey

  • 2

    Chapter 1: Introduction

    • Chapter 1 - Introduction

  • 3

    Chapter 2: Financial Covenants

    • Chapter 2 - Financial Covenants

  • 4

    Chapter 3: Constructing A Model

    • Chapter 3.1 - Profitability Drivers and Economic Assumptions

    • Chapter 3.2 - Internal Profitability Drivers

    • Chapter 3.3 - Process Flow (Putting the Links Together)

    • Chapter 3.4 - Tax

    • Practice Activity 3.4: Tax

    • Chapter 3.5 - Working Capital

    • Practice Activity 3.5: Working Capital

    • Chapter 3.6 - Debt

    • Practice activity 3.6: Debt

    • Chapter 3.7 - Accounting Statements

    • Chapter 3.8 - Cashflow Model

  • 5

    Chapter 4: Financial Model Analysis

    • Chapter 4.1 - Graphs Part 1

    • Chapter 4.2 - Graphs Part 2

    • Chapter 4.3 - Graphs Part 3

    • Chapter 4.4 - Data Summary and Useful Functions

    • Chapter 4.5 - Data Tables

    • Chapter 4.6 - Goal Seek Breakeven Analysis

  • 6

    Chapter 5: Financial Modelling - Advanced

    • Chapter 5.1 - The Summary Tab - Part 1

    • Chapter 5.2 - Mining Tab Part 1 - Building Scenario Analysis Capabilities

    • Chapter 5.3 - Mining Tab Part 2 - Building Stress Testing Capabilities

    • Chapter 5.4 - Mining Tab Part 3 - Real-time Data Analysis using Scenarios and Stress Testing

    • Chapter 5.5 - Cashflow Waterfalls and Cash Sweeps

    • Chapter 5.6 - The Debt Service Cover Ratio

    • Chapter 5.7 - The Loan Life Cover Ratio

    • Chapter 5.8 - The Project Life Cover Ratio

    • Chapter 5.9 - The Reserve Tail Ratio

    • Chapter 5.10 - Default vs Drawdown Covenants

    • Chapter 5.11 - Covenants and Subordinated Debt

    • Chapter 5.12 - Interaction between facilities and alignment of interests

    • Chapter 5.13 - Project Finance Covenants vs Corporate Covenants

    • Chapter 5.14 - Corporate Covenants

    • Chapter 5.15 - The Gearing Ratio

    • Bonus Lesson: Prepayment Facilities, Royalties and Streaming

    • Chapter 5.16 - Calculating Debt Capacity

    • Chapter 5.17 - Debt Summary Chart

    • Chapter 5.18 - Summary Tab Part 2 (Stresses, Ratios, and Graphs)

    • Chapter 5.19 - Summary Tab Part 3 (Sources and Uses and Presentations)

    • Chapter 5.20 - Per-period Breakevens

    • Chapter 5.21 - Long-term Breakeven

    • Chapter 5.22 - Hedging

    • Chapter 5.23 - Recap and Summary

    • Chapter 5.24 - Weighted Average Cost of Capital

    • Chapter 5.25 - Discounted Cash Flow Valuations

    • Chapter 5.26 - Valuation Data Tables

    • Chapter 5.27 - Summary Final

  • 7

    Next Steps...

    • Congratulations on Completing the Course!!

    • Before you go...

Instructor

Perry Fisher

Instructor

Perry Fisher

Perry has extensive experience in investment banking and education. While an investment banker he structured multimillion-dollar transactions, developed pricing models, managed investment-related risks, prepared client pitches and successfully closed deals. Prior to investment banking, Perry worked as a training facilitator for a small business incubator program. He also taught A-level Economics, Statistics and Mathematics at one of South Africa's most prestigious high schools, and authored mathematics textbooks for distance learning students. Perry holds a Bachelor’s degree in statistics and actuarial science and an honours degree in advanced mathematics of finance.

Satisfied Clients

Absa bank
Coronation merchant bank
ECIC
Eskom
FBN quest
FSCA
Providus bank
RMB
Stanbic bank