Financial Modeling

Available Dates

Feb-10-2025

London
Apr-14-2025

London
June-23-2025

London
Aug-11-2025

London
Oct-13-2025

London
Dec-22-2025

London

Dates in Other Venues

Jan-13-2025

Dubai
Feb-10-2025

Barcelona
Feb-10-2025

Amsterdam
Feb-10-2025

Kuala Lumpur
Feb-10-2025

Singapore
Feb-10-2025

Paris
Feb-10-2025

Istanbul
Mar-24-2025

Dubai
May-12-2025

Kuala Lumpur
May-12-2025

Singapore
May-12-2025

Paris
May-12-2025

Barcelona
May-12-2025

Amsterdam
May-12-2025

Dubai
May-12-2025

Istanbul
July-14-2025

Dubai
Aug-11-2025

Barcelona
Aug-11-2025

Paris
Aug-11-2025

Amsterdam
Aug-11-2025

Istanbul
Aug-11-2025

Kuala Lumpur
Aug-11-2025

Singapore
Sep-22-2025

Dubai
Nov-10-2025

Istanbul
Nov-10-2025

Barcelona
Nov-10-2025

Dubai
Nov-10-2025

Amsterdam
Nov-10-2025

Paris
Nov-10-2025

Singapore
Nov-10-2025

Kuala Lumpur

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

LPC Oxford Street Offices: 25 N Row, London W1K 6DJ

London Head Office: 47 - 49 Park Royal Road, London NW10 7LQ

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