Modeling structured finance cash flows with microsoft excel : a step-by-step guide /
Keith A. Allman.
- Hoboken, N.J : John Wiley & Sons, 2007.
- xv, 199 pages : ill ; 23 cm.
Include index.
Introduction -- Dates and timing -- Asset cash flow generation -- Prepayments -- Delinquency, default, and loss analysis -- Recoveries -- Liabilities and the cash flow waterfall -- Advanced liability structures : triggers, interest rate swaps, and reserve accounts -- Analytics and output reporting -- Understanding the model -- Automation using Visual Basic Applications (VBA) -- Conclusion.