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

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.

Nyckelord: 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, Institutional & Corporate Finance, Institutional & Corporate Finance