/  Financial Modelling and Petroleum Project Economics Training

Financial Modelling and Petroleum Project Economics Training

BMC Training provides a training course in Financial Modelling and Petroleum Project Economics in Oil and Gas Training

Course Title
Venue
Start Date
End Date
  • Kuala Lumpur
    20 - 10 - 2019
    31 - 10 - 2019
  • Rome
    20 - 10 - 2019
    31 - 10 - 2019
  • Barcelona
    20 - 10 - 2019
    31 - 10 - 2019
  • Zurich
    20 - 10 - 2019
    31 - 10 - 2019
  • London
    27 - 10 - 2019
    7 - 11 - 2019
  • Madrid
    27 - 10 - 2019
    7 - 11 - 2019
  • Munich
    27 - 10 - 2019
    7 - 11 - 2019
  • Berlin
    27 - 10 - 2019
    7 - 11 - 2019
  • New York
    27 - 10 - 2019
    7 - 11 - 2019
  • London
    3 - 11 - 2019
    14 - 11 - 2019
  • Madrid
    3 - 11 - 2019
    14 - 11 - 2019
  • Munich
    3 - 11 - 2019
    14 - 11 - 2019
  • Berlin
    3 - 11 - 2019
    14 - 11 - 2019
  • New York
    3 - 11 - 2019
    14 - 11 - 2019
  • Istanbul
    17 - 11 - 2019
    28 - 11 - 2019
  • Bali
    17 - 11 - 2019
    28 - 11 - 2019
  • Singapore
    17 - 11 - 2019
    28 - 11 - 2019
  • Washington
    17 - 11 - 2019
    28 - 11 - 2019
  • Kuala Lumpur
    3 - 11 - 2019
    14 - 11 - 2019
  • Rome
    3 - 11 - 2019
    14 - 11 - 2019
  • Barcelona
    3 - 11 - 2019
    14 - 11 - 2019
  • Zurich
    3 - 11 - 2019
    14 - 11 - 2019
  • Dubai
    10 - 11 - 2019
    21 - 11 - 2019
  • Paris
    10 - 11 - 2019
    21 - 11 - 2019
  • Hong Kong
    10 - 11 - 2019
    21 - 11 - 2019
  • Kuala Lumpur
    15 - 12 - 2019
    26 - 12 - 2019
  • Rome
    15 - 12 - 2019
    26 - 12 - 2019
  • Barcelona
    15 - 12 - 2019
    26 - 12 - 2019
  • Zurich
    15 - 12 - 2019
    26 - 12 - 2019
  • London
    22 - 12 - 2019
    2 - 1 - 2020
  • Madrid
    22 - 12 - 2019
    2 - 1 - 2020
  • Munich
    22 - 12 - 2019
    2 - 1 - 2020
  • Berlin
    22 - 12 - 2019
    2 - 1 - 2020
  • New York
    22 - 12 - 2019
    2 - 1 - 2020
  • Dubai
    1 - 12 - 2019
    12 - 12 - 2019
  • Paris
    1 - 12 - 2019
    12 - 12 - 2019
  • Hong Kong
    1 - 12 - 2019
    12 - 12 - 2019
  • Istanbul
    8 - 12 - 2019
    19 - 12 - 2019
  • Bali
    8 - 12 - 2019
    19 - 12 - 2019
  • Singapore
    8 - 12 - 2019
    19 - 12 - 2019
  • Washington
    8 - 12 - 2019
    19 - 12 - 2019
  • London
    26 - 1 - 2020
    6 - 2 - 2020
  • Madrid
    26 - 1 - 2020
    6 - 2 - 2020
  • Munich
    26 - 1 - 2020
    6 - 2 - 2020
  • Berlin
    26 - 1 - 2020
    6 - 2 - 2020
  • New York
    26 - 1 - 2020
    6 - 2 - 2020
  • Istanbul
    19 - 1 - 2020
    30 - 1 - 2020
  • Bali
    19 - 1 - 2020
    30 - 1 - 2020
  • Singapore
    19 - 1 - 2020
    30 - 1 - 2020
  • Washington
    19 - 1 - 2020
    30 - 1 - 2020
  • Kuala Lumpur
    12 - 1 - 2020
    23 - 1 - 2020
  • Rome
    12 - 1 - 2020
    23 - 1 - 2020
  • Barcelona
    12 - 1 - 2020
    23 - 1 - 2020
  • Zurich
    12 - 1 - 2020
    23 - 1 - 2020
  • Dubai
    5 - 1 - 2020
    16 - 1 - 2020
  • Paris
    5 - 1 - 2020
    16 - 1 - 2020
  • Hong Kong
    5 - 1 - 2020
    16 - 1 - 2020
  • Kuala Lumpur
    23 - 2 - 2020
    6 - 3 - 2020
  • Rome
    23 - 2 - 2020
    6 - 3 - 2020
  • Barcelona
    23 - 2 - 2020
    6 - 3 - 2020
  • Zurich
    23 - 2 - 2020
    6 - 3 - 2020
  • London
    16 - 2 - 2020
    27 - 2 - 2020
  • Madrid
    16 - 2 - 2020
    27 - 2 - 2020
  • Munich
    16 - 2 - 2020
    27 - 2 - 2020
  • Berlin
    16 - 2 - 2020
    27 - 2 - 2020
  • New York
    16 - 2 - 2020
    27 - 2 - 2020
  • Dubai
    9 - 2 - 2020
    20 - 2 - 2020
  • Paris
    9 - 2 - 2020
    20 - 2 - 2020
  • Hong Kong
    9 - 2 - 2020
    20 - 2 - 2020
  • Istanbul
    2 - 2 - 2020
    13 - 2 - 2020
  • Bali
    2 - 2 - 2020
    13 - 2 - 2020
  • Singapore
    2 - 2 - 2020
    13 - 2 - 2020
  • Washington
    2 - 2 - 2020
    13 - 2 - 2020
  • London
    15 - 3 - 2020
    26 - 3 - 2020
  • Madrid
    15 - 3 - 2020
    26 - 3 - 2020
  • Munich
    15 - 3 - 2020
    26 - 3 - 2020
  • Berlin
    15 - 3 - 2020
    26 - 3 - 2020
  • New York
    15 - 3 - 2020
    26 - 3 - 2020
  • Istanbul
    8 - 3 - 2020
    19 - 3 - 2020
  • Bali
    8 - 3 - 2020
    19 - 3 - 2020
  • Singapore
    8 - 3 - 2020
    19 - 3 - 2020
  • Washington
    8 - 3 - 2020
    19 - 3 - 2020
  • Kuala Lumpur
    1 - 3 - 2020
    12 - 3 - 2020
  • Rome
    1 - 3 - 2020
    12 - 3 - 2020
  • Barcelona
    1 - 3 - 2020
    12 - 3 - 2020
  • Zurich
    1 - 3 - 2020
    12 - 3 - 2020
  • Dubai
    22 - 3 - 2020
    2 - 4 - 2020
  • Paris
    22 - 3 - 2020
    2 - 4 - 2020
  • Hong Kong
    22 - 3 - 2020
    2 - 4 - 2020
  • Kuala Lumpur
    26 - 4 - 2020
    7 - 5 - 2020
  • Rome
    26 - 4 - 2020
    7 - 5 - 2020
  • Barcelona
    26 - 4 - 2020
    7 - 5 - 2020
  • Zurich
    26 - 4 - 2020
    7 - 5 - 2020
  • London
    5 - 4 - 2020
    16 - 4 - 2020
  • Madrid
    5 - 4 - 2020
    16 - 4 - 2020
  • Munich
    5 - 4 - 2020
    16 - 4 - 2020
  • Berlin
    5 - 4 - 2020
    16 - 4 - 2020
  • New York
    5 - 4 - 2020
    16 - 4 - 2020
  • Dubai
    12 - 4 - 2020
    23 - 4 - 2020
  • Paris
    12 - 4 - 2020
    23 - 4 - 2020
  • Hong Kong
    12 - 4 - 2020
    23 - 4 - 2020
  • Istanbul
    19 - 4 - 2020
    30 - 4 - 2020
  • Bali
    19 - 4 - 2020
    30 - 4 - 2020
  • Singapore
    19 - 4 - 2020
    30 - 4 - 2020
  • Washington
    19 - 4 - 2020
    30 - 4 - 2020
  • London
    10 - 5 - 2020
    21 - 5 - 2020
  • Madrid
    10 - 5 - 2020
    21 - 5 - 2020
  • Munich
    10 - 5 - 2020
    21 - 5 - 2020
  • Berlin
    10 - 5 - 2020
    21 - 5 - 2020
  • New York
    10 - 5 - 2020
    21 - 5 - 2020
  • Istanbul
    3 - 5 - 2020
    14 - 5 - 2020
  • Bali
    3 - 5 - 2020
    14 - 5 - 2020
  • Singapore
    3 - 5 - 2020
    14 - 5 - 2020
  • Washington
    3 - 5 - 2020
    14 - 5 - 2020
  • Kuala Lumpur
    17 - 5 - 2020
    28 - 5 - 2020
  • Rome
    17 - 5 - 2020
    28 - 5 - 2020
  • Barcelona
    17 - 5 - 2020
    28 - 5 - 2020
  • Zurich
    17 - 5 - 2020
    28 - 5 - 2020
  • Dubai
    24 - 5 - 2020
    4 - 6 - 2020
  • Paris
    24 - 5 - 2020
    4 - 6 - 2020
  • Hong Kong
    24 - 5 - 2020
    4 - 6 - 2020
  • Kuala Lumpur
    14 - 6 - 2020
    25 - 6 - 2020
  • Rome
    14 - 6 - 2020
    25 - 6 - 2020
  • Barcelona
    14 - 6 - 2020
    25 - 6 - 2020
  • Zurich
    14 - 6 - 2020
    25 - 6 - 2020
  • London
    21 - 6 - 2020
    2 - 7 - 2020
  • Madrid
    21 - 6 - 2020
    2 - 7 - 2020
  • Munich
    21 - 6 - 2020
    2 - 7 - 2020
  • Berlin
    21 - 6 - 2020
    2 - 7 - 2020
  • New York
    21 - 6 - 2020
    2 - 7 - 2020
  • Dubai
    28 - 6 - 2020
    9 - 7 - 2020
  • Paris
    28 - 6 - 2020
    9 - 7 - 2020
  • Hong Kong
    28 - 6 - 2020
    9 - 7 - 2020
  • Istanbul
    7 - 6 - 2020
    18 - 6 - 2020
  • Bali
    7 - 6 - 2020
    18 - 6 - 2020
  • Singapore
    7 - 6 - 2020
    18 - 6 - 2020
  • Washington
    7 - 6 - 2020
    18 - 6 - 2020
  • London
    5 - 7 - 2020
    16 - 7 - 2020
  • Madrid
    5 - 7 - 2020
    16 - 7 - 2020
  • Munich
    5 - 7 - 2020
    16 - 7 - 2020
  • Berlin
    5 - 7 - 2020
    16 - 7 - 2020
  • New York
    5 - 7 - 2020
    16 - 7 - 2020
  • Istanbul
    12 - 7 - 2020
    23 - 7 - 2020
  • Bali
    12 - 7 - 2020
    23 - 7 - 2020
  • Singapore
    12 - 7 - 2020
    23 - 7 - 2020
  • Washington
    12 - 7 - 2020
    23 - 7 - 2020
  • Kuala Lumpur
    19 - 7 - 2020
    30 - 7 - 2020
  • Rome
    19 - 7 - 2020
    30 - 7 - 2020
  • Barcelona
    19 - 7 - 2020
    30 - 7 - 2020
  • Zurich
    19 - 7 - 2020
    30 - 7 - 2020
  • Dubai
    26 - 7 - 2020
    6 - 8 - 2020
  • Paris
    26 - 7 - 2020
    6 - 8 - 2020
  • Hong Kong
    26 - 7 - 2020
    6 - 8 - 2020
  • Kuala Lumpur
    2 - 8 - 2020
    13 - 8 - 2020
  • Rome
    2 - 8 - 2020
    13 - 8 - 2020
  • Barcelona
    2 - 8 - 2020
    13 - 8 - 2020
  • Zurich
    2 - 8 - 2020
    13 - 8 - 2020
  • London
    9 - 8 - 2020
    20 - 8 - 2020
  • Madrid
    9 - 8 - 2020
    20 - 8 - 2020
  • Munich
    9 - 8 - 2020
    20 - 8 - 2020
  • Berlin
    9 - 8 - 2020
    20 - 8 - 2020
  • New York
    9 - 8 - 2020
    20 - 8 - 2020
  • Dubai
    16 - 8 - 2020
    27 - 8 - 2020
  • Paris
    16 - 8 - 2020
    27 - 8 - 2020
  • Hong Kong
    16 - 8 - 2020
    27 - 8 - 2020
  • Istanbul
    23 - 8 - 2020
    3 - 9 - 2020
  • Bali
    23 - 8 - 2020
    3 - 9 - 2020
  • Singapore
    23 - 8 - 2020
    3 - 9 - 2020
  • Washington
    23 - 8 - 2020
    3 - 9 - 2020
  • London
    27 - 9 - 2020
    8 - 10 - 2020
  • Madrid
    27 - 9 - 2020
    8 - 10 - 2020
  • Munich
    27 - 9 - 2020
    8 - 10 - 2020
  • Berlin
    27 - 9 - 2020
    8 - 10 - 2020
  • New York
    27 - 9 - 2020
    8 - 10 - 2020
  • Istanbul
    6 - 9 - 2020
    17 - 9 - 2020
  • Bali
    6 - 9 - 2020
    17 - 9 - 2020
  • Singapore
    6 - 9 - 2020
    17 - 9 - 2020
  • Washington
    6 - 9 - 2020
    17 - 9 - 2020
  • Kuala Lumpur
    13 - 9 - 2020
    24 - 9 - 2020
  • Rome
    13 - 9 - 2020
    24 - 9 - 2020
  • Barcelona
    13 - 9 - 2020
    24 - 9 - 2020
  • Zurich
    13 - 9 - 2020
    24 - 9 - 2020
  • Dubai
    20 - 9 - 2020
    1 - 10 - 2020
  • Paris
    20 - 9 - 2020
    1 - 10 - 2020
  • Hong Kong
    20 - 9 - 2020
    1 - 10 - 2020
  • Dubai
    4 - 10 - 2020
    15 - 10 - 2020
  • Paris
    4 - 10 - 2020
    15 - 10 - 2020
  • Hong Kong
    4 - 10 - 2020
    15 - 10 - 2020

