Code Date Venue Fees
FI072 13 - 17 Jul 2020 Houston - USA $6,950 Register
FI072 27 - 31 Dec 2020 Dubai - UAE $4,950 Register
Home » Seminars » Finance & Budgeting » Oil and Gas Financial Modelling: A Practical Approach

Introduction

This GLOMACS 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 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 GLOMACS training course will highlight:

  • Applications of Excel from the basics to the most advanced use of Excel
  • A real-world approach to the discipline
  • Numerous examples based around the oil and gas industry
  • A dual approach that develops not only modelling skills but also financial management skills
  • In-depth analysis of the performance using statistical techniques

Objectives

By the end of this GLOMACS 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

Training Methodology

Each of the sessions will involve formal lectures, demonstration of modelling techniques, and the opportunity for practical application. Screen recordings of essential techniques, examples, and mini case studies will be made available to the participants to assist in the practical applications and to facilitate the application of the techniques used when they approach the workplace.

Organisational Impact

The organisation will benefit the following upon participating this GLOMACS 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

The impact of this GLOMACS training course 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

Who Should Attend?

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

Seminar Outline

DAY 1

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 2 

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 3

Oil Product Spreads  

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

DAY 4

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 5

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

Share this Course:

Accreditation

  • Quality Logo

In Association With

Oxford Management Centre

Oxford Management Centre

A GLOMACS - Oxford Management Centre collaboration aimed at providing the best training services and benefits to our valued clients.

Visit website

PetroKnowledge

PetroKnowledge

Our collaboration with Petroknowledge aims to provide the best training services and benefits for our valued clients

Visit website

testimonials

What Previous Delegates Say About This Course...

The company project valuation metrics were very useful to reinforce my prior knowledge of IRR and NPV. It was interesting to discover the limitations of these methods if the cashflows were non conventional. It was helpful to learn about company valuation using market data and determining the associated risk using beta values.

- C Okoye

The scenario manager tutorial was so real, i loved it and will be applying it immediately. This will indefinitely improve my presentation skills on budgets vs. actual. Overall, the course has made me learnt much on application of various excel functions which will be of great use to at my work place as well as my studies at the university in data collection and analysis.

- J W Mulati

Learnt a lot especially finance from a statistical point of view. This will enhance my modelling skills as previously I used to take arbitrary percentages for example, 10% sales growth instead of using statistics. I have also learnt some of the managerial performance measurement from a finance point of view.

- E A Onsomu

I managed to link my statistical knowledge learned in university to finance area. I learned about the ratios and there application, forecasting financial figures, and most important, build a functional financial model.­

- D S Cacita

I really enjoyed the practical approach in the training especially as regards the computer applications to solving problems. Great course for me.

- A E Mabur

I enjoyed modified rate of return and cost of equity estimation for oil and gas.

- A Y Akintunde

Send to Colleague

© 2020. Material published by GLOMACS 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...

Send Successfully

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

Please complete all the fields in the form before sending.

Print Page

© 2020. Material published by GLOMACS 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 GLOMACS 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...

PDF logo Click here to download PDF file
note: Cancel Print button to open or view PDF
Close

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

Please complete all the fields in the form before sending.

Download Training Calendar

Want to stay in touch with what's happening in Glomacs?
Join the conversation on our social media channels: