The Management & Economics Society (MES) of CIM is pleased to offer the following short course (2-day course) in Vancouver:
Mining Financial Modeling
Tuesday, November 12 and Wednesday November 13, 2019
8:30 am to 5:00 pm PT
UBC Robson Square
800 Robson Street, Vancouver, BC V6Z 2E7
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:
- Logical design and layout
- Clearly-defined inputs and assumptions sections
Development of powerful scenarios, cash flow projection and financial statements:
- Use of switches to create effective scenarios and value drivers
- Forecasting of project revenues and expenses
- Commodity pricing, including hedging
- Variable and fixed operating costs, including mining, milling and treatment and refining charges
- Development and maintenance capital costs; reclamation and closure costs
- Resource and income taxes
Evaluation of a mining project and company:
- NPV, NAV, IRR, payback period
- Sensitivity analysis
- Detailed summary page for displaying 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.
Prerequisites: Participants should have an understanding of the fundamentals of accounting and proficiency in Excel. 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 ( Prices are subject to 12% GST )
Early Bird Pricing ( until October 29, 2019 ): $1,050
Regular Pricing ( closes November 11, 2019 ): $1,200
40% off the Regular Pricing Student Discount (current, full-time students only)
Email a photo of your student ID to firstname.lastname@example.org and include the name and date of the course(s) you plan to attend. Please register using your university email address.
Please click HERE to register!
CPD/CE Credits: The Association of Professional Geoscientists of Ontario (APGO) considers 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 get connected!