The Institute for Mergers, Acquisitions and Alliances

Advanced Valuation With Crystal Ball

Available dates

This course has no confirmed dates in the future. Subscribe to be notified when it is offered.

About the course

Executives, managers, and analysts are facing increasing pressure to make the right decisions in times of information overload and big data. Imagine being able to leverage historical data in estimating scenarios and to simulate what-if-scenarios over a million times in only a few minutes? With Crystal Ball you can. Crystal Ball is the leading spreadsheet-based application for predictive modeling, forecasting, simulation, and optimization.

The Advanced Valuation with Crystal Ball training, focusing specifically on corporate finance, investments, and derivatives, teaches participants to use Oracle’s Crystal Ball as a tool for better predictive modeling. In this 2-day training, participants will actively learn how to use this tool and take full advantage of its functionality and features.

Participants are expected to come prepared with their own laptops.

Day 1

  • Introduction to Stochastic Modeling
  • Building a Stochastic Model
  • Input Specification
  • Stochastic Optimization
  • Selecting Run Preferences

Day 2

  • Net Present Value and Internal Rate of Return
  • Portfolio Models and Value at Risk
  • Modeling Financial Time Series
  • Financial Option Valuation
  • Real Options and Credit Risk

Benefits

  • Refine simulation design
  • Improve financial and operational performance
  • Understand and apply various simulation methods
  • Build and customize more effective models
  • Strengthen forecast analyzation
  • Gain Crystal Ball assumption selection, variable input and preference run experience

Who should attend

The advanced valuation training is attended by a wide variety of professionals in the financial arena, most notably: financial and fund analysts, risk analysts, credit and market analysts, quantitative analysts, financial engineers, treasury analysts and individuals with a background in statistics aspiring to become financial analysts.

Course reviews