Vancouver: Mining Financial Modeling (Two-day Course)

When:
June 20, 2018 – June 21, 2018 all-day
2018-06-20T00:00:00-07:00
2018-06-22T00:00:00-07:00
Where:
UBC Robson Square
800 Robson Street
Vancouver, BC
V6Z 3B7
Contact:

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 EDT

 

Location

UBC Robson Square
800 Robson Street
Vancouver, BC, V6Z 3B7

View Map

 

OVERVIEW

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.

 

TOPICS INCLUDE

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

 

LEARNING OUTCOMES

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.

 

INSTRUCTOR

Duncan McKeen, CFA
Principal, The Marquee Group

marquee-group-logo

 

INSTRUCTOR’s BIO

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

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!

 

Upcoming Events

Sep
26
Wed
all-day Toronto: Mining Financial Modeli... @ The Marquee Group
Toronto: Mining Financial Modeli... @ The Marquee Group
Sep 26 – Sep 27 all-day
Toronto: Mining Financial Modeling (Two-day Course) @ The Marquee Group
The Management & Economics Society (MES) of CIM is pleased to offer the following short course (2-day course) in Toronto: Mining Financial Modeling Wednesday, September 26 and Thursday, September 27, 2018 8:30 am to 5:00 pm EDT  [...]
Sep
27
Thu
all-day Vancouver: Mine Project Finance ... @ Segal Graduate School of Business - Simon Fraser University
Vancouver: Mine Project Finance ... @ Segal Graduate School of Business - Simon Fraser University
Sep 27 all-day
CIM MES Vancouver is pleased to present: Mauro Chiesa Independent Adviser (EDC, NYC Bank and World Bank Financier and Adviser)   who will deliver a presentation on: Mine Project Finance in 2018: and Now Comes[...]
Oct
25
Thu
all-day Toronto: Rocks & Stocks 2018 @ Ernst & Young LLP
Toronto: Rocks & Stocks 2018 @ Ernst & Young LLP
Oct 25 all-day
Toronto: Rocks & Stocks 2018 @ Ernst & Young LLP
Join us for the CIM’s Management & Economics Society and the Toronto Branch Professional Development Series   The Emerging Cycle: Risk Mitigation & Opportunities   Opening & Welcome ————————– Session 1: Risk Aversion & Adverting[...]

CIM MES Supporters and Patrons

We at CIM MES would not be able to accomplish everything we do throughout Canada and beyond, annually, without the generous backing of our partners, sponsors, supporters, and volunteers.

The Management & Economics Society expresses a special gratitude to the following supporters and sponsors for their extraordinary assistance. Please visit them online by clicking on their logos below!

To learn about financial sponsorship opportunities, how you can support us or how to partner up with MES for an event please contact us. Thank you!