Pay Mortgages
In Association w/ Amazon Shopping
Tuesday, January 06th 2009


Pay Mortgages Resources
Mortgage Refinancing
Mortgage Calculator
Mortgage Loan
Mortgage Lender
Mortgage Broker
Home Mortgage
Bad Credit Mortgage
Reverse Mortgage
Mortgage Lead
Mortgage Quote
Commercial Mortgage
Mortgage Marketing
Mortgage Application
Important Resources
Pay Mortgages Books
Pay Mortgages Magazines
Other Shopping Sites
Retailers Discount
More Shopping Sites


Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide.Book & CD-ROM

Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide.Book & CD-ROM
List Price: $80.00
Pay Mortgages Price: $50.40
Your Savings: $ 29.60 ( 37% )
Subject To Change Without Notice
Availability: Usually ships in 24 hours
Manufacturer: Wiley
Average Customer Rating: Average rating of 4.5/5Average rating of 4.5/5Average rating of 4.5/5Average rating of 4.5/5Average rating of 4.5/5

Buy it now at Amazon.com!

Binding: Paperback
Dewey Decimal Number: 658.1550285554
EAN: 9780470042908
ISBN: 0470042907
Label: Wiley
Manufacturer: Wiley
Number Of Items: 1
Number Of Pages: 224
Publication Date: 2007-03-09
Publisher: Wiley
Studio: Wiley

Related Items

Editorial Reviews:

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 the modeling exercises, as well as a final version of the model that is created in the text.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.


Spotlight customer reviews:

Customer Rating: Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5
Summary: The best first step on Structured Finance Modeling
Comment: It is a one good forst step if you want to learn how to model a structured finance product. With a very easy language and taking you by the hand the author gives you all the basis to learn something that many people consider complicate or very difficult

Customer Rating: Average rating of 4/5Average rating of 4/5Average rating of 4/5Average rating of 4/5Average rating of 4/5
Summary: Cool
Comment: This is a good book. It is well-written, gives both the theoretical side and implementation, and gives tips on excel. I am a beginner but it was easy for me to follow. I recommend this book to anyone who wants to learn excel for i-banking or some other finance job.

Customer Rating: Average rating of 4/5Average rating of 4/5Average rating of 4/5Average rating of 4/5Average rating of 4/5
Summary: Helps Building Cash Flow Model
Comment: Teaches how to build up a cash flow model for big companies such as banks and insurance companies. Not useful for small companies, but even for small companies gives some idea for building a cash flow model.

Customer Rating: Average rating of 4/5Average rating of 4/5Average rating of 4/5Average rating of 4/5Average rating of 4/5
Summary: Good Intro to Cash Flow Modeling
Comment: 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.

Customer Rating: Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5
Summary: Excellent introduction to MBS modeling
Comment: 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.



Buy it now at Amazon.com!

Copyright © 2005-2006 Pay Mortgages. All rights reserved.



Pay Mortgages
Maintained by: Marketer Solutions | Link Building