Contact information
London (UK) Office
22 Portman Square, Marylebone, London W1H 7BG, UK
Istanbul (Turkey) Office
19 Mayıs Mahallesi, 19 Mayis Street No 2 Sisli
Download Brochure
Company Profile Global Horizon Plus Training Center
Company profile
Company profile Gh4t Plus 2020 (PDF) Download
Soft Skills global Horizon Plus Training Center
COMPETENCY ASSESSMENT
SOFT SKILLS COMPETENCY ASSESSMENT FRAMEWORK Download

Oil and Gas Financial Modelling a Practical Approach

Financial Management Skills, Financial Modelling and Forecasting

Oil and Gas Financial Modelling a Practical Approach

Register Inquiry PDF
FB44
27.Oct.2024 to 31.Oct.2024
Online -
Cost 1250 £ GBP

Introduction

This training course on "A Practical Approach in Oil and Gas Financial Modelling" is designed for senior and intermediate managers who want to improve their Excel skills. It is decided to have the ability to fully utilize Excel in a growing and competitive environment. This is intended to provide in-depth knowledge of using Excel in financial modeling.

After completing this training course, Delegates will have the necessary tools to effectively use Excel and be better prepared to challenge decisions. They will also learn how to deal with several significant issues related to financial modeling, performance measurements, setting targets, and being able to describe the impacts on the overall results of the company.

Furthermore, if you are working upstream or downstream and your career progression is being hampered by an outdated understanding of modeling methods, measuring performance, and limitations, this will help you to advance your career.

This training course will highlight:

  • Applicability of Excel from the basics to the most advanced utility of Excel
  • Real-world access to the system
  • Infinite examples based around the oil and gas industry
  • A dual method that promotes not only modeling skills but also financial management skills
  • The in-depth judgment of the performance utilizing statistical methods

Course Objectives of Oil and Gas Financial Modelling

By the end of this training course, the delegates will be ready to:

  • Develop the spirit of the quantitative judgment of corporate presentations
  • Utilize financial modeling in the oil and gas industry
  • Efficiently evaluate the suitable discount rate
  • Utilize the model investment appraisal methods
  • Utilize business statistics to improve operations and target frame for the organization

Course Methodology of Oil and Gas Financial Modelling

Each of the assemblies will require formal lectures, a demonstration of modeling methods, and the possibility of functional application.

Screen records of essential techniques, examples, and mini-case studies will be created and available to the delegates to assist in the practical applications and to promote the application of the techniques utilized when they approach the workplace.

Organizational Impact of Oil and Gas Financial Modelling

The organization will benefit the following upon participating in this Oil and Gas Financial Modelling is profound:

  • Giving opportunities to improve high-level financial management methods
  • Appropriate utilization of the financial modeling to the Oil and Gas industry
  • Renewing their quantitative methods to allow them to make a better-informed decision
  • Converting Excel skills to advanced awareness of Excel for financial modeling
  • Improving the capability to use business statistics
  • Efficient data analysis to develop day-to-day operation actions

Personal Impact of Oil and Gas Financial Modelling

The impression of this training course to the delegates is manifold and involves: 

  • Excellent understanding of financial modeling utilizing Excel
  • Increase more comprehensive skill set when subscribing to corporate decisions
  • Capacity to question significant decisions formed utilizing financial modeling
  • Capability to utilize statistics in the operation and performance measurements
  • Establishing consistent targets utilizing statistical analysis
  • A clear judgment of special measurements

Who Should Attend

This training course is a fitting wide range of professionals but will significantly serve:

  • Resolution Makers and Performance Monitoring Experts
  • Budgeting and Financial Modelling Specialists
  • Accountant and Analysts
  • Financial Analysis Specialists
  • Junior Managers in Data Analyst

Course 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

Associations

FB44
27.Oct.2024 to 31.Oct.2024
Online -
Cost 1250 £ GBP