Financial Modelling For Mining Companies

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

Last updated 2022-01-10 | 4.9

- 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

What you'll 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

Description

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