Structured Finance Modeling with Object-Oriented VBA: A Maverick Medical Genius and His Tragic Quest to Rid the World of Mental Illness: Wiley Finance, cartea 390
Autor Evan Ticken Limba Engleză Hardback – 8 iun 2007
Din seria Wiley Finance
- 8%
Preț: 517.95 lei - 8%
Preț: 417.68 lei -
Preț: 332.25 lei -
Preț: 304.99 lei - 8%
Preț: 512.39 lei - 9%
Preț: 775.82 lei - 8%
Preț: 438.17 lei - 20%
Preț: 375.05 lei - 9%
Preț: 620.97 lei - 8%
Preț: 410.89 lei -
Preț: 272.29 lei - 8%
Preț: 409.31 lei -
Preț: 346.95 lei -
Preț: 350.20 lei - 9%
Preț: 635.89 lei - 8%
Preț: 452.88 lei - 8%
Preț: 438.93 lei - 8%
Preț: 622.19 lei - 9%
Preț: 595.39 lei - 9%
Preț: 641.61 lei - 8%
Preț: 510.20 lei - 8%
Preț: 527.28 lei - 9%
Preț: 770.78 lei - 8%
Preț: 458.93 lei - 8%
Preț: 492.43 lei - 8%
Preț: 386.61 lei - 8%
Preț: 370.06 lei - 8%
Preț: 577.42 lei - 9%
Preț: 517.83 lei - 8%
Preț: 529.92 lei - 20%
Preț: 542.47 lei - 8%
Preț: 396.96 lei - 8%
Preț: 510.58 lei -
Preț: 359.69 lei - 8%
Preț: 563.09 lei - 8%
Preț: 416.60 lei - 8%
Preț: 362.18 lei - 9%
Preț: 618.28 lei - 9%
Preț: 607.96 lei - 9%
Preț: 637.68 lei -
Preț: 283.02 lei -
Preț: 292.03 lei - 9%
Preț: 843.32 lei - 8%
Preț: 573.87 lei - 8%
Preț: 457.44 lei - 8%
Preț: 508.00 lei -
Preț: 270.40 lei -
Preț: 355.58 lei - 8%
Preț: 437.66 lei - 8%
Preț: 418.05 lei
Preț: 321.18 lei
Nou
Puncte Express: 482
Preț estimativ în valută:
61.49€ • 63.23$ • 51.01£
61.49€ • 63.23$ • 51.01£
Carte disponibilă
Livrare economică 30 ianuarie-13 februarie
Livrare express 15-21 ianuarie pentru 38.94 lei
Preluare comenzi: 021 569.72.76
Specificații
ISBN-13: 9780470098592
ISBN-10: 0470098597
Pagini: 332
Dimensiuni: 161 x 228 x 31 mm
Greutate: 0.54 kg
Editura: Wiley
Seria Wiley Finance
Locul publicării:Hoboken, United States
ISBN-10: 0470098597
Pagini: 332
Dimensiuni: 161 x 228 x 31 mm
Greutate: 0.54 kg
Editura: Wiley
Seria Wiley Finance
Locul publicării:Hoboken, United States
Public țintă
Wall Street professionals and analysts in structured finance, and MBA professors and students.Descriere
Praise for STRUCTURED FINANCE MODELING with Object–Oriented VBA
"This book is an excellent and interesting integration of financial engineering, structured finance, and structured programming, and the book accomplishes this with easy–to–follow examples, using the most commonly available tools, MS VBA and spreadsheets. The author is clearly intimately familiar with structured products, the mechanics and challenges of securitization, and the financial and analytical modeling that is required to understand and manage these diverse financial products. The result is a book that demonstrates an easy–to–follow combination of finance and object–oriented programming. This is a ′must own book′ for the active practitioner, the financial engineer on the front lines of the structuring battle."
Cyrus Mohebbi, PhD, Head of MBS/ABS Structuring and Analytics, HSBC Securities Inc.
"Tick has written a seminal structured finance book. He presents an approach to modeling that is both efficient and practical. His work will serve as a timeless template to simplify the complexity of structured finance."
Janet Tavakoli, President, Tavakoli Structured Finance
"Dr. Tick′s experience in applying theoretical concepts to various markets is well encapsulated in this book. A must–read for technicians and market practitioners alike who would like insight into practical solutions to complex financial modeling problems."
Adil Nathani, Old Lane Management
"Reading Tick′s book gives a real–world introduction to practical bond structuring, the activity that generates a significant part of Wall Street′s profits. This book from a (financial) engineer who is intimately involved in this business, gives the details needed to generate accurate cash flows along with meticulously presented real–life examples. In addition to meat–and–potatoes asset and liability cash flows, he discusses optimization and stochastic modeling, a useful introduction to synthetic structures. This book also serves as an introduction to programming skills in VBA."
Ramine Rouhani, Managing Director, Head of Capital Markets, IXIS Capital Markets North America
"This book is an excellent and interesting integration of financial engineering, structured finance, and structured programming, and the book accomplishes this with easy–to–follow examples, using the most commonly available tools, MS VBA and spreadsheets. The author is clearly intimately familiar with structured products, the mechanics and challenges of securitization, and the financial and analytical modeling that is required to understand and manage these diverse financial products. The result is a book that demonstrates an easy–to–follow combination of finance and object–oriented programming. This is a ′must own book′ for the active practitioner, the financial engineer on the front lines of the structuring battle."
Cyrus Mohebbi, PhD, Head of MBS/ABS Structuring and Analytics, HSBC Securities Inc.
"Tick has written a seminal structured finance book. He presents an approach to modeling that is both efficient and practical. His work will serve as a timeless template to simplify the complexity of structured finance."
Janet Tavakoli, President, Tavakoli Structured Finance
"Dr. Tick′s experience in applying theoretical concepts to various markets is well encapsulated in this book. A must–read for technicians and market practitioners alike who would like insight into practical solutions to complex financial modeling problems."
Adil Nathani, Old Lane Management
"Reading Tick′s book gives a real–world introduction to practical bond structuring, the activity that generates a significant part of Wall Street′s profits. This book from a (financial) engineer who is intimately involved in this business, gives the details needed to generate accurate cash flows along with meticulously presented real–life examples. In addition to meat–and–potatoes asset and liability cash flows, he discusses optimization and stochastic modeling, a useful introduction to synthetic structures. This book also serves as an introduction to programming skills in VBA."
Ramine Rouhani, Managing Director, Head of Capital Markets, IXIS Capital Markets North America
Textul de pe ultima copertă
Praise for STRUCTURED FINANCE MODELING with Object–Oriented VBA
"This book is an excellent and interesting integration of financial engineering, structured finance, and structured programming, and the book accomplishes this with easy–to–follow examples, using the most commonly available tools, MS VBA and spreadsheets. The author is clearly intimately familiar with structured products, the mechanics and challenges of securitization, and the financial and analytical modeling that is required to understand and manage these diverse financial products. The result is a book that demonstrates an easy–to–follow combination of finance and object–oriented programming. This is a ′must own book′ for the active practitioner, the financial engineer on the front lines of the structuring battle."
Cyrus Mohebbi, PhD, Head of MBS/ABS Structuring and Analytics, HSBC Securities Inc.
"Tick has written a seminal structured finance book. He presents an approach to modeling that is both efficient and practical. His work will serve as a timeless template to simplify the complexity of structured finance."
Janet Tavakoli, President, Tavakoli Structured Finance
"Dr. Tick′s experience in applying theoretical concepts to various markets is well encapsulated in this book. A must–read for technicians and market practitioners alike who would like insight into practical solutions to complex financial modeling problems."
Adil Nathani, Old Lane Management
"Reading Tick′s book gives a real–world introduction to practical bond structuring, the activity that generates a significant part of Wall Street′s profits. This book from a (financial) engineer who is intimately involved in this business, gives the details needed to generate accurate cash flows along with meticulously presented real–life examples. In addition to meat–and–potatoes asset and liability cash flows, he discusses optimization and stochastic modeling, a useful introduction to synthetic structures. This book also serves as an introduction to programming skills in VBA."
Ramine Rouhani, Managing Director, Head of Capital Markets, IXIS Capital Markets North America
"This book is an excellent and interesting integration of financial engineering, structured finance, and structured programming, and the book accomplishes this with easy–to–follow examples, using the most commonly available tools, MS VBA and spreadsheets. The author is clearly intimately familiar with structured products, the mechanics and challenges of securitization, and the financial and analytical modeling that is required to understand and manage these diverse financial products. The result is a book that demonstrates an easy–to–follow combination of finance and object–oriented programming. This is a ′must own book′ for the active practitioner, the financial engineer on the front lines of the structuring battle."
Cyrus Mohebbi, PhD, Head of MBS/ABS Structuring and Analytics, HSBC Securities Inc.
"Tick has written a seminal structured finance book. He presents an approach to modeling that is both efficient and practical. His work will serve as a timeless template to simplify the complexity of structured finance."
Janet Tavakoli, President, Tavakoli Structured Finance
"Dr. Tick′s experience in applying theoretical concepts to various markets is well encapsulated in this book. A must–read for technicians and market practitioners alike who would like insight into practical solutions to complex financial modeling problems."
Adil Nathani, Old Lane Management
"Reading Tick′s book gives a real–world introduction to practical bond structuring, the activity that generates a significant part of Wall Street′s profits. This book from a (financial) engineer who is intimately involved in this business, gives the details needed to generate accurate cash flows along with meticulously presented real–life examples. In addition to meat–and–potatoes asset and liability cash flows, he discusses optimization and stochastic modeling, a useful introduction to synthetic structures. This book also serves as an introduction to programming skills in VBA."
Ramine Rouhani, Managing Director, Head of Capital Markets, IXIS Capital Markets North America
Cuprins
Preface.List of Acronyms.
Acknowledgments.
About the Author.
Chapter 1. Cash–Flow Structures.
1.1 Getting Started.
1.2 Securitization.
1.3 Synthetic Structures.
1.4 Putting It All Together.
Chapter 2. Modeling.
2.1 Dipping a Toe in the Shallow End.
2.2 Swimming Toward the Deep End.
2.3 Types.
2.4 Class Architecture.
2.4.1 Weak Inheritance.
2.4.2 Parameterized Class.
2.4.3 Which Is Better?
2.5 Exercises.
Chapter 3. Assets.
3.1 Replines.
3.2 Portfolio Optimization.
3.2.1 Zero–One Program.
3.2.2 Simulated Annealing.
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 Exercises.
Chapter 4. Liabilities.
4.1 Getting Started.
4.2 Notation.
4.3 Expenses.
4.4 Interest.
4.5 Over–collateralization.
4.5.1 Current Subordinated Amount.
4.5.2 Stepdown Date.
4.5.3 Target Subordinated Amount.
4.6 Principal.
4.6.1 Gross Principal Distributions.
4.6.2 Detailed Principal Distributions.
4.7 Writedowns and Recoveries.
4.8 Derivatives.
4.8.1 Corridors.
4.8.2 Swaps.
4.8.3 Excess Reserve Fund Account.
4.9 Triggers.
4.9.1 Call Features.
4.9.2 Overcollateralization Test.
4.9.3 Interest Coverage Test.
4.9.4 Delinquency Trigger.
4.9.5 Loss Trigger.
4.10 Residuals: NIMs and Post–NIM.
4.11 Class Architecture.
4.11.1 Passive Approach.
4.11.2 Active Approach.
4.11.3 Comparison.
4.12 Doing It in Excel: Data Tables.
4.13 Exercises.
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 6. Analysis.
6.1 Risk Factors.
6.1.1 Prefunding.
6.1.2 Prepayments.
6.1.3 Buybacks and Cleanup Calls.
6.1.4 Defaults.
6.1.5 Interest Rates.
6.1.6 Spreads.
6.1.7 Miscellaneous.
6.1.8 Residual Sensitivities.
6.2 Mezzanine and Subordinate Classes.
6.3 NIM Classes.
6.4 Putting It All Together.
6.5 Exercises.
Chapter 7. Stochastic Models.
7.1 Static versus Stochastic.
7.2 Loss Model.
7.2.1 Probability of Default from Transition Matrix.
7.2.2 Probability of Default from Spread.
7.2.3 Probability of Time to Default.
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.1 Spreadsheet Style.
A.2 Code Style.
A.3 Compilation.
A.4 Bloomberg.
Appendix B. Bond Math.
B.1 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.
Acknowledgments.
About the Author.
Chapter 1. Cash–Flow Structures.
1.1 Getting Started.
1.2 Securitization.
1.3 Synthetic Structures.
1.4 Putting It All Together.
Chapter 2. Modeling.
2.1 Dipping a Toe in the Shallow End.
2.2 Swimming Toward the Deep End.
2.3 Types.
2.4 Class Architecture.
2.4.1 Weak Inheritance.
2.4.2 Parameterized Class.
2.4.3 Which Is Better?
2.5 Exercises.
Chapter 3. Assets.
3.1 Replines.
3.2 Portfolio Optimization.
3.2.1 Zero–One Program.
3.2.2 Simulated Annealing.
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 Exercises.
Chapter 4. Liabilities.
4.1 Getting Started.
4.2 Notation.
4.3 Expenses.
4.4 Interest.
4.5 Over–collateralization.
4.5.1 Current Subordinated Amount.
4.5.2 Stepdown Date.
4.5.3 Target Subordinated Amount.
4.6 Principal.
4.6.1 Gross Principal Distributions.
4.6.2 Detailed Principal Distributions.
4.7 Writedowns and Recoveries.
4.8 Derivatives.
4.8.1 Corridors.
4.8.2 Swaps.
4.8.3 Excess Reserve Fund Account.
4.9 Triggers.
4.9.1 Call Features.
4.9.2 Overcollateralization Test.
4.9.3 Interest Coverage Test.
4.9.4 Delinquency Trigger.
4.9.5 Loss Trigger.
4.10 Residuals: NIMs and Post–NIM.
4.11 Class Architecture.
4.11.1 Passive Approach.
4.11.2 Active Approach.
4.11.3 Comparison.
4.12 Doing It in Excel: Data Tables.
4.13 Exercises.
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 6. Analysis.
6.1 Risk Factors.
6.1.1 Prefunding.
6.1.2 Prepayments.
6.1.3 Buybacks and Cleanup Calls.
6.1.4 Defaults.
6.1.5 Interest Rates.
6.1.6 Spreads.
6.1.7 Miscellaneous.
6.1.8 Residual Sensitivities.
6.2 Mezzanine and Subordinate Classes.
6.3 NIM Classes.
6.4 Putting It All Together.
6.5 Exercises.
Chapter 7. Stochastic Models.
7.1 Static versus Stochastic.
7.2 Loss Model.
7.2.1 Probability of Default from Transition Matrix.
7.2.2 Probability of Default from Spread.
7.2.3 Probability of Time to Default.
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.1 Spreadsheet Style.
A.2 Code Style.
A.3 Compilation.
A.4 Bloomberg.
Appendix B. Bond Math.
B.1 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.
Notă biografică
Evan Tick is a director at IXIS Capital Markets, and has worked on Wall Street for ten years. His expertise is fixed income and structured finance modeling in the areas of risk management, asset–backed securities (ABS), residential mortgages, and credit derivatives.