Course Description

This hands-on course demonstrates advanced techniques EC RISK USA & EUROPE, LLC has found useful in its consulting activities. We explain how to use @RISK to perform quantitative risk assessments focusing on financial decisions. We also show how to use the analysis results to improve decision-making-from exposure identification, quantification, and mitigation. In addition, we introduce the concept of real options-how to identify and quantify the flexibilities that exist in decisions. These techniques are presented in the context of new and current projects and acquisitions. We show you how to identify and analyze the key uncertainty drivers, which form the basis for efficient risk and opportunity management strategies.

Day 1: Introduction to Advanced Techniques

1. Accelerated review of risk analysis using @RISK: Working through a simple example
   a) Model structure
   b) Selecting distributions
   c) Recommended @RISK settings
   d) Custom report
   e) Assessing the risk
   f) Testing mitigation alternatives
   g) Reporting results
2. Modeling techniques: Modeling conditional events
3. Automating @RISK with VBA Macros
4. Modeling Correlation
   a) Building interdependence between uncertain inputs
   

Day 2: Modeling the Key Components of a Risk Analysis

1. Selecting a sound distribution
   a) Quantifying expert judgment
   b) Fitting distributions to uneven data
   c) Exercises
2. Modeling uncertainty over time (time series uncertainty):
   a) EC RISK's mainstream methods
   b) Exercises
3. Developing an @RISK model step-by-step: Project Valuation (NPV) w/o Flexibility
4. Introduction to Real Options
5. Extending @RISK models: Finding the best values for decision cells in models using RISKOptimizer.

All Contents © 2005-2009, EC RISK USA & EUROPE, LLC. All Rights Reserved. Terms, Privacy
Design and Hosting by Pacifica