Get 20% discount

Financial Planning, Forecasting and Simulation with Crystal Ball


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.


The programme will be delivered using formal lectures combined with practical and interactive case studies and exercises. There will be a great emphasis on gaining practical experiences.

Contents of Training:

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
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
Real life cases

Related Courses

Enamul Haque Sujon
  • 2 Jul - 1 Aug 2017

Tally is a most powerful, yet very simple and easy, ...

Price 5,000 Tk + VAT
Muhammad Arif-ur-Rahman
  • 8 - 21 Jul 2017 (04 Sessions)

At the end of the course you will be a confident, skilful ...

Enamul Haque Sujon
  • 11 - 25 Jul 2017 (05 Sessions) 5 Basic Functions of QuickBooks. by ...

Price 13,000 Tk + VAT
Md. Jehad Uddin
  • 12 Jul - 14 Aug 2017

This course is designed in such a way that participants ...



9140345, 9117179 Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

Professionals from finance background
Adequate knowledge of statistics (stat-1 and stat-2)