Modeling Structured Finance Cash Flows with Microsoft Excel

By Keith A. Allman

Subjects: Cash management, Microsoft Excel (Computer file), Microsoft excel (computer program), Nonfiction, Microsoft excel (computer file), Mathematical models, Cash flow, Corporations--finance--mathematical models, Corporations, Hg4028.c45 a454 2007, Business, Cash flow--mathematical models, Cash management--mathematical models, Corporations, finance, mathematical models, Finance

Description: 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 CD-ROM features all of Note: CD-ROM/DVD and other supplementary materials are not included....