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...
Classroom
16 sessions
Scroll for more
Online / Live
16 sessions
Scroll for more
Introduction
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
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 1 - 5 June 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
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 Istanbul, Amsterdam, Paris, Barcelona, Munich, Kuala lumpur, London.
Still Have Questions?
Contact the academy team for course details, delivery options, and delegate guidance.
Related training courses
Continue building your improvement capability
Quick request
Send quick request
Send a fast enquiry about this course and the academy team will get back to you.