Financial Modelling for Mining Companies - Novice to Expert
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
Financial modelling is the most important analysis tool in a company’s decision-making arsenal. This course is specifically designed to provide dealmakers, analysts and other financing professionals with the tools they would require in order to analyze any mining financial model, and prepare powerful summarization outputs upon which decisions would be made.
This course is ideal for fast-tracking industry professionals in their career path - teaching them to analyze existing client models and also create their own models for various applications. The material is well suited to middle-office and front-office professionals, teaching them to assess the risks of funding mining opportunities.
This course blends theoretical principles with real industry insights. Its bottom-up nature is designed to provide a holistic journey, from the initial construction of a model, to the final financial assessment in order to be able to make an investment decision (whether debt or equity related). This would allow participants to deeply analyze potential funding opportunities, structure tailor-made financing packages, and produce comprehensive and concise outputs which summarize bulky raw data.
By the end of the course you will be able to effectively construct a financial model that describes the process flow of your mining business, from raw material extraction, all the way until net profit after tax. You will learn how to itemize all cost and revenue drivers, model tax, working capital, and debt funding.
The concepts taught are based on years of investment banking experience, and billions of dollars worth of project financing deals in multiple jurisdictions.
Students would need to download the ABC Mining Financial Model (provided for free) in order to participate in the course.
I look forward to engaging with you as the course progresses!
Perry Fisher
Who this course is for:
- 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;
Instructor
- 4.6 Instructor Rating
- 112 Reviews
- 8,832 Students
- 4 Courses
I am passionate about coaching and training.
My services include consulting and training in the areas of risk assessment, financial modelling, deal appraisal, and financial structuring for debt and equity transactions.
I previously worked as an investment banker where I was involved in the structuring of multi-million dollar transactions, developing pricing models, managing investment-related risks, preparing client pitches and successfully closing deals.
I have concluded corporate debt financing, advisory, as well as project financing transactions. My areas of expertise include:
· Presentation of sales pitches, advisory mandates, and information memorandums (both the preparation and presentation thereof);
· Deal pricing (structuring pricing and deal terms for credit and capital considerations);
· Preparing of term sheets and deal structuring;
· Credit analysis;
· Financial modelling and debt capacity calculations;
· Legal documentation and review;
Prior to investment banking, I worked as a training facilitator for a small business incubator program, taught A-level Economics, Statistics and Mathematics, and also authored a mathematics textbook for distance learning students across Southern Africa.
I hold a Bachelor’s degree in Actuarial Science and an Honours degree in Advanced Mathematics of Finance. My Areas of study included:
· South African Financial Markets
· Introduction to Derivative Securities
· Stochastic Calculus
· Risk Theory
· Numerical Methods
· Differential Equations
· Swaps and Exotic Options
· Interest Rate Options
· Portfolio Optimization