Financial modeling with Crystal Ball and Excel

MaRDI QIDQ2904642zbMATH OpenFDO

Authors John Charnes

Publication date 15 August 2012

zbMATH Keywords

credit riskCrystall Ball\(^{\circledR}\)Excel\(^{\circledR}\)financial modelingfinancial time seriesMonte Carlo simulationoption pricingrisk analysisrisk management

Mathematics Subject Classification ID

Introductory exposition (textbooks, tutorial papers, etc.) pertaining to game theory, economics, and finance (91-01) Computational methods for problems pertaining to game theory, economics, and finance (91-08) Microeconomic theory (price theory and economic markets) (91B24) Credit risk (91G40) Numerical methods (including Monte Carlo methods) (91G60)

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.

Recommendations

• Statistical decision problems. Selected concepts and portfolio safeguard case studies
• Excel Basics to Blackbelt
• The value of simple models in new product forecasting and customer‐base analysis
• scientific article; zbMATH DE number 5865552
• Computational finance. An introductory course with R
• scientific article; zbMATH DE number 1139029
• Soft Decision Support Systems for Evaluating Real and Financial Investments

Cited in

(4)

• CrystallBall
• Introduction to financial models for management and planning
• The art of company financial modelling
• Selecting the best alternative based on its quantile

Describes a project that uses

Uses Software

• Excel
• OptQuest

This page was built for publication: Financial modeling with Crystal Ball and Excel

Report a bug (only for logged in users!)Click here to report a bug for this page (MaRDI item Q2904642)