E-Book Overview
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.
E-Book Content
Financial Modeling with Crystal Ball and Excel JOHN CHARNES John Wiley & Sons, Inc. Financial Modeling with Crystal Ball and Excel Founded in 1807, John Wiley & Sons is the oldest independent publishing company in the United States. With offices in North America, Europe, Australia and Asia, Wiley is globally committed to developing and marketing print and electronic products and services for our customers’ professional and personal knowledge and understanding. The Wiley Finance series contains books written specifically for finance and investment professionals as well as sophisticated individual investors and their financial advisors. Book topics range from portfolio management to e-commerce, risk management, financial engineering, valuation and financial instrument analysis, as well as much more. For a list of available titles, please visit our Web site at www.WileyFinance.com. Financial Modeling with Crystal Ball and Excel JOHN CHARNES John Wiley & Sons, Inc.