Financial modelling course
Sep – 3 days
September 11 @ 9:30am - September 13 @ 5:30pm
This modelling training course is designed as a first program for people who would like an opportunity to practise and improve their ability to model cash flows in Excel.
The course is conducted in a work shop format, with the emphasis on “learning by doing”. During the program delegates work as a team to create a cash flow model from scratch.
Building a financial model – course day 1 of 3
Course delegates start their Excel modelling by building up financial accounts in pre-set “stages”. They save their work in clear steps as they go. At the end of the course they have a record of their own work (each completed stage of their Excel model) plus refresher notes supplied by the lecturer.
Course day 2
Course delegates complete their model. Then they start to look at how to, for example, use the financial model to analyse a new and revised deal structure:
- Completing a financial model
- Getting to cash flow
- Modelling a new deal
Course day 3
- Determining outputs
- scenario analysis
- Excel modelling help
- Modelling best practice
- Working with a financial model
- Topics in more advanced financial modelling