INTERMEDIATE STRUCTURED FINANCE MODELING by William Preinitz with Matthew Niedermaier, William Preinitz and Matthew Niedermaier, Preinitz, William, Niedermaier, Matthew ISBN 9780470928752, 9780470562390, 0470562390, 0470928751 instant download

INTERMEDIATE STRUCTURED FINANCE MODELING by William Preinitz with Matthew Niedermaier, William Preinitz and Matthew Niedermaier, Preinitz, William, Niedermaier, Matthew ISBN 9780470928752, 9780470562390, 0470562390, 0470928751 instant download

A pragmatic, hands-on approach to reaching an intermediate level of sophistication as a financial modeler

Intermediate Structured Finance Modeling is packed with insight and tips to teach you step by step to expand your current level of organizational, coding, modeling, and financial skills to enhance and develop new and more powerful applications. It expertly employs a code-intensive approach to improve your VBA and Excel skills and demonstrates how to integrate them with a real-life application.

Providing you with a set of immediately applicable modeling approaches, techniques, skills, and examples with a focus on large model development, you will learn how to:

• Organize and build a set of directories to contain the model system you will develop


• Separate an existing basic structured finance model into two special-purpose models, an Asset (collateral) model and a Liabilities Structure (bonds) model


• Expand the computational, data management, and reporting capabilities of both new models


• Employ Excel UserForms to build a sophisticated model interfaces


• Introduce Access databases and code to manage model data requirements and outputs


• Dramatically expand existing reporting packages, producing more sophisticated analytical results


• Automate the production of ready-to-use PowerPoint presentations


• Improve your model's ability to distribute its results by integrating Outlook mailing lists

If you have some modeling experience and are confident in your mastery of the fundamental features of VBA and Excel, Intermediate Structured Finance Modeling is the book for you. With working solutions to the challenges of developing larger scale models, you will learn successful intermediate modeling techniques that can be applied to any real-world situation and activity.

This book is the intermediate-level companion…