Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide
By Keith Allman
Language: English
Category: Ebook - Business
Categories: Business/Money
Uploader: logandb
Uploaded At: 2019-05-24 05:24:07
2007, Structured Finance, Excel, Modeling, Cash Flow, Cash Management
Description
ISBN: 978-0-470-04290-8
March 2007
221 Pages
Table of Contents
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.