{"product_id":"modeling-structured-finance-cash-flows-with-microsoft-excel-a-step-by-step-guide-paperback","title":"Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-By-Step Guide - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eKeith A. Allman\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003cb\u003eA practical guide to building fully operational financial cash flow models for structured finance transactions\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eStructured 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. \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e 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.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eNote: \u003c\/b\u003e Companion website and other supplementary materials are not included as part of eBook file.\u003c\/p\u003e\u003ch3\u003eFront Jacket\u003c\/h3\u003e\u003cp\u003e\u003cb\u003ePraise for \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e \u003c\/p\u003e\u003cp\u003eYou 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.\u003cbr\u003e--\u003cb\u003eOmar Haneef\u003c\/b\u003e, Global Securitized Markets, Citigroup\u003c\/p\u003e \u003cp\u003eAllman 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.\u003cbr\u003e--\u003cb\u003eHenry Wilson\u003c\/b\u003e, Bond Insurance Company Analyst\u003c\/p\u003e \u003cp\u003eA 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.\u003cbr\u003e--\u003cb\u003eWilliam Preinitz\u003c\/b\u003e, Managing Director, Citigroup\u003c\/p\u003e \u003cp\u003eAn essential tool for any credit officer wishing to gain a general or in-depth understanding of cash flow modeling for new or existing deals.\u003cbr\u003e--\u003cb\u003eJoseph B. Keener\u003c\/b\u003e, Structured Portfolio Management, Citigroup London\u003c\/p\u003e \u003cp\u003eWritten 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, \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e 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.\u003c\/p\u003e \u003cp\u003eBy combining specific application instruction with theory, \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e will teach you skills that can be instantly applied to professional-level modeling.\u003c\/p\u003e\u003ch3\u003eBack Jacket\u003c\/h3\u003e\u003cp\u003e\u003cb\u003ePraise for \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e \u003c\/p\u003e\u003cp\u003e\"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.\"\u003cbr\u003e--\u003cb\u003eOmar Haneef\u003c\/b\u003e, Global Securitized Markets, Citigroup\u003c\/p\u003e \u003cp\u003e\"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.\"\u003cbr\u003e--\u003cb\u003eHenry Wilson\u003c\/b\u003e, Bond Insurance Company Analyst\u003c\/p\u003e \u003cp\u003e\"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.\"\u003cbr\u003e--\u003cb\u003eWilliam Preinitz\u003c\/b\u003e, Managing Director, Citigroup\u003c\/p\u003e \u003cp\u003e\"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.\"\u003cbr\u003e--\u003cb\u003eJoseph B. Keener\u003c\/b\u003e, Structured Portfolio Management, Citigroup London\u003c\/p\u003e \u003cp\u003eWritten 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, \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e 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.\u003c\/p\u003e \u003cp\u003eBy combining specific application instruction with theory, \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e will teach you skills that can be instantly applied to professional-level modeling.\u003c\/p\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003cb\u003eKeith Allman\u003c\/b\u003e 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.\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 224\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.47 x 9.19 x 7.57 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eIllustrated:\u003c\/strong\u003e Yes\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e February 01, 2007\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":45342673698918,"sku":"9780470042908","price":104.76,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0599\/7255\/0758\/files\/b05iWDlzL0phQjk0cHIzZ050ZnRwUT09.webp?v=1774896575","url":"https:\/\/infinitylightwa.com\/products\/modeling-structured-finance-cash-flows-with-microsoft-excel-a-step-by-step-guide-paperback","provider":"Infinity Light","version":"1.0","type":"link"}