Course description
Overview
This two-day course has been developed for anybody looking to develop their financial modelling skills. The focus is on best practice financial modelling, the Dos and the Don’ts that are critical to ensure your models are sturdy, dynamic and flexible.Delegates should be comfortable with the skills taught on the Introduction to Excel course before attending this course.An integrated forecast set of financial statements is built, based on recent actual historic data. Delegates build their own model with the help of the trainer. A discounted cash flow valuation is then performed, enabling some sensitivity analysis to be performed using the model.
Who is this for?
This course is designed for anybody who needs to build, interpret, review and audit financial models. It is suitable for both accountants and non-accountants, but an existing understanding of basic accounting concepts and terminology will be beneficial.
What will you learn?
- 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
Please read the following guidance carefully, which only applies if you are attending this course online:
- In addition to the Online Classroom, you will need to have your own version of Excel open to complete the exercises
- It is difficult (but not impossible) to do this with only 1 screen as you will need to be regularly switching between open windows. We recommend to either:
- Extend from a computer to a 2nd screen, or
- Use 2 computers, or
- Use a tablet for the online classroom and a computer for the Excel
- You are strongly recommended to perform the exercises on a PC rather than a MAC. Using a MAC is possible but the trainer will be unable to help you with the required shortcuts.
Related courses
Introduction to Excel
Financial Modelling - Advanced (& Introduction to VBA)
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Suitability - Who should attend?
This two-day course is designed for financial professionals needing to build, interpret, review and audit financial models (forecast integrated income statement, cash flow statement and balance sheet). It is suitable for both accountants and non-accountants, but an existing understanding of basic accounting concepts and terminology would be helpful. Delegates concerned about their basic excel ability should first attend the one-day Financial Modelling - Excel Essentials. Laptops (excel v.2013) are provided.
Outcome / Qualification etc.
- Financial modeling “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
- Essential financial maths
- Discounted cash flow valuation
- Scenario analysis
- Sensitivity analysis
- Rolling forward the forecast
- Model audit and review
- Circularity and trouble shooting