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!