Financial Modeling

Available Dates

Venue

Dec-23-2024

Dubai
Dec-23-2024

Kuala Lumpur
Dec-30-2024

Barcelona
Dec-30-2024

Istanbul
Jan-20-2025

London
Jan-20-2025

Dubai
Mar-31-2025

Kuala Lumpur
Mar-31-2025

Istanbul
Mar-31-2025

Paris
Mar-31-2025

Barcelona
Mar-31-2025

Amsterdam
Mar-31-2025

Singapore
Apr-21-2025

London
Apr-21-2025

Dubai
June-16-2025

Dubai
June-16-2025

London
June-30-2025

Barcelona
June-30-2025

Singapore
June-30-2025

Amsterdam
June-30-2025

Paris
June-30-2025

Istanbul
June-30-2025

Kuala Lumpur
July-21-2025

London
July-21-2025

Dubai
Sep-29-2025

Paris
Sep-29-2025

Amsterdam
Sep-29-2025

Barcelona
Sep-29-2025

Istanbul
Sep-29-2025

London
Sep-29-2025

Dubai
Sep-29-2025

Kuala Lumpur
Sep-29-2025

Singapore
Nov-24-2025

London
Nov-24-2025

Dubai
Dec-29-2025

Barcelona
Dec-29-2025

Singapore
Dec-29-2025

Istanbul
Dec-29-2025

Paris
Dec-29-2025

Kuala Lumpur
Dec-29-2025

Amsterdam

Course Details

This training course is designed to develop financial modeling skills through evaluating and analyzing studies that match real-world cases. It also aims to expand knowledge and understanding of the financial field, enabling participants to make important financial decisions related to cost reduction, profit increase, and risk minimization. The course highlights the latest tools and methods for managing modeling risks and performing oil and gas project analysis using sensitivity analysis, scenario analysis, and simulation of global events, such as oil price fluctuations.

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

Identify and improve the financial decision-making process.
Prepare financial models.
Apply the latest methods and tools for financial data analysis.
Manage financial risks using financial models.
Evaluate project performance using financial models.

This training course is intended for:

Financial analysts, business analysts, and investment analysts.
Professionals in risk and treasury.
Accountants.
Portfolio managers.
Financial model auditors.
Corporate controllers.
Project finance specialists.
Business development managers.

Course Outline

5 days course

Day 1

Day 2

Day 3

Day 4

Day 5

Fundamentals of Finance

Financial and managerial accounting.
Preparation of financial statements - income statement, balance sheet (statement of financial position), and cash flow statements.
Financial performance and financial ratio analysis.
Managerial accounting - budget preparation.
Operating expenses and capital expenditures.
Explanation of financial terms.

Fundamentals of Financial Modeling

Basic functions of Excel.
Steps for preparing a financial model.
Data flowchart and improving the financial modeling process.
Input tables.
Pivot tables.
Excel tools for fundamental analysis.

Financial Modeling

Forecasting in the income statement, balance sheet (statement of financial position), and cash flow statements.
Budgeting models.
Purchase decisions.
Modeling financing decisions - equity or debt, and cost of capital.
Capital investment decisions - payback period, average rate of return, net present value, and internal rate of return using Excel.
Charts and diagrams used to support financial models.

Risk Management Modeling Visualizations

Identifying key risks facing the oil and gas sector.
Risk modeling and uncertainty.
Sensitivity analysis.
Scenario analysis.
Break-even analysis.
Modeling and managing changes in interest rates and exchange rates.

Financial Performance Modeling for Oil and Gas Projects

Variance analysis.
Critical path analysis - financial outcomes and workforce.
Gantt chart.
Earned value analysis.
Variance management.
Simulation of project changes.

Financial Modeling

Course Info

Course Details

Course Outline

Search Course

Related Courses