Financial Modelling - Comprehensive
Why should you attend this course?
- Practical skills: you will learn to build sustainable and flexible financial models according to best practice.
- Working with real data: you will create forecasts and models based on real data.
- Expert support: step-by-step workshops led by an experienced tutor.
- Comprehensive approach: building forecasts, DCF valuation and scenario analyses in one course.
Language of the course
English
Training level
intermediate
Who is this course for?
- For those who create financial models as part of their professional work.
- For those who interpret and evaluate financial models.
- For those responsible for checking and verifying the accuracy of financial models.
- The course is suitable for both those with an accounting background and those without formal training in the field. Basic accounting knowledge and familiarity with terminology will be helpful but is not an absolute requirement.
Course programme
- Financial modelling “Golden Rules”: Best practice DOs and DON’Ts
- Model set-up: model planning; worksheet grouping; date Functionality
- Historic data:cleaning up the numbers
- Integrating the statements
- Balancing the balance sheet
- Forecasting techniques: pros and cons
- Forecasting the numbers and populating the financial statements
- Valuation: enterprise vs equity value; discounted cash flow valuation; weighted average cost of capital (WACC); terminal value
- Scenario analysis
- Sensitivity analysis
- Rolling forward the forecast
„Training delivered in an understandable manner and at the right pace.”
From a feedback form on tailored training provided in 2024.5,57/6
Average evaluation of tutors and training materials among participants of workshops for companies organized in 2023-2024.„The presenter was very good, gave good examples and was very communicative. He is able to explain everything in a simple way.”
From a feedback form on tailored training provided in 2023.97%
of all participants of the 2023-2024 tailored workshops for companies would recommend our training to their friends!
Open courses
Our open courses are short courses taught by experienced tutors whose role is to give you practical knowledge and skills that you can use immediately in your daily work.
It's a great opportunity to expand your knowledge and enhance your skills, whether you're motivated by an internal desire to develop or by your employer.
Bespoke programmes for companies
Does your team need training on this topic? Or, would your organization benefit from additional focus on specific issues in the course program, allowing some elements to be explored in greater depth?
With bespoke programs, we can adjust the training content to meet your organization’s specific needs. This includes adding topics not covered in the standard program or omitting sections less relevant to your team. The final cost of customized training is set individually at the proposal stage.
Related courses
Financial Modelling - Advanced (& Introduction to VBA)
Find out more
Introduction to Finance and Controlling - Level 1 - Fundamentals
Find out more
Managing Risk in the Financial Services Industry
Find out more