By the end of the program, participants will be able to:       

• Improve the quality of quantitative analysis used in financial and corporate presentations.
• Apply financial modeling techniques specific to the oil and gas industry, including production and revenue forecasting.
• Evaluate and justify appropriate discount rates, incorporating WACC, country risk, and project risk parameters.
• Identify and apply various investment valuation models, such as NPV, IRR, payback, sensitivity, scenario, and Monte Carlo analysis.
• Use business statistics to enhance operational decision‑making and establish meaningful organizational goals.

This course is ideal for professionals involved in financial planning, analysis, and decision‑making in the oil & gas sector:

• Financial Analysts & Planning Specialists
• Petroleum Economists
• Business Analysts & Strategy Professionals
• Energy Investment Analysts
• Project Managers & Project Engineers
• Corporate Finance, Accounting & Budgeting Teams
• Oil & Gas Consultants & Advisors
• Government regulators assessing project economics

The training uses a highly practical, hands‑on approach:

• Instructor‑led presentations with industry examples
• Step‑by‑step model building in Excel
• Case studies based on upstream, LNG, refining, and petrochemical projects
• Exercises & assignments for real‑world application
• Group workshops for discussion and peer learning
• Financial modeling templates provided to all participants
• Final capstone model built collaboratively by participants

Day 1 – Foundations of Financial Modelling & Petroleum Economics

Topics:

• Overview of the oil & gas industry value chain
• Fundamentals of petroleum economics
• Forecasting production & reserves
• Price dynamics (Brent, WTI, Henry Hub, JKM)
• Introduction to financial modelling structure and logic

Workshop:

• Build the basic structure of a financial model (inputs → calculations → outputs)

Day 2 – Cash Flow Modelling & Discount Rates

Topics:

• CAPEX & OPEX modelling
• Revenue modelling for crude, LNG, NGLs, and refined products
• Fiscal regimes: royalties, taxes, PSAs, concessions
• Selecting discount rates (WACC, risk adjustments, inflation, country risk)
• Real vs. nominal cash flows

Workshop:

• Build a cash flow model (FCFF & FCFE) with price and cost assumptions

Day 3 – Investment Appraisal & Sensitivity Analysis

Topics:

• NPV, IRR, Payback, Profitability Index
• Breakeven price and cost analysis
• Sensitivity analysis (tornado diagrams)
• Scenario modelling (base, low, high cases)

Workshop:

• Perform multi‑scenario evaluation for an oilfield development

Day 4 – Statistics for Financial Modelling & Forecasting

Topics:

• Business statistics for decision‑making
• Regression analysis and forecasting of oil & gas prices
• Probability distributions and uncertainty modelling
• Monte Carlo simulation concepts
• KPI development for oil & gas operations

Workshop:

• Build a statistical forecasting model for oil prices or production

Day 5 – Integrated Model Development & Final Presentation

Topics:

• Integrating economics, cash flows, and valuation
• Corporate presentation techniques for financial results
• Model auditing and error‑checking
• Best practices in financial modelling

Final Capstone Project:

Participants in teams will:

• Build a full upstream project financial model
• Conduct valuation and sensitivity tests
• Prepare and deliver a corporate-style financial presentation

CDGA attendance certificate will be issued to all attendees completing minimum of 80% of the total course duration