{"product_id":"reverse-engineering-deals-on-wall-street-with-microsoft-excel-website-a-step-by-step-guide-with-cdrom-paperback","title":"Reverse Engineering Deals on Wall Street with Microsoft Excel, + Website: A Step-By-Step Guide [With CDROM] - 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 serious source of information for those looking to reverse engineer business deals\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eIt's clear from the current turbulence on Wall Street that the inner workings of its most complex transactions are poorly understood. Wall Street deals parse risk using intricate legal terminology that is difficult to translate into an analytical model. \u003ci\u003eReverse Engineering Deals on Wall Street: A Step-By-Step Guide\u003c\/i\u003e takes readers through a detailed methodology of deconstructing the public deal documentation of a modern Wall Street transaction and applying the deconstructed elements to create a fully dynamic model that can be used for risk and investment analysis.\u003c\/p\u003e \u003cp\u003eAppropriate for the current market climate, an actual residential mortgage backed security (RMBS) transaction is taken from prospectus to model by the end of the book. Step by step, Allman walks the reader through the reversing process with textual excerpts from the prospectus and discussions on how it directly transfers to a model. Each chapter begins with a discussion of concepts with exact references to an example prospectus, followed by a section called \"Model Builder,\" in which Allman translates the theory into a fully functioning model for the example deal. Also included is valuable VBA code and detailed explanation that shows proper valuation methods including loan level amortization and full trigger modeling.\u003c\/p\u003e \u003cp\u003eAside from investment analysis this text can help anyone who wants to keep track of the competition, learn from others public transactions, or set up a system to audit one's own models.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eNote: \u003c\/b\u003e CD-ROM\/DVD 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 Reverse Engineering Deals on Wall Street with Microsoft Excel\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eAllman has written an excellent sequel to his first book \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e, providing a simple guide on how to deconstruct cash flows through modeling and understanding the collateral by analyzing the prospectus. Whether you are new to the structured finance industry or steeped in structured financing--this book is a must-read.\u003cbr\u003e --\u003cb\u003eRalph Armenta\u003c\/b\u003e, PMI Mortgage Insurance\/Structured Transactions\u003c\/p\u003e \u003cp\u003eThe credit crisis has shown that more financial institutions and analysts need to be able to reverse-engineer structured finance deals to assess their values and risks for themselves. Keith Allman has produced a thorough guide for creating reverse-engineered models that both beginners and experienced analysts will find invaluable.\u003cbr\u003e --\u003cb\u003eChandan Sengupta\u003c\/b\u003e, author of \u003ci\u003eFinancial Modeling Using Excel and VBA\u003c\/i\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eA serious source of information for those looking to reverse-engineer business deals\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow does Wall Street keep track of the competition? They reverse-engineer deals by taking a prospectus or term sheet and recreating a model from it. The skills involved in this task are sophisticated, but are important to understand--especially in today's dynamic business environment.\u003c\/p\u003e \u003cp\u003eIn this practical resource, financial professional Keith Allman demystifies the process by interpreting complicated legal terminology and clearly showing how it can be organized into a dynamic model. Step by step, Allman walks you through this endeavor with textual excerpts from the prospectus and details how it directly transfers to a model. Each chapter begins with a discussion of concepts with exact references to an example prospectus, followed by a section called Model Builder, in which Allman translates the theory into a fully functioning model for the example deal. In addition, the companion CD-ROM features all of the modeling exercises, as well as a final version of the model that is outlined in the text.\u003c\/p\u003e\u003ch3\u003eBack Jacket\u003c\/h3\u003e\u003cp\u003e\u003cb\u003ePraise for Reverse Engineering Deals on Wall Street with Microsoft Excel\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\"Allman has written an excellent sequel to his first book \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e, providing a simple guide on how to deconstruct cash flows through modeling and understanding the collateral by analyzing the prospectus. Whether you are new to the structured finance industry or steeped in structured financing--this book is a must-read.\"\u003cbr\u003e --\u003cb\u003eRalph Armenta\u003c\/b\u003e, PMI Mortgage Insurance\/Structured Transactions\u003c\/p\u003e \u003cp\u003e\"The credit crisis has shown that more financial institutions and analysts need to be able to reverse-engineer structured finance deals to assess their values and risks for themselves. Keith Allman has produced a thorough guide for creating reverse-engineered models that both beginners and experienced analysts will find invaluable.\"\u003cbr\u003e --\u003cb\u003eChandan Sengupta\u003c\/b\u003e, author of \u003ci\u003eFinancial Modeling Using Excel and VBA\u003c\/i\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eA serious source of information for those looking to reverse-engineer business deals\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow does Wall Street keep track of the competition? They reverse-engineer deals by taking a prospectus or term sheet and recreating a model from it. The skills involved in this task are sophisticated, but are important to understand--especially in today's dynamic business environment.\u003c\/p\u003e \u003cp\u003eIn this practical resource, financial professional Keith Allman demystifies the process by interpreting complicated legal terminology and clearly showing how it can be organized into a dynamic model. Step by step, Allman walks you through this endeavor with textual excerpts from the prospectus and details how it directly transfers to a model. Each chapter begins with a discussion of concepts with exact references to an example prospectus, followed by a section called \"Model Builder,\" in which Allman translates the theory into a fully functioning model for the example deal. In addition, the companion CD-ROM features all of the modeling exercises, as well as a final version of the model that is outlined in the text.\u003c\/p\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003cb\u003eKeith A. Allman\u003c\/b\u003e is a capital markets professional with a specialization in analytics and modeling. He is currently the principal trainer and founder of Enstruct, a quantitative finance training company, as well as a Managing Director with NSM Capital Management. Prior to this, Allman was a vice president at Citigroup's Global Corporate and Investment Bank. He has also worked for MBIA Corporation in their Quantitative Analytics division. Allman is the author of \u003ci\u003eModeling Structured Finance Cash Flows with Microsoft Excel\u003c\/i\u003e, which is published by Wiley.\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.6 x 9 x 7.4 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 December 01, 2008\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":45343604441190,"sku":"9780470242056","price":105.8,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0599\/7255\/0758\/files\/WEtvSHBYbXNRaExiUDhKV2JQaU1vZz09.webp?v=1774939807","url":"https:\/\/infinitylightwa.com\/products\/reverse-engineering-deals-on-wall-street-with-microsoft-excel-website-a-step-by-step-guide-with-cdrom-paperback","provider":"Infinity Light","version":"1.0","type":"link"}