Financial Modeling

Overview:

Finance modeling is crucial for investment decisions. This course will acquaint you with methods used to prepare and build financial models to cater to different types of investment decisions.

You get an opportunity to practise not only the accounting methods used in financial modeling such as time value, present value, WACC Weighted Average Cost of Capital; we also incorporate the excel techniques using pivot tables and VBA Programming used to create flexible, dynamic and professional models.

This an intensive 3 days workshop, which starts with basic and progresses in a logical step by step manner to evolve a deeper understanding of developing a professional finance model. This program involves practical financial markets issues to emphasize some important financial concepts that will assist in building vigorous models. Participants will need some professional modelling and vba programming knowledge in excel.

Key Takeaways: 

- Understand the accounting concepts of Finance Modeling
- Learn to make an investment decision in a practical financial market scenario
- Learn the tools used to build models that are less time and effort consuming
- Learn the application of Pivot Tables in Finance Modeling
- Learn the application of VBA Programming in Finance Modeling

Benefits:

- Certification of Completion awarded by AAA (UAE Government Body)
- Prepare effective financial statement models using Excel
- Determinevalue of project using free cash flow techniques
- Perform capital budgeting analysis using money value concepts, cost of capital calculations
- Stress test risk of developed financial model
-  Performing sensitivity analysis
- Review scenario analysis and recognize special
- Modelling and valuation considerations best practices