Start date Duration Cost Location Status
12/15/2023 5 Days 7350 AED Dubai, United Arab Emirates Register
11/15/2023 5 Days 7350 AED Dubai, United Arab Emirates Register
10/15/2023 5 Days 7350 AED Dubai, United Arab Emirates Register
9/15/2023 5 Days 7350 AED Dubai, United Arab Emirates Register
8/15/2023 5 Days 7350 AED Dubai, United Arab Emirates Register
7/15/2023 5 Days 7350 AED Dubai, United Arab Emirates Register
6/15/2023 5 Days 7350 AED Dubai, United Arab Emirates Register

Course description

Securing finance in today’s challenging and volatile markets is difficult. In order to take advantage of the opportunities available within this unique market you need to understand the key drivers for growth, areas of economic opportunity and combine this with a sound understanding of how to structure and secure project finance to deliver commercially viable solutions.
This dynamic and interactive programme reviews an integrated and practical understanding of financial analysis tools and techniques for the oil and gas industry,
financial modelling, project evaluation concepts, qualitative and quantitative project finance assessment, identifying and quantifying energy projects risks and uncertainty into project analysis in the oil and gas industry.
It is designed to help participants to build sophisticated analytical models that are robust, flexible and user‐friendly and then use these to analyse oil & gas projects for potential investment.


This course is designed for staff involved in Project Evaluation, Feasibility Studies or Company Valuations including

  • Business & Finance Analysts, Executives & Managers
  • Corporate Finance Executives & Managers
  • Budgeting/Forecasting Managers
  • Finance Managers & Financial Controllers
  • Economists
  • Financial Advisors & Managers
  • Project Investment Executives & Managers
  • Investment & Corporate Bankers
  • Investment and Credit Analysts


Course content

Day 1

Foundations of Economic Valuation and Modelling
General concepts:
cash flow
cash versus profit
free cash flow
cost of capital
net present value
internal rate of return
return on capital
The role and effect of risk in valuation and decision‐making in practice
Main components to construct cash flow projections
Special topics: real and nominal terms, incorporating inflation, sunk cost versus future decisions
Hands‐on exercises
Building cash flow forecasts
Economic production life
Cash flow valuation
Creation of sensitivities and scenarios, including on price decks, volume curves
Calculation of beta in the capital asset pricing model

Day 2

Building Financial Statements
Recap of core elements of financial statement modelling
Applications of financial statement modelling and related applications (e.g. project finance)
Hands‐on exercises:
Building an integrated financial statement model, with issues arising (e.g. cost escalation, tax)
Linking to valuation; sensitivities and scenario analysis
Creating the ability to update with actuals

Day 3

Data Analysis and Manipulation using Excel
Manipulating and cleaning data e.g. downloads of oil prices, dates, multicurrency databases, matching and reversing data, and combining databases
Introduction to statistical analysis and database manipulation and analysis (filtering, dynamic sorting, database functions, database queries, intro. to
array functions etc.)
Hands‐on exercises:
Splitting text and numerical fields using functions
Calculations with multicurrency databases
Querying databases in multiple languages
Consolidating data sets
Creating dynamic charts
Creating flexible time axes, working with date fields
Creating database queries

Day 4

Transitioning to Advanced Modelling
Sensitivity versus risk, uncertainty and optimisation: definitions and concepts, tools and methods
Introduction to VBA macros
Hands‐on exercises:
Optimisation analysis and modeling
Sensitivity analysis and (Monte Carlo) simulation using macros; various applications in oil and gas
Other use of VBA macros: data analysis, treatment of circular references

Day 5

Introduction to add‐ins for simulation (overview of @RISK)
Modelling best practices (design, layout, structure, format etc.)
Discussion of participants’ applications and modelling issues, Q&A, course close calculations etc.).
Modelling (e.g. exploration risk, cost estimation, capex planning, reserves aggregation)

comments (0)

leave a comment