Introduction

Many senior and middle managers do not utilise Excel to its maximum potential. Instead they use it as they would a calculator. If you fall into this category then this seminar is for you. Having completed this ten day seminar you will have the requisite tools to utilise Excel to its fullest and be better equipped to challenge decisions. In addition, if you work in the upstream or downstream, and your career progression is being restricted by outdated knowledge of modelling techniques then this seminar will help you move your career forward.

Highlights of the seminar include:

  • A seminar which takes delegates from Excel basics to the most advanced use of Excel.
  • Real world approach to the discipline.
  • Numerous examples based around the oil and gas industry.
  • Dual approach that not only develops modelling skills but also financial management skills.

Objectives

The seminar provides delegates with the tools required to find better answers to questions such as:

  • How to improve the quality of the quantitative analysis of my corporate presentations
  • How to model and advise on hedging price changes in the oil and gas industry
  • How to model investment appraisal techniques and utilise decision trees to model the option to abandon

The Content:

An introduction to the Excel Environment, with Petroleum based examples

  • Background to the Petroleum industry
  • Cell referencing, using formula’s, formatting
  • Advanced charting within Excel
  • Data manipulation and management

Financial Analysis in the up and down stream Oil and Gas industry I

  • Introduction to financial statements
  • Ratio analysis applied to the Oil and Gas Industry

