This session: 8–12 Feb 2027
This Advanced Financial Modeling: Building Dynamic Forecasts session in London (UK) runs from Monday 8 February to Friday 12 February 2027 (week 6, Q1 2027). It is the 1st of 2 dates in London (UK) in 2027, at a fee of 5,400 £, the same for each of them. Registration is open for this date. It is held in person.
| Dates | Monday 8 Feb – Friday 12 Feb 2027 |
|---|---|
| Week | 6 of 2027 |
| Duration | 5 days |
| Fee | 5,400 £ |
| 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