Keith A. Allman

Modeling Structured Finance Cash Flows with Microsoft Excel (eBook, PDF)

A Step-by-Step Guide

• Format: PDF

Produktbeschreibung

A practical guide to building fully operational financial cash flow models for structured finance transactions 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. In addition, the companion website features all of the modeling exercises, as well as a final version of the model that is created in the text. Note: Companion website and other supplementary materials are not included as part of eBook file.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons
• Seitenzahl: 224
• Erscheinungstermin: 22. August 2007
• Englisch
• ISBN-13: 9780470117170
• Artikelnr.: 37290996

Autorenporträt

Keith Allman is currently the principal trainer and founder of Enstruct, a structured finance analytics training company. Previously he was a Vice President at Citigroup in their Global Fixed Income, Structured Finance Division. He has built and reviewed hundreds of models from many different sectors. Allman received his master's degree in international affairs from Columbia University.

Inhaltsangabe

Preface. Acknowledgments. About the Author. Introduction. The Three Basic
Elements of a Cash Flow Model. Inputs. Cash Flow Structure. Outputs. The
Process of Building a Cash Flow Model. Plan and Design. Obtain All
Necessary Information. Construct Basic Framework. Develop Advanced
Structure. Validate Assumptions. Test Model. How This Book Is Designed.
CHAPTER 1. Dates and Timing. CHAPTER 2. Asset Cash Flow Generation. CHAPTER
3. Prepayments. CHAPTER 4. Delinquency, Default, and Loss Analysis. CHAPTER
5. Recoveries. CHAPTER 6. Liabilities and the Cash Flow Waterfall. CHAPTER
7. Advanced Liability Structures: Triggers, Interest Rate Swaps, and
Reserve Accounts. CHAPTER 8. Analytics and Output Reporting. CHAPTER 9.
Understanding the Model. CHAPTER 10. Automation Using Visual Basic
Applications (VBA). CHAPTER 11. Conclusion. Appendix: Using This Book with
Excel 2007. About the CD-ROM. Index.