Financial Modelling and Petroleum Project Economics Course

Learn financial modeling and petroleum project economics. Join this course to acquire skills in analyzing financial data and evaluating project viability. BMC Training offers Financial Modelling and Petroleum Project Economics Course in Oil and Gas Training Courses.

  • English
  • 103 Training Sessions
  • Confirmed
  • Two Weeks
Financial Modelling and Petroleum Project Economics Training Course

Detailed description for visually impaired users: The image presents a view of Financial Modelling and Petroleum Project Economics Training Course

Type a city name or a month
Venue Start Date End Date Net Fees Details & Registration
Kuala Lumpur , Malaysia 21 - Jul - 2024 1 - Aug - 2024 10600 GBP
Rome , Italy 21 - Jul - 2024 1 - Aug - 2024 15800 GBP
Barcelona , Spain 21 - Jul - 2024 1 - Aug - 2024 16600 GBP
Zurich , Switzerland 21 - Jul - 2024 1 - Aug - 2024 17400 GBP
Dubai , UAE 28 - Jul - 2024 8 - Aug - 2024 11172.5 GBP
Paris , France 28 - Jul - 2024 8 - Aug - 2024 15800 GBP
Hong Kong , Hong Kong 28 - Jul - 2024 8 - Aug - 2024 18200 GBP
Tokyo , Japan 28 - Jul - 2024 8 - Aug - 2024 23000 GBP
Kuala Lumpur , Malaysia 4 - Aug - 2024 15 - Aug - 2024 10600 GBP
Rome , Italy 4 - Aug - 2024 15 - Aug - 2024 15800 GBP
Barcelona , Spain 4 - Aug - 2024 15 - Aug - 2024 16600 GBP
Zurich , Switzerland 4 - Aug - 2024 15 - Aug - 2024 17400 GBP
London , UK 11 - Aug - 2024 22 - Aug - 2024 11900 GBP
Madrid , Spain 11 - Aug - 2024 22 - Aug - 2024 15000 GBP
Munich , Germany 11 - Aug - 2024 22 - Aug - 2024 17800 GBP
Berlin , Germany 11 - Aug - 2024 22 - Aug - 2024 16600 GBP
New York , United States 11 - Aug - 2024 22 - Aug - 2024 25500 GBP
Amsterdam , Netherlands 11 - Aug - 2024 22 - Aug - 2024 18200 GBP
Dubai , UAE 18 - Aug - 2024 29 - Aug - 2024 11172.5 GBP
Paris , France 18 - Aug - 2024 29 - Aug - 2024 15800 GBP
Hong Kong , Hong Kong 18 - Aug - 2024 29 - Aug - 2024 18200 GBP
Istanbul , Turkey 25 - Aug - 2024 5 - Sep - 2024 11100 GBP
Bali , Indonesia 25 - Aug - 2024 5 - Sep - 2024 17400 GBP
Singapore , Singapore 25 - Aug - 2024 5 - Sep - 2024 16800 GBP
Washington , United States 25 - Aug - 2024 5 - Sep - 2024 27000 GBP
Milan , Italy 11 - Aug - 2024 22 - Aug - 2024 15000 GBP
Tokyo , Japan 18 - Aug - 2024 29 - Aug - 2024 23000 GBP
London , UK 22 - Sep - 2024 3 - Oct - 2024 11900 GBP
Madrid , Spain 22 - Sep - 2024 3 - Oct - 2024 15000 GBP
Munich , Germany 22 - Sep - 2024 3 - Oct - 2024 17800 GBP
Berlin , Germany 22 - Sep - 2024 3 - Oct - 2024 16600 GBP
New York , United States 22 - Sep - 2024 3 - Oct - 2024 25500 GBP
Bali , Indonesia 1 - Sep - 2024 12 - Sep - 2024 17400 GBP
Singapore , Singapore 1 - Sep - 2024 12 - Sep - 2024 16800 GBP
Amsterdam , Netherlands 22 - Sep - 2024 3 - Oct - 2024 18200 GBP
Istanbul , Turkey 1 - Sep - 2024 12 - Sep - 2024 11100 GBP
Washington , United States 1 - Sep - 2024 12 - Sep - 2024 27000 GBP
Kuala Lumpur , Malaysia 8 - Sep - 2024 19 - Sep - 2024 10600 GBP
Rome , Italy 8 - Sep - 2024 19 - Sep - 2024 15800 GBP
Barcelona , Spain 8 - Sep - 2024 19 - Sep - 2024 16600 GBP
Zurich , Switzerland 8 - Sep - 2024 19 - Sep - 2024 17400 GBP
Dubai , UAE 15 - Sep - 2024 26 - Sep - 2024 11172.5 GBP
Paris , France 15 - Sep - 2024 26 - Sep - 2024 15800 GBP
Hong Kong , Hong Kong 15 - Sep - 2024 26 - Sep - 2024 18200 GBP
Milan , Italy 22 - Sep - 2024 3 - Oct - 2024 15000 GBP
Tokyo , Japan 15 - Sep - 2024 26 - Sep - 2024 23000 GBP
Kuala Lumpur , Malaysia 20 - Oct - 2024 31 - Oct - 2024 10600 GBP
Rome , Italy 20 - Oct - 2024 31 - Oct - 2024 15800 GBP
Barcelona , Spain 20 - Oct - 2024 31 - Oct - 2024 16600 GBP
Zurich , Switzerland 20 - Oct - 2024 31 - Oct - 2024 17400 GBP
London , UK 27 - Oct - 2024 7 - Nov - 2024 11900 GBP
Madrid , Spain 27 - Oct - 2024 7 - Nov - 2024 15000 GBP
Munich , Germany 27 - Oct - 2024 7 - Nov - 2024 17800 GBP
Berlin , Germany 27 - Oct - 2024 7 - Nov - 2024 16600 GBP
New York , United States 27 - Oct - 2024 7 - Nov - 2024 25500 GBP
Amsterdam , Netherlands 27 - Oct - 2024 7 - Nov - 2024 18200 GBP
Dubai , UAE 6 - Oct - 2024 17 - Oct - 2024 11172.5 GBP
Paris , France 6 - Oct - 2024 17 - Oct - 2024 15800 GBP
Hong Kong , Hong Kong 6 - Oct - 2024 17 - Oct - 2024 18200 GBP
Istanbul , Turkey 13 - Oct - 2024 24 - Oct - 2024 11100 GBP
Bali , Indonesia 13 - Oct - 2024 24 - Oct - 2024 17400 GBP
Singapore , Singapore 13 - Oct - 2024 24 - Oct - 2024 16800 GBP
Washington , United States 13 - Oct - 2024 24 - Oct - 2024 27000 GBP
Milan , Italy 27 - Oct - 2024 7 - Nov - 2024 15000 GBP
Tokyo , Japan 6 - Oct - 2024 17 - Oct - 2024 23000 GBP
London , UK 17 - Nov - 2024 28 - Nov - 2024 11900 GBP
Madrid , Spain 17 - Nov - 2024 28 - Nov - 2024 15000 GBP
Munich , Germany 17 - Nov - 2024 28 - Nov - 2024 17800 GBP
Berlin , Germany 17 - Nov - 2024 28 - Nov - 2024 16600 GBP
New York , United States 17 - Nov - 2024 28 - Nov - 2024 25500 GBP
Amsterdam , Netherlands 17 - Nov - 2024 28 - Nov - 2024 18200 GBP
Istanbul , Turkey 24 - Nov - 2024 5 - Dec - 2024 11100 GBP
Bali , Indonesia 24 - Nov - 2024 5 - Dec - 2024 17400 GBP
Singapore , Singapore 24 - Nov - 2024 5 - Dec - 2024 16800 GBP
Washington , United States 24 - Nov - 2024 5 - Dec - 2024 27000 GBP
Kuala Lumpur , Malaysia 3 - Nov - 2024 14 - Nov - 2024 10600 GBP
Rome , Italy 3 - Nov - 2024 14 - Nov - 2024 15800 GBP
Barcelona , Spain 3 - Nov - 2024 14 - Nov - 2024 16600 GBP
Zurich , Switzerland 3 - Nov - 2024 14 - Nov - 2024 17400 GBP
Dubai , UAE 10 - Nov - 2024 21 - Nov - 2024 11172.5 GBP
Paris , France 10 - Nov - 2024 21 - Nov - 2024 15800 GBP
Hong Kong , Hong Kong 10 - Nov - 2024 21 - Nov - 2024 18200 GBP
Milan , Italy 17 - Nov - 2024 28 - Nov - 2024 15000 GBP
Tokyo , Japan 10 - Nov - 2024 21 - Nov - 2024 23000 GBP
Kuala Lumpur , Malaysia 15 - Dec - 2024 26 - Dec - 2024 10600 GBP
Rome , Italy 15 - Dec - 2024 26 - Dec - 2024 15800 GBP
Barcelona , Spain 15 - Dec - 2024 26 - Dec - 2024 16600 GBP
Zurich , Switzerland 15 - Dec - 2024 26 - Dec - 2024 17400 GBP
London , UK 22 - Dec - 2024 2 - Jan - 2025 11900 GBP
Madrid , Spain 22 - Dec - 2024 2 - Jan - 2025 15000 GBP
Munich , Germany 22 - Dec - 2024 2 - Jan - 2025 17800 GBP
Berlin , Germany 22 - Dec - 2024 2 - Jan - 2025 16600 GBP
New York , United States 22 - Dec - 2024 2 - Jan - 2025 25500 GBP
Amsterdam , Netherlands 22 - Dec - 2024 2 - Jan - 2025 18200 GBP
Dubai , UAE 1 - Dec - 2024 12 - Dec - 2024 11172.5 GBP
Paris , France 1 - Dec - 2024 12 - Dec - 2024 15800 GBP
Hong Kong , Hong Kong 1 - Dec - 2024 12 - Dec - 2024 18200 GBP
Istanbul , Turkey 8 - Dec - 2024 19 - Dec - 2024 11100 GBP
Bali , Indonesia 8 - Dec - 2024 19 - Dec - 2024 17400 GBP
Singapore , Singapore 8 - Dec - 2024 19 - Dec - 2024 16800 GBP
Washington , United States 8 - Dec - 2024 19 - Dec - 2024 27000 GBP
Milan , Italy 22 - Dec - 2024 2 - Jan - 2025 15000 GBP
Tokyo , Japan 1 - Dec - 2024 12 - Dec - 2024 23000 GBP

Course Syllabus

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

Related Courses

OGT11

Oil and Gas Contracts Course

Master oil and gas contracts and agreements. Enroll in this course to develop skills in negotiating, drafting, and managing contracts within the industry.
OGT8

International Petroleum Management Course

Master international petroleum management strategies. Join this course to develop skills in managing petroleum operations and navigating the global market.
OGT29

The Chemical and Petrochemical Industries for Non-Technical Personnel Course

Essential chemical and petrochemical industry insights for non-technical professionals. Understand key concepts, terminology, and industry trends.
OGT9

Managing Project Risks in the Oil and Gas Industry Course

Learn to manage project risks in the oil and gas industry. Join this course to acquire skills in identifying, assessing, and mitigating project-related risks.
OGT3

Essential Skills for Oil and Gas Managers and Supervisors Course

Develop essential skills for managing and supervising in the oil and gas industry. Enroll in this course to acquire the knowledge needed for effective leadership.
OGT13

Operation, Diagnostics and Maintenance of Equipment for Oil and Gas Production Course

Master equipment operation, diagnostics, and maintenance in oil and gas production. Enroll in this course to develop skills in optimizing production processes.

Available Cities