Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide

Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called "Model Builder," in which Allman translates the theory into functions and formulas.

• The Mechanics of Securitization: A Practical Guide to Structuring and Closing Asset-Backed Security Transactions
• A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA
• Reverse Engineering Deals on Wall Street with Microsoft Excel, + Website: A Step-by-Step Guide
• Introduction to Structured Finance
• Big Debt Crises
• The Handbook of Mortgage-Backed Securities, 7th Edition
• Investing in Mortgage-Backed and Asset-Backed Securities, + Website: Financial Modeling with R and Open Source Analytics (Wiley Finance)
• Mortgage-Backed Securities: Products, Structuring, and Analytical Techniques
• Structured Finance and Collateralized Debt Obligations: New Developments in Cash and Synthetic Securitization
• Mastering the Market Cycle: Getting the Odds on Your Side