Course Code: OGC 144
28 Course Visits
Oil & Gas Financial Modeling
Course Sector:
Oil, Gas and Chemical
Course Dates and Locations
Choose a date and location to book your seat
No.
Date
Days
Location
Fees
Enrollment
No available dates now, will be added soon..
Introduction
Training course introducion / brief
This training course is designed to provide participants with the essential concepts on the advanced use of Excel in the oil & gas industry particularly for financial modeling. This training course will cover topics such as how to deal with several important issues related to financial modelling, performance measurements, setting targets using sophisticated techniques, and various methods relevant in enhancing company performance.

Course Objectives
At the end of the training course, participants will be able to

  • Improve the quality of the quantitative analysis of corporate presentations
  • Apply financial modelling in the oil and gas industry
  • Effectively assess the appropriate discount rate
  • Use various models of investment appraisal techniques
  • Use business statistics to enhance operations and target setting for the organization

Course Audience
Who is this course for, and can benefit the most
.
Course Outline
The course aims and learning outcomes

  • Introduction to the Excel Environment with Oil and Gas 
  • A Quick-start Tutorial for Excel
  • Describing Data Sets Using Statistics
  • Representing Data sets Graphically
  • Understanding the Concept of Normal Distribution and practical application
  • Trend Analysis Using Excel
  • Time Series Analysis

  • Statistical Analysis (Applied to the Oil and Gas Industry) Using Excel
  • Use of Excel Functions for Statistical Analysis
  • Descriptive Statistics and their applications:
  • Mean
  • Median
  • Standard Deviation
  • Skewness
  • Kurtosis
  • Use of Scatter Diagrams, Frequency and Histogram Distribution
  • Regression Techniques to Calculate the Cost of Equity Financing
  • Analysis of Equity Returns of Oil and Gas Industry and Companies

  • Oil Product Spreads 
  • Examining the Relationship between Energy Products
  • Differences between Data Sets and their importance.
  • Correlation Analysis
  • Confidence Intervals
  • Application of Analysis of Variance (ANOVA)

  • Investment Appraisal Using Excel 
  • Investment Appraisal using NPV, IRR, and Payback as Applied to the Oil and Gas Industry
  • Use of Excel Functions for Investment Appraisal: IRR, PV and NPV
  • Modified Internal Rate of Return (MIRR)
  • Use of Scenario Analysis and Stress Testing
  • Predicting Financial Distress

  • Financial Analysis in the Up and Down Stream Oil and Gas Industry
  • Introduction to Financial Statements
  • Ratio Analysis Applied to the Oil and Gas Industry
  • Ratios as a System – Pyramids of Ratios
  • Financial Modelling
  • Cash Flow Forecasts Using Excel

Providers and Associations
Providing the best training services and benefits to our valued clients
Boost certificate of completion
BOOST's Professional Attendance Certificate “BPAC” is always given to the delegates after completing the training course, and depends on their attendance of the program at a rate of no less than 80%, besides their active participation and engagement during the program sessions.
ENDORSED EDUCATION PROVIDER
Over all rating
Excellent
Average
Below average
Flexible deadlines
Customized dates accordance to your schedule
Shareable Certificate
Earn certificate upon completion
COURSE METHODOLOGY

Our Training programs are implemented by combining the participants' academic knowledge and practical practice (30% theoretical / 70% practical activities).

At The end of the training program, Participants are involved in practical workshop to show their skills in applying what they were trained for. A detailed report is submitted to each participant and the training department in the organization on the results of the participant's performance and the return on training. Our programs focus on exercises, case studies, and individual and group presentations.

Trending Courses
The most bespoke and flexible training courses
01
Sep
- 05 -
Days
Introduction to Machine Learning and Artificial Intelligence
Abu Dhabi, UAE
14
Sep
- 05 -
Days
Competitive Bidding: Understanding Procurement Bids
Riyadh, KSA
07
Apr
- 05 -
Days
IOSH Managing and Working Safely
Abu Dhabi, UAE
17
Feb
- 05 -
Days
Artificial Intelligence for Leaders
Abu Dhabi, UAE
20
Jan
- 05 -
Days
Certified Treasury Professional
Dubai, UAE
10
Feb
- 05 -
Days
The Scheduling Professional (PMI-SP Exam Preparation)
Dubai, UAE
24
Nov
- 03 -
Days
Happiness To Have and Hold
Dubai, UAE
13
Apr
- 05 -
Days
OSHA: Occupational Safety and Health Administration Standards
Riyadh, KSA
01
Sep
- 05 -
Days
Certified Business Analysis Professional- IIBA
Dubai, UAE
20
Jan
- 05 -
Days
Leading and Building a Positive, Motivated, and Empowered Teams
Online, Virtual
10
Aug
- 05 -
Days
Emotional Intelligence and Advanced Communication Skills for Leaders
Salalah, Oman
18
Aug
- 05 -
Days
ISO 55001 2014 Lead Auditor (Asset Management Systems) – Lead Auditor
Muscat, Oman
10
Nov
- 05 -
Days
Practical Negotiation Skills for Contract Management
Jeddah, KSA
15
Dec
- 05 -
Days
The Business Analyst (PBA) - PMI Certified
Dubai, UAE
30
Jun
- 05 -
Days
The Risk Management Professional (PMI-RMP Exam Preparation)
Istanbul, Turkey
18
May
- 05 -
Days
Professional in Business Analysis (PMI-PBA Exam Preparation)
Jeddah, KSA