Reverse Engineering Deals on Wall Street with Microsoft Excel

A Step-by-Step Guide

Business & Finance, Finance & Investing, Finance
Cover of the book Reverse Engineering Deals on Wall Street with Microsoft Excel by Keith A. Allman, Wiley
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Keith A. Allman ISBN: 9780470472156
Publisher: Wiley Publication: December 11, 2008
Imprint: Wiley Language: English
Author: Keith A. Allman
ISBN: 9780470472156
Publisher: Wiley
Publication: December 11, 2008
Imprint: Wiley
Language: English

A serious source of information for those looking to reverse engineer business deals

It’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. Reverse Engineering Deals on Wall Street: A Step-By-Step Guide 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.

Appropriate 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.

Aside 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.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

A serious source of information for those looking to reverse engineer business deals

It’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. Reverse Engineering Deals on Wall Street: A Step-By-Step Guide 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.

Appropriate 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.

Aside 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.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

More books from Wiley

Cover of the book Whiteness in Higher Education: The Invisible Missing Link in Diversity and Racial Analyses: ASHE Higher Education Report, Volume 42, Number 6 by Keith A. Allman
Cover of the book Method of Lines PDE Analysis in Biomedical Science and Engineering by Keith A. Allman
Cover of the book Mesh Generation by Keith A. Allman
Cover of the book EPR Spectroscopy by Keith A. Allman
Cover of the book Telecom For Dummies by Keith A. Allman
Cover of the book Performance Management For Dummies by Keith A. Allman
Cover of the book Children With School Problems: A Physician's Manual by Keith A. Allman
Cover of the book Structural Methods in Molecular Inorganic Chemistry by Keith A. Allman
Cover of the book Comprehensive Chiroptical Spectroscopy by Keith A. Allman
Cover of the book Creative Visualization For Dummies by Keith A. Allman
Cover of the book The Power of Identity by Keith A. Allman
Cover of the book Will China Dominate the 21st Century? by Keith A. Allman
Cover of the book Rethinking Undergraduate Business Education by Keith A. Allman
Cover of the book Reverse Engineering in Control Design by Keith A. Allman
Cover of the book Fracking by Keith A. Allman
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy