Financial Modelling - Comprehensive (ICAS)

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

Valuation Techniques (with Valuation Modelling)