Login

Niedermaier, Matthew

Intermediate Structured Finance Modeling: Leveraging Excel, VBA, Access, and Powerpoint

Niedermaier, Matthew - Intermediate Structured Finance Modeling: Leveraging Excel, VBA, Access, and Powerpoint, ebook

DRM Restrictions

Printing302 pages with an additional page accrued every 3 hours, capped at 302 pages
Copy to clipboard50 excerpts

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.

Keywords: model evolution, tiered reporting, balloon mortgages, hybrid adjustable rate mortgages, market value decline, recovery lag period, liabilities waterfall, multiple tranche structure, interest rate swap, financial selection criteria, demographic selection criteria, geographic selection criteria, geographic concentration criteria, eligible collateral, floater rate index, pricing spreads, structured finance, VBA module organization, Constant variables, Excel UserForms, stratification reports, cross-tabulation reports, dynamic report generation, representative lines, demographic risk factors, data sufficiency testing, CPR, PSA, Geographic Prepayment/Default Methodology, Demographic Default Methodology, representative line generator program, menu data sheets, Metropolitan Statistical Areas, assumption reporting, demographic risk factors, geographic prepayment/default curves, PowerPoint presentation reports, payment subordination, credit enhancement, targeted subordination, excess spread, step down characteristics, cleanup call, performance triggers, overcollateralization, loss allocations, Access data bases, SQL, ADODB connections, null reports, stress case modeling, William Preinitz, Matthew Niedermaier, structured finance modeling

Author(s)
 
Publisher
John Wiley and Sons, Inc.
Publication year
2011
Language
en
Edition
1
Series
Wiley Finance
Page amount
1008 pages
Category
Economy
Format
Ebook
eISBN (ePUB)
9780470928783
Printed ISBN
9780470562390

Similar titles