Course Info

Length: 1 Week

Type: In Classroom

Available Dates

Venue

  • Oct-21-2024

    Amsterdam

  • Oct-21-2024

    London

  • Oct-28-2024

    Barcelona

  • Oct-28-2024

    Dubai

  • Nov-04-2024

    Kuala Lumpur

  • Nov-04-2024

    Singapore

  • Nov-04-2024

    Paris

  • Nov-04-2024

    Istanbul

  • Nov-18-2024

    London

  • Nov-18-2024

    Amsterdam

  • Nov-25-2024

    Dubai

  • Nov-25-2024

    Barcelona

  • Dec-02-2024

    Istanbul

  • Dec-02-2024

    Kuala Lumpur

  • Dec-09-2024

    Singapore

  • Dec-09-2024

    Paris

  • Dec-16-2024

    London

  • Dec-16-2024

    Amsterdam

  • Dec-23-2024

    Dubai

  • Dec-23-2024

    Kuala Lumpur

  • Dec-30-2024

    Istanbul

  • Dec-30-2024

    Barcelona

  • Jan-06-2025

    Dubai

  • Jan-06-2025

    Barcelona

  • Jan-13-2025

    Kuala Lumpur

  • Jan-13-2025

    Istanbul

  • Jan-20-2025

    Paris

  • Jan-20-2025

    Singapore

  • Jan-27-2025

    Amsterdam

  • Jan-27-2025

    London

  • Feb-03-2025

    Dubai

  • Feb-03-2025

    Barcelona

  • Feb-10-2025

    Kuala Lumpur

  • Feb-10-2025

    Istanbul

  • Feb-17-2025

    Paris

  • Feb-17-2025

    Singapore

  • Feb-24-2025

    London

  • Feb-24-2025

    Amsterdam

  • Mar-03-2025

    Barcelona

  • Mar-03-2025

    Dubai

  • Mar-10-2025

    Istanbul

  • Mar-10-2025

    Kuala Lumpur

  • Mar-17-2025

    Paris

  • Mar-17-2025

    Singapore

  • Mar-24-2025

    Amsterdam

  • Mar-24-2025

    London

  • Apr-07-2025

    Dubai

  • Apr-07-2025

    Barcelona

  • Apr-14-2025

    Istanbul

  • Apr-14-2025

    Kuala Lumpur

  • Apr-21-2025

    Paris

  • Apr-21-2025

    Singapore

  • Apr-28-2025

    Amsterdam

  • Apr-28-2025

    London

  • May-05-2025

    Dubai

  • May-05-2025

    Barcelona

  • May-12-2025

    Istanbul

  • May-12-2025

    Kuala Lumpur

  • May-19-2025

    Paris

  • May-19-2025

    Singapore

  • May-26-2025

    Amsterdam

  • May-26-2025

    London

  • June-02-2025

    Barcelona

  • June-02-2025

    Dubai

  • June-09-2025

    Kuala Lumpur

  • June-09-2025

    Istanbul

  • June-16-2025

    Paris

  • June-16-2025

    Singapore

  • June-23-2025

    Amsterdam

  • June-30-2025

    London

  • June-30-2025

    Barcelona

  • June-30-2025

    Dubai

  • July-07-2025

    Dubai

  • July-07-2025

    Barcelona

  • July-14-2025

    Istanbul

  • July-14-2025

    Kuala Lumpur

  • July-21-2025

    Singapore

  • July-21-2025

    Paris

  • July-28-2025

    London

  • July-28-2025

    Amsterdam

  • Aug-04-2025

    Dubai

  • Aug-04-2025

    Barcelona

  • Aug-11-2025

    Istanbul

  • Aug-11-2025

    Kuala Lumpur

  • Aug-18-2025

    Singapore

  • Aug-18-2025

    Paris

  • Aug-25-2025

    London

  • Aug-25-2025

    Amsterdam

  • Sep-01-2025

    Barcelona

  • Sep-01-2025

    Dubai

  • Sep-08-2025

    Kuala Lumpur

  • Sep-08-2025

    Istanbul

  • Sep-15-2025

    Singapore

  • Sep-15-2025

    Paris

  • Sep-22-2025

    Amsterdam

  • Sep-29-2025

    Barcelona

  • Sep-29-2025

    Dubai

  • Sep-29-2025

    London

  • Oct-06-2025

    Dubai

  • Oct-06-2025

    Barcelona

  • Oct-13-2025

    Kuala Lumpur

  • Oct-13-2025

    Istanbul

  • Oct-20-2025

    Singapore

  • Oct-20-2025

    Paris

  • Oct-27-2025

    London

  • Oct-27-2025

    Amsterdam

  • Nov-03-2025

    Barcelona

  • Nov-03-2025

    Dubai

  • Nov-10-2025

    Istanbul

  • Nov-10-2025

    Kuala Lumpur

  • Nov-17-2025

    Paris

  • Nov-17-2025

    Singapore

  • Nov-24-2025

    London

  • Nov-24-2025

    Amsterdam

  • Dec-01-2025

    Dubai

  • Dec-01-2025

    Barcelona

  • 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

  • Dec-29-2025

    Barcelona

Course Details

Course Outline

5 days course

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.