DMCA. Copyrighted Work that you can Claim.
Base have 223 081 books.
Search: 


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


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.

About book:

About file:

  • File size: 36 065 641
  • Format: epub


Security code:
Download button

Similar books results


Structural Equation Modeling With AMOS: Basic Concepts, Applications, and Programming (Multivariate Applications), 2nd edition
Structural Equation Modeling With AMOS: Basic Concepts, Applications, and Programming (Multivariate Applications), 2nd edition pdf free by Barbara Byrne

This bestselling text provides a practical guide to the basic concepts of structural equation modeling (SEM) and the AMOS program (Versions 17 & 18). The author reviews SEM applications based on?actual data taken from her research. Noted for its non-mathe...

Structured Finance Modeling with Object-Oriented VBA (Wiley Finance)
Structured Finance Modeling with Object-Oriented VBA (Wiley Finance) epub download by Evan Tick

This textbook is interesting. it describe the modeling in programming style and math. It make me easy to catch the relation of math formula and programming pesudo code. It does not only the math concept but pesudo code which is used to describe the concep...

LISREL 8: Structural Equation Modeling with the SIMPLIS Command Language
LISREL 8: Structural Equation Modeling with the SIMPLIS Command Language pdf free by Dag Sorbom

The book is supposed to serve as a guide to users of the LISREL program. I did not quite like the book because I am a fresh user to the program and the book does not take you step by step to what is required in doing structural equation modeling. this b...

Structural Equation Modeling: A Second Course
Structural Equation Modeling: A Second Course epub download by Gregory R. Hancock, Ralph O. Mueller

A volume in Quantitative Methods in Education and the Behavioral Sciences: Issues, Research, and Teaching (sponsored by the American Educational Research Association’s Special Interest Group: Educational Statisticians) Series Editor Ronald C. Ser...

Formulas and Functions with Microsoft Office Excel 2007 (Business Solutions)
Formulas and Functions with Microsoft Office Excel 2007 (Business Solutions) free download by Paul McFedries

“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you’re already an expert and you’re moving up to Excel 2007, this book will quickly show you features you’ve only d...

A Fast Track To Structured Finance Modeling, Monitoring and Valuation: Jump Start VBA (Wiley Finance)
A Fast Track To Structured Finance Modeling, Monitoring and Valuation: Jump Start VBA (Wiley Finance) pdf free by William Preinitz

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 finan...

Financial Modeling with Crystal Ball and Excel
Financial Modeling with Crystal Ball and Excel pdf free by John Charnes

Updated look at financial modeling and Monte Carlo simulation with software by Oracle Crystal Ball.This revised and updated edition of the bestselling book on financial modeling provides the tools and techniques needed to perform spreadsheet simulation. I...

Financial Modeling with Crystal Ball and Excel
Financial Modeling with Crystal Ball and Excel download pdf by John Charnes

An insightful look at financial modeling and Monte Carlo simulation using Crystal Ball softwareFinancial Modeling with Crystal Ball and Excel outlines the tools and techniques needed to become an expert in financial modeling and simulation. After reviewin...

Structural Equation Modelling: A Bayesian Approach (Wiley Series in Probability and Statistics)
Structural Equation Modelling: A Bayesian Approach (Wiley Series in Probability and Statistics) epub download by Sik-Yum Lee

Bayesian methods are moving into structural equation modeling. The most sophisticated approach to modeling interactions is Bayesian. People who want to be able to predict the values of observed variables need a Bayesian approach. This book, with the...

How to Instantly Connect with Anyone: 96 All-New Little Tricks for Big Success in Relationships

Geometric Stability Theory

Thinking Italian Translation: Teacher's Book (Thinking Translation)

The Phonological Spectrum, Volume 1: Segmental Structure
The Phonological Spectrum, Volume 1: Segmental Structure pdf free by Jeroen van de Weijer, Vincent J. van Heuven, Harry van der Hulst (Eds.)

The Definitive Guide to symfony (Definitive Guide)

Metacognition: Cognitive and Social Dimensions
Metacognition: Cognitive and Social Dimensions epub download by Vincent Y. Yzerbyt, Guy Lories, Benoit Dardenne

Game-Based Marketing: Inspire Customer Loyalty Through Rewards, Challenges, and Contests

CORROSION of LININGS and COATINGS: Cathodic and Inhibitor Protection and Corrosion Monitoring (Corrosion Engineering Handbook, Second Edition)

Engineering Ethics: An Industrial perspective

The last professors : the twilight of the humanities in the corporate university
The last professors : the twilight of the humanities in the corporate university download pdf by Donoghue, Frank

What makes the modern university different from any other corporation? asked Columbia's Andrew Delbanco recently in the New York Times. There is more and more reason to think: less and less,he answered. In this provocative book, Frank Donoghue shows how t...