Financial Modeling with Crystal Ball and Excel ( Wiley Finance )

Publication series :Wiley Finance

Author: John Charnes  

Publisher: John Wiley & Sons Inc‎

Publication year: 2007

E-ISBN: 9780470129937

P-ISBN(Paperback): 9780471779728

P-ISBN(Hardback):  9780471779728

Subject: F830.49 modernization management

Language: ENG

Access to resources Favorite

Disclaimer: Any content in publications that violate the sovereignty, the constitution or regulations of the PRC is not accepted or approved by CNPIEC.

Description

Praise for
Financial Modeling with Crystal Ball(r) and Excel(r)

"Professor Charnes's book drives clarity into applied Monte Carlo analysis using examples and tools relevant to real-world finance. The book will prove useful for analysts of all levels and as a supplement to academic courses in multiple disciplines."
-Mark Odermann, Senior Financial Analyst, Microsoft

"Think you really know financial modeling? This is a must-have for power Excel users. Professor Charnes shows how to make more realistic models that result in fewer surprises. Every analyst needs this credibility booster."
-James Franklin, CEO, Decisioneering, Inc.

"This book packs a first-year MBA's worth of financial and business modeling education into a few dozen easy-to-understand examples. Crystal Ball software does the housekeeping, so readers can concentrate on the business decision. A careful reader who works the examples on a computer will master the best general-purpose technology available for working with uncertainty."
-Aaron Brown, Executive Director, Morgan Stanley, author of The Poker Face of Wall Street

"Using Crystal Ball and Excel, John Charnes takes you step by step, demonstrating a conceptual framework that turns static Excel data and financial models into true risk models. I am astonished by the clarity of the text and the hands-on, step-by-step examples using Crystal Ball and Excel; Professor Charnes is a masterful teacher, and this is an absolute gem of a book for the new generation of analyst."
-Brian Watt, Chief Operating Officer, GECC, Inc.

"Financial Modeling with Crystal Ball and Excel is a comprehensive, well-written guide to one of the most useful analysis tools available to professional risk managers and quantitative analysts. This is a must-have book for anyone using Crystal Ball, and anyone wanting an overview of basic risk management concepts."
-Paul Dietz, Manager, Quantitative Analysis, Westar Energy

"John Charnes presents an insightful exploration of techniques for analysis and understanding of risk and uncertainty in business cases. By application of real options theory and Monte Carlo simulation to planning, doors are opened to analysis of what used to be impossible, such as modeling the value today of future project choices."
-Bruce Wallace, Nortel

Chapter

Contents

pp.:  1 – 9

Preface

pp.:  9 – 13

Acknowledgments

pp.:  13 – 17

About the Author

pp.:  17 – 19

Chapter 1: Introduction

pp.:  19 – 21

Chapter 3: Building a Crystal Ball Model

pp.:  31 – 48

Chapter 4: Selecting Crystal Ball Assumptions

pp.:  48 – 56

Chapter 5: Using Decision Variables

pp.:  56 – 91

Chapter 6: Selecting Run Preferences

pp.:  91 – 115

Chapter 7: Net Present Value and Internal Rate of Return

pp.:  115 – 125

Chapter 8: Modeling Financial Statements

pp.:  125 – 145

Chapter 9: Portfolio Models

pp.:  145 – 152

Chapter 10: Value at Risk

pp.:  152 – 160

Chapter 11: Simulating Financial Time Series

pp.:  160 – 167

Chapter 12: Financial Options

pp.:  167 – 190

Chapter 13: Real Options

pp.:  190 – 207

Appendix A: Crystal Ball’s Probability Distributions

pp.:  207 – 222

Appendix B: Generating Assumption Values

pp.:  222 – 255

Appendix C: Variance Reduction Techniques

pp.:  255 – 263

Appendix D: About the Download

pp.:  263 – 269

Glossary

pp.:  269 – 271

References

pp.:  271 – 275

Index

pp.:  275 – 283

LastPages

pp.:  283 – 289

The users who browse this book also browse