Financial Modeling

Available Dates

Nov-25-2024

Barcelona
Dec-30-2024

Barcelona
Jan-06-2025

Barcelona
Feb-03-2025

Barcelona
Mar-03-2025

Barcelona
Apr-07-2025

Barcelona
May-05-2025

Barcelona
June-02-2025

Barcelona
June-30-2025

Barcelona
July-07-2025

Barcelona
Aug-04-2025

Barcelona
Sep-01-2025

Barcelona
Sep-29-2025

Barcelona
Oct-06-2025

Barcelona
Nov-03-2025

Barcelona
Dec-01-2025

Barcelona
Dec-29-2025

Barcelona

Dates in Other Venues

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-16-2024

Amsterdam
Dec-23-2024

Kuala Lumpur
Dec-23-2024

Dubai
Dec-30-2024

Istanbul
Jan-06-2025

Dubai
Jan-13-2025

Kuala Lumpur
Jan-13-2025

Istanbul
Jan-20-2025

Singapore
Jan-20-2025

Paris
Jan-27-2025

Amsterdam
Jan-27-2025

London
Feb-03-2025

Dubai
Feb-10-2025

Istanbul
Feb-10-2025

Kuala Lumpur
Feb-17-2025

Singapore
Feb-17-2025

Paris
Feb-24-2025

Amsterdam
Feb-24-2025

London
Mar-03-2025

Dubai
Mar-10-2025

Kuala Lumpur
Mar-10-2025

Istanbul
Mar-17-2025

Singapore
Mar-17-2025

Paris
Mar-24-2025

Amsterdam
Mar-24-2025

London
Apr-07-2025

Dubai
Apr-14-2025

Kuala Lumpur
Apr-14-2025

Istanbul
Apr-21-2025

Singapore
Apr-21-2025

Paris
Apr-28-2025

Amsterdam
Apr-28-2025

London
May-05-2025

Dubai
May-12-2025

Kuala Lumpur
May-12-2025

Istanbul
May-19-2025

Singapore
May-19-2025

Paris
May-26-2025

London
May-26-2025

Amsterdam
June-02-2025

Dubai
June-09-2025

Istanbul
June-09-2025

Kuala Lumpur
June-16-2025

Singapore
June-16-2025

Paris
June-23-2025

Amsterdam
June-30-2025

Dubai
June-30-2025

London
July-07-2025

Dubai
July-14-2025

Kuala Lumpur
July-14-2025

Istanbul
July-21-2025

Paris
July-21-2025

Singapore
July-28-2025

Amsterdam
July-28-2025

London
Aug-04-2025

Dubai
Aug-11-2025

Istanbul
Aug-11-2025

Kuala Lumpur
Aug-18-2025

Paris
Aug-18-2025

Singapore
Aug-25-2025

London
Aug-25-2025

Amsterdam
Sep-01-2025

Dubai
Sep-08-2025

Kuala Lumpur
Sep-08-2025

Istanbul
Sep-15-2025

Paris
Sep-15-2025

Singapore
Sep-22-2025

Amsterdam
Sep-29-2025

Dubai
Sep-29-2025

London
Oct-06-2025

Dubai
Oct-13-2025

Istanbul
Oct-13-2025

Kuala Lumpur
Oct-20-2025

Paris
Oct-20-2025

Singapore
Oct-27-2025

London
Oct-27-2025

Amsterdam
Nov-03-2025

Dubai
Nov-10-2025

Kuala Lumpur
Nov-10-2025

Istanbul
Nov-17-2025

Singapore
Nov-17-2025

Paris
Nov-24-2025

Amsterdam
Nov-24-2025

London
Dec-01-2025

Dubai
Dec-08-2025

Kuala Lumpur
Dec-08-2025

Istanbul
Dec-15-2025

Paris
Dec-15-2025

Singapore
Dec-22-2025

Amsterdam
Dec-29-2025

London
Dec-29-2025

Dubai

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 Barcelona are held at the LPC office located at:

Passeig de Gràcia, 21, planta principal, 08007 Barcelona, Spain

Once you register, we will subsequently send you the course details, including the location, trainer, and other logistical information.

Pay Attention, Please! The course location at our offices is subject to availability. Should our office be unavailable, we will secure an alternative nearby venue and promptly inform you of the change. The exact time and location will be confirmed one week prior to the course commencement.

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