A Fast Track to Structured Finance Modeling, Monitoring, and Valuation

Jump Start VBA

Business & Finance, Finance & Investing, Finance
Cover of the book A Fast Track to Structured Finance Modeling, Monitoring, and Valuation by William Preinitz, Wiley
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: William Preinitz ISBN: 9780470446065
Publisher: Wiley Publication: February 17, 2009
Imprint: Wiley Language: English
Author: William Preinitz
ISBN: 9780470446065
Publisher: Wiley
Publication: February 17, 2009
Imprint: Wiley
Language: English

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) 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 do we Determine Price? (24) Challenging Times For the Deal (25) Parting Admonitions

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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) 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 do we Determine Price? (24) Challenging Times For the Deal (25) Parting Admonitions

More books from Wiley

Cover of the book A Companion to Renaissance Poetry by William Preinitz
Cover of the book Parasitology by William Preinitz
Cover of the book Child and Adolescent Therapy by William Preinitz
Cover of the book The Field Description of Metamorphic Rocks by William Preinitz
Cover of the book Clint Eastwood's America by William Preinitz
Cover of the book Thermoset Nanocomposites by William Preinitz
Cover of the book Auditing Leadership by William Preinitz
Cover of the book In Praise of Literature by William Preinitz
Cover of the book Successful Defined Contribution Investment Design by William Preinitz
Cover of the book Nonresponse in Household Interview Surveys by William Preinitz
Cover of the book Hydrogen Bonding and Transfer in the Excited State by William Preinitz
Cover of the book Hydrodynamics of Gas-Liquid Reactors by William Preinitz
Cover of the book Biotechnology of Bioactive Compounds by William Preinitz
Cover of the book Oberflachentechnik fur den Maschinenbau by William Preinitz
Cover of the book Sport and Exercise Nutrition by William Preinitz
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy