28 & 30 November, 2023
CPD hours: 8
Aim
Over the past several years, Spreadsheet models have been the dominant vehicles for finance professionals to implement their financial knowledge. In the aftermath of the recent pandemic, the need for experienced Financial Modelling professionals has steadily increased, as organizations need to plan and adjust to the economic volatility and uncertainty. With a step by step approach this practical seminar guides participants through the various techniques of financial modelling. Participants will build their own models to forecast the financial performance of a case company and estimate its intrinsic value bringing a practical application to the skills they have learned.
Objective
This seminar provides a step-by-step guide that takes somebody through the entire process of developing long term projection plans using Excel. After the introduction of the basic accounting knowledge regarding the articulation of the three financial statements, the seminar builds on their modelling.
In addition, it discusses approaches for valuing companies and builds on these by examining practical examples. A significant portion of the seminar is dedicated to the discounted cash flow method and the market multiples analysis.
Finally, by making use of various tools (Excel Scenario Manager & Sensitivity Analysis), it provides practical examples on how to apply risk and uncertainty to the am projection plans and the associated value of a company.
Certification
All participants will be awarded a certificate. Each hour of attendance will account for one unit of Continuing Professional Development (CPD) as required for members of most professional bodies.
Corporate Discounts are available.
For 3 and more registrations, please contact us!