Free Downloads Modeling Structured Finance Cash Flows With Microsoft Excel: A Step-by-Step Guide (Wiley Finance)
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.
File Size: 2955 KB
Print Length: 227 pages
Page Numbers Source ISBN: 0470042907
Publisher: Wiley; 1 edition (March 8, 2010)
Publication Date: March 8, 2010
Sold by: Digital Services LLC
Language: English
ASIN: B008O5JW52
Text-to-Speech: Enabled
X-Ray: Not Enabled
Word Wise: Enabled
Lending: Not Enabled
Enhanced Typesetting: Not Enabled
Best Sellers Rank: #595,155 Paid in Kindle Store (See Top 100 Paid in Kindle Store) #137 in Books > Computers & Technology > Software > Personal Finance #163 in Books > Computers & Technology > Software > Accounting #676 in Books > Computers & Technology > Business Technology > Software > Spreadsheets
In structured finance, there is a tremendous discrepancy between academic literature and practice. In purporting a generalizable, scientific approach, many textbooks avoid explaining the intracacies of actual structured finance deals. The fundamental issue is that the implicit value of deal transparency required for issuer and investor tends to be overlooked by authors approaching the field from an academic background. Technical pyrotechnics that suit liquid markets fail when fees, interest rates, and other deal specifics are malleable constructs negotiated among a handful of parties. At the same time, basic bond math on an unsegregated pool of loans cannot accurately describe how assets generate cash flows and the risks faced by investors.MFSC is the *only* book (afaik) that demonstrates how real structured finance pros bridge the void between these 2 common pitfalls made by other structured finance books. For one, the calculations that belie each component of a structured finance deal is integrated into a single model rather than considered separately. Other books may describe how cash flows pay out in a senior-sub structure, but they won't, for example, take the time to step through how funding costs and triggers affect the cash flows. The primary model also gives the user flexibility to stress the model and enables the user to treat the model as a base for all structured finance deals. Through a neatly organized inputs sheet, each component in the primary model described painstakingly anticipates the gamut of variations common to these types of deals.All this in a book that's easy to follow and a delight to read. Five stars.
Anyone needing to learn how structured finance cash flow models work will benefit from going through this book and building the spreadsheet-based model it describes. It will be faster if you are already good at using Excel for complex modeling or pricing, but there is a fair amount of Excel advice for those who need it. The book models a single pool of mortgages that can be described by weighted average statistics incorporating both prepayment and default scenarios. Great care is taken to make the model flexible in terms of the kinds of mortgages in the pool. On the liability side the model allows for the creation of a single senior class and a sub class with an interest rate swap and a reserve. While very good for learning the cash flow consequences of sequential and pro rata payment waterfalls, this model cannot describe the structures actually issued in the market. The skills learned, however, should allow the reader to build models capable of modeling issued structures. The writing is clear and the examples are explained well. The flow of cash into and out of the structure is emphasized by clear inputs, cash flow modeling and summary outputs.
Keith's book saved me hours of trial-and-error effort with Excel for modeling structured transactions. This book takes a simple, step-by-step approach to help the reader understand the mechanics of building the cash flow model for Mortgage Backed Securities (MBS).Once you understand the basics of model creation and cash flow, then it is a matter of refining your skills by revere-engineering more MBS transactions out there. You will find all the basic tools to become proficient in that task by following this book.
I received the excel model by writing to the author. Thank you, great introductory book with step by step explanation!=======It is clearly stated that the Kindle edition does not include the CD-ROM, but I thought at least one could download the models from the author's website. It's a waist of money if you do not get the software that comes with the hardcover edition.Will change the rating if the software becomes available to kindle edition.
This book is exactly what I was looking for. I stongly, strongly recommend this to any one looking to acquire VBA proficiency in the context of modeling and monitoring structured finance transactions. I am indebted to the author and publisher for finally bringing to market a book thats been noticeably absent to any one looking in the past. You will not learn whats in this book in any other book, and you will save an enormous amount of time by going through the book and CD, and building a model concurrently.
Very nice model to start with. Only purchase one with the CD content if you can, helpful reference and the book does require you to copy/paste from the files to your model (default data, libor data)...though not an absolute must, you could make it up and it would still work.There is a critical error in the PMT formula on the Cash Flow tab beginning in cell G7: =IF(J6
This is an excellent book for beginner/intermediate practitioners of structured finance. The book takes you step by step (handholds) you through the process of building the right model and also explains the logic behind it in a very lucid way. Suggest using the book to set up working models on your own a couple of times to gain confidence. All in all a superb, grounded book.-Avishek.
Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide (Wiley Finance) Excel: The Complete Beginners Guide - Boost Your Poductivity And Master Excel In Just 24 Hours! (Excel, Microsoft Office, MS Excel 2016) The Ten Cash Commentary:: The General Issue Ten Cash Coins of the Republic of China Structured Settlement Basics - Understanding Structured Settlement Buying, Selling and Investing EXCEL: Strategic Use of the Calc Spreadsheet in Business Environment. Data Analysis and Business Modeling (Functions and Formulas, Macros, MS Excel 2016, Shortcuts, Microsoft Office) Microsoft Excel 2013 Data Analysis and Business Modeling: Data Analysis and Business Modeling (Introducing) Publishing eBooks Concept to Cash-Flow: How to Publish Your eBook on Kindle Step-by-Step From Start to Finish Microsoft® Windows® XP Step by Step Microsoft® Office Excel® 2007 Visual Basic® for Applications Step by Step Microsoft® Office Outlook® 2007 Step by Step Microsoft® Outlook® 2010 Step by Step Excel Conditional Formatting: Tips You Can Use Immediately To Make Your Data Stand Out (Data Analysis With Excel Book 3) Excel VBA Programming: Learn Excel VBA Programming FAST and EASY! (Programming is Easy Book 9) The Wiley-Blackwell Companion to Zoroastrianism (Wiley Blackwell Companions to Religion) Tourism and Transport: Modes, Networks and Flows (Aspects of Tourism Texts) Heat, Bearings, and Lubrication: Engineering Analysis of Thermally Coupled Shear Flows and Elastic Solid Boundaries UMTS Signaling: UMTS Interfaces, Protocols, Message Flows and Procedures Analyzed and Explained Godless Circumcisions: A Recollecting & Re-membering of Blackness, Queerness & Flows of Survivance Everything Flows (New York Review Books Classics) A River Flows from Eden: The Language of Mystical Experience in the Zohar
