Course Description:

❖ Over the past several years, spreadsheet models have been the dominant vehicles for finance professionals to implement their financial knowledge. Financial modeling is a core skill in many key leadership and strategic roles ranging from CFOs and FP&As to Private Equity and Investment Banking. Moreover, Financial modeling professionals has steadily increased as organizations need to plan and adjust to the economic volatility and uncertainty that has become the “new normal”.

❖ The course develops the initial model with integrated financial statements and adds more advanced features. The workshop uses the logical consistent approach and builds the cash flow model through a series of practical stages. Upon completion delegates, will have a comprehensive understanding of advanced modeling, as well as how they can apply each technique to their own models.

Course Benefits.

• Learn how to develop step by step guide that it takes through the entire process of developing long term projection plans using Excel.

• Learn the articulation of the three financial statements and the theory behind the DCF and Comps valuation techniques.

• Learn to build the detailed proforma financial statements for an explicit forecast period of 5 years and then applies DCF and Comps to estimate the so-called intrinsic value of a company.

• Learn to use of various tools (Excel Scenario Manager & Sensitivity Analysis and Monte Carlo Simulation).

• Provides practical examples on how to apply risk and uncertainty to these projection plans and the associated intrinsic value.

Who Should Attend:

Course is designed specifically for individuals participating in or aspiring to further their professional careers and accreditation.

• Financial Directors / Controllers / CFO's

• Corporate / Structures / Project Finance Officers

• Management Accountants

• Financial / Strategic Planners

• Business / Financial / Treasury / Market Analysts

• Operational Managers

• Business Analysts

For more information and course brochure, Please feel free to contact: edurelevents@edurel.com