Financial modeling with Crystal Ball and Excel
type: Item
instance of: scholarly article
zbMATH Open document ID: 1251.91006
author: John Charnes
publication date: 2012-08-15T00:00:00Z
Mathematics Subject Classification ID: 91-08
Mathematics Subject Classification ID: 91-01
Mathematics Subject Classification ID: 91G60
Mathematics Subject Classification ID: 91B24
Mathematics Subject Classification ID: 91G40
zbMATH DE Number: 6066589
zbMATH Keywords: Crystall Ball\(^{\circledR}\)
zbMATH Keywords: Excel\(^{\circledR}\)
zbMATH Keywords: financial modeling
zbMATH Keywords: risk analysis
zbMATH Keywords: risk management
zbMATH Keywords: Monte Carlo simulation
zbMATH Keywords: financial time series
zbMATH Keywords: option pricing
zbMATH Keywords: credit risk
describes a project that uses: Excel
describes a project that uses: OptQuest
MaRDI profile type: Publication
Recommended article: Statistical decision problems. Selected concepts and portfolio safeguard case studies
Recommended article: Excel Basics to Blackbelt
Recommended article: The value of simple models in new product forecasting and customer‐base analysis
Recommended article: Q3083937
Recommended article: Computational finance. An introductory course with R
Recommended article: Q4383862
Recommended article: Soft Decision Support Systems for Evaluating Real and Financial Investments
title: Financial modeling with Crystal Ball and Excel
review text: The book is written to help statisticians, financial analysts and other interested persons learn how to build and interpret the results of Crystall Ball\(^{\circledR}\) models for decision support. Instructors with a practical bent may also find it useful as a supplement for courses in finance, statistics, management science and industrial engineering. The book consists of 16 chapters. The first six chapters cover the features of Crystal Ball and OptQuest. Several examples illustrate how these programs can be used to enhance deterministic Excel models for stochastic financial analysis and planning. The remaining ten chapters provide more detailed examples of how Crystal Ball and OptQuest can be used in financial risk analysis of investments in securities, derivatives, real options and project management. The technical appendices provide details about the methods used by Crystal Ball in its algorithms and a description of some methods of variance reduction. All of the models described in the book are available through a link to a web site from which a trial version of Crystal Ball may also be downloaded.
reviewed by: Yuliya S. Mishura
description: scientific article; zbMATH DE number 6066589