Reverse Engineering Deals on Wall Street with Microsoft Excel

Inhaltsverzeichnis

Preface.

Acknowledgements.

About the Author.

Chapter 1. Introduction.

The Transaction.

The Documents.

The Process.

How This Book Works.

Chapter 2. Determining Dates and Setting Up Times.

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

Automatic Range Naming.

About the CD.

Index.

Reverse Engineering Deals on Wall Street with Microsoft Excel

A Step-by-Step Guide

Buch (Taschenbuch, Englisch)

Fr.137.00

inkl. gesetzl. MwSt.
Taschenbuch

Taschenbuch

Fr. 137.00

Reverse Engineering Deals on Wall Street with Microsoft Excel

Ebenfalls verfügbar als:

Taschenbuch

Taschenbuch

ab Fr. 137.00
eBook

eBook

ab Fr. 60.00

Beschreibung

Details

Einband

Taschenbuch

Erscheinungsdatum

13.11.2008

Verlag

John Wiley & Sons, Ltd.

Seitenzahl

224

Maße (L/B/H)

23.5/19.1/1.2 cm

Beschreibung

Details

Einband

Taschenbuch

Erscheinungsdatum

13.11.2008

Verlag

John Wiley & Sons, Ltd.

Seitenzahl

224

Maße (L/B/H)

23.5/19.1/1.2 cm

Gewicht

420 g

Auflage

1. Auflage

Reihe

Wiley Finance Editions

Sprache

Englisch

ISBN

978-0-470-24205-6

Das meinen unsere Kund*innen

0.0

0 Bewertungen

Informationen zu Bewertungen

Zur Abgabe einer Bewertung ist eine Anmeldung im Kund*innenkonto notwendig. Die Authentizität der Bewertungen wird von uns nicht überprüft. Wir behalten uns vor, Bewertungstexte, die unseren Richtlinien widersprechen, entsprechend zu kürzen oder zu löschen.

Verfassen Sie die erste Bewertung zu diesem Artikel

Helfen Sie anderen Kund*innen durch Ihre Meinung

Erste Bewertung verfassen

Unsere Kund*innen meinen

0.0

0 Bewertungen filtern

Die Leseprobe wird geladen.
  • Reverse Engineering Deals on Wall Street with Microsoft Excel
  • Preface.

    Acknowledgements.

    About the Author.

    Chapter 1. Introduction.

    The Transaction.

    The Documents.

    The Process.

    How This Book Works.

    Chapter 2. Determining Dates and Setting Up Times.

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

    Automatic Range Naming.

    About the CD.

    Index.