Main MenuMain Menu
Course Code: OGC 901
35 Course Visits
Financial Modelling in the Oil and Gas industry
Course Sector:
Oil, Gas and Chemical
Course Dates and Locations
Choose a date and location to book your seat
No.
Date
Days
Location
Fees
Enrollment
01
5 Days
Singapore,SG $4,950
02
5 Days
Dubai, UAE $4,250
Introduction
Training course introducion / brief
This training course is designed to provide participants with the essential concepts on the advanced use of Excel in the oil & gas industry particularly for financial modeling. This training course will cover topics such as how to deal with several important issues related to financial modelling, performance measurements, setting targets using sophisticated techniques, and various methods relevant in enhancing company performance.
Course Methodology
The training course is designed to be interactive and participatory, and includes various learning tools to enable the participants to operate effectively and efficiently in a multifunctional environment. The course will use lectures and presentations, exercises, experiential and exposure to real world problems and policy choices confronting delegates.
Course Objectives
At the end of the training course, participants will be able to
- Improve the quality of the quantitative analysis of corporate presentations
- Apply financial modelling in the oil and gas industry
- Effectively assess the appropriate discount rate
- Use various models of investment appraisal techniques
- Use business statistics to enhance operations and target setting for the organization
Course Audience
Who is this course for, and can benefit the most
- Process design
- Unit Operator
- Environmental
- Process safety engineer
- Gasoline blender engineer
- Lab supervisor
- Supply chain engineer
- Distillates analyst
- Models engineer
- Chemical Operator
- Chemical Plant Operator
- Chemical Process Technician
- Control Room Supervisor
- Gas Plant Process Operator
- Gas Production Operator
- Gas Terminal Operations and Storage
- Gathering Pipeline engineer
- Oil Terminal / Storage engineer
- Pipeline Maintenance / Equipment / Compliance / Repair
- Pipeline Testing / Technician / Supervisor / Safety
- Plant Equipment Operator
- Plant Operations Technician
- Plant Shutdown
- Plant Supervisor
- Power Distribution
- Power Plant Manager
- Process Supervisor
- Refinery Operations Technician / Manager
- Terminal Operator / Manager
- Utilities Operator
Course Outline
The course aims and learning outcomes
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 and practical application
- Trend Analysis Using Excel
- Time Series Analysis
Statistical Analysis (Applied to the Oil and Gas Industry) Using Excel
- Use of Excel Functions for Statistical Analysis
- Descriptive Statistics and their applications:
- 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
Oil Product Spreads
- Examining the Relationship between Energy Products
- Differences between Data Sets and their importance.
- Correlation Analysis
- Confidence Intervals
- Application of Analysis of Variance (ANOVA)
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
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
Providers and Associations
Providing the best training services and benefits to our valued clients
Boost certificate of completion
BOOST's Professional Attendance Certificate “BPAC” is always given to the delegates after completing the training course, and depends on their attendance of the program at a rate of no less than 80%, besides their active participation and engagement during the program sessions.
ENDORSED EDUCATION PROVIDER
Flexible deadlines
Customized dates accordance to your schedule
Shareable Certificate
Earn certificate upon completion
COURSE METHODOLOGY
Our Training programs are implemented by combining the participants' academic knowledge and practical practice (30% theoretical / 70% practical activities).
At The end of the training program, Participants are involved in practical workshop to show their skills in applying what they were trained for. A detailed report is submitted to each participant and the training department in the organization on the results of the participant's performance and the return on training. Our programs focus on exercises, case studies, and individual and group presentations.
Since 2001, we have been pioneering the training field in the middle east, we managed to unlock potential and help individuals, teams and organisations to be the best that they can be with our full and integrated solutions.
Quick Links
Our sister companies in Egypt and United Arab Emirates
MOST TRENDING
And Recommended Training Courses
trending
IOSH Managing and Working Safely
Date: Apr 7, 2025
Location:Abu Dhabi, UAE
trending
Professional in Business Analysis (PMI-PBA Exam Preparation)
Date: May 18, 2025
Location:Jeddah, KSA
trending
OSHA: Occupational Safety and Health Administration Standards
Date: Apr 13, 2025
Location:Riyadh, KSA
We believe in progress for everyone.
We helped more than 10.000 clients over 20 countries on 4 continents in boosting their knowledge, skills and careers.
Boost Training And Consulting © All Copyrights Reserved 2025