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
   b) Exercises

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) Ad Hoc Methods
   b) Regression
   c) Exercises
3. Developing an @RISK model step-by-step: Project Valuation (NPV) w/o Flexibility
4. Extending @RISK models: Finding the best values for decision cells in the models using RISKOptimizer.

Day 3: Introduction to Real Options -- Valuing Flexibility

1. Introduction to Real Options
2. Learning 3 different solution methods:
   a) Black-Scholes
   b) Binomial Lattices
   c) Monte Carlo Simulation
3. Exercises

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