Professional training in London and 13 international cities info@llmi.uk

Professional training course · AF-009

Foundations of Financial Modeling

The Foundations of Financial Modeling training course is designed to enhance participants’ analytical skills by combining essential financial knowledge with practical…

  • 5 daysClassroom
  • 16Upcoming dates
  • 8Cities
  • £2,250Fees from

Course overview

Why Attend
The Foundations of Financial Modeling training course is designed to enhance participants’ analytical skills by combining essential financial knowledge with practical modeling methods. In today’s fast-changing business environment, professionals need the ability to analyze financial data accurately and build models that support sound planning and decision-making. This course provides a practical and structured introduction to financial modeling, helping participants understand how effective models are designed, organized, and applied.

Using realistic case studies, including examples from the oil and gas industry, participants will learn how to create and interpret models that improve budgeting, cost control, profitability measurement, and risk evaluation. The program also covers forecasting techniques, sensitivity testing, and scenario analysis to help participants respond confidently to changing market conditions such as price volatility and operational uncertainty. By the end of the course, participants will be able to develop financial models that support stronger business performance and better strategic decisions.

Course Methodology
This course uses an interactive and practical approach through presentations, Excel-based workshops, financial exercises, case studies, group discussions, modeling practice, and real workplace examples.

Course Objectives

  • Understand core finance and accounting concepts
  • Build structured financial models using Excel
  • Forecast financial statements and budgets
  • Evaluate financing and investment decisions
  • Apply sensitivity and scenario analysis
  • Model risks and uncertainty effectively
  • Analyze project performance using financial tools
  • Improve decision-making through practical modeling techniques

Target Audience

  • Finance Professionals
  • Accountants
  • Financial Analysts
  • Budget Analysts
  • Project Finance Staff
  • Oil & Gas Professionals involved in finance
  • Anyone seeking practical financial modeling skills

Target Competencies

  • Financial Modeling
  • Excel Analysis
  • Forecasting
  • Budgeting
  • Investment Appraisal
  • Risk Analysis
  • Performance Measurement
  • Decision-Making


Course outline

  1. 1Day 1: Foundations of Finance
    • Financial and management accounting
    • Developing financial statements: income statement, balance sheet, and cashflow statements
    • Financial performance using ratio analysis
    • Management accounting and developing budgets
    • Financial terminology explained
    • Linking finance concepts to business decisions
  2. 2Day 2: 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
  3. 3Day 3: Financial Modelling
    • Forecasting the income statement, balance sheet, and cashflow statements
    • Budgeting models
    • Purchase decisions
    • Modelling finance decisions: equity or debt and cost of capital
    • Capital investment decisions: payback, ARR, NPV and IRR using Excel
    • Graphs and charts to support financial models
  4. 4Day 4: Modelling Risk Management Scenarios
    • Identifying the major risks in the Oil & Gas sector
    • Modelling risk and uncertainty
    • Sensitivity analysis
    • Scenario analysis
    • Break-even analysis
    • Modelling and managing changes in interest rates and exchange rates
  5. 5Day 5: Modelling the Financial Performance of Oil & Gas Projects
    • Variance analysis
    • Critical path analysis: financial and manpower implications
    • GANTT charts
    • Earned value analysis
    • Managing variances
    • Simulating changes in the project

Schedule

Dates and fees

16 upcoming dates in 8 cities. Fees are per delegate; bring colleagues and every seat is discounted.

All dates as PDF
November 2026
16NOV 16 - 20 Nov 2026Mon to Fri · 5 daysNext sessionOur home city
United Kingdom flag LondonUnited Kingdom · Classroom
£3,850per delegate2+ people: £3,080 each
December 2026
7DEC 7 - 11 Dec 2026Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£4,250per delegate2+ people: £3,400 each
14DEC 14 - 18 Dec 2026Mon to Fri · 5 days
Malaysia flag Kuala LumpurMalaysia · Classroom
£2,850per delegate2+ people: £2,280 each
21DEC 21 - 25 Dec 2026Mon to Fri · 5 days
Turkey flag IstanbulTurkey · Classroom
£3,850per delegate2+ people: £3,080 each
January 2027
4JAN 4 - 8 Jan 2027Mon to Fri · 5 days
Turkey flag IstanbulTurkey · Classroom
£2,850per delegate2+ people: £2,280 each
February 2027
1FEB 1 - 5 Feb 2027Mon to Fri · 5 days
Netherlands flag AmsterdamNetherlands · Classroom
£4,250per delegate2+ people: £3,400 each
March 2027
1MAR 1 - 5 Mar 2027Mon to Fri · 5 days
Turkey flag IstanbulTurkey · Classroom
£2,850per delegate2+ people: £2,280 each
April 2027
5APR 5 - 9 Apr 2027Mon to Fri · 5 days
South Africa flag Cape TownSouth Africa · Classroom
£2,840per delegate2+ people: £2,272 each
May 2027
3MAY 3 - 7 May 2027Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
June 2027
7JUN 7 - 11 Jun 2027Mon to Fri · 5 days
Germany flag MunichGermany · Classroom
£4,250per delegate2+ people: £3,400 each
July 2027
5JUL 5 - 9 Jul 2027Mon to Fri · 5 days
Malaysia flag Kuala LumpurMalaysia · Classroom
£2,250per delegate2+ people: £1,800 each
August 2027
2AUG 2 - 6 Aug 2027Mon to Fri · 5 days
Netherlands flag AmsterdamNetherlands · Classroom
£4,250per delegate2+ people: £3,400 each
September 2027
6SEP 6 - 10 Sep 2027Mon to Fri · 5 daysOur home city
United Kingdom flag LondonUnited Kingdom · Classroom
£4,200per delegate2+ people: £3,360 each
October 2027
4OCT 4 - 8 Oct 2027Mon to Fri · 5 days
France flag ParisFrance · Classroom
£4,500per delegate2+ people: £3,600 each
November 2027
1NOV 1 - 5 Nov 2027Mon to Fri · 5 days
Turkey flag IstanbulTurkey · Classroom
£2,850per delegate2+ people: £2,280 each
December 2027
6DEC 6 - 10 Dec 2027Mon to Fri · 5 days
Netherlands flag AmsterdamNetherlands · Classroom
£4,250per delegate2+ people: £3,400 each

Questions

Frequently asked questions

How long is the Foundations of Financial Modeling course?

The course runs over 5 days of classroom training, usually Monday to Friday.

When is the next Foundations of Financial Modeling course?

The next public date is 16 - 20 Nov 2026 in London. There are 16 upcoming dates in total.

Where is this course held?

Upcoming sessions run in London, Barcelona, Kuala Lumpur, Istanbul, Amsterdam, Cape Town, Munich, Paris.

How much does the course cost?

Fees start from £2,250 per delegate, depending on the city. Fees include tuition and course materials.

Do participants receive a certificate?

Yes. Delegates who complete the course receive a London Leadership Management Innovation certificate of completion.

Can this course be delivered in-house for our team?

Yes. LLMI can tailor and deliver this course privately for your organisation at your premises or in one of our training cities.

Course information last updated 14 November 2026.

Related

More Accounting and Finance courses

View all

Training a team?

Any course in our catalogue can be delivered privately for your organisation, at your offices or in one of our cities, with content shaped around your goals.