Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide 59778th Edition

This is a great book. It doesn't deal too much in detail about ABS (you can find that in a LOT of other books out there). What this book does is give you the how-to of working a model in excel, step by step, formula by formula.Personally, I think it serves its purpose, helping you discover new ways of doing things in Excel, and once you master those ways, you can apply them to new financial structures or projects.Also, Keith Allman, the author, has a serious compromise and has responded to emails about doubts in the past, very quickly.If you want to get a real starter and intermediate training in structured finance, this is the book for you.

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<=G6,H7+E7,-PMT(F7*C7,OrgTerm1,AssetOrgBal1)). For a floating formula, you cannot reference the Asset's original balance to calculate the payment...must be previous ending balance.

The book did not come with a CD and therefore it's pretty much useless. Customer service was also useless when I requested to download the corresponding Excel file.

This is an excellent resource for building cash flow models in structured finance, and I highly recommend it.

Very much an overview of topics. The lack of internet downloads of the xls files is annoying. Complex is VBA in the authors world.

I am a law student with a focus in corporate and tax law. I have some background in finance but by no means am I an expert. Further, the problems I have done were always with an HP-12C and paper. There are some portions of this book that I will not use, but that is because this book covers materials that exceed my needs. That said, whether your goal is to understand the models built by others, to structure relatively basic models, or develop advanced and complex skills this book will provide everything you need.For Kindle users: you will need the supplemental materials which come on a CD with hard copy. The author promptly emailed this to me upon request.

I think Keith's approach to this is excellent. I have been involved in creating Structured Finance models for over 20 years and Keith has managed to simplify the explanation into a very readable yet explicit set of rules and objectives and provides templates that show very simply "how to do it". It will take a little while to implement for the average reader's pet project but the disciplines and results will be worth the effort. Best book on the subject yet - Excellent.

most of the models are taken from banking industry, if you want to use it in other kind of business models it could be tough.