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.
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 simulation and modelling. In addition, by making use of various tools (Excel Scenario Manager & Sensitivity Analysis) provides practical examples on how to apply risk and uncertainty to these projection plans and the associated intrinsic value that is based on these plans.
The course is designed for:
- Any accounting or finance professional, with moderate experience in financial modeling
- 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.
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.