Financial Modeling with Crystal Ball and Excel by John Charnes

Financial Modeling with Crystal Ball and Excel by John Charnes

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.” Also
-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.” Also
-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.” Also
-Aaron Brown, Executive Director, Morgan Stanley, author of The Poker Face of Wall Street

Get Financial Modeling with Crystal Ball and Excel by John Charnes on Traderknow.com

“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.” Also
-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.” Also
-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.” Also
-Bruce Wallace, Nortel 

Get Financial Modeling with Crystal Ball and Excel by John Charnes on Traderknow.com

Table of Contents

Preface. Also

Acknowledgments.

About the Author. Also

Chapter 1: Introduction.

Financial Modeling.

Risk Analysis. Also

Monte Carlo Simulation.

Risk Management. Also

Benefits and Limitations of Using Crystal Ball.

Chapter 2: Analyzing Crystal Ball Forecasts.

Simulating A 50–50 Portfolio. Also

Varying the Allocations.

Presenting the Results. Also

Chapter 3: Building a Crystal Ball Model.

Simulation Modeling Process.

Defining Crystal Ball Assumptions. Also

Running Crystal Ball.

Sources of Error. Also

Controlling Model Error.

Chapter 4: Selecting Crystal Ball Assumptions.

Crystal Ball’s Basic Distributions. Also

Using Historical Data to Choose Distributions.

Specifying Correlations. Also

Chapter 5: Using Decision Variables.

Defining Decision Variables.

Decision Table with One Decision Variable. Also

Decision Table with Two Decision Variables.

Using OptQuest. Also

Chapter 6: Selecting Run Preferences.

Trials.

Sampling. Also

Speed.

Options. Also

Statistics.

Chapter 7: Net Present Value and Internal Rate of Return.

Deterministic NPV and IRR. Also

Simulating NPV and IRR.

Capital Budgeting. Also

Customer Net Present Value.

Chapter 8: Modeling Financial Statements.

Deterministic Model. Also

Tornado Chart and Sensitivity Analysis.

Crystal Ball Sensitivity Chart. Also

Conclusion.

Chapter 9: Portfolio Models.

Single-Period Crystal Ball Model. Also

Single-Period Analytical Solution.

Multiperiod Crystal Ball Model. Also

Get Financial Modeling with Crystal Ball and Excel by John Charnes on Traderknow.com

Chapter 10: Value at Risk.

VaR.

Shortcomings of VaR. Also

CVaR.

Chapter 11: Simulating Financial Time Series.

White Noise. Also

Random Walk.

Autocorrelation. Also

Additive Random Walk with Drift.

Multiplicative Random Walk Model. Also

Geometric Brownian Motion Model.

Mean-Reverting Model. Also

Chapter 12: Financial Options.

Types of Options.

Risk-Neutral Pricing and the Black-Scholes Model. Also

Portfolio Insurance.

American Option Pricing. Also

Exotic Option Pricing.

Bull Spread. Also

Principal-Protected Instrument.

Chapter 13: Real Options.

Financial Options and Real Options. Also

Applications of ROA.

Black-Scholes Real Options Insights. Also

ROV Tool.

Summary. Also

Appendix A: Crystal Ball’s Probability Distributions.

And appendix B: Generating Assumption Values. Also

Appendix C: Variance Reduction Techniques.

And appendix D: About the Download. Also

Glossary.

References. Also

Index. Also

Get Financial Modeling with Crystal Ball and Excel by John Charnes on Traderknow.com

Author Information

Dr. John Charnes, PhD, MBA, is Professor, Scupin Faculty Fellow, and former director of the finance, economics, and decision sciences area in the University of Kansas School of Business. His specialty is the application of computer simulation and statistical methods for identifying and solving business problems, and his most current research involves using simulation for option pricing and hedging with derivatives to comply with Financial Accounting Standard (FAS) 133. Charnes has also performed research, consulting, and executive education for more than fifty corporations and other organizations. Also

New to This Edition

• After reviewing the basics, this book covers how to define and refine probability distributions in financial modeling, and exhaustively reviews the concepts behind the simulation modeling process. Also
• It includes a discussion of simulation controls and analysis of simulation results. Also
• Exercise models help students apply risk analysis to such areas as derivative pricing, cost estimation, portfolio allocation and optimization, design analysis, and cash flow analysis. Also
• The tools and techniques reviewed will help students immediately develop essential skills in the areas of areas of valuation, pricing, hedging, trading, risk management, project evaluation and portfolio management. Also

Also Get Financial Modeling with Crystal Ball and Excel by John Charnes on Traderknow.com

Visit more course:  FOREX TRADING COURSE

The same course:  Bill Williams Eduard Altmann SMB Simpler Trading Van Tharp Atlas Api Training Trading Template Sunil Mangwani Sunil Mangwani Frank Paul . Also  Market Delta Tradingacademy Simplertrading Urbanforex. Also  Candlechartscom Dan Sheridan Pipsociety  Atlas Api Training TopTradeTools Todd Mitchell Jerry Singh OpenTrader Alexandertrading Daytradingzones

Please contact email: [email protected] If you have any question.