WILEY

KNOWLEDGE FOR GENERATIONS

WILEY - KNOWLEDGE FOR GENERATIONS

United States Change Location

cart.gif CART |  MY ACCOUNT |  CONTACT US |  HELP    
Cover image for product 0470398124
A Fast Track To Structured Finance Modeling, Monitoring and Valuation: Jump Start VBA
ISBN: 978-0-470-39812-8
Hardcover
576 pages
February 2009
US $95.00 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

  • Description
  • Table of Contents
This book is designed to start with simple examples that progressively develop the reader's confidence to take on more complex tasks. There is very little theoretical discussion about computer science, operations research algorithms, mathematics, or finance. The thrust of the book is to teach the reader to break complex tasks down into simple tasks. It then looks to implement those simple tasks into VBA code using a critical subset of the features of the language.

The tentative contents is :(1) Why? What? Who? Where? And How?; (2) Is Modeling an Art or Science?; (3) Securitizing an SBA Loan; (4) Designing the Cash Flow Waterfall; (5) Designing the VBA Model; (6) Laying the Model Groundwork; (7) First Look at the VBA Language: Recorded Macros; (8) Writing Menus: An Introduction to Data, Ranges, and Objects; (9) Controlling the Model Flow; (10) Building Messaging Capabilities; (11) Designing the Model's Reports; (12) Writing the Main Program; (13) Writing the Collateral Selection Code; (14) Calculating the Collateral Cash Flows; (15) Calculating the Waterfall Results; (16) Debugging the Model; (17) Validation of the Initial Results; (18) Running the Model; (19) Building in Additional Capabilities; (20) Documentation of the Model; (21) Managing the Growth of the Model