TRAINING COURSE BACKGROUND
Financial modeling techniques allow users to improve the reliability, quality and timeliness of their decision making. Modeling techniques are now used in many different areas, such as investment appraisal, capital planning, budgeting, valuation, and financial analysis and forecasting. With a step-by step approach, this course will guide you through the various techniques, providing you with a comprehensive understanding of advanced modeling, as well as how each technique can practically be applied through the use of Excel.
TRAINING COURSE STRUCTURE
The course starts by focusing on the advanced use of Excel in modeling. These newly gained skills will be applied in the construction of basic company valuation models, before the incorporation of risk assessment, scenarios, optimization and forecasting into the models. With the help of the course director and through a proven step-by-step approach, delegates will then construct models of different types. Delegates will leave this intensive three-day course with the ability to effectively apply modeling techniques in Excel in a wide range of practical scenarios.
TEACHING METHOD
This program will be delivered through practical and interactive case studies and worked examples, demonstrating how and why each technique is used. Emphasis is placed on delegates gaining practical, hands-on experience of the design and construction of financial models in Excel. Delegates will also benefit from formal lectures and group discussions. Comprehensive product notes and modeling software will be provided for future reference.
WHO SHOULD ATTEND FINANCIAL MODELLING IN EXCEL
This course has been designed for: