A Practical Approach in Oil and Gas Financial Modelling

Jan | Feb | Mar 2022
5 Days
Online Live | Onsite


This course “A Practical Approach in Oil and Gas Financial Modelling” is aimed to senior and middle managers to enhance the understanding of appropriate use of Excel. It is critical in a growing and yet competitive environment to have the ability to use Excel to its fullest. This is designed to provide in-depth knowledge of using Excel in financial modelling. Upon completing this training course, the participants will have the requisite tools to utilize Excel effectively and be better equipped to challenge decisions and also learn how to deal with several important issues related to financial modelling, performance measurements, setting targets and to be able to explain the effects on the overall results of the company.


  • By the end of this training course, the 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 the model investment appraisal techniques
  • • Use business statistics to enhance operations and target setting for the organization


This training seminar is a suitable wide range of professionals but will significantly benefit:
• Decision Makers and Performance Monitoring Specialists
• Budgeting and Financial Modelling Specialists
• Accountant and Analysts
• Financial Analysis Specialists
• Junior Managers in Data Analyst


• A Quick-Start Tutorial for Excel
• Describing Data sets using Statistics
• Representing Data sets Graphically
• Understanding the Concept of Normal Distribution
• Trend Analysis Using Excel
• Time Series Analysis

• Use of Excel Functions for Statistical Analysis
• Descriptive Statistics:
• 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

• Examining the Relationship between Energy Products
• Differences Between Data Sets
• Correlation Analysis
• Confidence Intervals
• Analysis of Variance (ANOVA)

• 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

• 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


Mark Steele

Mark is certified trainer with 20+ years of experience in gulf and London. He has trained batches, corporates, individuals and companies from all over the world.

Enroll Now

Fill out this field
Please enter a valid email address.
Fill out this field
Fill out this field

More courses you might like

Learners who joined this course have also enjoyed these courses.

No results found.