/  Foundations of Financial Modeling Training

Foundations of Financial Modeling Training

BMC Training provides a training course in Foundations of Financial Modeling in Finance , Accounting and Budgeting

Course Title
Venue
Start Date
End Date
  • Dubai
    27 - 1 - 2019
    31 - 1 - 2019
  • Paris
    27 - 1 - 2019
    31 - 1 - 2019
  • Hong Kong
    27 - 1 - 2019
    31 - 1 - 2019
  • London
    20 - 1 - 2019
    24 - 1 - 2019
  • Madrid
    20 - 1 - 2019
    24 - 1 - 2019
  • Munich
    20 - 1 - 2019
    24 - 1 - 2019
  • Berlin
    20 - 1 - 2019
    24 - 1 - 2019
  • New York
    20 - 1 - 2019
    24 - 1 - 2019
  • Kuala Lumpur
    13 - 1 - 2019
    17 - 1 - 2019
  • Rome
    13 - 1 - 2019
    17 - 1 - 2019
  • Rome
    13 - 1 - 2019
    17 - 1 - 2019
  • Barcelona
    13 - 1 - 2019
    17 - 1 - 2019
  • Zurich
    13 - 1 - 2019
    17 - 1 - 2019
  • Istanbul
    6 - 1 - 2019
    10 - 1 - 2019
  • Bali
    6 - 1 - 2019
    10 - 1 - 2019
  • Singapore
    6 - 1 - 2019
    10 - 1 - 2019
  • Washington
    6 - 1 - 2019
    10 - 1 - 2019
  • Dubai
    24 - 2 - 2019
    28 - 2 - 2019
  • Paris
    24 - 2 - 2019
    28 - 2 - 2019
  • Hong Kong
    24 - 2 - 2019
    28 - 2 - 2019
  • Kuala Lumpur
    17 - 2 - 2019
    21 - 2 - 2019
  • Rome
    17 - 2 - 2019
    21 - 2 - 2019
  • Rome
    17 - 2 - 2019
    21 - 2 - 2019
  • Barcelona
    17 - 2 - 2019
    21 - 2 - 2019
  • Zurich
    17 - 2 - 2019
    21 - 2 - 2019
  • Istanbul
    10 - 2 - 2019
    14 - 2 - 2019
  • Bali
    10 - 2 - 2019
    14 - 2 - 2019
  • Singapore
    10 - 2 - 2019
    14 - 2 - 2019
  • Washington
    10 - 2 - 2019
    14 - 2 - 2019
  • London
    3 - 2 - 2019
    7 - 2 - 2019
  • Madrid
    3 - 2 - 2019
    7 - 2 - 2019
  • Munich
    3 - 2 - 2019
    7 - 2 - 2019
  • Berlin
    3 - 2 - 2019
    7 - 2 - 2019
  • New York
    3 - 2 - 2019
    7 - 2 - 2019
  • Dubai
    17 - 3 - 2019
    21 - 3 - 2019
  • Paris
    17 - 3 - 2019
    21 - 3 - 2019
  • Hong Kong
    17 - 3 - 2019
    21 - 3 - 2019
  • London
    10 - 3 - 2019
    14 - 3 - 2019
  • Madrid
    10 - 3 - 2019
    14 - 3 - 2019
  • Munich
    10 - 3 - 2019
    14 - 3 - 2019
  • Berlin
    10 - 3 - 2019
    14 - 3 - 2019
  • New York
    10 - 3 - 2019
    14 - 3 - 2019
  • Kuala Lumpur
    3 - 3 - 2019
    7 - 3 - 2019
  • Rome
    3 - 3 - 2019
    7 - 3 - 2019
  • Rome
    3 - 3 - 2019
    7 - 3 - 2019
  • Barcelona
    3 - 3 - 2019
    7 - 3 - 2019
  • Zurich
    3 - 3 - 2019
    7 - 3 - 2019
  • Istanbul
    24 - 3 - 2019
    28 - 3 - 2019
  • Bali
    24 - 3 - 2019
    28 - 3 - 2019
  • Singapore
    24 - 3 - 2019
    28 - 3 - 2019
  • Washington
    24 - 3 - 2019
    28 - 3 - 2019
  • Dubai
    28 - 4 - 2019
    2 - 5 - 2019
  • Paris
    28 - 4 - 2019
    2 - 5 - 2019
  • Hong Kong
    28 - 4 - 2019
    2 - 5 - 2019
  • Kuala Lumpur
    7 - 4 - 2019
    11 - 4 - 2019
  • Rome
    7 - 4 - 2019
    11 - 4 - 2019
  • Rome
    7 - 4 - 2019
    11 - 4 - 2019
  • Barcelona
    7 - 4 - 2019
    11 - 4 - 2019
  • Zurich
    7 - 4 - 2019
    11 - 4 - 2019
  • Istanbul
    14 - 4 - 2019
    18 - 4 - 2019
  • Bali
    14 - 4 - 2019
    18 - 4 - 2019
  • Singapore
    14 - 4 - 2019
    18 - 4 - 2019
  • Washington
    14 - 4 - 2019
    18 - 4 - 2019
  • London
    21 - 4 - 2019
    25 - 4 - 2019
  • Madrid
    21 - 4 - 2019
    25 - 4 - 2019
  • Munich
    21 - 4 - 2019
    25 - 4 - 2019
  • Berlin
    21 - 4 - 2019
    25 - 4 - 2019
  • New York
    21 - 4 - 2019
    25 - 4 - 2019
  • Dubai
    12 - 5 - 2019
    16 - 5 - 2019
  • Paris
    12 - 5 - 2019
    16 - 5 - 2019
  • Hong Kong
    12 - 5 - 2019
    16 - 5 - 2019
  • London
    5 - 5 - 2019
    9 - 5 - 2019
  • Madrid
    5 - 5 - 2019
    9 - 5 - 2019
  • Munich
    5 - 5 - 2019
    9 - 5 - 2019
  • Berlin
    5 - 5 - 2019
    9 - 5 - 2019
  • New York
    5 - 5 - 2019
    9 - 5 - 2019
  • Kuala Lumpur
    19 - 5 - 2019
    23 - 5 - 2019
  • Rome
    19 - 5 - 2019
    23 - 5 - 2019
  • Rome
    19 - 5 - 2019
    23 - 5 - 2019
  • Barcelona
    19 - 5 - 2019
    23 - 5 - 2019
  • Zurich
    19 - 5 - 2019
    23 - 5 - 2019
  • Istanbul
    26 - 5 - 2019
    30 - 5 - 2019
  • Bali
    26 - 5 - 2019
    30 - 5 - 2019
  • Singapore
    26 - 5 - 2019
    30 - 5 - 2019
  • Washington
    26 - 5 - 2019
    30 - 5 - 2019
  • Dubai
    9 - 6 - 2019
    13 - 6 - 2019
  • Paris
    9 - 6 - 2019
    13 - 6 - 2019
  • Hong Kong
    9 - 6 - 2019
    13 - 6 - 2019
  • Kuala Lumpur
    16 - 6 - 2019
    20 - 6 - 2019
  • Rome
    16 - 6 - 2019
    20 - 6 - 2019
  • Rome
    16 - 6 - 2019
    20 - 6 - 2019
  • Barcelona
    16 - 6 - 2019
    20 - 6 - 2019
  • Zurich
    16 - 6 - 2019
    20 - 6 - 2019
  • Istanbul
    23 - 6 - 2019
    27 - 6 - 2019
  • Bali
    23 - 6 - 2019
    27 - 6 - 2019
  • Singapore
    23 - 6 - 2019
    27 - 6 - 2019
  • Washington
    23 - 6 - 2019
    27 - 6 - 2019
  • London
    2 - 6 - 2019
    6 - 6 - 2019
  • Madrid
    2 - 6 - 2019
    6 - 6 - 2019
  • Munich
    2 - 6 - 2019
    6 - 6 - 2019
  • Berlin
    2 - 6 - 2019
    6 - 6 - 2019
  • New York
    2 - 6 - 2019
    6 - 6 - 2019
  • Dubai
    7 - 7 - 2019
    11 - 7 - 2019
  • Paris
    7 - 7 - 2019
    11 - 7 - 2019
  • Hong Kong
    7 - 7 - 2019
    11 - 7 - 2019
  • London
    14 - 7 - 2019
    18 - 7 - 2019
  • Madrid
    14 - 7 - 2019
    18 - 7 - 2019
  • Munich
    14 - 7 - 2019
    18 - 7 - 2019
  • Berlin
    14 - 7 - 2019
    18 - 7 - 2019
  • New York
    14 - 7 - 2019
    18 - 7 - 2019
  • London
    21 - 7 - 2019
    25 - 7 - 2019
  • Madrid
    21 - 7 - 2019
    25 - 7 - 2019
  • Munich
    21 - 7 - 2019
    25 - 7 - 2019
  • Berlin
    21 - 7 - 2019
    25 - 7 - 2019
  • New York
    21 - 7 - 2019
    25 - 7 - 2019
  • Istanbul
    28 - 7 - 2019
    1 - 8 - 2019
  • Bali
    28 - 7 - 2019
    1 - 8 - 2019
  • Singapore
    28 - 7 - 2019
    1 - 8 - 2019
  • Washington
    28 - 7 - 2019
    1 - 8 - 2019
  • Dubai
    4 - 8 - 2019
    8 - 8 - 2019
  • Paris
    4 - 8 - 2019
    8 - 8 - 2019
  • Hong Kong
    4 - 8 - 2019
    8 - 8 - 2019
  • Kuala Lumpur
    11 - 8 - 2019
    15 - 8 - 2019
  • Rome
    11 - 8 - 2019
    15 - 8 - 2019
  • Rome
    11 - 8 - 2019
    15 - 8 - 2019
  • Barcelona
    11 - 8 - 2019
    15 - 8 - 2019
  • Zurich
    11 - 8 - 2019
    15 - 8 - 2019
  • Istanbul
    18 - 8 - 2019
    22 - 8 - 2019
  • Bali
    18 - 8 - 2019
    22 - 8 - 2019
  • Singapore
    18 - 8 - 2019
    22 - 8 - 2019
  • Washington
    18 - 8 - 2019
    22 - 8 - 2019
  • London
    25 - 8 - 2019
    29 - 8 - 2019
  • Madrid
    25 - 8 - 2019
    29 - 8 - 2019
  • Munich
    25 - 8 - 2019
    29 - 8 - 2019
  • Berlin
    25 - 8 - 2019
    29 - 8 - 2019
  • New York
    25 - 8 - 2019
    29 - 8 - 2019
  • Dubai
    22 - 9 - 2019
    26 - 9 - 2019
  • Paris
    22 - 9 - 2019
    26 - 9 - 2019
  • Hong Kong
    22 - 9 - 2019
    26 - 9 - 2019
  • London
    1 - 9 - 2019
    5 - 9 - 2019
  • Madrid
    1 - 9 - 2019
    5 - 9 - 2019
  • Munich
    1 - 9 - 2019
    5 - 9 - 2019
  • Berlin
    1 - 9 - 2019
    5 - 9 - 2019
  • New York
    1 - 9 - 2019
    5 - 9 - 2019
  • Kuala Lumpur
    8 - 9 - 2019
    12 - 9 - 2019
  • Rome
    8 - 9 - 2019
    12 - 9 - 2019
  • Rome
    8 - 9 - 2019
    12 - 9 - 2019
  • Barcelona
    8 - 9 - 2019
    12 - 9 - 2019
  • Zurich
    8 - 9 - 2019
    12 - 9 - 2019
  • Istanbul
    15 - 9 - 2019
    19 - 9 - 2019
  • Bali
    15 - 9 - 2019
    19 - 9 - 2019
  • Singapore
    15 - 9 - 2019
    19 - 9 - 2019
  • Washington
    15 - 9 - 2019
    19 - 9 - 2019
  • Dubai
    20 - 10 - 2019
    24 - 10 - 2019
  • Paris
    20 - 10 - 2019
    24 - 10 - 2019
  • Hong Kong
    20 - 10 - 2019
    24 - 10 - 2019
  • Kuala Lumpur
    27 - 10 - 2019
    31 - 10 - 2019
  • Rome
    27 - 10 - 2019
    31 - 10 - 2019
  • Rome
    27 - 10 - 2019
    31 - 10 - 2019
  • Barcelona
    27 - 10 - 2019
    31 - 10 - 2019
  • Zurich
    27 - 10 - 2019
    31 - 10 - 2019
  • Istanbul
    6 - 10 - 2019
    10 - 10 - 2019
  • Bali
    6 - 10 - 2019
    10 - 10 - 2019
  • Singapore
    6 - 10 - 2019
    10 - 10 - 2019
  • Washington
    6 - 10 - 2019
    10 - 10 - 2019
  • London
    13 - 10 - 2019
    17 - 10 - 2019
  • Madrid
    13 - 10 - 2019
    17 - 10 - 2019
  • Munich
    13 - 10 - 2019
    17 - 10 - 2019
  • Berlin
    13 - 10 - 2019
    17 - 10 - 2019
  • New York
    13 - 10 - 2019
    17 - 10 - 2019
  • Dubai
    17 - 11 - 2019
    21 - 11 - 2019
  • Paris
    17 - 11 - 2019
    21 - 11 - 2019
  • Hong Kong
    17 - 11 - 2019
    21 - 11 - 2019
  • London
    24 - 11 - 2019
    28 - 11 - 2019
  • Madrid
    24 - 11 - 2019
    28 - 11 - 2019
  • Munich
    24 - 11 - 2019
    28 - 11 - 2019
  • Berlin
    24 - 11 - 2019
    28 - 11 - 2019
  • New York
    24 - 11 - 2019
    28 - 11 - 2019
  • Kuala Lumpur
    3 - 11 - 2019
    7 - 11 - 2019
  • Rome
    3 - 11 - 2019
    7 - 11 - 2019
  • Rome
    3 - 11 - 2019
    7 - 11 - 2019
  • Barcelona
    3 - 11 - 2019
    7 - 11 - 2019
  • Zurich
    3 - 11 - 2019
    7 - 11 - 2019
  • Istanbul
    10 - 11 - 2019
    14 - 11 - 2019
  • Bali
    10 - 11 - 2019
    14 - 11 - 2019
  • Singapore
    10 - 11 - 2019
    14 - 11 - 2019
  • Washington
    10 - 11 - 2019
    14 - 11 - 2019
  • Dubai
    15 - 12 - 2019
    19 - 12 - 2019
  • Paris
    15 - 12 - 2019
    19 - 12 - 2019
  • Hong Kong
    15 - 12 - 2019
    19 - 12 - 2019
  • Kuala Lumpur
    22 - 12 - 2019
    26 - 12 - 2019
  • Rome
    22 - 12 - 2019
    26 - 12 - 2019
  • Rome
    22 - 12 - 2019
    26 - 12 - 2019
  • Barcelona
    22 - 12 - 2019
    26 - 12 - 2019
  • Zurich
    22 - 12 - 2019
    26 - 12 - 2019
  • Istanbul
    8 - 12 - 2019
    12 - 12 - 2019
  • Bali
    8 - 12 - 2019
    12 - 12 - 2019
  • Singapore
    8 - 12 - 2019
    12 - 12 - 2019
  • Washington
    8 - 12 - 2019
    12 - 12 - 2019
  • London
    1 - 12 - 2019
    5 - 12 - 2019
  • Madrid
    1 - 12 - 2019
    5 - 12 - 2019
  • Munich
    1 - 12 - 2019
    5 - 12 - 2019
  • Berlin
    1 - 12 - 2019
    5 - 12 - 2019
  • New York
    1 - 12 - 2019
    5 - 12 - 2019

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

Courses Search

Recent Posts

Connect with us

IFRS Preparation. (5 Days)Available in London - Dubai - Istanbul - Kuala Lumpur

Join our Civil and Construction Engineering Training Courses , Electrical and Power Engineering Training Courses and Facilities Management Training

Technical Training Courses

Newsletter