Foundations of Financial Modeling Course

Build strong foundations in financial modeling with our specialized training course, designed for financial analysts. BMC Training offers Foundations of Financial Modeling Course in Finance , Accounting and Budgeting Courses.

  • English
  • 125 Training Sessions
  • Confirmed
  • One Week
Foundations of Financial Modeling Training Course

Detailed description for visually impaired users: The image presents a view of Foundations of Financial Modeling Training Course

Type a city name or a month
Venue Start Date End Date Net Fees Details & Registration
Kuala Lumpur , Malaysia 16 - Jun - 2024 20 - Jun - 2024 4750 GBP
Rome , Italy 16 - Jun - 2024 20 - Jun - 2024 7300 GBP
Barcelona , Spain 16 - Jun - 2024 20 - Jun - 2024 6950 GBP
Zurich , Switzerland 16 - Jun - 2024 20 - Jun - 2024 7950 GBP
Istanbul , Turkey 23 - Jun - 2024 27 - Jun - 2024 4700 GBP
Bali , Indonesia 23 - Jun - 2024 27 - Jun - 2024 8100 GBP
Singapore , Singapore 23 - Jun - 2024 27 - Jun - 2024 7500 GBP
Washington , United States 23 - Jun - 2024 27 - Jun - 2024 11000 GBP
Dubai , UAE 7 - Jul - 2024 11 - Jul - 2024 4987.5 GBP
Paris , France 7 - Jul - 2024 11 - Jul - 2024 6700 GBP
Hong Kong , Hong Kong 7 - Jul - 2024 11 - Jul - 2024 8500 GBP
London , UK 14 - Jul - 2024 18 - Jul - 2024 4950 GBP
Madrid , Spain 14 - Jul - 2024 18 - Jul - 2024 6950 GBP
Munich , Germany 14 - Jul - 2024 18 - Jul - 2024 7900 GBP
Berlin , Germany 14 - Jul - 2024 18 - Jul - 2024 7900 GBP
New York , United States 14 - Jul - 2024 18 - Jul - 2024 10900 GBP
Amsterdam , Netherlands 14 - Jul - 2024 18 - Jul - 2024 8100 GBP
London , UK 21 - Jul - 2024 25 - Jul - 2024 4950 GBP
Madrid , Spain 21 - Jul - 2024 25 - Jul - 2024 6950 GBP
Munich , Germany 21 - Jul - 2024 25 - Jul - 2024 7900 GBP
Berlin , Germany 21 - Jul - 2024 25 - Jul - 2024 7900 GBP
New York , United States 21 - Jul - 2024 25 - Jul - 2024 10900 GBP
Amsterdam , Netherlands 21 - Jul - 2024 25 - Jul - 2024 8100 GBP
Istanbul , Turkey 28 - Jul - 2024 1 - Aug - 2024 4700 GBP
Bali , Indonesia 28 - Jul - 2024 1 - Aug - 2024 8100 GBP
Singapore , Singapore 28 - Jul - 2024 1 - Aug - 2024 7500 GBP
Washington , United States 28 - Jul - 2024 1 - Aug - 2024 11000 GBP
Tokyo , Japan 7 - Jul - 2024 11 - Jul - 2024 9750 GBP
Milan , Italy 14 - Jul - 2024 18 - Jul - 2024 6950 GBP
Milan , Italy 21 - Jul - 2024 25 - Jul - 2024 6950 GBP
Dubai , UAE 4 - Aug - 2024 8 - Aug - 2024 4987.5 GBP
Paris , France 4 - Aug - 2024 8 - Aug - 2024 6700 GBP
Hong Kong , Hong Kong 4 - Aug - 2024 8 - Aug - 2024 8500 GBP
Kuala Lumpur , Malaysia 11 - Aug - 2024 15 - Aug - 2024 4750 GBP
Rome , Italy 11 - Aug - 2024 15 - Aug - 2024 7300 GBP
Barcelona , Spain 11 - Aug - 2024 15 - Aug - 2024 6950 GBP
Zurich , Switzerland 11 - Aug - 2024 15 - Aug - 2024 7950 GBP
Istanbul , Turkey 18 - Aug - 2024 22 - Aug - 2024 4700 GBP
Bali , Indonesia 18 - Aug - 2024 22 - Aug - 2024 8100 GBP
Singapore , Singapore 18 - Aug - 2024 22 - Aug - 2024 7500 GBP
Washington , United States 18 - Aug - 2024 22 - Aug - 2024 11000 GBP
London , UK 25 - Aug - 2024 29 - Aug - 2024 4950 GBP
Madrid , Spain 25 - Aug - 2024 29 - Aug - 2024 6950 GBP
Munich , Germany 25 - Aug - 2024 29 - Aug - 2024 7900 GBP
Berlin , Germany 25 - Aug - 2024 29 - Aug - 2024 7900 GBP
New York , United States 25 - Aug - 2024 29 - Aug - 2024 10900 GBP
Amsterdam , Netherlands 25 - Aug - 2024 29 - Aug - 2024 8100 GBP
Tokyo , Japan 4 - Aug - 2024 8 - Aug - 2024 9750 GBP
Milan , Italy 25 - Aug - 2024 29 - Aug - 2024 6950 GBP
Dubai , UAE 22 - Sep - 2024 26 - Sep - 2024 4987.5 GBP
Paris , France 22 - Sep - 2024 26 - Sep - 2024 6700 GBP
Hong Kong , Hong Kong 22 - Sep - 2024 26 - Sep - 2024 8500 GBP
London , UK 1 - Sep - 2024 5 - Sep - 2024 4950 GBP
Madrid , Spain 1 - Sep - 2024 5 - Sep - 2024 6950 GBP
Munich , Germany 1 - Sep - 2024 5 - Sep - 2024 7900 GBP
Berlin , Germany 1 - Sep - 2024 5 - Sep - 2024 7900 GBP
New York , United States 1 - Sep - 2024 5 - Sep - 2024 10900 GBP
Amsterdam , Netherlands 1 - Sep - 2024 5 - Sep - 2024 8100 GBP
Kuala Lumpur , Malaysia 8 - Sep - 2024 12 - Sep - 2024 4750 GBP
Rome , Italy 8 - Sep - 2024 12 - Sep - 2024 7300 GBP
Barcelona , Spain 8 - Sep - 2024 12 - Sep - 2024 6950 GBP
Zurich , Switzerland 8 - Sep - 2024 12 - Sep - 2024 7950 GBP
Istanbul , Turkey 15 - Sep - 2024 19 - Sep - 2024 4700 GBP
Bali , Indonesia 15 - Sep - 2024 19 - Sep - 2024 8100 GBP
Singapore , Singapore 15 - Sep - 2024 19 - Sep - 2024 7500 GBP
Washington , United States 15 - Sep - 2024 19 - Sep - 2024 11000 GBP
Tokyo , Japan 22 - Sep - 2024 26 - Sep - 2024 9750 GBP
Milan , Italy 1 - Sep - 2024 5 - Sep - 2024 6950 GBP
Dubai , UAE 20 - Oct - 2024 24 - Oct - 2024 4987.5 GBP
Paris , France 20 - Oct - 2024 24 - Oct - 2024 6700 GBP
Hong Kong , Hong Kong 20 - Oct - 2024 24 - Oct - 2024 8500 GBP
Kuala Lumpur , Malaysia 27 - Oct - 2024 31 - Oct - 2024 4750 GBP
Rome , Italy 27 - Oct - 2024 31 - Oct - 2024 7300 GBP
Barcelona , Spain 27 - Oct - 2024 31 - Oct - 2024 6950 GBP
Zurich , Switzerland 27 - Oct - 2024 31 - Oct - 2024 7950 GBP
Istanbul , Turkey 6 - Oct - 2024 10 - Oct - 2024 4700 GBP
Bali , Indonesia 6 - Oct - 2024 10 - Oct - 2024 8100 GBP
Singapore , Singapore 6 - Oct - 2024 10 - Oct - 2024 7500 GBP
Washington , United States 6 - Oct - 2024 10 - Oct - 2024 11000 GBP
London , UK 13 - Oct - 2024 17 - Oct - 2024 4950 GBP
Madrid , Spain 13 - Oct - 2024 17 - Oct - 2024 6950 GBP
Munich , Germany 13 - Oct - 2024 17 - Oct - 2024 7900 GBP
Berlin , Germany 13 - Oct - 2024 17 - Oct - 2024 7900 GBP
New York , United States 13 - Oct - 2024 17 - Oct - 2024 10900 GBP
Amsterdam , Netherlands 13 - Oct - 2024 17 - Oct - 2024 8100 GBP
Tokyo , Japan 20 - Oct - 2024 24 - Oct - 2024 9750 GBP
Milan , Italy 13 - Oct - 2024 17 - Oct - 2024 6950 GBP
Dubai , UAE 17 - Nov - 2024 21 - Nov - 2024 4987.5 GBP
Paris , France 17 - Nov - 2024 21 - Nov - 2024 6700 GBP
Hong Kong , Hong Kong 17 - Nov - 2024 21 - Nov - 2024 8500 GBP
London , UK 24 - Nov - 2024 28 - Nov - 2024 4950 GBP
Madrid , Spain 24 - Nov - 2024 28 - Nov - 2024 6950 GBP
Munich , Germany 24 - Nov - 2024 28 - Nov - 2024 7900 GBP
Berlin , Germany 24 - Nov - 2024 28 - Nov - 2024 7900 GBP
New York , United States 24 - Nov - 2024 28 - Nov - 2024 10900 GBP
Amsterdam , Netherlands 24 - Nov - 2024 28 - Nov - 2024 8100 GBP
Kuala Lumpur , Malaysia 3 - Nov - 2024 7 - Nov - 2024 4750 GBP
Rome , Italy 3 - Nov - 2024 7 - Nov - 2024 7300 GBP
Barcelona , Spain 3 - Nov - 2024 7 - Nov - 2024 6950 GBP
Zurich , Switzerland 3 - Nov - 2024 7 - Nov - 2024 7950 GBP
Istanbul , Turkey 10 - Nov - 2024 14 - Nov - 2024 4700 GBP
Bali , Indonesia 10 - Nov - 2024 14 - Nov - 2024 8100 GBP
Singapore , Singapore 10 - Nov - 2024 14 - Nov - 2024 7500 GBP
Washington , United States 10 - Nov - 2024 14 - Nov - 2024 11000 GBP
Tokyo , Japan 17 - Nov - 2024 21 - Nov - 2024 9750 GBP
Milan , Italy 24 - Nov - 2024 28 - Nov - 2024 6950 GBP
Dubai , UAE 15 - Dec - 2024 19 - Dec - 2024 4987.5 GBP
Paris , France 15 - Dec - 2024 19 - Dec - 2024 6700 GBP
Hong Kong , Hong Kong 15 - Dec - 2024 19 - Dec - 2024 8500 GBP
Kuala Lumpur , Malaysia 22 - Dec - 2024 26 - Dec - 2024 4750 GBP
Rome , Italy 22 - Dec - 2024 26 - Dec - 2024 7300 GBP
Barcelona , Spain 22 - Dec - 2024 26 - Dec - 2024 6950 GBP
Zurich , Switzerland 22 - Dec - 2024 26 - Dec - 2024 7950 GBP
Istanbul , Turkey 8 - Dec - 2024 12 - Dec - 2024 4700 GBP
Bali , Indonesia 8 - Dec - 2024 12 - Dec - 2024 8100 GBP
Singapore , Singapore 8 - Dec - 2024 12 - Dec - 2024 7500 GBP
Washington , United States 8 - Dec - 2024 12 - Dec - 2024 11000 GBP
London , UK 1 - Dec - 2024 5 - Dec - 2024 4950 GBP
Madrid , Spain 1 - Dec - 2024 5 - Dec - 2024 6950 GBP
Munich , Germany 1 - Dec - 2024 5 - Dec - 2024 7900 GBP
Berlin , Germany 1 - Dec - 2024 5 - Dec - 2024 7900 GBP
New York , United States 1 - Dec - 2024 5 - Dec - 2024 10900 GBP
Amsterdam , Netherlands 1 - Dec - 2024 5 - Dec - 2024 8100 GBP
Tokyo , Japan 15 - Dec - 2024 19 - Dec - 2024 9750 GBP
Milan , Italy 1 - Dec - 2024 5 - Dec - 2024 6950 GBP

