Book description
A detailed look at how object-oriented VBA should be used to model complex financial structures
This guide helps readers overcome the difficult task of modeling complex financial structures and bridges the gap between professional C++/Java programmers writing production models and front-office analysts building Excel spreadsheet models. It reveals how to model financial structures using object-oriented VBA in an Excel environment, allowing desk-based analysts to quickly produce flexible and robust models. Filled with in-depth insight and expert advice, it skillfully illustrates the art of object-oriented programming for the explicit purpose of modeling structured products. Residential mortgage securitization is used as a unifying example throughout the text.
Table of contents
- Cover
- Title
- Copyright
- Dedication
- Contents
- Preface
- List of Acronyms
- Acknowledgments
- About the Author
- Chapter 1: Cash-Flow Structures
- Chapter 2: Modeling
- Chapter 3: Assets
- Chapter 4: Liabilities
- Chapter 5: Sizing the Structure
- Chapter 6: Analysis
- Chapter 7: Stochastic Models
- Appendix A: Excel and VBA
- Appendix B: Bond Math
- References
- Index
Product information
- Title: Structured Finance Modeling with Object-Oriented VBA
- Author(s):
- Release date: May 2007
- Publisher(s): Wiley
- ISBN: 9780470098592
You might also like
book
Advanced Modelling in Finance Using Excel and VBA
This new and unique book demonstrates that Excel and VBA can play an important role in …
book
How to Implement Market Models Using VBA
Accessible VBA coding for complex financial modelling How to Implement Market Models Using VBA makes solving …
book
Financial Simulation Modeling in Excel
"I've worked with simulation in business for over 20 years, and Allman really nails it with …
book
Hedge Fund Modelling and Analysis Using Excel and VBA
Co-authored by two respected authorities on hedge funds and asset management, this implementation-oriented guide shows you …