Structured finance modeling with object-oriented VBA:
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Hoboken, NJ
John Wiley & Sons, Inc.
c2007
|
| Series: | Wiley finance series
|
| Subjects: | |
| Online Access: | Table of contents only Inhaltsverzeichnis |
| Item Description: | Includes bibliographical references and index |
| Physical Description: | XIX, 332 p. graph. Darst. |
| ISBN: | 9780470098592 0470098597 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV022535205 | ||
| 003 | DE-604 | ||
| 005 | 20070820 | ||
| 007 | t | ||
| 008 | 070730s2007 xxud||| |||| 00||| eng d | ||
| 010 | |a 2006032748 | ||
| 020 | |a 9780470098592 |9 978-0-470-09859-2 | ||
| 020 | |a 0470098597 |c cloth |9 0-470-09859-7 | ||
| 035 | |a (OCoLC)72353834 | ||
| 035 | |a (DE-599)BVBBV022535205 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-1049 | ||
| 050 | 0 | |a HG106 | |
| 082 | 0 | |a 332.01/13 | |
| 100 | 1 | |a Tick, Evan |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Structured finance modeling with object-oriented VBA |c Evan Tick |
| 264 | 1 | |a Hoboken, NJ |b John Wiley & Sons, Inc. |c c2007 | |
| 300 | |a XIX, 332 p. |b 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 and index | ||
| 630 | 0 | 4 | |a Microsoft Visual Basic for applications |
| 650 | 4 | |a Microsoft Visual Basic for applications | |
| 650 | 4 | |a Finances - Modèles mathématiques | |
| 650 | 4 | |a Investissements - Modèles mathématiques | |
| 650 | 4 | |a Mathematisches Modell | |
| 650 | 4 | |a Finance |x Mathematical models | |
| 650 | 4 | |a Investments |x Mathematical models | |
| 856 | 4 | |u http://www.loc.gov/catdir/toc/ecip072/2006032748.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=015741725&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-015741725 | ||
Record in the Search Index
| _version_ | 1804136646266847232 |
|---|---|
| adam_text | Contents
Preface xi
List of Acronyms xv
Acknowledgments xvN
About the Author xix
CHAPTHti
Cash-How Structures 1
1.1 Getting Started 1
1.2 Securitization 3
1.3 Synthetic Structures 10
1.4 Putting It All Together 13
CHAPTK2
IB
2.1 Dipping a Toe in the Shallow End 17
2.2 Swimming Toward the Deep End 22
2.3 Types 29
2.4 Class Architecture 33
2.4.1 Weak Inheritance 37
2.4.2 Parameterized Class 42
2.4.3 Which Is Better? 43
2.5 Exercises 46
CHAPTK3
Assets 48
3.1 Replines 49
3.2 Portfolio Optimization 52
3.2.1 Zero-One Program 53
3.2.2 Simulated Annealing 56
VI
VW CONTENTS
60
61
63
66
74
75
77
80
82
84
86
89
94
94
98
102
108
110
116
4.5.1 Current Subordinated Amount 116
4.5.2 StepdownDate 118
4.5.3 Target Subordinated Amount 119
4.6 Principal 122
4.6.1 Gross Principal Distributions 122
4.6.2 Detailed Principal Distributions 124
4.7 Writedowns and Recoveries 128
4.8 Derivatives 130
4.8.1 Corridors 132
4.8.2 Swaps 134
4.8.3 Excess Reserve Fund Account 135
4.9 Triggers 137
4.9.1 Call Features 138
4.9.2 Overcollateralization Test 138
4.9.3 Interest Coverage Test 139
4.9.4 Delinquency Trigger 140
4.9.5 Loss Trigger 141
4.10 Residuals: NIMs and Post-NIM 141
4.11 Class Architecture 144
4.11.1 Passive Approach 144
3.3 Losses, Prepayments, and Interest Rates
3.4 Cash-Flow Model
3.4.1 Zero-Prepay Cash Flows
3.4.2 Actual Cash Flows
3.4.3 Examples
3.5 S P Cash-Flow Model
3.5.1 Model Parameters
3.6 Moody s Cash-Flow Model
3.6.1 Model Parameters
3.6.2 Algorithm
3.7 Option ARMs
3.8 Class Architecture: Multiple Inheritance
3.9 Doing It in Excel: SumProduct
3.10 1 Exercises
CHAPTK4
Uabflitfes
4.1 Getting Started
4.2 Notation
4.3 Expenses
4.4 Interest
4.5 Over-collateralization
Contents_______________________________________________________________jx
4.11.2 Active Approach 158
4.11.3 Comparison 170
4.12 Doing It in Excel: Data Tables 170
4.13 Exercises 176
179
182
185
190
192
196
198
203
203
207
210
213
217
6.1 Risk Factors 217
6.1.1 Prefunding 217
6.1.2 Prepayments 217
6.1.3 Buybacks and Cleanup Calls 219
6.1.4 Defaults 219
6.1.5 Interest Rates 221
6.1.6 Spreads 221
6.1.7 Miscellaneous 222
6.1.8 Residual Sensitivities 222
6.2 Mezzanine and Subordinate Classes 223
6.3 MM Classes 230
6.4 Putting It All Together 232
6.5 Exercises 234
CHAPTER 7
Stochastic Models 235
7.1 Static versus Stochastic 235
7.2 Loss Model 238
7.2.1 Probability of Default from Transition Matrix 238
7.2.2 Probability of Default from Spread 241
7.2.3 Probability of Time to Default 242
CHAPTER 5
Sizing the Structure
5.1 Senior Sizing
5.2 Subordinate Sizing
5.2.1 Fully Funded vs. Non-Fully Funded
5.3 Optimizations and Complexity
5.4 Example of Sizing
5.5 NIM and OTE Sizing
5.6 Class Architecture
5.6.1 Inheritance Revisited
5.6.2 Odds and Ends
5.7 Doing It in Excel: Solver
5.8 Exercises
CHAPTER G
Analysis
7.3 Gaussian Copula
7.4 Monte Carlo Simulation
7.5 Synthetic Credit Indexes
7.5.1 Loss Lets
7.5.2 Analysis
7.5.3 Hedging
7.6 Doing It in Excel
7.7 Exercises
Appendix A
Excel and VBA
A.I Spreadsheet Style
A.2 Code Style
A.3 Compilation
A.4 Bloomberg
Appendix B
Bond Math
B.I Mortgage Payment
B.2 Yield to Price
B.3 Price to Yield
B.4 Duration
B.4.1 Index or Interest-Rate Duration
B.4.2 Discount Spread Duration
B.5 Hazard Rate
B.6 Static Credit Card Model
References
Index
CONTENTS
244
249
251
253
256
264
270
279
285
286
290
295
299
303
305
306
307
308
308
312
315
321
325
|
| adam_txt |
Contents
Preface xi
List of Acronyms xv
Acknowledgments xvN
About the Author xix
CHAPTHti
Cash-How Structures 1
1.1 Getting Started 1
1.2 Securitization 3
1.3 Synthetic Structures 10
1.4 Putting It All Together 13
CHAPTK2
IB
2.1 Dipping a Toe in the Shallow End 17
2.2 Swimming Toward the Deep End 22
2.3 Types 29
2.4 Class Architecture 33
2.4.1 Weak Inheritance 37
2.4.2 Parameterized Class 42
2.4.3 Which Is Better? 43
2.5 Exercises 46
CHAPTK3
Assets 48
3.1 Replines 49
3.2 Portfolio Optimization 52
3.2.1 Zero-One Program 53
3.2.2 Simulated Annealing 56
VI
VW CONTENTS
60
61
63
66
74
75
77
80
82
84
86
89
94
94
98
102
108
110
116
4.5.1 Current Subordinated Amount 116
4.5.2 StepdownDate 118
4.5.3 Target Subordinated Amount 119
4.6 Principal 122
4.6.1 Gross Principal Distributions 122
4.6.2 Detailed Principal Distributions 124
4.7 Writedowns and Recoveries 128
4.8 Derivatives 130
4.8.1 Corridors 132
4.8.2 Swaps 134
4.8.3 Excess Reserve Fund Account 135
4.9 Triggers 137
4.9.1 Call Features 138
4.9.2 Overcollateralization Test 138
4.9.3 Interest Coverage Test 139
4.9.4 Delinquency Trigger 140
4.9.5 Loss Trigger 141
4.10 Residuals: NIMs and Post-NIM 141
4.11 Class Architecture 144
4.11.1 Passive Approach 144
3.3 Losses, Prepayments, and Interest Rates
3.4 Cash-Flow Model
3.4.1 Zero-Prepay Cash Flows
3.4.2 Actual Cash Flows
3.4.3 Examples
3.5 S P Cash-Flow Model
3.5.1 Model Parameters
3.6 Moody's Cash-Flow Model
3.6.1 Model Parameters
3.6.2 Algorithm
3.7 Option ARMs
3.8 Class Architecture: Multiple Inheritance
3.9 Doing It in Excel: SumProduct
3.10 1 Exercises
CHAPTK4
Uabflitfes
4.1 Getting Started
4.2 Notation
4.3 Expenses
4.4 Interest
4.5 Over-collateralization
Contents_jx
4.11.2 Active Approach 158
4.11.3 Comparison 170
4.12 Doing It in Excel: Data Tables 170
4.13 Exercises 176
179
182
185
190
192
196
198
203
203
207
210
213
217
6.1 Risk Factors 217
6.1.1 Prefunding 217
6.1.2 Prepayments 217
6.1.3 Buybacks and Cleanup Calls 219
6.1.4 Defaults 219
6.1.5 Interest Rates 221
6.1.6 Spreads 221
6.1.7 Miscellaneous 222
6.1.8 Residual Sensitivities 222
6.2 Mezzanine and Subordinate Classes 223
6.3 MM Classes 230
6.4 Putting It All Together 232
6.5 Exercises 234
CHAPTER 7
Stochastic Models 235
7.1 Static versus Stochastic 235
7.2 Loss Model 238
7.2.1 Probability of Default from Transition Matrix 238
7.2.2 Probability of Default from Spread 241
7.2.3 Probability of Time to Default 242
CHAPTER 5
Sizing the Structure
5.1 Senior Sizing
5.2 Subordinate Sizing
5.2.1 Fully Funded vs. Non-Fully Funded
5.3 Optimizations and Complexity
5.4 Example of Sizing
5.5 NIM and OTE Sizing
5.6 Class Architecture
5.6.1 Inheritance Revisited
5.6.2 Odds and Ends
5.7 Doing It in Excel: Solver
5.8 Exercises
CHAPTER G
Analysis
7.3 Gaussian Copula
7.4 Monte Carlo Simulation
7.5 Synthetic Credit Indexes
7.5.1 Loss Lets
7.5.2 Analysis
7.5.3 Hedging
7.6 Doing It in Excel
7.7 Exercises
Appendix A
Excel and VBA
A.I Spreadsheet Style
A.2 Code Style
A.3 Compilation
A.4 Bloomberg
Appendix B
Bond Math
B.I Mortgage Payment
B.2 Yield to Price
B.3 Price to Yield
B.4 Duration
B.4.1 Index or Interest-Rate Duration
B.4.2 Discount Spread Duration
B.5 Hazard Rate
B.6 Static Credit Card Model
References
Index
CONTENTS
244
249
251
253
256
264
270
279
285
286
290
295
299
303
305
306
307
308
308
312
315
321
325 |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Tick, Evan |
| author_facet | Tick, Evan |
| author_role | aut |
| author_sort | Tick, Evan |
| author_variant | e t et |
| building | Verbundindex |
| bvnumber | BV022535205 |
| callnumber-first | H - Social Science |
| callnumber-label | HG106 |
| callnumber-raw | HG106 |
| callnumber-search | HG106 |
| callnumber-sort | HG 3106 |
| callnumber-subject | HG - Finance |
| ctrlnum | (OCoLC)72353834 (DE-599)BVBBV022535205 |
| dewey-full | 332.01/13 |
| dewey-hundreds | 300 - Social sciences |
| dewey-ones | 332 - Financial economics |
| dewey-raw | 332.01/13 |
| dewey-search | 332.01/13 |
| dewey-sort | 3332.01 213 |
| dewey-tens | 330 - Economics |
| discipline | Wirtschaftswissenschaften |
| discipline_str_mv | Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01672nam a2200445zc 4500</leader><controlfield tag="001">BV022535205</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20070820 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">070730s2007 xxud||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2006032748</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780470098592</subfield><subfield code="9">978-0-470-09859-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0470098597</subfield><subfield code="c">cloth</subfield><subfield code="9">0-470-09859-7</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)72353834</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV022535205</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-1049</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HG106</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">332.01/13</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Tick, Evan</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Structured finance modeling with object-oriented VBA</subfield><subfield code="c">Evan Tick</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken, NJ</subfield><subfield code="b">John Wiley & Sons, Inc.</subfield><subfield code="c">c2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIX, 332 p.</subfield><subfield code="b">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 and index</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Visual Basic for applications</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Visual Basic for applications</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Finances - Modèles mathématiques</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Investissements - Modèles mathématiques</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="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/toc/ecip072/2006032748.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=015741725&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-015741725</subfield></datafield></record></collection> |
| id | DE-604.BV022535205 |
| illustrated | Illustrated |
| index_date | 2024-07-02T18:07:58Z |
| indexdate | 2024-07-09T20:59:42Z |
| institution | BVB |
| isbn | 9780470098592 0470098597 |
| language | English |
| lccn | 2006032748 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-015741725 |
| oclc_num | 72353834 |
| open_access_boolean | |
| owner | DE-1049 |
| owner_facet | DE-1049 |
| physical | XIX, 332 p. graph. Darst. |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | John Wiley & Sons, Inc. |
| record_format | marc |
| series2 | Wiley finance series |
| spelling | Tick, Evan Verfasser aut Structured finance modeling with object-oriented VBA Evan Tick Hoboken, NJ John Wiley & Sons, Inc. c2007 XIX, 332 p. graph. Darst. txt rdacontent n rdamedia nc rdacarrier Wiley finance series Includes bibliographical references and index Microsoft Visual Basic for applications Finances - Modèles mathématiques Investissements - Modèles mathématiques Mathematisches Modell Finance Mathematical models Investments Mathematical models http://www.loc.gov/catdir/toc/ecip072/2006032748.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=015741725&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Tick, Evan Structured finance modeling with object-oriented VBA Microsoft Visual Basic for applications Finances - Modèles mathématiques Investissements - Modèles mathématiques Mathematisches Modell Finance Mathematical models Investments Mathematical models |
| title | Structured finance modeling with object-oriented VBA |
| title_auth | Structured finance modeling with object-oriented VBA |
| title_exact_search | Structured finance modeling with object-oriented VBA |
| title_exact_search_txtP | Structured finance modeling with object-oriented VBA |
| title_full | Structured finance modeling with object-oriented VBA Evan Tick |
| title_fullStr | Structured finance modeling with object-oriented VBA Evan Tick |
| title_full_unstemmed | Structured finance modeling with object-oriented VBA Evan Tick |
| title_short | Structured finance modeling with object-oriented VBA |
| title_sort | structured finance modeling with object oriented vba |
| topic | Microsoft Visual Basic for applications Finances - Modèles mathématiques Investissements - Modèles mathématiques Mathematisches Modell Finance Mathematical models Investments Mathematical models |
| topic_facet | Microsoft Visual Basic for applications Finances - Modèles mathématiques Investissements - Modèles mathématiques Mathematisches Modell Finance Mathematical models Investments Mathematical models |
| url | http://www.loc.gov/catdir/toc/ecip072/2006032748.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015741725&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT tickevan structuredfinancemodelingwithobjectorientedvba |