Course Syllabus

Introduction:

This course is designed to develop your financial modeling skills through the evaluation and analysis of real-life case studies. It will also develop your knowledge and understanding of finance enabling you to make financial decisions, which will reduce costs, increase profit and minimize risk.

The course will examine the latest tools and techniques modeling risk management and performance of oil & gas projects using sensitivity and scenario analysis, simulating world events, such as oil price volatility.

This course will feature:

  • Practical application of financial modeling skills to real life case studies in the Oil & Gas sector and your company
  • Development of finance knowledge and its application to business problems and decision-making
  • The development of Financial Models which will be of practical use to you and your organization
  • Excel and the latest financial analysis tools and techniques

Objectives

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

  • Identify & make improved financial decisions
  • Develop financial models
  • Apply the latest tools and techniques to analyse financial data
  • Manage financial risk using financial models
  • Evaluate the performance of projects using financial models

The Contents:

Foundations of Finance

  • Financial & Management Accounting
  • Developing Financial Statements – Income Statement, Balance Sheet (Statement of Financial Position) & Cash flow Statements
  • Financial Performance using Ratio Analysis
  • Management Accounting – developing budgets
  • OPEX & CAPEX
  • Financial Terminology Explained

Foundation of Modeling

  • Basic Excel functions
  • Steps to develop a Financial Model
  • Flow charting Techniques to improve Modeling
  • Input Tables
  • Pivot Tables
  • Foundation Analysis Tools in Excel

