A Fast Track To Structured Finance Modeling, Monitoring and Valuation
Jump Start VBA
This book is intended to begin with straightforward illustrations that continuously build up the peruser’s certainty to go up against more mind boggling undertakings. There is next to no hypothetical talk about software engineering, operations look into calculations, science, or fund. The pushed of the book is to instruct the peruser to separate complex assignments into straightforward undertakings. It then hopes to actualize those straightforward assignments into VBA code utilizing a basic subset of the elements of the dialect.
The conditional substance is: (1) Why? What? Who? Where? also, How? (2) Common Sense (3) Securitizing A Loan Portfolio (4) Understanding the Excel Waterfall (5) Designing the VBA Model (6) Laying the Model Groundwork (7) Recorded Macros: A First Look at the VBA Language (8) Writing Menus: An Introduction to Data, Ranges, Arrays, and Objects (9) Controlling the Flow of the Model (10) Building Messaging Capabilities (11) Designing the Model’s Reports (12) Main Program and Menus (13) Writing the Collateral Selection Code (14) Calculating the Cash Flows (15) Running the Waterfall: Producing Initial Results (16) Debugging the Model (17) Validating the Model (18) Running the Model (19) Building Additional Capabilities (20) Documentation of the Model (21) Managing the Growth of the Model (22) Building Portfolio Monitoring Model (23) Valuation Techniques: How would we Determine Price? (24) Challenging Times For the Deal (25) Parting Admonitions