The Management & Economics Society of CIM is pleased to offer its two-day Mining Financial Modeling course together with the Marquee Group:
Mining Financial Modeling
Wednesday, June 20, and Thursday, June 21, 2018
8:30 am to 5:00 pm PDT
UBC Robson Square
800 Robson Street
Vancouver, BC, V6Z 3B7
This course focuses on the skills required to design and create a dynamic financial model of a mining company that is developing an open pit mine to produce base and precious metals. Issues related to mining, milling and processing will be discussed. The course material includes model design, logic, construction and financial concepts to create a best-in-class financial model of a mining company. Various intermediate Excel tools along with helpful keyboard shortcuts will also be covered throughout the course.
Design and structure of a financial model:
- Design and layout a financial model clearly and logically
- Discuss the need for a model to serve as a marketing tool
- Create clearly defined inputs and assumptions sections
Development of powerful scenarios and financial statements:
- Use switches to create effective scenarios and value drivers
- Forecast and build-up the project’s revenues and expenses
- Construct all necessary schedules, including:
- Commodity pricing (includes hedging for primary and secondary minerals)
- Production profile (includes construction, mining and processing profiles)
- Variable and fixed operating costs (includes mining, milling and TC/RCs)
- Development and maintenance capital costs
- Reclamation and closure costs
- Resource tax (includes regional resource tax rules)
- Income tax (includes federal and provincial taxation)
- Develop a cash flow projection for the mining company
- Forecast the company’s financial statements
Evaluation of a mining project and company:
- Incorporate a schedule to evaluate the project’s returns:
- Net Present Value (NPV)
- Internal Rate of Return (IRR)
- Payback and Discounted Payback periods
- Build a detailed summary page to display the results
- Use various sensitivity tools to sensitize the project’s returns
- Conditionally format output tables to highlight specified results
Participants design and create a financial model to determine the value of a mining company developing an open-pit mine. Participants leave the course with a dynamic model which evaluates the net present value of the project, internal rate of return as well as payback and discounted payback periods.
Duncan McKeen, CFA
Principal, The Marquee Group
Duncan is a Principal of The Marquee Group. He has taught finance courses at the Queen’s University School of Business, and has extensive experience in equity research where he focused on the resource sector. Prior to joining the financial community, Duncan worked with Ingersoll-Rand. He received his Master of Finance degree from the Queen’s University School of Business and a Bachelor of Engineering degree from McGill University. He is also a CFA charterholder.
The Marquee Group has developed a framework and discipline for model design, structure and development. Marquee has provided training to professionals at financial institutions, corporations, professional organizations and universities since 2002.
WHO SHOULD ATTEND
This course is suited to mining company employees, capital market participants and others involved in analysis and evaluation of mining assets or companies, and who aim to develop their modeling skills. Particularly, it is for anyone who wishes to improve their modeling skills for mining companies. These sessions teach best-in-class financial modeling principles using a detailed mining model.
Prerequisites: Participants should have an understanding of the fundamentals of accounting and should possess a working knowledge of Microsoft Excel and mining. Included in registration fee: a printed copy of the course material and an electronic copy of the completed financial model.
Participants must bring a laptop with any version of Microsoft Excel to the course.
Registration (closes June 14, 2018): $1,200 + applicable taxes
Early Bird Pricing (until June 8, 2018): $1,050 + applicable taxes
Please click HERE to register!
CPD/CE Credits: Various professional associations consider participation of its members in this course as an acceptable Continuing Professional Development activity.
Cancellations are not permitted within seven days of the start of the event, but you may send someone else in your place. For complete cancellation and refund policy, click HERE.
For more information on upcoming CIM MES events, click HERE to check our calendar.
Keep up to date by checking us out at: www.cimmes.org
Be part of an MES conversation, start a conversation or simply be informed – join us on LinkedIn! Click HERE to register!