Stochastic Modelling (Chapter 14)

Crystal Ball Construction – A single page example of Crystal Ball used for an analysis.  This is meant as a “practice” model and for demonstration.

Crystal Ball Sheet – This stand-alone sheet which can be “Bolted-On” to existing spreadsheet models to enable stochastic modelling of inputs.

Crystal Ball Add-on 5-Unit – The 5-unit real estate pro forma has been enhanced with Monte Carlo and Latin hypercube simulation of Crystal Ball.  The basic Crystal Ball “Bolt-On” page has been added and the capability of stochastic risk quantification included within an existing spreadsheet model.