Global Learning for Operational Leaders
Course AF-009
Foundations of Financial Modeling
The Foundations of Financial Modeling training course is designed to enhance participants’ analytical skills by combinin... The outline covers Foundations of Finance, Foundation of Modelling, Financial Modelling, and Mod...
- 5 daysClassroom or online
- 17Upcoming dates
- 8Cities
- €1,625Fees from
Classroom
17 sessions
Scroll for more
Online / Live
17 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
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.
Complete course outline
Five focused days of learning and application
The timings provided are estimates and may vary depending on the number of participants and the discussions taking place during the sessions. They are indicative only and do not constitute a binding commitment.
Day 1
Foundations of Finance
- Financial and management accounting
- Developing financial statements: income statement, balance sheet, and cashflow statements
- Financial performance using ratio analysis
- Coffee break
- Financial performance using ratio analysis (continued)
- 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
- Coffee break
- Flow charting techniques to improve modelling (continued)
- 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
- Coffee break
- Purchase decisions (continued)
- 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
- Coffee break
- Sensitivity analysis (continued)
- 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
- Coffee break
- GANTT charts (continued)
- Earned value analysis
- Managing variances
- Simulating changes in the project
Course FAQs
Questions about this course
What participants and training managers usually ask before booking Foundations of Financial Modeling. Can't find your answer?
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 9 - 13 November 2026. See the course schedules section for the available dates and delivery formats.
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?
Check the course schedules section for currently published classroom and Online / Live sessions.
Where are classroom sessions delivered?
Current classroom venues include Amsterdam, London, Barcelona, Kuala lumpur, Istanbul, Cape Town, Munich, Paris.
How long is the training programme?
The programme runs for five days from 09:00 to 14:00, which gives 25 contact hours, including a daily 30-minute break (22.5 hours of instruction).
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.