Oil and Gas Industry Modelling: Technical and Financial Mastery Program

Training Introduction:

The oil and gas sector is capital-intensive, volatile, and globally complex. Success in this industry depends heavily on data-driven decision-making, accurate project evaluation, and robust financial modelling. This Oil and Gas Industry Modelling course provides participants with the essential technical, operational, and financial modelling skills to evaluate exploration, production, and midstream/downstream projects across the value chain.

Over 16 modules, the course combines industry fundamentals with practical financial and Excel-based modelling exercises. Participants will learn how to build project cash flows, model production forecasts, calculate economic indicators such as NPV and IRR, and assess risk and sensitivity for oil & gas investments. The training also addresses reserve classification, pricing scenarios, fiscal regimes, and capital budgeting specific to the energy sector.

 

Course Objectives:

By the end of this training, participants will be able to:

• Understand the upstream, midstream, and downstream oil & gas value chain
• Build financial models specific to oil and gas projects
• Forecast production profiles and operating costs
• Analyze project economics under different pricing, tax, and royalty regimes
• Evaluate investment returns using NPV, IRR, and payback metrics
• Perform risk, sensitivity, and scenario analysis
• Understand reserve classification, decline curves, and capex planning
• Structure models for investor presentations and internal decision-making

 

Target Audience:

• Energy and Finance Analysts
• Oil & Gas Project Engineers and Managers
• Corporate Finance and Strategy Teams
• Investment Bankers and Private Equity Professionals
• Government Energy Planners and Regulators
• Business Development and Asset Valuation Teams
• Graduate Students in Petroleum Engineering, Energy, or Finance

 

Course Duration:

4 Weeks (Typically delivered over 15 0days, depending on depth)

 

Course Content

Module 1: Overview of the Oil and Gas Industry

• The oil & gas value chain: upstream, midstream, downstream
• Global production and consumption dynamics
• Key industry players and market forces
• Introduction to oil price volatility and benchmarks (Brent, WTI)

Module 2: Oil and Gas Reserves and Resource Classification

• Proven, probable, and possible reserves (1P, 2P, 3P)
• SPE/SEC classification standards
• Role of reserve estimates in project modelling
• Integration with economic forecasts

Module 3: Production Forecasting and Decline Curve Analysis

• Decline curve models: exponential, hyperbolic, harmonic
• Modelling production profiles over time
• Forecasting peak production and abandonment points
• Linking to revenue and cost forecasts

Module 4: Pricing, Revenue, and Contracts

• Understanding oil & gas pricing mechanisms
• Crude oil vs. natural gas pricing
• Sales contracts: spot vs. long-term offtake agreements
• Revenue modelling based on pricing scenarios

Module 5: Capital Expenditures (CapEx) and Development Planning

• Phases of development: exploration, appraisal, development, production
• Modelling upfront and sustaining CapEx
• CapEx scheduling, inflation, and contingency modelling
• Linking CapEx to project phases and funding needs

Module 6: Operating Expenditures (OpEx) and Lifting Costs

• Fixed vs. variable OpEx
• Lifting cost per barrel (unit operating cost)
• Modelling production-related and non-production-related OpEx
• Benchmarking OpEx across similar assets

Module 7: Fiscal Regimes, Royalties, and Tax Structures

• Types of fiscal regimes: royalty-tax, PSCs, service contracts
• Modelling government take, royalties, and special levies
• Tax modelling: corporate tax, ring-fence rules, uplift, and allowances
• Real examples from key producing countries

Module 8: Building a Base Project Cash Flow Model

• Structuring the model (inputs, calculations, outputs)
• Linking CapEx, OpEx, and production to revenue
• Calculating EBIT, EBITDA, and operating cash flows
• Integrating timelines and production phases

Module 9: Economic Evaluation and Investment Appraisal

• Net Present Value (NPV), Internal Rate of Return (IRR), and Payback Period
• Real options and hurdle rates
• Profitability index and break-even analysis
• Economic limit testing and abandonment

Module 10: Financing Oil and Gas Projects

• Debt vs. equity financing structures
• Project finance and reserve-based lending (RBL)
• Modelling debt schedules, interest, and repayment
• Cash flow waterfall and lender ratios (DSCR, LLCR)

Module 11: Sensitivity and Scenario Analysis

• Key value drivers: oil price, CapEx, OpEx, production rates
• Running what-if scenarios and stress tests
• Tornado charts and data tables in Excel
• Interpreting sensitivity outputs for decision-making

Module 12: Risk Analysis and Probabilistic Modelling

• Monte Carlo simulation basics
• Probabilistic reserve and pricing models
• Quantifying technical and commercial risks
• Building confidence intervals around forecasts

Module 13: Midstream and Downstream Modelling Basics

• Introduction to pipeline, LNG, and refining economics
• Tariff-based revenue models
• Operating cost structures for mid/downstream assets
• Modelling multi-segment value chain impacts

Module 14: Environmental and Decommissioning Cost Modelling

• ESG and environmental compliance in modelling
• Decommissioning cost estimation and scheduling
• Asset retirement obligation (ARO) accounting
• Modelling future liabilities and escrow accounts

Module 15: Building Executive Dashboards and Model Outputs

• Creating investor-ready summaries in Excel
• Visualizing key metrics and valuation outputs
• KPI dashboards: breakeven oil price, IRR, cash flow curves
• Common pitfalls and audit-proofing the model

Module 16: Capstone Case Study – Full Project Model Build

• Participants build a full upstream project model
• Includes production forecast, fiscal regime, CapEx, OpEx, and valuation
• Perform sensitivity, scenario, and exit analysis
• Present investment decision memo and key outputs

 

Assessment and Certification:

• Module-based quizzes and Excel assignments
• Capstone project: full oil & gas model build
• Final presentation or peer-reviewed model
• Certificate of Completion for qualified participants

 

Delivery Format:

• Instructor-led sessions (in-person or virtual)
• Excel templates for all modelling activities
• Real-life case studies and sector-specific data
• Optional software integration (e.g., @Risk for Monte Carlo)
• Post-training support and model reviews available

 

Pre-Requisites:

• Basic understanding of Excel and financial concepts
• Familiarity with project evaluation or oil & gas sector is helpful
• No advanced modelling skills required — starts from foundational level and builds up