Financial Modeling with Crystal Ball and Excel (Paperback)
John Charnes
立即出貨 (庫存=1)
買這商品的人也買了...
-
$420$378投資分析 + MATLAB 應用
-
$880$695深入淺出設計模式 (Head First Design Patterns)
-
$550$468SQL 語法範例辭典
-
$880$792深入淺出 SQL (Head First SQL)
-
$790$751基礎資料結構 ─ 使用 C (Fundamentals of Data Structures in C, 2/e)
-
$600$570Linear Algebra with Applications, 4/e (IE-Paperback)
-
$480$408PHP + Ajax 網頁模組隨學隨用
-
$890$712資料庫系統原理 (Fundamentals of Database Systems, 6/e)
-
$520$416Android 4.X 手機/平板電腦程式設計入門、應用到精通, 2/e (適用 Android 1.X~4.X)
-
$680$544ASP.NET MVC 4 網站開發美學
-
$590$460HTML5 + CSS3 + JavaScript 開發實力養成:365 個範例全方位提升你的網頁設計概念
-
$1,130$1,130超圖解 Arduino 互動設計入門 (附 Arduino UNO R3 開發板)
-
$720$698數位邏輯設計 (Mano: Digital Design, 5/e)
-
$400$380Arduino UNO R3
-
$380$342Nikon D7100 數位單眼相機完全解析
-
$680$544Java 程式設計導論(第九版) (Introduction to Java Programming : Comprehensive Version, 9/e)
-
$1,400$1,330Arduino 升級入門(進階)套件(附範例程式光碟)
-
$650$520TQC+ AutoCAD 2014 特訓教材─基礎篇 (附贈術科動態解題教學)
-
$1,300$1,235C : How to Program, 7/e (IE-Paperback)
-
$1,680$1,596Operating System Concepts, 9/e (IE-Paperback)
-
$380$304Joomla! 素人架站計畫 Power Pack-給 Joomla! 網站更強大的力量!
-
$480$408Information Architecture 100: 100 個網站規劃必備的知識
-
$380$323智慧手機 App UI‧UX 設計鐵則-想做出好用的 App 和手機網站,就看這一本 (iPhone / Android 皆適用)
-
$650$553ASP.NET 學習教材-使用 C#
-
$480$408Android App 程式設計教本之無痛起步, 2/e
商品描述
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
Table of Contents
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.