Reverse Engineering Deals on Wall Street with Microsoft Excel: A Step-by-Step Guide (Wiley Finance Book 442)

This book builds on Mr. Allman's previous work, "Modeling Structured Finance Cash Flows With Microsoft Excel" by adding "real-world" scenarios involving MBS with multiple loans. Excellent summaries of the risk and valuation issues but by far the most important area focuses on a good working introduction to VBA for Excel, with very good explanation of the "how" and "why" in using VBA.

I use the framework describede in the books modeling structured finance cash flows and reverse engineering deals on Wall Street as a basis for my analysis of portfolios. My clients love the detailed outcome of these models.

Keith provides clear methods and strategies to reverse engineer MBS securitizations. Keith addresses many of the issues you would encounter in trying to model complex structured finance transactions in Excel. He shows you methods of forecasting collateral cash flows that are necessary in order to model a deal correctly. This book is a must for anyone interested in evaluating structure finance transactions.