An Interactive 10-Day Training Course
Financial Modelling & Petroleum Project Economics
Course Overview
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.
Training 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
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.
About Saudi Glomacs
At Saudi GLOMACS, we specialize in delivering world-class training courses in Saudi Arabia and across various international locations. Our training courses are tailored to meet the unique demands of Saudi Vision 2030 and the Human Capability Development Program, focusing on empowering Saudi citizens and enhancing workforce skills. We offer diverse courses spanning leadership, management, engineering, and technical disciplines to cultivate expertise and drive professional growth. Our flexible learning options—whether in-person, online, or in-house—ensure accessibility and convenience for individuals and organizations alike.
With over 30+ years of experience through the GLOMACS global network, we are committed to delivering innovative, results-driven training solutions. Our expert instructors combine industry knowledge with dynamic teaching methods, fostering practical skill development and long-term career success. By choosing Saudi GLOMACS, you're investing in personal excellence and contributing to the Kingdom’s sustainable economic growth and vision-driven transformation.
Training 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 Sponsor, one CPE credit is granted per 50 minutes of attendance
Accreditation
GLOMACS is registered with NASBA as a sponsor of Continuing Professional Education (CPE) on the National Registry of CPE Sponsors. NASBA have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.
All Training Seminars delivered by GLOMACS by default are eligible for CPE Credit.
What do you need to learn next?
Check our list of courses or let us customize a course for you.
View courses
