Financial Modeling with Crystal Ball and Excel

Author(s): John Charnes

Series: Wiley Finance

Publisher: Wiley, Year: 2007

An insightful look at financial modeling and Monte Carlo simulation using Crystal Ball softwareFinancial Modeling with Crystal Ball and Excel outlines the tools and techniques needed to become an expert in financial modeling and simulation. After reviewing the basics, this comprehensive guide discusses how to define and refine probability distributions in financial modeling, and exhaustively reviews the concepts behind the simulation modeling process. Example models help readers apply risk analysis to such areas as derivative pricing, cost estimation, portfolio allocation and optimization, present value, and cash flow analysis. The information found within these pages will immediately help readers develop essential skills in the areas of valuation, pricing, hedging, trading, risk management, project evaluation, and portfolio management.