An Intensive Professional
Development Training Course on

Foundations of Financial Modeling

Sensitivities, Scenarios, Risk & Optimisation

Course Options

How would you like to proceed?

Need a tailored solution or group booking discount? Contact our course advisors.

Why Choose Us

The Foundations of Financial Modeling training course provides finance and project professionals with a structured, practical route from financial accounting principles to advanced Excel-based modelling. It develops capabilities relevant to financial models used in real project and investment settings. The course starts with financial statements, ratio analysis, budgets, OPEX, CAPEX and essential financial terminology. It then progresses to Excel fundamentals, flowcharting, pivot tables and the process of building a financial model from scratch.

Delegates learn to forecast income statements, balance sheets and cash flow statements, while also developing budgeting models and assessing purchase and finance decisions. Capital investment appraisal is performed in Excel using payback, ARR, NPV and IRR. Risk modelling includes sensitivity, scenario and break-even analysis, alongside interest rate and exchange rate modelling applied specifically to the oil and gas sector. The course concludes with project performance modelling through variance and critical path analysis, GANTT charts, earned value analysis and project simulation, providing end-to-end modelling capability.

This Foundations of Financial Modeling training course will highlight:

Interpreting financial statements, ratios, budgets, OPEX and CAPEX
Applying Excel fundamentals, flowcharting and pivot tables
Building financial models from scratch
Forecasting financial statements and developing budgeting models
Evaluating purchase, finance and capital investment decisions
Modelling risk and project performance in oil and gas contexts

Why Choose Foundations of Financial Modeling

Course Goals

What are the Goals?

This introductory financial modelling course aims to provide delegates with a practical command of financial accounting concepts, Excel modelling methods, financial forecasting, risk analysis, and project performance modelling, applied directly within oil and gas project settings.

Upon completing this course, delegates will be able to:

Produce and interpret financial statements: Create and assess income statements, balance sheets, and cash flow statements through ratio analysis and financial performance frameworks.
Use financial modelling fundamentals in Excel: Apply essential Excel functions, input tables, pivot tables, and flowcharting methods to organise and construct financial models.
Create financial forecasting models: Project financial statements, build budgeting models, and use Excel to model purchase, equity, debt, and capital investment decisions.
Use capital investment appraisal methods: Assess capital projects within Excel-based models using payback, ARR, NPV, and IRR.
Model uncertainty and risk: Use sensitivity analysis, scenario analysis, break-even analysis, and interest rate and exchange rate modelling in risk management scenarios.
Apply risk modelling within oil and gas: Recognise and model the principal risks and uncertainties associated with financial decisions in the oil and gas sector.
Model the financial performance of projects: Perform variance analysis, critical path analysis, earned value analysis, and project simulation with GANTT charts and Excel-based project models.

Who is this Training Course for?

This Foundations of Financial Modeling training course is designed for:

Financial Analysts
Financial Planning and Analysis Professionals
Corporate Finance Professionals
Management Accountants
Investment Analysts
Equity Research Analysts
Budget Analysts
Business Analysts
Commercial Analysts
Finance Managers

Learning Approach

How will this Training Course be Presented?

This foundational financial modelling course combines structured technical teaching with practical Excel modelling sessions at every stage, ensuring delegates develop genuine, transferable modelling skills alongside the financial and project management frameworks supporting each model.

Methods of delivery include:

Instructor-Led Technical Sessions: Expert facilitators take delegates through financial accounting principles, Excel fundamentals, financial forecasting, risk modelling, and project performance analysis using a structured and progressive sequence.
Excel Modelling Exercises: Throughout the course, delegates construct financial models directly in Excel, including input tables, pivot tables, forecasting models, capital appraisal tools, sensitivity analysis, and project performance models.
Financial Statement Modelling: Through structured modelling exercises reflecting real-world financial reporting and planning scenarios, delegates create and forecast income statements, balance sheets, and cash flow statements.
Risk Scenario Modelling Sessions: Dedicated sessions apply sensitivity analysis, scenario analysis, break-even analysis, and interest rate and exchange rate modelling within oil and gas risk environments.
Project Performance Modelling Workshops: Delegates gain applied experience in modelling complex project financial performance through variance analysis, critical path analysis, GANTT chart development, earned value analysis, and project simulation exercises.

The Course Content

Foundations of Finance

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

Foundation of Modelling

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

Financial Modelling

Forecasting the Income Statement, Balance Sheet (Statement of Financial Position) & Cashflow Statements
Budgeting Models
Purchase Decisions
Modelling 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

Modelling Risk Management Scenarios

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

Modelling 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

Recognition

Certificate

• Wallstreet Development Academy Certificate of Completion for delegates who attend and complete the training course.

Collaborations

In Partnership With

Frequently Asked Questions

This course introduces the foundations of financial modeling. Its stated focus includes sensitivities, scenarios, risk, and optimisation. These topics frame the course around examining financial models under different assumptions and conditions.

Sensitivity analysis is one of the course’s stated areas of focus. It is presented as part of the foundations of financial modeling alongside scenarios, risk, and optimisation. The supplied course information does not specify which sensitivity methods or variables are covered.

The course includes risk as a stated component of foundational financial modeling. It places risk alongside sensitivity analysis, scenarios, and optimisation. The available course content does not identify particular risk measures, frameworks, or modeling techniques.

The title presents this as a foundations course, indicating an emphasis on core financial modeling concepts. Its scope also includes sensitivities, scenarios, risk, and optimisation. The supplied information does not state a required experience level or define the course as beginner, intermediate, or advanced.

You will learn about foundational financial modeling concepts in the context of sensitivities, scenarios, risk, and optimisation. The course information does not provide a detailed list of learning objectives or techniques. Specific model types, formulas, and applications are therefore not stated.

Yes, scenarios are explicitly included in the course subtitle. They form part of the broader financial modeling foundation covered by the course. No specific scenario structures, examples, or industries are identified in the available information.

Optimisation is listed as one of the course’s core subject areas. It is addressed within the broader context of foundational financial modeling, together with sensitivities, scenarios, and risk. The course information does not specify the optimisation methods, objectives, or constraints that will be examined.

The available course information does not name any software, spreadsheet platform, or modeling tool. Only the subject focus—financial modeling foundations, sensitivities, scenarios, risk, and optimisation—is provided. Participants should not assume that a particular application is included based on the current description.