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).
Chapter 3.1 - Profitability Drivers and Economic Assumptions
FREE PREVIEWChapter 3.2 - Internal Profitability Drivers
FREE PREVIEWChapter 3.3 Building the Model from Scratch
FREE PREVIEWChapter 3.4 - Process Flow (Putting the Links Together)
FREE PREVIEWChapter 3.5 - Tax
FREE PREVIEWPractice Activity 3.5: Tax
FREE PREVIEWChapter 3.6 - Working Capital
FREE PREVIEWPractice Activity 3.6: Working Capital
FREE PREVIEWChapter 3.7 - Debt
FREE PREVIEWPractice activity 3.7: Debt
FREE PREVIEWChapter 3.8 - Accounting Statements
FREE PREVIEWChapter 3.9 - Cashflow Model
FREE PREVIEWPractice Activity 3.9: Putting the Model Together
FREE PREVIEWBonus Lesson: Chapter 3.10: Asset-Based Financing
Bonus Lesson Practice Activity 3.10: Asset-Based Financing Modelling
Bonus Lesson: Lease Discounting Modelling
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
Practice Activity 4.6 - Goal Seek Breakeven Analysis
Chapter 5.1 - The Summary Tab - Part 1
Chapter 5.2 - Mining Tab Part 1 - Scenario Selection and Choose Function
Chapter 5.3 - Mining Tab Part 2 - Building Stress Testing Capabilities
Chapter 5.4 - Mining Tab Part 3 - The Sumif Function and Combo Charts
Payment Flags and Conditional Formatting
Chapter 5.5 - Cashflow Waterfalls and Cash Sweeps
Practice Activity: Cashflow Waterfalls and Cash Sweeps
Financial Covenants
FREE PREVIEWChapter 5.6 - The Debt Service Cover Ratio
Chapter 5.7 Calculating Debt Capacity Using DSCR
Chapter 5.8 Calculating Debt Service Profile Using DSCR
8 Calculating the Loan Life Cover Ratio
Practice Activity Debt Capacity DSCR and LLCR
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
Practice Activity: Prepayment Facilities, Royalties and Streaming
Chapter 5.16 - Calculating Debt Capacity Manually
Practice Activity: Calculating Debt Capacity Manually
Chapter 5.17 - The Debt Summary Chart and Sources and Uses Table
11 ABC Mining Debt Tab Part 1
12 ABC Mining Debt Tab Part 2
13 ABC Mining Debt Tab Part 3
14 Breakeven Analysis Copper Price
15 The Small and Countif Functions and the Minimum DSCR
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
Bonus Lesson: Alternatives to DCF Valuation
Congratulations on Completing the Course!!
Before you go...
Perry Fisher
Perry Fisher
