Given the lack of transparency in the market and the difficult time investors have in understanding complex Wall Street transaction, Keith Allman’s second book takes readers through the detailed process of reverse engineering a deal by decomposing legal documentation and rebuilding it in an computer model.

Using a sophisticated mortgage-backed transaction as an example, the book jumps between excerpts from the legal documentation and the corresponding Excel formulas and code.

This book is particularly valuable for those who want to expand their knowledge of Visual Basic Applications (VBA) as there is extensive coding to create the loan-level amortization engine.

The included CD-ROM includes all code and the final model.

.