Reverse Engineering Deals on Wall Street with Microsoft E... and over one million other books are available for Amazon Kindle. Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Buy Used
Used - Good See details
$50.96 & this item ships for FREE with Super Saver Shipping. Details

or
Sign in to turn on 1-Click ordering.
 
   
Kindle Edition
 
   
More Buying Choices
Have one to sell? Sell yours here
Reverse Engineering Deals on Wall Street with Microsoft Excel: A Step-by-Step Guide (Wiley Finance)
 
 
Start reading Reverse Engineering Deals on Wall Street with Microsoft E... on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Reverse Engineering Deals on Wall Street with Microsoft Excel: A Step-by-Step Guide (Wiley Finance) [Paperback]

Keith Allman (Author)
5.0 out of 5 stars  See all reviews (1 customer review)

List Price: $95.00
Price: $61.21 & this item ships for FREE with Super Saver Shipping. Details
You Save: $33.79 (36%)
  Special Offers Available
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Only 4 left in stock--order soon (more on the way).
Want it delivered Friday, February 3? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for students on millions of items. Learn more

Formats

Amazon Price New from Used from
Kindle Edition $55.09  
Paperback $61.21  

Book Description

0470242051 978-0470242056 December 10, 2008 1
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.


Special Offers and Product Promotions

  • Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)

Frequently Bought Together

Reverse Engineering Deals on Wall Street with Microsoft Excel: A Step-by-Step Guide (Wiley Finance) + Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide.Book & CD-ROM + A Fast Track To Structured Finance Modeling, Monitoring and Valuation: Jump Start VBA (Wiley Finance)
Price For All Three: $162.84

Some of these items ship sooner than the others. Show details

Buy the selected items together


Editorial Reviews

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.

Product Details

  • Paperback: 224 pages
  • Publisher: Wiley; 1 edition (December 10, 2008)
  • Language: English
  • ISBN-10: 0470242051
  • ISBN-13: 978-0470242056
  • Product Dimensions: 7.5 x 0.5 x 9.3 inches
  • Shipping Weight: 14.9 ounces (View shipping rates and policies)
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Best Sellers Rank: #925,786 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

 

Customer Reviews

1 Review
5 star:
 (1)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (1 customer review)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

1 of 2 people found the following review helpful:
5.0 out of 5 stars Great Methods for Reverse Engineering Deals!, November 23, 2010
By 
Amazon Verified Purchase(What's this?)
This review is from: Reverse Engineering Deals on Wall Street with Microsoft Excel: A Step-by-Step Guide (Wiley Finance) (Paperback)
Keith provides clear methods and strategies to reverse engineer MBS securitizations. Keith addresses many of the issues you would encounter in trying to model complex structured finance transactions in Excel. He shows you methods of forecasting collateral cash flows that are necessary in order to model a deal correctly. This book is a must for anyone interested in evaluating structure finance transactions.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
stepdown date, trigger event, credit enhancement mechanisms, principal distributions, interest accrual period, realized losses, servicing fees, distribution account, loan performance, project window, servicing fee rate, first payment date, aggregate certificate principal balance, such distribution date, amortization arrays, day count system, preceding distribution date, corresponding cell references, related distribution date, unscheduled collections, first distribution date, analytics sheet, data validation list, aggregate principal balance, static pool information
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Mezzanine Certificates, Principal Distribution Amount, Model Builder, Prospectus Data, Creating Asset Cash Flow, Due Period, Distributing Interest, Paying Fees, Wall Street Deal, Setting Up Liability Assumptions, Interest Remittance Amount, Senior Enhancement Percentage, Interest Carry Forward Amount, Principal Remittance Amount, Mitigate Loss, Prepayment Period, Distribution Paid, Certificate Principal Balance, Interest Due, Rate Carryover Amount, Interest Paid, Lockout Distribution Percentage, Pass-Through Rate, Principal Distributed, Auditing the Model
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums



So You'd Like to...



Look for Similar Items by Category


Look for Similar Items by Subject