Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Kindle Price: £54.62

Save £2.88 (5%)

includes VAT*
* Unlike print books, digital books are subject to VAT.

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Deliver to your Kindle or other device

Deliver to your Kindle or other device

Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide (Wiley Finance) by [Allman, Keith A.]
Kindle App Ad

Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide (Wiley Finance) Kindle Edition

2.3 out of 5 stars 3 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"

Length: 227 pages Word Wise: Enabled

Kindle Books from 99p
Load up your Kindle library before your next holiday -- browse over 500 Kindle Books on sale from 99p until 31 August, 2016. Shop now

Product Description

From the Back Cover

Praise for Modeling Structured Finance Cash Flows with Microsoft Excel

"You can roll up your sleeves, dive into this book, and shortly thereafter, you have a full–blown honest–to– goodness working model of a transaction. This sure beats the old method of slaving at the feet of gurus for years in the hopes that they′ll throw you a scrap. It almost feels as though Allman has given away a shortcut through the ′hazing′ period of learning, but then I am grateful I have a resource with which to train new analysts or remind myself how some things work."
Omar Haneef, Global Securitized Markets, Citigroup

"Allman has written a book that reveals to the reader/user a robust framework for using Excel to model structured finance transactions. Both seasoned cash flow modelers and those new to, or curious about, how structured finance transactions are analyzed can benefit from this book."
Henry Wilson, Bond Insurance Company Analyst

"A powerful, concise, and tiered approach. It′s a bedrock foundation to build on for both the art and science of structured finance modeling. An excellent platform from which to leverage your financial knowledge and personal capital."
William Preinitz, Managing Director, Citigroup

"An essential tool for any credit officer wishing to gain a general or in–depth understanding of cash flow modeling for new or existing deals."
Joseph B. Keener, Structured Portfolio Management, Citigroup London

Written by industry expert Keith Allman, this well–rounded resource provides detailed guidance on constructing one of today′s most adaptable models the cash flow model. Filled with in–depth insight, expert advice, and illustrative examples, Modeling Structured Finance Cash Flows with Microsoft Excel explains individual functions and formulas, while also examining 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.

By combining specific application instruction with theory, Modeling Structured Finance Cash Flows with Microsoft Excel will teach you skills that can be instantly applied to professional–level modeling.

About the Author

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.

Product details

  • Format: Kindle Edition
  • File Size: 2955 KB
  • Print Length: 227 pages
  • Page Numbers Source ISBN: 0470042907
  • Publisher: Wiley; 1 edition (8 Mar. 2010)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B008O5JW52
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Enabled
  • Enhanced Typesetting: Not Enabled
  • Average Customer Review: 2.3 out of 5 stars 3 customer reviews
  • Amazon Bestsellers Rank: #875,442 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images or tell us about a lower price?

Customer Reviews

2.3 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 3 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback Verified Purchase
After receiving the book I found out that the CD-ROM wasn't attached to this version, I reached out to Keith Allman (author) via email and received access to the Project Model Builder files the next day. This book has helped me tremendously in understanding Structured Finance cash flows from the bottom up by building my own model. I can now navigate how various inputs and assumptions can affect a base case model and how I can limit losses with credit enhancements. I would recommend this book to any beginner or intermediate excel user, the explanations are very well described and I was able to follow each step meticulously.

Will definitely be referring to the book again in the future.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition Verified Purchase
The kindle edition of this book is a bit pointless when you are unable to download the files which are essential in working logically through the book. Sure print edition is fine but kindle edition rendered useless.
3 Comments One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book does NOT come with a CD, hence it is completely useless as it's sole content is description of the Excel spreadsheets that are supposed to be included with the book. there is no website from which software can be downloaded either.
3 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: HASH(0x9148a714) out of 5 stars 20 reviews
25 of 28 people found the following review helpful
HASH(0x90e2d3e4) out of 5 stars Excellent Hands-On Introduction to Structured Finance 3 Jun. 2007
By BL - Published on Amazon.com
Format: Paperback
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.
11 of 12 people found the following review helpful
HASH(0x90e2d438) out of 5 stars Excellent introduction to MBS modeling 12 Aug. 2007
By abacus - Published on Amazon.com
Format: Paperback Verified Purchase
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.
11 of 12 people found the following review helpful
HASH(0x90e2d714) out of 5 stars Good Intro to Cash Flow Modeling 20 Sept. 2007
By Patrick Pancoast - Published on Amazon.com
Format: Paperback
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.
6 of 7 people found the following review helpful
HASH(0x90e2dc24) out of 5 stars Great introductory book on the subject 28 Feb. 2011
By Walid K. - Published on Amazon.com
Format: Kindle Edition Verified Purchase
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.
4 of 4 people found the following review helpful
HASH(0x90e2d4f8) out of 5 stars Exactly what I was looking for 8 Nov. 2009
By M. Larrabee - Published on Amazon.com
Format: Paperback
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.
Were these reviews helpful? Let us know
click to open popover