Average Reviews:
(More customer reviews)Whether you're a seasoned veteran of the financial markets or a curious student looking to find out what all the fuss is down on Wall Street, "A Fast Track to Structured Finance" has something for you.
This book offers a very detailed approach to managing and analyzing the securitization process utilizing Excel and Visual Basic. What makes this book brilliant is its careful balance of the author's industry knowledge, well designed Excel templates and concise Visual Basic coding.
Bill opens up the book with a discussion of the securitization process. Here we get our first glimpse at his expertise is this subject. During this discussion he details how the integration of VBA and Excel will help streamline the analyst and management of the deal. Interspersed throughout the book are tidbits of history, personal experiences and humor that add to a very entertaining read.
Don't let the size of the book scare you. It's filled with numerous screen shots and code samples that add clarity. And as a bonus, the spreadsheet and code examples can be found on the Wiley website. The Visual Basic coding is incredibly well documented and is portable. You'll find yourself looking for opportunities to apply his unique strategies to your own projects. There are many tips he offers the novice programmer to help ensure that their code is easy to read and understand in the future. This is especially important when you come back to your code months later and wonder why you wrote that "if" statement.
(For those advanced Excel VBA users, check out the code in chapter 13 where Bill discusses the "Ineligible Collateral Report". Very cool.)
Bill also deserves credit for his integration of Excel spreadsheets with Visual Basic.
No longer will you have the fear of, "there's too much data, I need a database".
Bill proves it can all be done in Excel.
Well written, detailed, filled with examples and fun to read. "Where can I find a book on Structured Finance like that?" Look no further...
This is that book.
Click Here to see more reviews about: A Fast Track To Structured Finance Modeling, Monitoring and Valuation: Jump Start VBA (Wiley Finance)
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
Get 38% OFF
No comments:
Post a Comment