Course Description

This Oil & Gas training course on "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.
In addition, working in the upstream or downstream and the career progression is being restricted by outdated knowledge of modelling techniques, measuring performance, and limitations, then this will help you move your career forward.

Course Objectives

Providing opportunities to develop high-level financial management techniques

Appropriate application of the financial modelling to the Oil and Gas industry

Updating their quantitative techniques to enable them to make a better-informed decision

Transforming Excel skills to advanced knowledge of Excel for financial modelling

Enhancing the ability to apply business statistics

Effective data analysis to improve day-to-day operation activities

Who should attend?

This training course 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

Course Overview

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

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: Mean, Median, Standard Deviation, Skewness and 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

Correlation Analysis

Confidence Intervals

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

Course Conclusion
POST-TEST and EVALUATION
Expected Outcome
By the end of the training, 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