Intermediate Structured Finance Modeling

Leveraging Excel, VBA, Access, and Powerpoint
Wiley (Verlag)
  • erschienen am 3. Mai 2016
  • |
  • 1008 Seiten
E-Book | PDF mit Adobe-DRM | Systemvoraussetzungen
978-0-470-92875-2 (ISBN)
This book provides a pragmatic, hands-on approach to reaching an intermediate level of sophistication as a financial modeler. Expanding on the first book, A Fast Tract to Structured Finance Modeling, Monitoring, and Valuation, the book will guide you step-by-step through using learned principals in new and more powerful applications. These applications will build on the knowledge of Excel and VBA gained, expand the use of Access for data management tasks, as well as PowerPoint and Outlook for reporting and presentation tasks.
weitere Ausgaben werden ermittelt
WILLIAM PREINITZ has thirty years' experience in investmentbanking and structured finance analytics. A former managingdirector at Citigroup, highlights of his career include thecreation and marketing of securitizations backed by 12b-1 mutualfund fees. With a team of ten people over a fifteen-year period,his group concurrently provided analytical structuring support forthe over 100 different asset classes contained in the ABCP programof the bank. These included such varied items as movie revenues,fast-food franchise financing, and communication satellite leasing.In conjunction with the bank's corporate training program, hetaught Excel/VBA modeling classes to over 300 people ranging fromassociates to managing directors.
MATTHEW NIEDERMAIER is currently a vice president in theStructured Finance Group at Markit, where he is a member of apricing and valuation group focused on agency mortgages and CMOs.Within Markit he has also taught courses in Excel/VBA globally.Prior to Markit he modeled U.S. and Latin American ABS deals atCitigroup, including auto loans, credit cards, and timeshares.
Goals of the Book.
What You Should Know.
Setting the Context for Learning.
The Structure of the Book.
A Fish Story.
A Perspective on Modeling.
Approaching This Material.
A Parting Remark.
On the Web Site.
PART ONE. First Steps.
CHAPTER 1. Introduction.
CHAPTER 2. The Existing Model.
CHAPTER 3. Conventions and Advice.
CHAPTER 4. Segregation of the Existing Model'sFunctionality.
CHAPTER 5. Creating the Base Asset Model.
CHAPTER 6. Building the Base Liabilities Model.
CHAPTER 7. Establishing the Model Environment.
PART TWO. Building the New Assets Model.
CHAPTER 8. Designing the New Collateral Cash Flow Generator.
CHAPTER 9. Writing the CCFG Menus and Data Sheets.
CHAPTER 10. Writing the Collateral Data Handling Code.
CHAPTER 11. Writing the Collateral Selection Code.
CHAPTER 12. Writing the Collateral Cash Flow AmortizationCode.
CHAPTER 13. Writing the CCFG Reporting Capability.
PART THREE. Building the New Liabilities Model.
CHAPTER 14. Designing the Liabilities Waterfall Model.
CHAPTER 15. Writing the Liabilities Waterfall ModelSpreadsheet.
CHAPTER 16. Writing the LWM VBA Code.
PART FOUR. Access, PowerPoint, and Outlook.
CHAPTER 17. Access: An Introduction.
CHAPTER 18. Implementing Access in the CCFG and LWM.
CHAPTER 19. Implementing PowerPoint and Outlook in the CCFG.
PART FIVE. Running the CCFG and the LWM.
CHAPTER 20. Running the Models.
Exhibits Index.
Subject Index.

Dateiformat: PDF
Kopierschutz: Adobe-DRM (Digital Rights Management)


Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).

Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions (siehe E-Book Hilfe).

E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat PDF zeigt auf jeder Hardware eine Buchseite stets identisch an. Daher ist eine PDF auch für ein komplexes Layout geeignet, wie es bei Lehr- und Fachbüchern verwendet wird (Bilder, Tabellen, Spalten, Fußnoten). Bei kleinen Displays von E-Readern oder Smartphones sind PDF leider eher nervig, weil zu viel Scrollen notwendig ist. Mit Adobe-DRM wird hier ein "harter" Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie bei der Verwendung der Lese-Software Adobe Digital Editions: wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Download (sofort verfügbar)

112,99 €
inkl. 7% MwSt.
Download / Einzel-Lizenz
PDF mit Adobe-DRM
siehe Systemvoraussetzungen
E-Book bestellen