Over the past several years, Spreadsheet models have been the dominant vehicles for finance professionals to implement their financial knowledge. Financial modeling is now a core skill in many key leadership and strategic roles ranging from CFOs and strategy groups to private equity to funds management to corporate finance to accounting firms providing business advisory services. Moreover, Financial Modelling professionals has steadily increased as organizations need to plan and adjust to the economic volatility and uncertainty that has become the “new normal”.
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 and the theory behind the DCF valuation technique, the seminar builds detailed proforma financial statements for an explicit forecast period of 5 years and then applies DCF to estimate the so called intrinsic value of a company. 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.
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.
Για την εγγραφή σας παρακαλώ πατήστε εδώ