About Workshop
Oracle Crystal Ball is the leading spreadsheet-based application suite for predictive modeling, forecasting, simulation, and optimization. It provides an unparalleled insight into the critical factors affecting risk. With Crystal Ball, you can make the right tactical decisions to reach your objectives and gain a competitive edge under even the most uncertain market conditions.
Workshop topics to be covered:
Session 1
Introduction to Financial Modeling, Simulation, Risk Analysis and Risk Management
Financial Modeling
Risk Analysis
Monte Carlo Simulation
Risk Management
Introduction to Crystal Ball
Analyzing a Crystal Ball Forecast
Session 2
Building Crystal Ball Models
Building a Crystal Ball Model
Selecting Crystal Ball Assumptions
Using Decision Variables
Selecting Run Preferences
Session 3
Building Financial Models – I
Building NPV and IRR Model
Modeling Financial Statements
Portfolio Models
Value at Risk
Session 4
Simulating Financial Time Series
White noise and random walk
Autocorrelation
Multiplicative Random Walk Model
Geometric Brownian Motion Model
Mean-reverting model
Session 5
Financial Options and Real Options
Risk-neutral Pricing and the Black Scholes Model
American Option Pricing
Exotic Option Pricing
Principal-Protected Instruments
Financial Options and Real Options
Session 6
Review
Real life cases
Test