Global Learning for Operational Leaders
Classroom
19 sessions
Scroll for more
Online / Live
19 sessions
Scroll for more
Introduction
Course overview
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.
What you will achieve
Learning 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
Who should attend
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
Methodology
Learning approach
- 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 content
Five focused days of learning and application
Day 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
Day 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
Day 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
Day 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
Day 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
FAQ
Frequently asked questions
What does Foundations of Financial Modeling (AF-009) cover?
This course covers Accounting and Finance through a structured five-day outline focused on practical application, discussion, and implementation planning.
When is the next available session?
The next scheduled session starts on 5 - 9 October 2026, with additional classroom dates and mirrored Online / Live options listed in the course schedules section.
Who should attend this course?
Finance Professionals, Accountants, Financial Analysts
Is bilingual course delivery available?
Yes. All course materials and presentations are provided in English, while bilingual explanation and discussion support may be available depending on the selected location and trainer availability. For example, when attending a course in Istanbul, you may request a Turkish-speaking trainer to explain the English course content in Turkish. Arabic explanation support may also be requested at this location. Other languages are available in selected cities. You can choose your preferred language support as an optional preference during registration.
How can I register for a session?
Use any Register button next to the available course dates to open the participant registration page and submit your booking request for the selected session.
Is this course available online as well as classroom-based?
Yes. The course detail page includes both classroom sessions and Online / Live sessions, with online options aligned to the same course dates for easier planning.
Where are classroom sessions delivered?
Current classroom venues include Paris, Istanbul, Amsterdam, London, Barcelona, Kuala lumpur, Munich.
How long is the training programme?
The programme runs for five days, with up to five training hours per day, from 9:00 AM to 2:00 PM. Each programme includes a total of 25 accredited training hours.
Quick request
Send quick request
Send a fast enquiry about this course and the academy team will get back to you.
Get a quotation
Request a formal quotation
Choose an available date and venue, add your participants, and we will email a formal quotation for Foundations of Financial Modeling to your business address.