Financial Analysis in the up and down stream Oil and Gas industry II

  • Trend analysis using Excel
  • Projecting financial statements using forecasting techniques available within Excel

Statistical analysis (applied to the Oil and Gas industry) using Excel

  • Analysis of equity returns of oil and gas industry companies
  • Use of Excel functions for statistical analysis
  • Use of scatter diagrams and regression techniques to calculate cost of equity financing.

Capital Structure in the Oil and Gas industry

  • Analysis of capital structure throughout the up-stream and down-stream oil and gas industry.
  • Examination of bond issues and IPO’s by oil and gas industry participants.
  • Examination and calculation of the cost of debt financing.

Investment Appraisal using Excel I

  • 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
  • Use of solver in scenario analysis and stress testing

Investment Appraisal using Excel II

  • Using Excel to model decision trees
  • Using Excel to calculate the value of a real option and the abandonment decision

An introduction to energy derivatives

  • An introduction to the derivatives market
  • Examination of petroleum based derivatives, including futures and options.
  • Modelling up-stream down stream energy products using Excel

Hedging risk using energy derivatives

  • Hedging against price decreases and increases using petroleum futures
  • Using VBA to create functions to value energy derivatives
  • Hedging against price changes using petroleum based options

Oil product spreads

  • Examining the relationship between energy products
  • Using futures spreads to speculate and to hedge against profit margin risk

Courses Search

Recent Posts

Connect with us

IFRS Preparation. (5 Days)Available in London - Dubai - Istanbul - Kuala Lumpur

Join our Civil and Construction Engineering Training Courses , Electrical and Power Engineering Training Courses and Facilities Management Training

Technical Training Courses

Newsletter