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.

- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
Structured Finance Modeling with Object-Oriented VBA
About this book
A detailed look at how object-oriented VBA should be used to model complex financial structures
Trusted by 375,005 students
Access to over 1.5 million titles for a fair monthly price.
Study more efficiently using our study tools.
Table of contents
- Cover
- Contents
- Title
- Copyright
- Dedication
- 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
Frequently asked questions
Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1.5 million books across 990+ topics, we’ve got you covered! Learn about our mission
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Yes, you can access Structured Finance Modeling with Object-Oriented VBA by Evan Tick in PDF and/or ePUB format, as well as other popular books in Business & Finance. We have over 1.5 million books available in our catalogue for you to explore.