Short Course (One-day Online) — Mining Financial Modeling: Stand-Alone Project

May 23, 2024 all-day

The Management & Economics Society (MES) of CIM is pleased to offer the following ONLINE short course (one-day course):

Mining Financial Modeling

Thursday, May 23, 2024
9:00 am to 5:00 pm ET






This course focuses on the skills required to design and create a dynamic financial model for a mining company that is developing an open pit mine. Issues related to mining, milling and processing will be discussed. The course material includes model design, logic, construction, and operational 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 mining project model clearly and logically
  • Discuss the need for a model to serve as a marketing tool
  • Create clearly defined inputs and assumptions sections

Build 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:
    • Mine sequencing showing waste, ore and strip ratio
    • Commodity pricing for primary and secondary metals
    • Variable and fixed operating costs (including mining, milling, and refining charges)
    • Development and maintenance capital costs
    • Depreciation schedule using a unit of production method
    • Resource tax (includes regional resource tax rules)
    • Working capital schedule

Evaluate the project and the company:

  • Incorporate a schedule to evaluate the project’s returns:
    • Pre-Tax Unlevered Free Cash Flow (“UFCF”)
    • Net Present Value (“NPV”)
  • Use various sensitivity tools to sensitize the project’s returns
  • Conditionally format output tables to highlight specified results
  • Build a dynamic summary page to display results for the project



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.



Dave Thomas, MBA, CFA, AFM — Co-CEO of Canada, TTS
Training The Street



Dave Thomas co-leads all Canadian client service and operations and is based in Toronto. Dave manages the program design, content development and client service for Canadian clients in addition to his role as a lead instructor. Since joining Marquee in 2012, Dave has taught hundreds of courses including training programs for analysts and associates at major banks, corporate business development and budgeting teams, undergraduate and post-graduate business students as well as legal professionals in Canada, the US, Mexico, and China. Dave is passionate about teaching and in addition to instructing with Marquee, is a visiting lecturer in Finance at the Ivey Business School.

Dave worked in Investment Banking for 12 years at BMO Capital Markets. While at BMO, he was a Director in Equity Capital Markets where he oversaw prospectus-offered retail structured products for the firm as well as numerous equity financings and initial public offerings. Prior to that role, he was a member of the Utilities Group and was involved in numerous financing and mergers & acquisition transactions including significant work in the renewable and alternative power sector.

Prior to joining The Marquee Group, Dave was CEO and Director of a Caribbean-based private bank providing asset management, trust and corporate services for high-net-worth and corporate clients.

        **Training The Street acquired The Marquee Group in 2023.**



This course is suited to mining company employees, capital market participants and others involved in the analysis and evaluation of mining assets, and who aim to develop their modelling skills for mining projects.

Prerequisites: Participants will be sent a link in advance of the course and must use their computer to participate. Microsoft Excel is required for this course. Participants should have a working knowledge of Excel and mining projects. A laptop with any version of Excel is required for this course.



This course is being offered online. Note that there will be a 15-minute break in the morning and afternoon and a lunch break from 12:00 pm to 1:00 pm ET.

Cancellations are not permitted within 7 days of the start of the event, but a colleague may attend in your place. Note that only current, full-time students may attend with a ticket purchased at the student discount rate. For a complete cancellation and refund policy, click HERE.



REGISTRATION (Prices are subject to 13% HST)

Registration: $600


50% off Student Discount (Limited Number of Current, Full-Time Students only)

Please email a photo of both sides of your student ID to and include the name and date of the course you want to attend. Since student-discounted seats are limited, if selected, you will be sent a discount code that you can use to complete your registration.


Please click HERE to register!


CPD/CE Credits, PD Hours: Eligible for CFA, CPA and P.Eng. professional development hours. Professional Geoscientists of Ontario (PGO) considers participation of its members in this course as an acceptable Continuing Professional Development activity.


For more information on upcoming CIM MES events, click HERE to check our calendar.


Keep up to date by checking us out at:

Be part of an MES conversation, start a conversation or simply be informed – join us on LinkedIn! Click HERE to register!



Upcoming Events

all-day Trends in Mining Equity Valuations
Trends in Mining Equity Valuations
May 29 all-day
Trends in Mining Equity Valuations
For its Wednesday, May 29, 2024, Discussion Group seminar, CIM’s Management and Economics Society is pleased to welcome: Robert Cohen, Vice President and Portfolio Manager Dynamic Funds and Greg Barnes, Managing Director and Senior Mining[...]
all-day Short Course (One-day Online) — ... @ ONLINE
Short Course (One-day Online) — ... @ ONLINE
Jun 19 all-day
Short Course (One-day Online) — Upstream Oil & Gas Financial Modeling: Stand-Alone Project @ ONLINE
The Management & Economics Society (MES) of CIM is pleased to offer the following ONLINE short course (one-day course): Upstream Oil & Gas Financial Modeling Wednesday, June 19, 2024 9:00 am to 5:00 pm ET[...]

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!