Structured finance modeling with object-oriented VBA:
Gespeichert in:
1. Verfasser: | |
---|---|
Format: | Elektronisch E-Book |
Sprache: | English |
Veröffentlicht: |
Hoboken, N.J.
John Wiley & Sons
©2007
|
Schriftenreihe: | Wiley finance series
|
Schlagworte: | |
Online-Zugang: | Volltext |
Beschreibung: | Includes bibliographical references (pages 321-324) and index Cover -- Structured Finance Modeling with Object-Oriented VBA. TOContents -- Preface -- List of Acronyms -- Acknowledgments -- About the Author -- CHhapter 1: Cash-Flow Structures -- Modeling / 1.1 GETTING STARTED. 1.2 SECURITIZATION. 1.3 SYNTHETIC STRUCTURES. 1.4 PUTTING IT ALL TOGETHER. CHhapter 2 -- Assets / 2.1 DIPPING A TOE IN THE SHALLOW END. 2.2 SWIMMING TOWARD THE DEEP END. 2.3 TYPES. 2.4 CLASS ARCHITECTURE. 2.5 EXERCISES. CHhapter 3 -- MULTIPLE INHERITANCE. 3.9 DOING IT IN EXCEL: SUMPRODUCT. 3.10 EXERCISES. CHhapter 4: Liabilities / 3.1 REPLINES. 3.2 PORTFOLIO OPTIMIZATION. 3.3 LOSSES, PREPAYMENTS, AND INTEREST RATES. 3.4 CASH-FLOW MODEL. 3.5 S & P CASH-FLOW MODEL. 3.6 MOODY'S CASH-FLOW MODEL. 3.7 OPTION ARMS. 3.8 CLASS ARCHITECTURE -- NIMS AND POST-NIM. 4.11 CLASS ARCHITECTURE. 4.12 DOING IT IN EXCEL: DATA TABLES. 4.13 EXERCISES. CHhapter 5: Sizing the Structure / 4.1 GETTING STARTED. 4.2 NOTATION. 4.3 EXPENSES. 4.4 INTEREST. 4.5 OVER-COLLATERALIZATION. 4.6 PRINCIPAL. 4.7 WRITEDOWNS AND RECOVERIES. 4.8 DERIVATIVES. 4.9 TRIGGERS. 4.10 RESIDUALS -- SOLVER. 5.8 EXERCISES. CHhapter 6: Analysis / 5.1 SENIOR SIZING. 5.2 SUBORDINATE SIZING. 5.3 OPTIMIZATIONS AND COMPLEXITY. 5.4 EXAMPLE OF SIZING. 5.5 NIM AND OTE SIZING. 5.6 CLASS ARCHITECTURE. 5.7 DOING IT IN EXCEL -- Stochastic Models / 6.1 RISK FACTORS. 6.2 MEZZANINE AND SUBORDINATE CLASSES. 6.3 NIM CLASSES. 6.4 PUTTING IT ALL TOGETHER. 6.5 EXERCISES. CHhapter 7 -- Excel and VBA. A. 1 SPREADSHEET STYLE. A. 2 CODE STYLE. A. 3 COMPILATION. A. 4 BLOOMBERG. Appendix B: Bond Math / 7.1 STATIC VERSUS STOCHASTIC. 7.2 LOSS MODEL. 7.3 GAUSSIAN COPULA. 7.4 MONTE CARLO SIMULATION. 7.5 SYNTHETIC CREDIT INDEXES. 7.6 DOING IT IN EXCEL. 7.7 EXERCISES. Appendix A -- B. 1 MORTGAGE PAYMENT. B. 2 YIELD TO PRICE. B. 3 PRICE TO YIELD. B. 4 DURATION. B. 5 HAZARD RATE. B. 6 STATIC CREDIT CARD MODEL. References -- IDXndex -- Last Page "Structured Finance Modeling with Object-Oriented VBA introduces this model and its implementation, providing illustrations of the model in action for actual deals, along with empirical studies of its sensitivities. Using sub-prime mortgage securitization throughout the book as a unifying example, it provides a detailed look at how object-oriented Visual Basic for Applications (VBA) can be used to price complex financial structures." "Along with securitization, this book covers stochastic models, optimization techniques, object-oriented architecture, and more. Wall Street analysts and MBA students mastering object-oriented VBA programming skills are in great demand on Wall Street, and a step ahead of those without these skills. This invaluable guide provides both the mathematical specifications and programming techniques needed to perform modeling tasks efficiently and effectively - and keep ahead of the competition."--Jacket |
Beschreibung: | 1 Online-Ressource (xix, 332 pages) |
ISBN: | 9780470130414 0470130415 |
Internformat
MARC
LEADER | 00000nmm a2200000zc 4500 | ||
---|---|---|---|
001 | BV042967145 | ||
003 | DE-604 | ||
005 | 00000000000000.0 | ||
007 | cr|uuu---uuuuu | ||
008 | 151030s2007 |||| o||u| ||||||eng d | ||
020 | |a 9780470130414 |c electronic bk. |9 978-0-470-13041-4 | ||
020 | |a 0470130415 |c electronic bk. |9 0-470-13041-5 | ||
035 | |a (OCoLC)133491102 | ||
035 | |a (DE-599)BVBBV042967145 | ||
040 | |a DE-604 |b ger |e aacr | ||
041 | 0 | |a eng | |
049 | |a DE-1046 |a DE-1047 | ||
082 | 0 | |a 332.01/13 |2 22 | |
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, N.J. |b John Wiley & Sons |c ©2007 | |
300 | |a 1 Online-Ressource (xix, 332 pages) | ||
336 | |b txt |2 rdacontent | ||
337 | |b c |2 rdamedia | ||
338 | |b cr |2 rdacarrier | ||
490 | 0 | |a Wiley finance series | |
500 | |a Includes bibliographical references (pages 321-324) and index | ||
500 | |a Cover -- Structured Finance Modeling with Object-Oriented VBA. TOContents -- Preface -- List of Acronyms -- Acknowledgments -- About the Author -- CHhapter 1: Cash-Flow Structures -- Modeling / 1.1 GETTING STARTED. 1.2 SECURITIZATION. 1.3 SYNTHETIC STRUCTURES. 1.4 PUTTING IT ALL TOGETHER. CHhapter 2 -- Assets / 2.1 DIPPING A TOE IN THE SHALLOW END. 2.2 SWIMMING TOWARD THE DEEP END. 2.3 TYPES. 2.4 CLASS ARCHITECTURE. 2.5 EXERCISES. CHhapter 3 -- MULTIPLE INHERITANCE. 3.9 DOING IT IN EXCEL: SUMPRODUCT. 3.10 EXERCISES. CHhapter 4: Liabilities / 3.1 REPLINES. 3.2 PORTFOLIO OPTIMIZATION. 3.3 LOSSES, PREPAYMENTS, AND INTEREST RATES. 3.4 CASH-FLOW MODEL. 3.5 S & P CASH-FLOW MODEL. 3.6 MOODY'S CASH-FLOW MODEL. 3.7 OPTION ARMS. 3.8 CLASS ARCHITECTURE -- NIMS AND POST-NIM. 4.11 CLASS ARCHITECTURE. 4.12 DOING IT IN EXCEL: DATA TABLES. 4.13 EXERCISES. CHhapter 5: Sizing the Structure / 4.1 GETTING STARTED. 4.2 NOTATION. 4.3 EXPENSES. 4.4 INTEREST. 4.5 OVER-COLLATERALIZATION. 4.6 PRINCIPAL. 4.7 WRITEDOWNS AND RECOVERIES. 4.8 DERIVATIVES. 4.9 TRIGGERS. 4.10 RESIDUALS -- SOLVER. 5.8 EXERCISES. CHhapter 6: Analysis / 5.1 SENIOR SIZING. 5.2 SUBORDINATE SIZING. 5.3 OPTIMIZATIONS AND COMPLEXITY. 5.4 EXAMPLE OF SIZING. 5.5 NIM AND OTE SIZING. 5.6 CLASS ARCHITECTURE. 5.7 DOING IT IN EXCEL -- Stochastic Models / 6.1 RISK FACTORS. 6.2 MEZZANINE AND SUBORDINATE CLASSES. 6.3 NIM CLASSES. 6.4 PUTTING IT ALL TOGETHER. 6.5 EXERCISES. CHhapter 7 -- Excel and VBA. A. 1 SPREADSHEET STYLE. A. 2 CODE STYLE. A. 3 COMPILATION. A. 4 BLOOMBERG. Appendix B: Bond Math / 7.1 STATIC VERSUS STOCHASTIC. 7.2 LOSS MODEL. 7.3 GAUSSIAN COPULA. 7.4 MONTE CARLO SIMULATION. 7.5 SYNTHETIC CREDIT INDEXES. 7.6 DOING IT IN EXCEL. 7.7 EXERCISES. Appendix A -- B. 1 MORTGAGE PAYMENT. B. 2 YIELD TO PRICE. B. 3 PRICE TO YIELD. B. 4 DURATION. B. 5 HAZARD RATE. B. 6 STATIC CREDIT CARD MODEL. References -- IDXndex -- Last Page | ||
500 | |a "Structured Finance Modeling with Object-Oriented VBA introduces this model and its implementation, providing illustrations of the model in action for actual deals, along with empirical studies of its sensitivities. Using sub-prime mortgage securitization throughout the book as a unifying example, it provides a detailed look at how object-oriented Visual Basic for Applications (VBA) can be used to price complex financial structures." "Along with securitization, this book covers stochastic models, optimization techniques, object-oriented architecture, and more. Wall Street analysts and MBA students mastering object-oriented VBA programming skills are in great demand on Wall Street, and a step ahead of those without these skills. This invaluable guide provides both the mathematical specifications and programming techniques needed to perform modeling tasks efficiently and effectively - and keep ahead of the competition."--Jacket | ||
630 | 0 | 4 | |a Microsoft Visual Basic for applications |
650 | 4 | |a Microsoft Visual Basic for applications | |
650 | 7 | |a BUSINESS & ECONOMICS / Finance |2 bisacsh | |
650 | 7 | |a Microsoft Visual Basic for applications |2 fast | |
650 | 7 | |a Finance / Mathematical models |2 fast | |
650 | 7 | |a Investments / Mathematical models |2 fast | |
650 | 4 | |a Mathematisches Modell | |
650 | 4 | |a Wirtschaft | |
650 | 4 | |a Finance |x Mathematical models | |
650 | 4 | |a Investments |x Mathematical models | |
776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe, Hardcover |z 978-0-470-09859-2 |
776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe, Hardcover |z 0-470-09859-7 |
856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=191459 |x Aggregator |3 Volltext |
912 | |a ZDB-4-EBA |a ZDB-4-EBU | ||
940 | 1 | |q FAW_PDA_EBA | |
940 | 1 | |q FLA_PDA_EBU | |
999 | |a oai:aleph.bib-bvb.de:BVB01-028393013 |
Datensatz im Suchindex
_version_ | 1804175294150475776 |
---|---|
any_adam_object | |
author | Tick, Evan |
author_facet | Tick, Evan |
author_role | aut |
author_sort | Tick, Evan |
author_variant | e t et |
building | Verbundindex |
bvnumber | BV042967145 |
collection | ZDB-4-EBA ZDB-4-EBU |
ctrlnum | (OCoLC)133491102 (DE-599)BVBBV042967145 |
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 |
format | Electronic eBook |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>04726nmm a2200517zc 4500</leader><controlfield tag="001">BV042967145</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151030s2007 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780470130414</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-0-470-13041-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0470130415</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">0-470-13041-5</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)133491102</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV042967145</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="049" ind1=" " ind2=" "><subfield code="a">DE-1046</subfield><subfield code="a">DE-1047</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">332.01/13</subfield><subfield code="2">22</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, N.J.</subfield><subfield code="b">John Wiley & Sons</subfield><subfield code="c">©2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xix, 332 pages)</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">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</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 (pages 321-324) and index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Cover -- Structured Finance Modeling with Object-Oriented VBA. TOContents -- Preface -- List of Acronyms -- Acknowledgments -- About the Author -- CHhapter 1: Cash-Flow Structures -- Modeling / 1.1 GETTING STARTED. 1.2 SECURITIZATION. 1.3 SYNTHETIC STRUCTURES. 1.4 PUTTING IT ALL TOGETHER. CHhapter 2 -- Assets / 2.1 DIPPING A TOE IN THE SHALLOW END. 2.2 SWIMMING TOWARD THE DEEP END. 2.3 TYPES. 2.4 CLASS ARCHITECTURE. 2.5 EXERCISES. CHhapter 3 -- MULTIPLE INHERITANCE. 3.9 DOING IT IN EXCEL: SUMPRODUCT. 3.10 EXERCISES. CHhapter 4: Liabilities / 3.1 REPLINES. 3.2 PORTFOLIO OPTIMIZATION. 3.3 LOSSES, PREPAYMENTS, AND INTEREST RATES. 3.4 CASH-FLOW MODEL. 3.5 S & P CASH-FLOW MODEL. 3.6 MOODY'S CASH-FLOW MODEL. 3.7 OPTION ARMS. 3.8 CLASS ARCHITECTURE -- NIMS AND POST-NIM. 4.11 CLASS ARCHITECTURE. 4.12 DOING IT IN EXCEL: DATA TABLES. 4.13 EXERCISES. CHhapter 5: Sizing the Structure / 4.1 GETTING STARTED. 4.2 NOTATION. 4.3 EXPENSES. 4.4 INTEREST. 4.5 OVER-COLLATERALIZATION. 4.6 PRINCIPAL. 4.7 WRITEDOWNS AND RECOVERIES. 4.8 DERIVATIVES. 4.9 TRIGGERS. 4.10 RESIDUALS -- SOLVER. 5.8 EXERCISES. CHhapter 6: Analysis / 5.1 SENIOR SIZING. 5.2 SUBORDINATE SIZING. 5.3 OPTIMIZATIONS AND COMPLEXITY. 5.4 EXAMPLE OF SIZING. 5.5 NIM AND OTE SIZING. 5.6 CLASS ARCHITECTURE. 5.7 DOING IT IN EXCEL -- Stochastic Models / 6.1 RISK FACTORS. 6.2 MEZZANINE AND SUBORDINATE CLASSES. 6.3 NIM CLASSES. 6.4 PUTTING IT ALL TOGETHER. 6.5 EXERCISES. CHhapter 7 -- Excel and VBA. A. 1 SPREADSHEET STYLE. A. 2 CODE STYLE. A. 3 COMPILATION. A. 4 BLOOMBERG. Appendix B: Bond Math / 7.1 STATIC VERSUS STOCHASTIC. 7.2 LOSS MODEL. 7.3 GAUSSIAN COPULA. 7.4 MONTE CARLO SIMULATION. 7.5 SYNTHETIC CREDIT INDEXES. 7.6 DOING IT IN EXCEL. 7.7 EXERCISES. Appendix A -- B. 1 MORTGAGE PAYMENT. B. 2 YIELD TO PRICE. B. 3 PRICE TO YIELD. B. 4 DURATION. B. 5 HAZARD RATE. B. 6 STATIC CREDIT CARD MODEL. References -- IDXndex -- Last Page</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">"Structured Finance Modeling with Object-Oriented VBA introduces this model and its implementation, providing illustrations of the model in action for actual deals, along with empirical studies of its sensitivities. Using sub-prime mortgage securitization throughout the book as a unifying example, it provides a detailed look at how object-oriented Visual Basic for Applications (VBA) can be used to price complex financial structures." "Along with securitization, this book covers stochastic models, optimization techniques, object-oriented architecture, and more. Wall Street analysts and MBA students mastering object-oriented VBA programming skills are in great demand on Wall Street, and a step ahead of those without these skills. This invaluable guide provides both the mathematical specifications and programming techniques needed to perform modeling tasks efficiently and effectively - and keep ahead of the competition."--Jacket</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="7"><subfield code="a">BUSINESS & ECONOMICS / Finance</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Microsoft Visual Basic for applications</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Finance / Mathematical models</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Investments / Mathematical models</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Mathematisches Modell</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Wirtschaft</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="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe, Hardcover</subfield><subfield code="z">978-0-470-09859-2</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe, Hardcover</subfield><subfield code="z">0-470-09859-7</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=191459</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield><subfield code="a">ZDB-4-EBU</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">FAW_PDA_EBA</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">FLA_PDA_EBU</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028393013</subfield></datafield></record></collection> |
id | DE-604.BV042967145 |
illustrated | Not Illustrated |
indexdate | 2024-07-10T07:14:00Z |
institution | BVB |
isbn | 9780470130414 0470130415 |
language | English |
oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028393013 |
oclc_num | 133491102 |
open_access_boolean | |
owner | DE-1046 DE-1047 |
owner_facet | DE-1046 DE-1047 |
physical | 1 Online-Ressource (xix, 332 pages) |
psigel | ZDB-4-EBA ZDB-4-EBU FAW_PDA_EBA FLA_PDA_EBU |
publishDate | 2007 |
publishDateSearch | 2007 |
publishDateSort | 2007 |
publisher | John Wiley & Sons |
record_format | marc |
series2 | Wiley finance series |
spelling | Tick, Evan Verfasser aut Structured finance modeling with object-oriented VBA Evan Tick Hoboken, N.J. John Wiley & Sons ©2007 1 Online-Ressource (xix, 332 pages) txt rdacontent c rdamedia cr rdacarrier Wiley finance series Includes bibliographical references (pages 321-324) and index Cover -- Structured Finance Modeling with Object-Oriented VBA. TOContents -- Preface -- List of Acronyms -- Acknowledgments -- About the Author -- CHhapter 1: Cash-Flow Structures -- Modeling / 1.1 GETTING STARTED. 1.2 SECURITIZATION. 1.3 SYNTHETIC STRUCTURES. 1.4 PUTTING IT ALL TOGETHER. CHhapter 2 -- Assets / 2.1 DIPPING A TOE IN THE SHALLOW END. 2.2 SWIMMING TOWARD THE DEEP END. 2.3 TYPES. 2.4 CLASS ARCHITECTURE. 2.5 EXERCISES. CHhapter 3 -- MULTIPLE INHERITANCE. 3.9 DOING IT IN EXCEL: SUMPRODUCT. 3.10 EXERCISES. CHhapter 4: Liabilities / 3.1 REPLINES. 3.2 PORTFOLIO OPTIMIZATION. 3.3 LOSSES, PREPAYMENTS, AND INTEREST RATES. 3.4 CASH-FLOW MODEL. 3.5 S & P CASH-FLOW MODEL. 3.6 MOODY'S CASH-FLOW MODEL. 3.7 OPTION ARMS. 3.8 CLASS ARCHITECTURE -- NIMS AND POST-NIM. 4.11 CLASS ARCHITECTURE. 4.12 DOING IT IN EXCEL: DATA TABLES. 4.13 EXERCISES. CHhapter 5: Sizing the Structure / 4.1 GETTING STARTED. 4.2 NOTATION. 4.3 EXPENSES. 4.4 INTEREST. 4.5 OVER-COLLATERALIZATION. 4.6 PRINCIPAL. 4.7 WRITEDOWNS AND RECOVERIES. 4.8 DERIVATIVES. 4.9 TRIGGERS. 4.10 RESIDUALS -- SOLVER. 5.8 EXERCISES. CHhapter 6: Analysis / 5.1 SENIOR SIZING. 5.2 SUBORDINATE SIZING. 5.3 OPTIMIZATIONS AND COMPLEXITY. 5.4 EXAMPLE OF SIZING. 5.5 NIM AND OTE SIZING. 5.6 CLASS ARCHITECTURE. 5.7 DOING IT IN EXCEL -- Stochastic Models / 6.1 RISK FACTORS. 6.2 MEZZANINE AND SUBORDINATE CLASSES. 6.3 NIM CLASSES. 6.4 PUTTING IT ALL TOGETHER. 6.5 EXERCISES. CHhapter 7 -- Excel and VBA. A. 1 SPREADSHEET STYLE. A. 2 CODE STYLE. A. 3 COMPILATION. A. 4 BLOOMBERG. Appendix B: Bond Math / 7.1 STATIC VERSUS STOCHASTIC. 7.2 LOSS MODEL. 7.3 GAUSSIAN COPULA. 7.4 MONTE CARLO SIMULATION. 7.5 SYNTHETIC CREDIT INDEXES. 7.6 DOING IT IN EXCEL. 7.7 EXERCISES. Appendix A -- B. 1 MORTGAGE PAYMENT. B. 2 YIELD TO PRICE. B. 3 PRICE TO YIELD. B. 4 DURATION. B. 5 HAZARD RATE. B. 6 STATIC CREDIT CARD MODEL. References -- IDXndex -- Last Page "Structured Finance Modeling with Object-Oriented VBA introduces this model and its implementation, providing illustrations of the model in action for actual deals, along with empirical studies of its sensitivities. Using sub-prime mortgage securitization throughout the book as a unifying example, it provides a detailed look at how object-oriented Visual Basic for Applications (VBA) can be used to price complex financial structures." "Along with securitization, this book covers stochastic models, optimization techniques, object-oriented architecture, and more. Wall Street analysts and MBA students mastering object-oriented VBA programming skills are in great demand on Wall Street, and a step ahead of those without these skills. This invaluable guide provides both the mathematical specifications and programming techniques needed to perform modeling tasks efficiently and effectively - and keep ahead of the competition."--Jacket Microsoft Visual Basic for applications BUSINESS & ECONOMICS / Finance bisacsh Microsoft Visual Basic for applications fast Finance / Mathematical models fast Investments / Mathematical models fast Mathematisches Modell Wirtschaft Finance Mathematical models Investments Mathematical models Erscheint auch als Druck-Ausgabe, Hardcover 978-0-470-09859-2 Erscheint auch als Druck-Ausgabe, Hardcover 0-470-09859-7 http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=191459 Aggregator Volltext |
spellingShingle | Tick, Evan Structured finance modeling with object-oriented VBA Microsoft Visual Basic for applications BUSINESS & ECONOMICS / Finance bisacsh Microsoft Visual Basic for applications fast Finance / Mathematical models fast Investments / Mathematical models fast Mathematisches Modell Wirtschaft 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_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 BUSINESS & ECONOMICS / Finance bisacsh Microsoft Visual Basic for applications fast Finance / Mathematical models fast Investments / Mathematical models fast Mathematisches Modell Wirtschaft Finance Mathematical models Investments Mathematical models |
topic_facet | Microsoft Visual Basic for applications BUSINESS & ECONOMICS / Finance Finance / Mathematical models Investments / Mathematical models Mathematisches Modell Wirtschaft Finance Mathematical models Investments Mathematical models |
url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=191459 |
work_keys_str_mv | AT tickevan structuredfinancemodelingwithobjectorientedvba |