Financial Modeling with Crystal Ball and Excel ( Wiley Finance )

Publication series :Wiley Finance

Author: John Charnes  

Publisher: John Wiley & Sons Inc‎

Publication year: 2012

E-ISBN: 9781118227053

P-ISBN(Paperback): 9781118175446

P-ISBN(Hardback):  9781118175446

Subject: F8 Finances

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

Updated look at financial modeling and Monte Carlo simulation with software by Oracle Crystal Ball

This 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 risk analysis is vital to the decision-making process, for any problem posed in finance and investment. This reliable resource reviews the basics and covers how to define and refine probability distributions in financial modeling, and explores the concepts driving the simulation modeling process. It also discusses simulation controls and analysis of simulation results.

The second edition of Financial Modeling with Crystal Ball and Excel contains instructions, theory, and practical example models to help apply risk analysis to such areas as derivative pricing, cost estimation, portfolio allocation and optimization, credit risk, and cash flow analysis. It includes the resources needed to develop essential skills in the areas of valuation, pricing, hedging, trading, risk management, project evaluation, credit risk, and portfolio management.

  • Offers an updated edition of the bestselling book covering the newest version of Oracle Crystal Ball
  • Contains valuable insights on Monte Carlo simulation—an essential skill applied by many corporate finance and investment professionals
  • Written by John Charnes, the former finance department chair at the University of Kansas and senior vice president of global portfolio strategies at Bank of America, who is currently President and Chief Data Scientist at Syntelli Solutions, Inc. Risk Analytics and Predictive Intelligence Division (Syntelli RAPID)

Engaging and informative, this book is a vital resource designed to help you become more adept at financial modeling and simulation.

Chapter

Contents

pp.:  1 – 7

Preface

pp.:  7 – 13

Acknowledgments

pp.:  13 – 19

About the Author

pp.:  19 – 21

CHAPTER 1 Introduction

pp.:  21 – 23

CHAPTER 3 Building A Crystal Ball Model

pp.:  33 – 51

CHAPTER 4 Selecting Crystal Ball Assumptions

pp.:  51 – 59

CHAPTER 5 Using Decision Variables

pp.:  59 – 101

CHAPTER 6 Selecting Run Preferences

pp.:  101 – 127

CHAPTER 7 Net Present Value and Internal Rate of Return

pp.:  127 – 139

CHAPTER 8 Modeling Financial Statements

pp.:  139 – 159

CHAPTER 9 Portfolio Models

pp.:  159 – 167

CHAPTER 10 Value at Risk

pp.:  167 – 177

CHAPTER 11 Simulating Financial Time Series

pp.:  177 – 185

CHAPTER 12 Financial Options

pp.:  185 – 209

CHAPTER 13 Real Options

pp.:  209 – 227

CHAPTER 14 Credit Risk

pp.:  227 – 243

CHAPTER 15 Construction Project Management

pp.:  243 – 251

CHAPTER 16 Oil and Gas Exploration

pp.:  251 – 257

APPENDIX A Crystal Ball’s Probability Distributions

pp.:  257 – 263

APPENDIX B Generating Assumption Values

pp.:  263 – 301

APPENDIX C Variance Reduction Techniques

pp.:  301 – 309

APPENDIX D About the Download

pp.:  309 – 315

Trialware

pp.:  315 – 317

Glossary

pp.:  317 – 319

References

pp.:  319 – 323

Index

pp.:  323 – 333

LastPages

pp.:  333 – 336

The users who browse this book also browse


No browse record.