skip to content
Reverse engineering deals on Wall Street with Microsoft Excel : a step-by-step guide Preview this item
ClosePreview this item
Checking...

Reverse engineering deals on Wall Street with Microsoft Excel : a step-by-step guide

Author: Keith A Allman
Publisher: Hoboken, N.J. : John Wiley & Sons, ©2009.
Series: Wiley finance series.
Edition/Format:   Print book : Document   Computer File : EnglishView all editions and formats
Database:WorldCat
Summary:

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  Read more...

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Material Type: Document, Internet resource
Document Type: Book, Computer File, Internet Resource
All Authors / Contributors: Keith A Allman
ISBN: 9780470242056 0470242051
OCLC Number: 232001986
Notes: Includes index.
Description: xv, 201 pages : illustrations ; 24 cm + 1 CD-ROM (4 3/4 in.).
Contents: Preface. Acknowledgments. About the Author. CHAPTER 1: Introduction. The Transaction. The Documents. The Process. How This Book Works. CHAPTER 2: Determining Dates and Setting Up Timing. Differences in Timing Approaches. A First Look at the Prospectus. Important Dates. Transforming Dates and Timing from Words to a Model. Model Builder 2.1: Reversing Dates and Timing. Conclusion of Dates and Timing. CHAPTER 3: Creating Asset Cash Flow from Prospectus Data. It's All in the Prospectus Supplement. The Basics of Amortization. Performance and the Prospectus Supplement. Delinquency. Loss. Prepayment. Recovery. Creating Cash Flow. A Complex Implementation. Model Builder 3.1: Entering in the Raw Asset Information. Model Builder 3.2: Entering in the Default and Prepayment Assumptions. Model Builder 3.3: Interest Rates and Additional Asset Amortization Inputs. Model Builder 3.4: Introducing VBA and Moving Data In and Out of the Model. Model Builder 3.5: Loading Loan Performance Assumptions into VBA. Model Builder 3.6: Global Functions. Model Builder 3.7: Loan-Level Asset Amortization. CHAPTER 4: Setting Up Liability Assumptions, Paying Fees, and Distributing Interest. Identifying the Offered Securities. Model Builder 4.1: Transferring the Liability Information to a Consolidated Sheet. The Liability Waterfall: A System of Priority. Model Builder 4.2: Starting the Waterfall with Fees. Interest: No Financing Is Free. Model Builder 4.3: Continuing the Waterfall with Interest Paid to the Certificate Holders. More on Waterfalls and Wall Street's Risk Parsing. Model Builder 4.4: Mezzanine Interest. Continuing the Waterfall: It Only Gets More Complicated. CHAPTER 5: Principal Repayment and the Shifting Nature of a Wall Street Deal. Model Builder 5.1: The Deal State and Senior Principal. Mezzanine Principal Returns. Model Builder 5.2: The Mezzanine Certificates' Priority of Payments. Number Games or Risk Parsing? CHAPTER 6: Credit Enhancement Mechanisms to Mitigate Loss. Model Builder 6.1: Excess Spread, Overcollateralization, and Credit Enhancement. CHAPTER 7: Auditing the Model. Model Builder 7.1. CHAPTER 8: Conclusion of Example Transaction and Final Thoughts on Reverse Engineering. Mortgage Insurance and Servicer Advances. Reverse Engineering in the Current and Future Market. Appendix. Automatic Range Naming. About the CD-ROM. Index.
Series Title: Wiley finance series.
Responsibility: Keith A. Allman.
More information:

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/232001986> # Reverse engineering deals on Wall Street with Microsoft Excel : a step-by-step guide
    a schema:CreativeWork, schema:MediaObject, schema:Book ;
    library:oclcnum "232001986" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nju> ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/197369424#Place/hoboken_n_j> ; # Hoboken, N.J.
    schema:about <http://experiment.worldcat.org/entity/work/data/197369424#Topic/marktubersicht> ; # Marktübersicht
    schema:about <http://experiment.worldcat.org/entity/work/data/197369424#Topic/deals_mathematical_models> ; # Deals--Mathematical models
    schema:about <http://id.worldcat.org/fast/1366659> ; # Microsoft Excel (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/197369424#Organization/new_york_stock_exchange> ; # New York Stock Exchange.
    schema:about <http://experiment.worldcat.org/entity/work/data/197369424#Topic/financial_engineering_mathematical_models> ; # Financial engineering--Mathematical models
    schema:about <http://experiment.worldcat.org/entity/work/data/197369424#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/197369424#Topic/mathematisches_modell> ; # Mathematisches Modell
    schema:about <http://experiment.worldcat.org/entity/work/data/197369424#Topic/borsenhandel> ; # Börsenhandel
    schema:about <http://id.loc.gov/authorities/subjects/sh85067718> ; # Investments--Mathematical models
    schema:about <http://experiment.worldcat.org/entity/work/data/197369424#Topic/excel> ; # EXCEL
    schema:about <http://dewey.info/class/338.830285554/e22/> ;
    schema:about <http://id.worldcat.org/fast/978277> ; # Investments--Mathematical models
    schema:bookFormat bgn:PrintBook ;
    schema:copyrightYear "2009" ;
    schema:creator <http://experiment.worldcat.org/entity/work/data/197369424#Person/allman_keith_a_1977> ; # Keith A. Allman
    schema:datePublished "2009" ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/197369424> ;
    schema:inLanguage "en" ;
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/197369424#Series/wiley_finance> ; # Wiley finance
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/197369424#Series/wiley_finance_series> ; # Wiley finance series.
    schema:name "Reverse engineering deals on Wall Street with Microsoft Excel : a step-by-step guide"@en ;
    schema:productID "232001986" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/232001986#PublicationEvent/hoboken_n_j_john_wiley_&_sons_2009> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/197369424#Agent/john_wiley_&_sons> ; # John Wiley & Sons
    schema:url <http://www.gbv.de/dms/zbw/569482631.pdf> ;
    schema:url <http://catdir.loc.gov/catdir/toc/ecip0820/2008025012.html> ;
    schema:url <http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&doc_number=017352802&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA> ;
    schema:workExample <http://worldcat.org/isbn/9780470242056> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/232001986> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/197369424#Agent/john_wiley_&_sons> # John Wiley & Sons
    a bgn:Agent ;
    schema:name "John Wiley & Sons" ;
    .

