Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint Book PDF, ePub eBook

Join our eBook service for unlimited books & audiobooks. Get a free 7 day subscription! ↓↓↓↓↓


Book Descriptions:
This book is written for financial analysts who have a working knowledge of Excel and VBA and who wish to enhance their marketability by improving their modeling expertise.  The goal of the book is to broaden the reader’s VBA skills and at the same time to progressively integrate Access, PowerPoint, and Outlook into an existing model.  Significant attention is also directed to the design and execution of an Excel/VBA interface employing detailed UserForms.  In addition, the construction of various reports, first in Excel, then Access, and finally PowerPoint is undertaken.  Regardless of your area of financial expertise, this book serves as an essential guide to mastering leveraging the effects of Microsoft products in whatever applications you choose to build.

The focus of the book is a case study containing a structured finance model.  The case study model was originally designed for the securitization of a portfolio of commercial small business loans.  This model now needs to be expanded to securitize a much larger portfolio of residential mortgages. 

The Original Structuring model will be bifurcated into a Sources of Funds model, the assets of the collateral pool, and a Uses of Funds model, the liabilities waterfall model.  This will give the reader experience working with an existing model as a base departure point of development rather than the less common “start from scratch” approach.  Once the Base Asset Model (BAM) and the Base Liabilities Models (BLM) are complete, each model will serve as the platform for future development.  From the BAM and BLM a pair of much more robust models, the Collateral Cash Flow Generator (CCFG) and the Liabilities Waterfall Model (LWM), respectively, are created.  The CCFG is designed to process a significantly greater quantity, variety, and complexity of collateral types.  It also introduces the analyst to Geographic based prepayment methods as well as those using Financial/Demographic factor approaches. The LWM, operating independently of the CCFG, reads the collateral cash flow scenarios and applies them across a two tiered, six tranche bond structure.  The liabilities waterfall contains provision for an interest rate swap, performance triggers and a variety of other credit enhancement features.

With the CCFG and LWM now complete Access is introduced.  Access will replace various Excel/VBA code modules in the CCFG such as the collateral data management, data scrubbing and reporting, data sufficiency testing, and eligibility screening.  Access is also employed to export and the various collateral cash flows.   In the LWM Access is used to import the cash flows, store the liability structure specifications, and export/save the resultant structure performance.  PowerPoint is then introduced in the CCFG to allow for the fully automated production of presentation report packages.  Last Outlook is added to the models to inform the analyst of model performance and to automatically distribute the various report packages to pre-designated mailing lists.

The book contains over 750 exhibits of reports, menus, calculation, and algorithmic examples and most of all code.  The complete Excel, VBA, Access, PowerPoint, and Outlook code for all of the models is included on the Web site.  The Web site also includes Web chapters containing detailed instructions on how to create and populate a directory environment to store this code, run the models, and organize the results.  Lastly there are other Web chapters containing supplemental information explaining the structure and function of the original model, bond and mortgage math (with calculation examples), representative line generator programs, and a tutorial on the construction and integration of UserForms.

This book is the intermediate level companion volume to A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA; Preinitz; Wiley 2009, an introductory work on the subject.

Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint by William Preinitz, Matthew Niedermaier

From reader reviews:

Abel Graham:

Reading can called imagination hangout, why? Because if you are reading a book mainly book entitled Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint your brain will drift away trough every dimension, wandering in every aspect that maybe not known for but surely can be your mind friends. Imaging every word written in a guide then become one web form conclusion and explanation that will maybe you never get just before. The Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint giving you one more experience more than blown away your mind but also giving you useful data for your better life in this particular era. So now let us explain to you the relaxing pattern is your body and mind will probably be pleased when you are finished reading it, like winning a casino game. Do you want to try this extraordinary shelling out spare time activity?

Tracy Lindsey:

In this era globalization it is important to someone to find information. The information will make a professional understand the condition of the world. The condition of the world makes the information better to share. You can find a lot of referrals to get information example: internet, magazine, book, and soon. You can see that now, a lot of publisher this print many kinds of book. The particular book that recommended for your requirements is Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint this publication consist a lot of the information on the condition of this world now. This specific book was represented how can the world has grown up. The dialect styles that writer use to explain it is easy to understand. The particular writer made some study when he makes this book. Honestly, that is why this book ideal all of you.

Richard Brassell:

Many people spending their moment by playing outside using friends, fun activity together with family or just watching TV all day long. You can have new activity to spend your whole day by reading through a book. Ugh, you think reading a book can definitely hard because you have to use the book everywhere? It alright you can have the e-book, taking everywhere you want in your Mobile phone. Like Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint which is finding the e-book version. So , why not try out this book? Let's view.

Suzanne Palmer:

This Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint is brand new way for you who has intense curiosity to look for some information mainly because it relief your hunger associated with. Getting deeper you in it getting knowledge more you know or you who still having little digest in reading this Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint can be the light food for you personally because the information inside this specific book is easy to get simply by anyone. These books build itself in the form and that is reachable by anyone, sure I mean in the e-book application form. People who think that in e-book form make them feel drowsy even dizzy this publication is the answer. So there is absolutely no in reading a publication especially this one. You can find what you are looking for. It should be here for a person. So , don't miss that! Just read this e-book style for your better life along with knowledge.