Financial Modelling
-
I want to thank you again for all the help that you have demonstrated me during the past 3 days of the program. I really liked the course and learned a lot. The trainer was very kind and very knowledgeable in the field and I would actively recommend your course to my colleagues and friends.
← | →
-
The practical exercises on corporate financing models were practical and effective.
← | →
-
The course as a whole is actually useful.
← | →
Course
In London
Description
-
Type
Course
-
Level
Intermediate
-
Location
London
-
Class hours
21h
-
Duration
3 Days
Suitable for: Analysts, Associates, Executives, Managers. This financial modelling course is designed as a first program for people who would like an opportunity to 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 course delegates work in teams to conduct finanicial modelling work from scratch.
Facilities
Location
Start date
Start date
Reviews
-
I want to thank you again for all the help that you have demonstrated me during the past 3 days of the program. I really liked the course and learned a lot. The trainer was very kind and very knowledgeable in the field and I would actively recommend your course to my colleagues and friends.
← | →
-
The practical exercises on corporate financing models were practical and effective.
← | →
-
The course as a whole is actually useful.
← | →
Course rating
Recommended
Centre rating
Mary T.
Former student
Harley
Larry
Matt
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 14 years
Subjects
- Financial Training
- Financial
- Excel
- MS Excel
- Spreadsheet
- Cash Flow
- Credit
- Financial Modelling
- Excel Modelling
- Finanacial Modelling
Teachers and trainers (1)
Course Tutor
Senior trainer
This programme is taught by an experienced corporate finance practitioner. Please click on www.financialtrainingassociates.com for further details.
Course programme
EXCEL FINANCIAL MODELLING COURSE – THREE DAYS
This financial modelling course is designed as a first program for people who would like an opportunity to 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 course delegates work in teams to conduct finanicial modelling work from scratch.
As part of their work on this course delegates work with their colleagues to conduct their own integrated financial statement modelling, using an interesting case study chosen before training by class participants.
Starting from a blank Excel spreadsheet, delegates create a full set of forecast financial statements for the business. Delegates can then choose a modelling scenario to see how the business performs under stress and, for example, how key financial ratios and bank covenant tests change with a change in circumstances.
Delegates are guided through a complete Excel financial model build up and are shown all the steps they need to take. Throughout modelling conducted on the course plenty of guidance and help is given by the instructor.
At the end of the course participants will have a record of their own work and a permanent record of the steps they have taken to create their own financial forecast. The course covers:
- Cash flow modelling
- Determining debt capacity
- Developing key outputs for credit analysis
- Scenario analysis
- Guidelines for good modelling practice
- Excel modelling tips and tricks.
Additional information
Financial Modelling