Get Free Ebook Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide
Get Free Ebook Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide
Looking for the brainwave suggestions? Need some publications? The amount of books that you need? Here, we will certainly ere among it that can be your brainwave concepts in worthy usage. Modeling Structured Finance Cash Flows With Microsoft Excel: A Step-by-Step Guide is what we indicate. This is not a fashion to earn you straight abundant or wise or incredible. But, this is a fashion to constantly accompany you to always do and also improve. Why should be better? Every person will need to achieve great development for their way of living. One that can affect this instance is understanding for brainwave from a book.
Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide
Get Free Ebook Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide
We supply the many book titles from many publishers and also collections on the planet. Where nation you are, you can find your favored book below. When you wish to deal with your life, reviewing publication will truly aid you. This is not just an activity to simplify or spend the moment. This is a need to that can be achieved by binding the life for much better future. It will depend upon how you make a decision to select the book in order to choose the far better advantages.
Besides, guide is suggested since it gives you not only entertainment. You can transform the enjoyable things to be great lesson. Yeah, the author is truly wise to convey the lessons as well as material of Modeling Structured Finance Cash Flows With Microsoft Excel: A Step-by-Step Guide that could attract all viewers to admire of that book. The writer likewise offers the simple means for you to get the fun entertainment. Read every word that is utilized by the writer, they are really interesting and also simple to be always comprehended.
Someone will constantly have reason when providing occasionally. As here, we likewise have numerous affordable advantages to extract from this publication. Initially, you can be one of the hundreds people who read this Modeling Structured Finance Cash Flows With Microsoft Excel: A Step-by-Step Guide, from numerous areas. After that, you can obtain an extremely easy method to locate, obtain, as well as read this book; it exists in soft documents based upon online system. So, you can read it in your gadget where it will certainly be always be with you.
It is not only to provide you the very easy way but also to obtain the book is soft file systems. This is the reason you could obtain the book asap. By connecting to web, your opportunity to locate and also obtain the Modeling Structured Finance Cash Flows With Microsoft Excel: A Step-by-Step Guide as soon as possible. By clicking link that is extended in this website, you can go to straight guide site. And also, that's your time to get your favorite book.
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. 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.
Read more
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.
Read more
Product details
Paperback: 199 pages
Publisher: Wiley; 59778th edition (March 9, 2007)
Language: English
ISBN-10: 9780470042908
ISBN-13: 978-0470042908
ASIN: 0470042907
Product Dimensions:
7.5 x 0.5 x 9.2 inches
Shipping Weight: 14.4 ounces (View shipping rates and policies)
Average Customer Review:
4.0 out of 5 stars
25 customer reviews
Amazon Best Sellers Rank:
#413,936 in Books (See Top 100 in Books)
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 copy of this book that I received contained a single page (last page of Contents) that had a link to download accompany materials. When I visited that link, the download .zip actually contained an executable file that two separate virus programs ID as a trojan. The site itself redirected to a Wiley knock-off site with a .do domain. Be careful and don't use this link.However, as he did for other users here, I contacted the author and he sent over the correct materials very promptly. The book itself is a good intro, and the longer book by his former coworker (W. Preinitz) is a lengthier look at the same concepts.
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.
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.
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.
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 am working as an investment professional and as charted valuator. I use the framework described in this book and in the book reverse reengineering deals on Wall Street as basis for all my portfolio models. I can recommend these books to anyone who wants to analyse economics of portfolios. My clients love the detailed outcome of these models.
Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide PDF
Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide EPub
Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide Doc
Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide iBooks
Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide rtf
Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide Mobipocket
Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide Kindle
Post a Comment