Financial Modelling for Mining Companies – Novice to Expert

Build and analyze mining financial models for project finance, corporate finance, or private equity.

Created by: Perry Fisher
Corporate Trainer | Consultant | The Tauro Group

What Will I Learn?

• How to Structure financial models to tell a complete story of a business from input cost to net profit or retained cash
• Demonstrate knowledge of, and analyze the main drivers of costs and profitability for a company
• Construct a process flow diagram from input, to production, to sale, and analyze each step of the process flow in terms of its impact on profitability
• How to construct a summary sheet, which illustrates all the key information and features of a business
• Perform stress testing and downside analysis on models via goal seek and data tables
• Construct waterfall diagrams assessing the impact of various factors on the profitability of a company
• Excel techniques for data clean up, financial calculations and data summary
• Construct key graphs which display multiple pieces of information clearly and coherently
• Understand the difference between analysing accounting statements vs a cashflow model from a banker’s perspective
• Drilling deep into a business' cost and revenue structure to uncover bottlenecks or weak spots
• Determining the optimal capital structure of a company using the Weighted Average Cost of Capital (WACC) and gearing ratios
• How to use a Discounted Cash Flow (DCF) model to value an investment or company
• Calculating the Enterprise Value and Equity Value of a company/project using perpetual growth vs EBITDA multiple
• Calculating debt capacity and sculpting debt repayments for a project or company
• Gearing and financial covenant ratios

Requirements

• Basic knowledge of Microsoft Excel

Target audience

• Analysts and investors wishing to obtain a deeper appreciation for project financing concepts, with particular attention to mining and minerals;
• Beginner investment bankers looking to accelerate their growth in the field of investment banking project finance;
• Employees of mining companies wishing to broaden their knowledge of raising debt funding for their companies;
• Mining professionals with chemical or engineering training, wishing to expand their knowledge into the disciplines of raising funding and debt finance in particular;