Master mining valuation and learn how to value a mining company in Excel. This course is designed for professionals seeking careers in investment banking, equity research, corporate development and financial planning and analysis (FP&A).
This course simulates the experience of working as a corporate development professional at a mining company evaluating an acquisition opportunity. The objective is to take all the information from the technical study, put it into Excel, and determine the net asset value (NAV) of the mine. The completed model will serve as a useful tool for testing different metal prices and other assumptions such as grade, recovery rate, unit operating costs, capital expenditures, and more.
You are expected to have either completed the stated prerequisite course(s) or possess the equivalent knowledge prior to enrolling in this course:
Mining financial modeling course overview
Master the art of building a financial model to value a mining company, complete with assumptions, financials, valuation, sensitivity analysis, and output charts. In this mining financial modeling course, we will work through a case study of a real mining valuation for an asset by pulling information from the Feasibility Study, inputting it into Excel, building a forecast, and valuing the asset.
Mining financial modeling & valuation course objectives
- Understand key mining terms and definitions used in the industry and in valuation
- Understand the mining life cycle from start to finish for assets, projects, and operating mines
- Read and extract the important information from a mining technical report (feasibility study)
- Input key assumptions into a financial model that will drive revenue, expenses, and cash flow in the forecast
- Calculate production statistics based on a detailed mine plan from the technical report
- Build financial statements based on the mine plan
- Perform a discounted cash flow DCF valuation of the mining asset in Excel
- Build sensitivity analysis to test for different input assumptions
- Output relevant graphs and charts to illustrate the investment opportunity
- Understand valuation methods such as Net Asset Value (NAV), P/NAV, P/CF, Total Acquisition Cost (TAC)