Available Dates

May-20-2024

Amsterdam
June-17-2024

Amsterdam
July-15-2024

Amsterdam
Aug-19-2024

Amsterdam
Sep-16-2024

Amsterdam
Oct-21-2024

Amsterdam
Nov-18-2024

Amsterdam
Dec-16-2024

Amsterdam

Dates in Other Venues

Apr-29-2024

Barcelona
Apr-29-2024

Istanbul
May-06-2024

Kuala Lumpur
May-06-2024

Istanbul
May-13-2024

Paris
May-13-2024

Singapore
May-20-2024

London
May-27-2024

Dubai
May-27-2024

Barcelona
June-03-2024

Istanbul
June-03-2024

Kuala Lumpur
June-10-2024

Singapore
June-10-2024

Paris
June-17-2024

London
June-24-2024

Barcelona
June-24-2024

Dubai
July-01-2024

Kuala Lumpur
July-01-2024

Istanbul
July-08-2024

Paris
July-08-2024

Singapore
July-15-2024

London
July-22-2024

Kuala Lumpur
July-22-2024

Dubai
July-29-2024

Barcelona
July-29-2024

Istanbul
Aug-05-2024

Kuala Lumpur
Aug-05-2024

Istanbul
Aug-12-2024

Singapore
Aug-12-2024

Paris
Aug-19-2024

London
Aug-19-2024

Barcelona
Aug-26-2024

Dubai
Sep-02-2024

Istanbul
Sep-02-2024

Kuala Lumpur
Sep-09-2024

Singapore
Sep-09-2024

Paris
Sep-16-2024

London
Sep-23-2024

Kuala Lumpur
Sep-23-2024

Dubai
Sep-30-2024

Istanbul
Sep-30-2024

Barcelona
Oct-07-2024

Istanbul
Oct-07-2024

Kuala Lumpur
Oct-14-2024

Paris
Oct-14-2024

Singapore
Oct-21-2024

London
Oct-28-2024

Barcelona
Oct-28-2024

Dubai
Nov-04-2024

Kuala Lumpur
Nov-04-2024

Istanbul
Nov-04-2024

Paris
Nov-04-2024

Singapore
Nov-18-2024

London
Nov-25-2024

Barcelona
Nov-25-2024

Dubai
Dec-02-2024

Kuala Lumpur
Dec-02-2024

Istanbul
Dec-09-2024

Singapore
Dec-09-2024

Paris
Dec-16-2024

London
Dec-23-2024

Kuala Lumpur
Dec-23-2024

Dubai
Dec-30-2024

Barcelona
Dec-30-2024

Istanbul

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.

Our courses in Amsterdam take place at :

Grand Hotel Amrâth Amsterdam: Prins Hendrikkade 108, 1011 AK Amsterdam, Netherlands
The Hoxton, Amsterdam: Herengracht 255, 1016 BJ Amsterdam
Regus - Spaces / AMSTERDAM, Spaces Vijzelstraat: Vijzelstraat 68, 1017 HL Amsterdam, Amsterdam, 1017 HL, Netherlands
Regus - Spaces / AMSTERDAM, Spaces Keizersgracht: Keizersgracht 555, 2nd Floor, Amsterdam, 1017 DR, Netherlands
The Office Operators - Rokin: Rokin 92-96, Amsterdam, 1012 KZ, Netherlands

Once you register for this course, we will subsequently send the invoice and course information, including location, trainer, and other logistics.

Pay Attention, Please! The course location is subject to availability; the course time will be precise one week before the course start date! We may change the course location if there is no availability, and we will let you know about the location change once it happens.

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