The purpose of this training is to enhance your existing Excel modeling skills and learn how to build and modify financial models faster by learning and applying industry best practices. The seminar highlights the core financial model design and construction techniques that every modeler should know. It will allow participants to adopt a structured and comprehensive design strategy to develop rigorous financial models, in less time and with greater accuracy.
This hands-on workshop will also teach you how to perform risk analysis and apply uncertainty into a model and undertake a more dynamic analysis to improve decision making by developing a risk assessment into an @RISK model. Participants will be introduced to the concepts and methods necessary to simulate almost all potential future outcomes, develop a risk assessment and make solid decisions under uncertainty.
The hands-on workshop will consist of the following activities:
- Adding uncertainty to deterministic models
- Select the proper distributions depending on the nature of their model / project
- Fit distributions to data
- Incorporate correlation in risk analysis and discuss its importance
- Interpret simulation results and produce reports in Excel
The FAST Modeling Standard
The FAST Modeling standard is an international recognized methodology in financial modeling that is used by major firms in their modelling assignments. Firms like Grant Thornton and PwC are using FAST for the client’s development.
The FAST Standard is used by thousands of Excel modelers worldwide, was written to provide clear guidance for the complex world of spreadsheet-based forecasting.
- Flexible: models must be easily adaptable when new information becomes available
- Appropriate: models must faithfully reflect key business assumptions and avoid unnecessary detail
- Structured: maintaining model integrity over time relies on rigorous consistency
- Transparent: to make models easily understandable, calculations must be simple and clear
This standard set of rules provides both a clear route to good financial model design for the individual modeller, and a common style platform on which modellers and reviewers can rely when passing models amongst themselves.
This seminar focuses on best practices and is based in case studies and real-life examples, using a highly effective hands-on intuitive training approach. It is designed for professionals who need to build flexible and transparent spreadsheet models by learning and applying industry best practices. Participants follow the instructor, while building their own financial models on their own laptop computers; in this way they immediately practice what they have been taught.
Participants will also cover how to build models accurately and efficiently through a series of best practice modelling rules, how to stress-test the assumptions used, to check their work efficiently and to document it.