Financial Modelling & Petroleum Project Economics
An Interactive 10-Day Training Course

Financial Modelling & Petroleum Project Economics

NASBA

We regret to inform you that we currently don't have any sessions scheduled for this course.

Please let us know your preferred date and venue, and we'll contact you soon.

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 course is for you. Having completed this ten day training course 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 course will help you move your career forward.

Highlights of the training course include: 

  • A course 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 training 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

Training Methodology

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

Organisational Impact

By sending delegates on the 10 Day Programme in Financial Modelling & Petroleum Project Economics your organisation will benefit by:

  • Providing your staff with the opportunities to develop high level financial management techniques appropriate to the Oil and Gas industry.
  • Updating their quantitative techniques to enable them to make better informed decisions.
  • Transforming their Excel skills so that the leave with advanced knowledge of Excel for financial modelling.

Personal Impact

By attending this training course you will:

  • Have advanced ability in financial modelling using Excel.
  • Have a larger skills set when contributing to corporate decisions.
  • The ability to question important decisions formed using financial modelling.

Who should Attend?

  • Decision makers and financial modelers in the up-stream and down-stream oil and gas industry
  • High level managers integral to the decision making process who wish to develop their financial modeling skills.
Course Outline
Day 1

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
Day 2

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
Day 3

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
Day 4

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.
Day 5

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.
  • Calculation of a company’s weighted average cost of capital (WACC)
Day 6

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

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
Day 8

An introduction to energy derivatives

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

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.
Day 10

Oil product spreads

  • Examining the relationship between energy products
  • Using futures spreads to speculate and to hedge against profit margin risk
Certificates
  • On successful completion of this training course, GLOMACS Certificate will be awarded to the delegates.
  • Continuing Professional Education credits (CPE): In accordance with the standards of the National Registry of CPE Sponsors, one CPE credit is granted per 50 minutes of attendance.
Providers

Endorsed Education Provider

NASBA
Options & Brochure
Related Categories
Finance & Budgeting Oil and Gas
Related Courses

Financial Modelling Using Excel

5 - Day Training

This training course, presented by GLOMACS Financial Modeling Using Excel equips participants with practical skills in building and applying financial models using Excel, enabling them to analyze...

View Course

Certificate in Advanced Financial Modelling

5 - Day Training

This training course is designed for experienced finance professionals seeking to elevate their financial modelling capabilities to an advanced level. It focuses on sophisticated techniques including...

View Course

Certificate in Financial Modelling

5 - Day Training

This Certificate in Financial Modelling training course provides participants with the essential tools and techniques to construct robust financial models. Whether you are looking to enhance...

View Course

Predictive Modeling for Financial Fraud

5 - Day Training

Financial fraud is one of the most costly and disruptive risks facing organisations today. While reactive detection techniques are still widely used, forward-looking strategies that harness...

View Course
Frequently Asked Question
GLOMACS offers both online and in-person training options. You can choose from interactive virtual sessions or attend one of our globally located in-person training courses. The flexibility ensures that learning fits your schedule and preferences.
Yes, GLOMACS provides customized training solutions tailored to meet the specific needs of organizations. We work closely with companies to design bespoke training courses that address their unique challenges and objectives.
Our courses are structured to provide a balanced mix of theory and practical application. They typically include presentations, case studies, group discussions, hands-on activities, and interactive Q&A sessions to maximize learning outcomes.
For detailed information about specific courses, including course content, schedules, and instructors, you can visit our website or contact our customer service team. They will be happy to provide all the information you need to make an informed decision.
You can register for a GLOMACS training course by visiting our website, selecting the course of your choice, and following the simple registration process. You can also contact our support team for assistance with the registration process.
Attending a GLOMACS training course offers numerous benefits, including enhanced professional skills, increased employability, industry-recognized certification, networking opportunities with peers and experts, and the chance to apply practical knowledge directly to your workplace.
GLOMACS is a globally recognized leader in professional training and development, with a reputation for delivering high-quality, results-driven training courses. We offer a broad spectrum of training courses taught by expert trainers, flexible delivery options (both online and in-person), and accredited certifications that add real value to your career.

Yes, upon successful completion of any of our training courses, GLOMACS Certificate will be awarded to the delegates. This certificate is a valuable addition to your professional portfolio and is recognized across various industries.

Related Categories
Finance & Budgeting
Finance & Budgeting
 Oil & Gas
Oil & Gas

Training Venues

Browse our complete list of training venues

Training Categories

Browse our complete list of training categories