Financial modeling with Crystal Ball and Excel:
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Hoboken, NJ
Wiley
2007
|
| Series: | Wiley finance series
|
| Subjects: | |
| Online Access: | Table of contents only Inhaltsverzeichnis |
| Item Description: | Includes bibliographical references |
| Physical Description: | XVII, 269 S. Ill., graph. Darst. |
| ISBN: | 0471779725 9780471779728 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV022428207 | ||
| 003 | DE-604 | ||
| 005 | 20100322 | ||
| 007 | t | ||
| 008 | 070516s2007 xxuad|| |||| 00||| eng d | ||
| 010 | |a 2006033467 | ||
| 020 | |a 0471779725 |9 0-471-77972-5 | ||
| 020 | |a 9780471779728 |9 978-0-471-77972-8 | ||
| 035 | |a (OCoLC)72988389 | ||
| 035 | |a (DE-599)BVBBV022428207 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-355 |a DE-1102 |a DE-706 |a DE-92 |a DE-945 |a DE-M347 |a DE-20 |a DE-19 | ||
| 050 | 0 | |a HG106 | |
| 082 | 0 | |a 332.0285/554 | |
| 084 | |a QP 700 |0 (DE-625)141926: |2 rvk | ||
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 100 | 1 | |a Charnes, John M. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Financial modeling with Crystal Ball and Excel |c John Charnes |
| 264 | 1 | |a Hoboken, NJ |b Wiley |c 2007 | |
| 300 | |a XVII, 269 S. |b Ill., graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Wiley finance series | |
| 500 | |a Includes bibliographical references | ||
| 630 | 0 | 4 | |a Crystal ball (Computer file) |
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 4 | |a Mathematisches Modell | |
| 650 | 4 | |a Finance |x Mathematical models | |
| 650 | 4 | |a Investments |x Mathematical models | |
| 650 | 0 | 7 | |a Mathematisches Modell |0 (DE-588)4114528-8 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Crystal Ball |g Programm |0 (DE-588)7578858-5 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Finanzierung |0 (DE-588)4017182-6 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Finanzierung |0 (DE-588)4017182-6 |D s |
| 689 | 0 | 1 | |a Mathematisches Modell |0 (DE-588)4114528-8 |D s |
| 689 | 0 | 2 | |a EXCEL |0 (DE-588)4138932-3 |D s |
| 689 | 0 | 3 | |a Crystal Ball |g Programm |0 (DE-588)7578858-5 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | |u http://www.loc.gov/catdir/toc/ecip072/2006033467.html |3 Table of contents only | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015636437&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-015636437 | ||
Record in the Search Index
| _version_ | 1804136500084867072 |
|---|---|
| adam_text | Contents
Preface xi
Acknowledgments xv
About the Author xvl
CHAPTBH
Introduction 1
Financial Modeling 2
Risk Analysis 2
Monte Carlo Simulation 4
Risk Management 8
Benefits and Limitations of Using Crystal Ball 8
CHAPTK2
Analyzing Crystal Bal Forecasts 11
Simulating A 50 50 Portfolio 11
Varying the Allocations 21
Presenting the Results 27
CHAPTB3
Buffing a Crystal Bal MoM 28
Simulation Modeling Process 28
Defining Crystal Ball Assumptions 29
Running Crystal Ball 32
Sources of Error 33
Controlling Model Error 35
CHAPTBM
Selecting Crystal Bal Assumptions 38
Crystal Ball s Basic Distributions 36
Using Historical Data to Choose Distributions 54
Specifying Correlations 63
¥l
VW CONTENTS
CHAPTBI5
Using Decision Variables 71
Defining Decision Variables 71
Decision Table with One Decision Variable 73
Decision Table with Two Decision Variables 79
Using OptQuest 89
CHAPTER G
Selecting Run Preferences 95
Trials 95
Sampling 98
Speed 101
Options 103
Statistics 104
CHAPTER 7
Net Present Value and Internal Rate of Return 105
Deterministic NPV and IRR 105
Simulating NPV and IRR 107
Capital Budgeting 111
Customer Net Present Value 121
CHAPTER 8
Modeling Financial Statements 125
Deterministic Model 125
Tornado Chart and Sensitivity Analysis 126
Crystal Ball Sensitivity Chart 129
Conclusion 129
CHAPTER 9
Portfolio Models 132
Single Period Crystal Ball Model 132
Single Period Analytical Solution 134
Multiperiod Crystal Ball Model 135
CHAPTER 10
Value at Risk 140
VaR 140
Shortcomings of VaR 142
CVaR 142
Contents ix
CHAPTBHI
Simulating Rnancial Time Series 147
White Noise 147
Random Walk 149
Autocorrelation 150
Additive Random Walk with Drift 154
Multiplicative Random Walk Model 157
Geometric Brownian Motion Model 160
Mean Reverting Model 164
CHAPTER 12
Financial Options 170
Types of Options 170
Risk Neutral Pricing and the Black Scholes Model 171
Portfolio Insurance 174
American Option Pricing 177
Exotic Option Pricing 179
Bull Spread 183
Principal Protected Instrument 184
CHAPTER 13
Real Options 187
Financial Options and Real Options 187
Applications of ROA 188
Black Scholes Real Options Insights 191
ROVTool 193
Summary 200
Appendix A Crystal Ball s Probability Distributions 202
Appendix B Generating Assumption Values 235
Appendix C Variance Reduction Techniques 243
Appendix D About the Download 249
Glossary 251
References 255
Index 283
|
| adam_txt |
Contents
Preface xi
Acknowledgments xv
About the Author xvl
CHAPTBH
Introduction 1
Financial Modeling 2
Risk Analysis 2
Monte Carlo Simulation 4
Risk Management 8
Benefits and Limitations of Using Crystal Ball 8
CHAPTK2
Analyzing Crystal Bal Forecasts 11
Simulating A 50 50 Portfolio 11
Varying the Allocations 21
Presenting the Results 27
CHAPTB3
Buffing a Crystal Bal MoM 28
Simulation Modeling Process 28
Defining Crystal Ball Assumptions 29
Running Crystal Ball 32
Sources of Error 33
Controlling Model Error 35
CHAPTBM
Selecting Crystal Bal Assumptions 38
Crystal Ball's Basic Distributions 36
Using Historical Data to Choose Distributions 54
Specifying Correlations 63
¥l
VW CONTENTS
CHAPTBI5
Using Decision Variables 71
Defining Decision Variables 71
Decision Table with One Decision Variable 73
Decision Table with Two Decision Variables 79
Using OptQuest 89
CHAPTER G
Selecting Run Preferences 95
Trials 95
Sampling 98
Speed 101
Options 103
Statistics 104
CHAPTER 7
Net Present Value and Internal Rate of Return 105
Deterministic NPV and IRR 105
Simulating NPV and IRR 107
Capital Budgeting 111
Customer Net Present Value 121
CHAPTER 8
Modeling Financial Statements 125
Deterministic Model 125
Tornado Chart and Sensitivity Analysis 126
Crystal Ball Sensitivity Chart 129
Conclusion 129
CHAPTER 9
Portfolio Models 132
Single Period Crystal Ball Model 132
Single Period Analytical Solution 134
Multiperiod Crystal Ball Model 135
CHAPTER 10
Value at Risk 140
VaR 140
Shortcomings of VaR 142
CVaR 142
Contents ix
CHAPTBHI
Simulating Rnancial Time Series 147
White Noise 147
Random Walk 149
Autocorrelation 150
Additive Random Walk with Drift 154
Multiplicative Random Walk Model 157
Geometric Brownian Motion Model 160
Mean Reverting Model 164
CHAPTER 12
Financial Options 170
Types of Options 170
Risk Neutral Pricing and the Black Scholes Model 171
Portfolio Insurance 174
American Option Pricing 177
Exotic Option Pricing 179
Bull Spread 183
Principal Protected Instrument 184
CHAPTER 13
Real Options 187
Financial Options and Real Options 187
Applications of ROA 188
Black Scholes Real Options Insights 191
ROVTool 193
Summary 200
Appendix A Crystal Ball's Probability Distributions 202
Appendix B Generating Assumption Values 235
Appendix C Variance Reduction Techniques 243
Appendix D About the Download 249
Glossary 251
References 255
Index 283 |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Charnes, John M. |
| author_facet | Charnes, John M. |
| author_role | aut |
| author_sort | Charnes, John M. |
| author_variant | j m c jm jmc |
| building | Verbundindex |
| bvnumber | BV022428207 |
| callnumber-first | H - Social Science |
| callnumber-label | HG106 |
| callnumber-raw | HG106 |
| callnumber-search | HG106 |
| callnumber-sort | HG 3106 |
| callnumber-subject | HG - Finance |
| classification_rvk | QP 700 ST 371 |
| ctrlnum | (OCoLC)72988389 (DE-599)BVBBV022428207 |
| dewey-full | 332.0285/554 |
| dewey-hundreds | 300 - Social sciences |
| dewey-ones | 332 - Financial economics |
| dewey-raw | 332.0285/554 |
| dewey-search | 332.0285/554 |
| dewey-sort | 3332.0285 3554 |
| dewey-tens | 330 - Economics |
| discipline | Informatik Wirtschaftswissenschaften |
| discipline_str_mv | Informatik Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02168nam a2200553zc 4500</leader><controlfield tag="001">BV022428207</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20100322 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">070516s2007 xxuad|| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2006033467</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0471779725</subfield><subfield code="9">0-471-77972-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780471779728</subfield><subfield code="9">978-0-471-77972-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)72988389</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV022428207</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-355</subfield><subfield code="a">DE-1102</subfield><subfield code="a">DE-706</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-945</subfield><subfield code="a">DE-M347</subfield><subfield code="a">DE-20</subfield><subfield code="a">DE-19</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HG106</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">332.0285/554</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 700</subfield><subfield code="0">(DE-625)141926:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 371</subfield><subfield code="0">(DE-625)143672:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Charnes, John M.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Financial modeling with Crystal Ball and Excel</subfield><subfield code="c">John Charnes</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken, NJ</subfield><subfield code="b">Wiley</subfield><subfield code="c">2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVII, 269 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Wiley finance series</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Crystal ball (Computer file)</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Mathematisches Modell</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Finance</subfield><subfield code="x">Mathematical models</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Investments</subfield><subfield code="x">Mathematical models</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Mathematisches Modell</subfield><subfield code="0">(DE-588)4114528-8</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Crystal Ball</subfield><subfield code="g">Programm</subfield><subfield code="0">(DE-588)7578858-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Finanzierung</subfield><subfield code="0">(DE-588)4017182-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Finanzierung</subfield><subfield code="0">(DE-588)4017182-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Mathematisches Modell</subfield><subfield code="0">(DE-588)4114528-8</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="3"><subfield code="a">Crystal Ball</subfield><subfield code="g">Programm</subfield><subfield code="0">(DE-588)7578858-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/toc/ecip072/2006033467.html</subfield><subfield code="3">Table of contents only</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015636437&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-015636437</subfield></datafield></record></collection> |
| id | DE-604.BV022428207 |
| illustrated | Illustrated |
| index_date | 2024-07-02T17:28:15Z |
| indexdate | 2024-07-09T20:57:23Z |
| institution | BVB |
| isbn | 0471779725 9780471779728 |
| language | English |
| lccn | 2006033467 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-015636437 |
| oclc_num | 72988389 |
| open_access_boolean | |
| owner | DE-355 DE-BY-UBR DE-1102 DE-706 DE-92 DE-945 DE-M347 DE-20 DE-19 DE-BY-UBM |
| owner_facet | DE-355 DE-BY-UBR DE-1102 DE-706 DE-92 DE-945 DE-M347 DE-20 DE-19 DE-BY-UBM |
| physical | XVII, 269 S. Ill., graph. Darst. |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | Wiley |
| record_format | marc |
| series2 | Wiley finance series |
| spelling | Charnes, John M. Verfasser aut Financial modeling with Crystal Ball and Excel John Charnes Hoboken, NJ Wiley 2007 XVII, 269 S. Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Wiley finance series Includes bibliographical references Crystal ball (Computer file) Microsoft Excel (Computer file) Mathematisches Modell Finance Mathematical models Investments Mathematical models Mathematisches Modell (DE-588)4114528-8 gnd rswk-swf Crystal Ball Programm (DE-588)7578858-5 gnd rswk-swf EXCEL (DE-588)4138932-3 gnd rswk-swf Finanzierung (DE-588)4017182-6 gnd rswk-swf Finanzierung (DE-588)4017182-6 s Mathematisches Modell (DE-588)4114528-8 s EXCEL (DE-588)4138932-3 s Crystal Ball Programm (DE-588)7578858-5 s DE-604 http://www.loc.gov/catdir/toc/ecip072/2006033467.html Table of contents only HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015636437&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Charnes, John M. Financial modeling with Crystal Ball and Excel Crystal ball (Computer file) Microsoft Excel (Computer file) Mathematisches Modell Finance Mathematical models Investments Mathematical models Mathematisches Modell (DE-588)4114528-8 gnd Crystal Ball Programm (DE-588)7578858-5 gnd EXCEL (DE-588)4138932-3 gnd Finanzierung (DE-588)4017182-6 gnd |
| subject_GND | (DE-588)4114528-8 (DE-588)7578858-5 (DE-588)4138932-3 (DE-588)4017182-6 |
| title | Financial modeling with Crystal Ball and Excel |
| title_auth | Financial modeling with Crystal Ball and Excel |
| title_exact_search | Financial modeling with Crystal Ball and Excel |
| title_exact_search_txtP | Financial modeling with Crystal Ball and Excel |
| title_full | Financial modeling with Crystal Ball and Excel John Charnes |
| title_fullStr | Financial modeling with Crystal Ball and Excel John Charnes |
| title_full_unstemmed | Financial modeling with Crystal Ball and Excel John Charnes |
| title_short | Financial modeling with Crystal Ball and Excel |
| title_sort | financial modeling with crystal ball and excel |
| topic | Crystal ball (Computer file) Microsoft Excel (Computer file) Mathematisches Modell Finance Mathematical models Investments Mathematical models Mathematisches Modell (DE-588)4114528-8 gnd Crystal Ball Programm (DE-588)7578858-5 gnd EXCEL (DE-588)4138932-3 gnd Finanzierung (DE-588)4017182-6 gnd |
| topic_facet | Crystal ball (Computer file) Microsoft Excel (Computer file) Mathematisches Modell Finance Mathematical models Investments Mathematical models Crystal Ball Programm EXCEL Finanzierung |
| url | http://www.loc.gov/catdir/toc/ecip072/2006033467.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015636437&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT charnesjohnm financialmodelingwithcrystalballandexcel |