Financial Modeling with Crystal Ball and Excel (eBook)

(Autor)

eBook Download: PDF
2007 | 1. Auflage
448 Seiten
John Wiley & Sons (Verlag)
978-0-470-12993-7 (ISBN)

Lese- und Medienproben

Financial Modeling with Crystal Ball and Excel - John Charnes
Systemvoraussetzungen
51,99 inkl. MwSt
  • Download sofort lieferbar
  • Zahlungsarten anzeigen
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

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.

Preface.

Acknowledgments.

About the Author.

Chapter 1: Introduction.

Financial Modeling.

Risk Analysis.

Monte Carlo Simulation.

Risk Management.

Benefits and Limitations of Using Crystal Ball.

Chapter 2: Analyzing Crystal Ball Forecasts.

Simulating A 50-50 Portfolio.

Varying the Allocations.

Presenting the Results.

Chapter 3: Building a Crystal Ball Model.

Simulation Modeling Process.

Defining Crystal Ball Assumptions.

Running Crystal Ball.

Sources of Error.

Controlling Model Error.

Chapter 4: Selecting Crystal Ball Assumptions.

Crystal Ball's Basic Distributions.

Using Historical Data to Choose Distributions.

Specifying Correlations.

Chapter 5: Using Decision Variables.

Defining Decision Variables.

Decision Table with One Decision Variable.

Decision Table with Two Decision Variables.

Using OptQuest.

Chapter 6: Selecting Run Preferences.

Trials.

Sampling.

Speed.

Options.

Statistics.

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

Deterministic NPV and IRR.

Simulating NPV and IRR.

Capital Budgeting.

Customer Net Present Value.

Chapter 8: Modeling Financial Statements.

Deterministic Model.

Tornado Chart and Sensitivity Analysis.

Crystal Ball Sensitivity Chart.

Conclusion.

Chapter 9: Portfolio Models.

Single-Period Crystal Ball Model.

Single-Period Analytical Solution.

Multiperiod Crystal Ball Model.

Chapter 10: Value at Risk.

VaR.

Shortcomings of VaR.

CVaR.

Chapter 11: Simulating Financial Time Series.

White Noise.

Random Walk.

Autocorrelation.

Additive Random Walk with Drift.

Multiplicative Random Walk Model.

Geometric Brownian Motion Model.

Mean-Reverting Model.

Chapter 12: Financial Options.

Types of Options.

Risk-Neutral Pricing and the Black-Scholes Model.

Portfolio Insurance.

American Option Pricing.

Exotic Option Pricing.

Bull Spread.

Principal-Protected Instrument.

Chapter 13: Real Options.

Financial Options and Real Options.

Applications of ROA.

Black-Scholes Real Options Insights.

ROV Tool.

Summary.

Appendix A: Crystal Ball's Probability Distributions.

Appendix B: Generating Assumption Values.

Appendix C: Variance Reduction Techniques.

Appendix D: About the Download.

Glossary.

References.

Index.

Erscheint lt. Verlag 5.7.2007
Reihe/Serie Wiley Finance Editions
Wiley Finance Editions
Sprache englisch
Themenwelt Informatik Grafik / Design Digitale Bildverarbeitung
Recht / Steuern Wirtschaftsrecht
Wirtschaft Betriebswirtschaft / Management Finanzierung
Schlagworte Finance & Investments • Finanz- u. Anlagewesen • Investments & Securities • Kapitalanlage • Kapitalanlagen u. Wertpapiere
ISBN-10 0-470-12993-X / 047012993X
ISBN-13 978-0-470-12993-7 / 9780470129937
Haben Sie eine Frage zum Produkt?
PDFPDF (Adobe DRM)
Größe: 3,6 MB

Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM

Dateiformat: PDF (Portable Document Format)
Mit einem festen Seiten­layout eignet sich die PDF besonders für Fach­bücher mit Spalten, Tabellen und Abbild­ungen. Eine PDF kann auf fast allen Geräten ange­zeigt werden, ist aber für kleine Displays (Smart­phone, eReader) nur einge­schränkt geeignet.

Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine Adobe-ID und die Software Adobe Digital Editions (kostenlos). Von der Benutzung der OverDrive Media Console raten wir Ihnen ab. Erfahrungsgemäß treten hier gehäuft Probleme mit dem Adobe DRM auf.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine Adobe-ID sowie eine kostenlose App.
Geräteliste und zusätzliche Hinweise

Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.

Mehr entdecken
aus dem Bereich
Discover the smart way to polish your digital imagery skills by …

von Gary Bradley

eBook Download (2024)
Packt Publishing (Verlag)
29,99
Explore powerful modeling and character creation techniques used for …

von Lukas Kutschera

eBook Download (2024)
Packt Publishing (Verlag)
43,19
Generate creative images from text prompts and seamlessly integrate …

von Margarida Barreto

eBook Download (2024)
Packt Publishing (Verlag)
32,39