Reverse Engineering Deals on Wall Street with Microsoft Excel + Website: A Step-by-Step Guide

Valutazione media 0
( su 0 valutazioni fornite da Goodreads )
 
9780470242056: Reverse Engineering Deals on Wall Street with Microsoft Excel + Website: A Step-by-Step Guide

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.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

From the Back Cover:

Praise for Reverse Engineering Deals on Wall Street with Microsoft Excel

"Allman has written an excellent sequel to his first book Modeling Structured Finance Cash Flows with Microsoft Excel, 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."
Ralph Armenta, PMI Mortgage Insurance/Structured Transactions

"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."
Chandan Sengupta, author of Financial Modeling Using Excel and VBA

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

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

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

About the Author:

Keith A. Allman 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 Modeling Structured Finance Cash Flows with Microsoft Excel, which is published by Wiley.

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

1.

Allman
ISBN 10: 0470242051 ISBN 13: 9780470242056
Nuovi Quantità: 1
Da
Bookshub
(Karol Bagh, India)
Valutazione libreria
[?]

Descrizione libro Condizione libro: New. New. US edition. Perfect condition. Customer satisfaction our priority. Codice libro della libreria ABE-FEB-44084

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 42,82
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: India a: U.S.A.
Destinazione, tempi e costi

2.

Allman
ISBN 10: 0470242051 ISBN 13: 9780470242056
Nuovi Quantità: 1
Da
EBOOKSTORE2010
(New Delhi, ND, India)
Valutazione libreria
[?]

Descrizione libro Condizione libro: Brand New. New. US edition. Customer Satisfaction guaranteed!!. Codice libro della libreria SHUB44084

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 42,86
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: India a: U.S.A.
Destinazione, tempi e costi

3.

Allman
ISBN 10: 0470242051 ISBN 13: 9780470242056
Nuovi Quantità: 1
Da
Basi6 International
(Irving, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Condizione libro: Brand New. New, US edition. Excellent Customer Service. Codice libro della libreria ABEUSA-44084

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 45,21
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

4.

Allman, Keith A
Editore: John Wiley and#38; Sons (2008)
ISBN 10: 0470242051 ISBN 13: 9780470242056
Nuovi Quantità: > 20
Print on Demand
Da
Pbshop
(Wood Dale, IL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro John Wiley and#38; Sons, 2008. PAP. Condizione libro: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Codice libro della libreria IQ-9780470242056

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 58,06
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,34
In U.S.A.
Destinazione, tempi e costi

5.

Allman, Keith A.
Editore: Wiley (2017)
ISBN 10: 0470242051 ISBN 13: 9780470242056
Nuovi Paperback Quantità: > 20
Print on Demand
Da
Murray Media
(North Miami Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Wiley, 2017. Paperback. Condizione libro: New. Never used! This item is printed on demand. Codice libro della libreria 0470242051

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 62,74
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 1,67
In U.S.A.
Destinazione, tempi e costi

6.

Keith Allman
Editore: Wiley
ISBN 10: 0470242051 ISBN 13: 9780470242056
Nuovi Paperback Quantità: > 20
Da
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Wiley. Paperback. Condizione libro: New. Paperback. 224 pages. Dimensions: 9.1in. x 7.4in. x 0.6in.A serious source of information for those looking to reverse engineer business dealsIts 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 ones own models. Note: CD-ROMDVD and other supplementary materials are not included as part of eBook file. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Codice libro della libreria 9780470242056

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 63,76
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,31
In U.S.A.
Destinazione, tempi e costi

7.

Allman, Keith A
Editore: John Wiley and#38; Sons (2008)
ISBN 10: 0470242051 ISBN 13: 9780470242056
Nuovi Quantità: > 20
Print on Demand
Da
Books2Anywhere
(Fairford, GLOS, Regno Unito)
Valutazione libreria
[?]

Descrizione libro John Wiley and#38; Sons, 2008. PAP. Condizione libro: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Codice libro della libreria IQ-9780470242056

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 58,50
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 10,17
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

8.

Keith A. Allman
Editore: John Wiley and Sons Ltd, United Kingdom (2008)
ISBN 10: 0470242051 ISBN 13: 9780470242056
Nuovi Prima edizione Quantità: 10
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro John Wiley and Sons Ltd, United Kingdom, 2008. CD-ROM. Condizione libro: New. 1. Auflage. Language: English . Brand New. 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. Codice libro della libreria APC9780470242056

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 70,46
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

9.

Keith A. Allman
Editore: Wiley (2008)
ISBN 10: 0470242051 ISBN 13: 9780470242056
Nuovi Paperback Prima edizione Quantità: 1
Da
Irish Booksellers
(Rumford, ME, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Wiley, 2008. Paperback. Condizione libro: New. book. Codice libro della libreria M0470242051

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 70,88
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

10.

Allman
Editore: John Wiley & Sons (2016)
ISBN 10: 0470242051 ISBN 13: 9780470242056
Nuovi Paperback Quantità: 1
Print on Demand
Da
Ria Christie Collections
(Uxbridge, Regno Unito)
Valutazione libreria
[?]

Descrizione libro John Wiley & Sons, 2016. Paperback. Condizione libro: New. PRINT ON DEMAND Book; New; Publication Year 2016; Not Signed; Fast Shipping from the UK. No. book. Codice libro della libreria ria9780470242056_lsuk

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 74,16
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 4,37
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro