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
-
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
-
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
-
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
-
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
-
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.
No dates in this city right now. Request a quotation and we will suggest the nearest date.
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
Accounting Policies and Procedures
Next: 16 - 20 Nov 2026 · Istanbul
Istanbul, Vienna, Geneva +4 more
Accounts Payable: Accounting and Management Best Practices
Next: 16 - 20 Nov 2026 · Rome
Rome, Munich, Barcelona +2 more
Activity-Based Costing and Profitability Analysis
Next: 7 - 11 Dec 2026 · Frankfurt
Frankfurt, London, Barcelona +9 more