MARK YOUR CALENDAR: Short Course (One-day Online) — Upstream Oil & Gas Financial Modeling: Stand-Alone Project

When:
June 19, 2024 all-day
2024-06-19T00:00:00-07:00
2024-06-20T00:00:00-07:00
Where:
ONLINE
Contact:

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

 

Location

ONLINE

 

OVERVIEW

This course focuses on the skills required to design and create a dynamic financial model of an oil and gas exploration and production company. The model starts from a known production schedule (for example, one provided by an engineering team) and covers model design, logic, construction, financial concepts, and accounting treatment. Participants will build an integrated 3-statement financial model. Various intermediate Excel tools along with helpful keyboard shortcuts will also be covered throughout the course.

 

TOPICS INCLUDE

Design and structure a financial model:

  • Design a clear and logical financial model
  • Discuss the need for a model to serve as a marketing tool
  • Create clearly defined inputs and assumptions sections

Build scenarios and financial forecasts:

  • Use switches to create effective scenarios and value drivers
  • Forecast and build up a company’s revenues and expenses
  • Construct all necessary schedules, including:
    • Commodities pricing fundamentals (includes regional differentials)
    • Hedging & derivatives impact on cash flow (time permitting)
    • Production profile and scenarios
    • Overview of depreciation/depletion expense
    • Overview of oil & gas specific tax considerations
    • Effective schedule to forecast the company’s working capital

Incorporate the capital structure:

  • Properly incorporate senior term debt with an amortizing repayment schedule
  • Create a robust bank operating line (or revolving credit facility)
  • Design and incorporate a cash sweep for a company’s bank operating line
  • Balance the company’s balance sheet
  • Calculate key operating and credit statistics

 

LEARNING OUTCOMES

This course focuses on the skills required to design and create a dynamic financial model of an oil and gas exploration and production company. The model includes producing oil and gas reserves and development drilling to increase production. The course material includes model design, logic, construction, financial concepts, and accounting treatment. Various intermediate Excel tools along with helpful keyboard shortcuts will also be covered throughout the course.

 

INSTRUCTOR

Jamie Wilkie, Director, Specialized Products, TTS
Training The Street

 

INSTRUCTOR’s BIO

Jamie Wilkie is based in Alberta, Canada and helps drive specialized product commercialization & development (including oil & gas, financial communications & other industry-specific applications), in addition to being a Western Canada-based instructor. Jamie spent approximately 12 years in investment banking with firms including Merrill Lynch, TD, UBS & Wells Fargo with a specialized focus on Energy & Infrastructure M&A, debt & equity transactions. In addition, he has consulted with publicly traded & private equity-backed energy companies in the areas of financial communications, financial modelling & analysis.

 

WHO SHOULD ATTEND

Financial professionals with exposure to this industry, such as Bankers Research Analysts, Advisors, Asset Managers, Internal Corporate Finance Professionals, etc. In short: anyone who recognizes that fossil fuels will not be replaced anytime soon.

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 Upstream Oil & Gas projects. A laptop with any version of Excel is required for this course.

 

LOCATION

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 education@cimmes.org 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: 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

Apr
24
Wed
all-day Building Legitimacy and Professi...
Building Legitimacy and Professi...
Apr 24 all-day
Building Legitimacy and Professionalization: The World Bank's Framework for Sustainable ASM Development
For its Wednesday, April 24, 2024, Discussion Group seminar, CIM’s Management and Economics Society is pleased to welcome: Rachel Perks, PhD Senior Mining Specialist, The World Bank   who will deliver an online presentation entitled:[...]
May
23
Thu
all-day MARK YOUR CALENDAR: Short Course... @ ONLINE
MARK YOUR CALENDAR: Short Course... @ ONLINE
May 23 all-day
MARK YOUR CALENDAR: Short Course (One-day Online) — Mining 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): Mining Financial Modeling Thursday, May 23, 2024 9:00 am to 5:00 pm ET   Location ONLINE[...]
Jun
19
Wed
all-day MARK YOUR CALENDAR: Short Course... @ ONLINE
MARK YOUR CALENDAR: Short Course... @ ONLINE
Jun 19 all-day
MARK YOUR CALENDAR: 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!