This session: 16–20 Nov 2026
This Advanced Financial Modeling: Building Dynamic Forecasts session in Lyon (France) runs from Monday 16 November to Friday 20 November 2026 (week 47, Q4 2026). It is the only date in Lyon (France) in 2026, at a fee of 5,200 £. Registration is open for this date. It is held in person.
| Dates | Monday 16 Nov – Friday 20 Nov 2026 |
|---|---|
| Week | 47 of 2026 |
| Duration | 5 days |
| Fee | 5,200 £ |
| Status | Open for registration |
| Format | In person |
Course Overview
Course Description
This intensive 1-week course equips finance professionals with advanced Excel skills to build sophisticated financial models. Participants will learn to construct dynamic, flexible 3-statement models, perform valuations, and conduct scenario analysis. The course emphasizes best practices in model design, formula efficiency, and error-checking techniques.
Learning Objectives
- Construct a fully integrated 3-statement financial model from scratch
- Apply advanced Excel functions and formulas for efficient modeling
- Perform sensitivity analysis and create dynamic scenarios
- Build valuation models including DCF and comparable company analysis
- Implement best practices in model design, documentation, and error-checking
Course Modules
Day 1: Foundations of Financial Modeling
- Excel best practices for financial modeling
- Building the income statement
- Forecasting techniques and driver-based projections
- Modeling operating expenses and margins
Day 2: Balance Sheet and Cash Flow Modeling
- Constructing the balance sheet
- Working capital projections
- Building the cash flow statement
- Balancing the model and error-checking
Day 3: Advanced Modeling Techniques
- Debt schedules and interest calculations
- Circular references and iteration
- Scenario and sensitivity analysis
- Data tables and goal seek
Day 4: Valuation Modeling
- Discounted Cash Flow (DCF) analysis
- Weighted Average Cost of Capital (WACC)
- Comparable company analysis
- Building summary dashboards
Day 5: Model Application and Best Practices
- Mergers and Acquisitions (M&A) modeling
- Leveraged Buyout (LBO) modeling basics
- Model audit techniques and error-checking
- Presenting model results effectively
Practical Wins for Participants
- Build a fully functional 3-statement model from scratch
- Create flexible, dynamic models for scenario analysis
- Construct a DCF valuation model for investment decisions
- Implement best practices for efficient, error-free modeling
Have Questions About This Event?
We understand that choosing the right training program is an important decision. Our comprehensive FAQ section provides answers to the most common questions about our courses, registration process, certification, payment options, and more.
- Course Information - Duration, format, and requirements
- Registration & Payment - Easy booking and flexible payment options
- Certification - Internationally recognized credentials
- Support Services - Training materials and post-course assistance
Register Your Interest
Fill out the form below and our team will get back to you shortly