Financial Modeling

  • Forecasting the Income Statement, Balance Sheet (Statement of Financial Position) & Cash flow Statements
  • Budgeting Models
  • Purchase Decisions
  • Modeling Finance Decisions – Equity or Debt and the Cost of Capital
  • Capital Investment Decisions – Payback, ARR, NPV & IRR using Excel
  • Graphs & Charts to support financial models

Modeling Risk Management Scenarios

  • Identifying the major Risks in the Oil & Gas sector
  • Modeling Risk & Uncertainty
  • Sensitivity Analysis
  • Scenario Analysis
  • Break Even Analysis
  • Modeling & Managing changes in Interest Rates & Exchange Rates

Modeling the Financial Performance of Oil & Gas Projects

  • Variance Analysis
  • Critical Path Analysis – Financial & Manpower implications
  • GANTT Charts
  • Earned Value Analysis
  • Managing Variances
  • Simulating changes in the project

Related Courses

FBA171

Risk Based Internal Auditing Course

Learn risk-based internal auditing techniques. Join this course to develop skills in identifying and assessing risks, performing internal audits, and enhancing organizational governance.
FBA117

Financial Accounting, Reporting and Business Support in the Oil and Gas Industry Course

Acquire skills in financial accounting and reporting, focused on the oil and gas industry, with our specialized training course.
FBA137

Financial Analysis Workshop - A Hands-On Approach Course

Equip yourself with hands-on financial analysis skills to make informed business decisions with our interactive training course.
FBA123

Budgeting, Planning and Management Reporting Course

Master the art of budgeting, planning, and management reporting with our specialized training course.
FBA109

Accounting, Decision Making, and Financial Communication Course

Master accounting practices, decision-making skills, and financial communication with our specialized training course.
FBA153

Payroll - Preparation, Analysis and Management Course

Learn the essentials of payroll preparation, analysis, and management to optimize employee compensation and benefits.

Available Cities