Intermediate structured finance modeling + website: leveraging Excel, VBA, Access, and PowerPoint

INDICE: Preface. 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. Style. A Parting Remark. On the Web Site. Acknowledgments. PART ONE. First Steps. CHAPTER 1. Introduction. CHAPTER 2. The Existing Model. CHAPTER 3. Conventions and Advice. CHAPTER 4. Segregation of the Existing Models Functionality. 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 Amortization Code. 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 Model Spreadsheet. 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. Afterword. Exhibits Index. Subject Index.

• ISBN: 978-0-470-56239-0
• Editorial: John Wiley & Sons
• Encuadernacion: Cartoné
• Páginas: 1032
• Fecha Publicación: 19/01/2011
• Nº Volúmenes: 1
• Idioma: Inglés