Structured Finance Modeling with Object-Oriented VBA (Wiley Finance)

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.

---

All Customer Reviews
Average Customer Review:
1 of 1 people found the following review helpful:

good modeling in theory And programming, 2008-03-15
This textbook is interesting. it describe the modeling in programming style and math. It make me easy to catch the relation of math formula and programming pesudo code. It does not only the math concept but pesudo code which is used to describe the concept. It is helpful to me while I met the problems in other finance engineering textbook. I can not link the complexity of math fomula to real world. But this textbook gave me another study viewpoints and help me link to to real world.


7 of 7 people found the following review helpful:

A practitioner's perspective, 2007-06-23
This is an outstanding textbook on how to master the intricacies of a structured finance (especially, home-equity ABS) deal. It teaches ABS from several angles: modeling (chapter 1-4), structuring (chatper 5), and ABS analytics (chapter 6).

Although definitions and explanations about any given deal can be readily found from prospectus and prospectus supplements, for practitioners like myself, this book improves one's understanding of what's, how's and why's of any particular feature of a typical RMBS structure. This is a book I wished I had read when I started in this business.

In this book, the process of modeling a RMBS deal was shown step-by-step, with definitions, equations, tables and figures accompanying easy to understand explanations. The equations are written in a way that if is straightforward to be coded into VBA (or any other language) and be implemented.

This is a book about learning about modeling and implementing an ABS. End of chapter programming excercises reinforce the notion of learning by doing. To respond to the prior reviewer's desire of having a complete program to run and test, I believe that the only way one is going to learn a complex structure is to read, follow, implement and experiment with self-written codes. This book provides you with all the tools and explanations you need to get started in this interesting field.









6 of 9 people found the following review helpful:

After waiting for more than 5 months..., 2007-05-25
I had been waiting for this book for more than 5 months (preordered since December 2006). The content is excellent, but I expect to see a complete VBA code as a wrap up. It should also help if the code is provided in soft file so that the readers can see how the model actually runs without the need to merge all the examples and manually type the code into the computer first.

Montri

Price is accurate as of the date/time indicated. Prices and product availability are subject to change. Any price displayed on the Amazon website at the time of purchase will govern the sale of this product.