Petroknowledge

An Intensive 5 - Day Training Course

A Practical Approach in
Oil and Gas Financial Modelling

Financial Management Skills, Financial Modelling and Forecasting

Print this Course

Code Date Venue Fee($)
FI119 13 - 17 Jul 2020 Houston TX - USA 6,950
FI119 27 - 31 Dec 2020 Dubai - UAE 4,950

*All fees are exclusive of VAT


Why Choose this Training Seminar?

This PetroKnowledge Oil & Gas training seminar 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 utilise 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.

This PetroKnowledge training seminar will highlight:


Training Objectives

What are the Goals?

By the end of this PetroKnowledge training seminar, 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

Target Audience

Who is this Training Seminar for?

This PetroKnowledge 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

Training Methods

How will this Training Seminar be Presented?

This PetroKnowledge Project Performance Measurement and Management training seminar will incorporate both theory and skill training components, applying hands-on exercises, facilitation of group discussions, practical case studies, and real-life examples

Organisational Impact

The organisation will benefit the following upon participating this PetroKnowledge Oil, and Gas Financial Modelling is profound:

  • 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

Personal Impact

This impact of this training seminar to the participants are manifold and includes:

  • Advanced ability in financial modelling using Excel
  • Gain larger skills set when contributing to corporate decisions
  • Ability to question important decisions formed using financial modelling
  • Ability to use statistics in the operation and performance measurements
  • Setting consistent targets using statistical analysis
  • A clear understanding of performance measurements

Daily Agenda

Day One: 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

Day Two: 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
    • 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

Day Three : Oil Product Spreads

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

Day Four: 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

Day Five: 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

Related Courses


Register Quick Enquiry Request an In-House Proposal
Home » Courses » Finance, Budgeting & Accounting » A Practical Approach in Oil and Gas Financial Modelling
PetroKnowledge Training


A Practical Approach in
Oil and Gas Financial Modelling

Financial Management Skills, Financial Modelling and Forecasting


Code Date Venue Fees
FI119 13 - 17 Jul 2020 Houston TX - USA $6,950
FI119 27 - 31 Dec 2020 Dubai - UAE $4,950



Why Choose this Training Seminar?

This PetroKnowledge Oil & Gas training seminar 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 utilise 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.

This PetroKnowledge training seminar will highlight:


Training Objectives

What are the Goals?

By the end of this PetroKnowledge training seminar, the participants will be able to:

Target Audience

Who is this Training Seminar for?

This PetroKnowledge training seminar is a suitable wide range of professionals but will significantly benefit:

Training Methods

How will this Training Seminar be Presented?

This PetroKnowledge Project Performance Measurement and Management training seminar will incorporate both theory and skill training components, applying hands-on exercises, facilitation of group discussions, practical case studies, and real-life examples

Organisational Impact

The organisation will benefit the following upon participating this PetroKnowledge Oil, and Gas Financial Modelling is profound:

Personal Impact

This impact of this training seminar to the participants are manifold and includes:

Daily Agenda

Day One: Introduction to the Excel Environment with Oil and Gas

Day Two: Statistical Analysis (Applied to the Oil and Gas Industry) Using Excel

Day Three : Oil Product Spreads

Day Four: Investment Appraisal Using Excel

Day Five: Financial Analysis in the Up and Down Stream Oil and Gas Industry

Print Page

© 2020. Material published by Petroknowledge shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.


Sending your message. Please wait...

Close

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

Download PDF

© 2020. Material published by Petroknowledge shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.


Sending your message. Please wait...

Download PDF Click here to download PDF file Close

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

Download The Complete PetroKnowledge Training Schedules Here