💼 Oil and Gas Financial Modelling Course

Overview

📘 Course Description

This intensive course equips oil and gas professionals with the knowledge and practical skills to build, interpret, and audit financial models for upstream, midstream, and downstream oil and gas projects. Participants will learn the fundamentals of discounted cash flow (DCF) modeling, economic indicators, project finance, fiscal regimes, and sensitivity analysis using Excel. The course emphasizes industry-specific challenges, including reserves classification, capital expenditure, operating costs, commodity price volatility, and risk analysis.

🎯 Learning Objectives

✅ Build fully integrated financial models in Excel
✅ Forecast production profiles, revenues, and costs
✅ Analyze net present value (NPV), internal rate of return (IRR), payback, and other KPIs
✅ Incorporate different fiscal regimes and tax structures
✅ Perform sensitivity and scenario analysis on key assumptions
✅ Apply Monte Carlo simulation for risk assessment
✅ Understand valuation of oil & gas assets for M&A or investment decisions

👥 Who Should Attend

Financial analysts, accountants, and economists in oil & gas
Petroleum engineers and reservoir engineers involved in planning
Managers and executives involved in investment decisions
Project finance and investment banking professionals
Anyone seeking practical financial modeling skills in energy

🗂️ Training Format

✅ Step-by-step Excel-based workshops
✅ Interactive lectures and discussions
✅ Group modeling exercises
✅ Real oil and gas project datasets
✅ Templates and modeling guides
✅ Daily Q&A sessions

📅 Day-by-Day Agenda with Time Breaks

📅 Day 1: Introduction & Modeling Fundamentals

Time	Topic
08:30 – 09:00	Welcome & Objectives
09:00 – 10:30	Overview of Oil & Gas Value Chain
10:30 – 10:45	☕ Coffee Break
10:45 – 12:15	Basics of Financial Statements in Oil & Gas
12:15 – 13:15	🍽 Lunch
13:15 – 14:45	Excel Essentials for Financial Modeling
14:45 – 15:00	☕ Coffee Break
15:00 – 16:30	Building a Simple Production & Revenue Model

📅 Day 2: Cash Flow & Economic Indicators

Time	Topic
08:30 – 10:00	Modeling Operating & Capital Expenditures
10:00 – 10:15	☕ Coffee Break
10:15 – 12:15	Building Discounted Cash Flow (DCF) Models
12:15 – 13:15	🍽 Lunch
13:15 – 14:45	NPV, IRR, Payback, and Profitability Index
14:45 – 15:00	☕ Coffee Break
15:00 – 16:30	Modeling Abandonment & Decommissioning Costs

📅 Day 3: Fiscal Regimes & Tax Modeling

Time	Topic
08:30 – 10:00	Overview of Oil & Gas Fiscal Systems
10:00 – 10:15	☕ Coffee Break
10:15 – 12:15	Royalty & Production Sharing Contract Modeling
12:15 – 13:15	🍽 Lunch
13:15 – 14:45	Tax Modeling & Cash Flow After Tax
14:45 – 15:00	☕ Coffee Break
15:00 – 16:30	Modeling Multiple Jurisdictions & Fiscal Scenarios

📅 Day 4: Sensitivity, Scenario & Risk Analysis

Time	Topic
08:30 – 10:00	Sensitivity Analysis on Key Assumptions
10:00 – 10:15	☕ Coffee Break
10:15 – 12:15	Scenario Analysis: Prices, Costs, Production
12:15 – 13:15	🍽 Lunch
13:15 – 14:45	Introduction to Monte Carlo Simulation
14:45 – 15:00	☕ Coffee Break
15:00 – 16:30	Incorporating Risk Analysis into Models

📅 Day 5: Valuation & Model Review

Time	Topic
08:30 – 10:00	Valuation of Oil & Gas Assets
10:00 – 10:15	☕ Coffee Break
10:15 – 12:15	M&A and Project Finance Modeling
12:15 – 13:15	🍽 Lunch
13:15 – 14:45	Model Audit, Error Checking & Best Practices
14:45 – 15:00	☕ Coffee Break
15:00 – 16:30	Final Group Exercise, Review & Certificates

📦 Materials Provided

✅ Excel templates and practical modeling tools
✅ Oil & gas datasets for exercises
✅ Electronic course manual
✅ Certificate of Completion

Target audiences

Reservoir Engineers, Geologists

$ 5,500

Course Features