Financial modeling with Crystal Ball and Excel /

• Main Author: Charnes, John Martin
• Format: eBook
• Language: English
• Published: Hoboken, New Jersey : Wiley, 2012.
• Edition: Second edition.
• Series: Wiley finance series.
• Subjects: Crystal ball (Computer file); Microsoft Excel (Computer file); Finance > Mathematical models.; Investments > Mathematical models.; BUSINESS & ECONOMICS > Investments & Securities.; Electronic books.

"Updated look at financial modeling and Monte Carlo simulation with software by Oracle Crystal BallThis revised and updated edition of the bestselling book on financial modeling provides the tools and techniques needed to perform spreadsheet simulation. It answers the essential question of why...

Table of Contents:

• Financial Modeling with Crystal Ball and Excel; Contents; Preface; Acknowledgments; About the Author; CHAPTER 1 Introduction; 1.1 FINANCIAL MODELING; 1.2 RISK ANALYSIS; 1.3 MONTE CARLO SIMULATION; 1.4 RISK MANAGEMENT; 1.5 BENEFITS AND LIMITATIONS OF USING CRYSTAL BALL; 1.5.1 Benefits; 1.5.2 Limitations; CHAPTER 2 Analyzing Crystal Ball Forecasts; 2.1 SIMULATING A 50-50 PORTFOLIO; 2.1.1 Accumulate.xls; 2.1.2 Frequency Chart; 2.1.3 Cumulative Frequency Chart; 2.1.4 Statistics View; 2.1.5 Forecast Window Percentiles View; 2.2 VARYING THE ALLOCATIONS; 2.2.1 Decision Table Tool; 2.2.2 Trend Chart.