<http://experiment.worldcat.org/entity/work/data/197369424#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/197369424#Person/allman_keith_a_1977> # Keith A. Allman
    a schema:Person ;
    schema:birthDate "1977" ;
    schema:familyName "Allman" ;
    schema:givenName "Keith A." ;
    schema:name "Keith A. Allman" ;
    .

<http://experiment.worldcat.org/entity/work/data/197369424#Place/hoboken_n_j> # Hoboken, N.J.
    a schema:Place ;
    schema:name "Hoboken, N.J." ;
    .

<http://experiment.worldcat.org/entity/work/data/197369424#Series/wiley_finance> # Wiley finance
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/232001986> ; # Reverse engineering deals on Wall Street with Microsoft Excel : a step-by-step guide
    schema:name "Wiley finance" ;
    .

<http://experiment.worldcat.org/entity/work/data/197369424#Series/wiley_finance_series> # Wiley finance series.
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/232001986> ; # Reverse engineering deals on Wall Street with Microsoft Excel : a step-by-step guide
    schema:name "Wiley finance series." ;
    .

<http://experiment.worldcat.org/entity/work/data/197369424#Topic/financial_engineering_mathematical_models> # Financial engineering--Mathematical models
    a schema:Intangible ;
    schema:hasPart <http://id.loc.gov/authorities/subjects/sh91003887> ;
    schema:name "Financial engineering--Mathematical models"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/197369424#Topic/mathematisches_modell> # Mathematisches Modell
    a schema:Intangible ;
    schema:name "Mathematisches Modell"@en ;
    .

<http://id.loc.gov/authorities/subjects/sh85067718> # Investments--Mathematical models
    a schema:Intangible ;
    schema:name "Investments--Mathematical models"@en ;
    .

<http://id.worldcat.org/fast/1366659> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://id.worldcat.org/fast/978277> # Investments--Mathematical models
    a schema:Intangible ;
    schema:hasPart <http://id.loc.gov/authorities/subjects/sh85067718> ; # Investments--Mathematical models
    schema:name "Investments--Mathematical models"@en ;
    .

<http://worldcat.org/isbn/9780470242056>
    a schema:ProductModel ;
    schema:isbn "0470242051" ;
    schema:isbn "9780470242056" ;
    .

<http://www.gbv.de/dms/zbw/569482631.pdf>
    rdfs:comment "lizenzfrei" ;
    .

<http://www.worldcat.org/title/-/oclc/232001986>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <http://www.worldcat.org/oclc/232001986> ; # Reverse engineering deals on Wall Street with Microsoft Excel : a step-by-step guide
    schema:dateModified "2016-07-21" ;
    void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.