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 financial crisis, 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 in order to forecast the financial performance of a case company and estimate its intrinsic value bringing a practical application to the skills they have learned.
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.
The course is designed for any accounting or finance professional, with moderate experience in financial modelling; Financial decision makers; Management Accountants; Financial Controllers;
Strategic Planners; Operational Managers; Business Analysts.
Participants should know how to navigate confidently in Excel and use Excel tools and functions on a regular basis.
Participants are required to bring their own laptop.