A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA

A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA, 9780470398128 (0470398124), John Wiley & Sons, 2009

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

Comments

Amazing Books

Bond Investing For Dummies

For Dummies, 2007

Bonds and bond funds are among the safest and most reliable investments you can make to ensure an ample and dependable retirement income — if you do it right! Bond Investing For Dummies helps you do just that, with clear explanations of everything you need to know to build a diversified bond portfolio that will be there when you...

Advanced Batteries: Materials Science Aspects

Springer, 2008

Energy is important to all of us, for a variety of reasons, but primarily because it can be useful. It can be found in a number of different forms. One readily recognizes the concepts of potential energy and kinetic energy, as well as the chemical energy in fuels, thermal energy as heat, the kinetic energy in wind and moving water, and magnetic and...

Electronic Design Automation of Analog ICs combining Gradient Models with Multi-Objective Evolutionary Algorithms (SpringerBriefs in Applied Sciences and Technology)

Springer, 2013

This book applies to the scientific area of electronic design automation (EDA) and addresses the automatic sizing of analog integrated circuits (ICs). Particularly, this book presents an approach to enhance a state-of-the-art layout-aware circuit-level optimizer (GENOM-POF), by embedding statistical knowledge from an automatically generated...

Intelligent Paradigms for Assistive and Preventive Healthcare (Studies in Computational Intelligence)

Springer, 2006

This book presents some of the recent advances in assistive and preventive healthcare in intelligent environment. As the world is becoming increasingly aware of the needs of people with disabilities, researchers are finding new technologies and applications to assist disabled people in performing the everyday activities which able-bodied people...

Credit Risk Modeling using Excel and VBA (The Wiley Finance Series)

John Wiley & Sons, 2007

In today's increasingly competitive financial world, successful risk management, portfolio management, and financial structuring demand more than up-to-date financial know-how. They also call for quantitative expertise, including the ability to effectively apply mathematical modeling tools and techniques, in this case credit.

Credit Risk...

Aqa Business for Gcse: Applied Options

Hodder Education, 2010

This book provides information, exercises and materials to cover the learning required for the new AQA GCSE Applied Business (Double Award).

The new GCSE qualification has several routes, but all begin with ‘Setting Up a Business’. This unit is an introduction to setting up and running a business and looks at the...