A Fast Track To Structured Finance Modeling, Monitoring and Valuation. Jump Start VBA

A detailed look at how object-oriented VBA should be used to model complex financial structures This guide helps readers overcome the difficult task of modeling complex financial structures and bridges the gap between professional C++/Java programmers writing production models and front-office analysts building Excel spreadsheet models. It reveals how to model financial structures using object-oriented VBA in an Excel environment, allowing desk-based analysts to quickly produce flexible and robust models. Filled with in-depth insight and expert advice, it skillfully illustrates the art of object-oriented programming for the explicit purpose of modeling structured products. Residential mortgage securitization is used as a unifying example throughout the text.

Structured Finance: The Object Orientated Approach is aimed at both the finance and IT professionals involved in the structured finance business with the intention of sharing common concepts and language within the industry. The financial community (structurers, pricers and risk managers) view structured products as collections of objects under the so-called replicating portfolio paradigm. The IT community use object oriented programming (OOP) techniques to improve the software updating and maintenance process. For them structured products are collections of objects as well. Despite use of the same object concept, it looks like communication between these different professional functions has been problematic. Recently, construction of standard data structures known as FpML has begun to lay out a common definition of objects, at least for plain vanilla derivatives, both between IT and financial people and across different market players. Along this line, this book builds upon the concept of object to provide frontier treatment of structured finance issues relevant to both communities engaged in building, pricing and hedging products and people engaged in designing and up-dating the corresponding software. Structured Finance: The Object Orientated Approach will enable you to: decompose a structured product in elementary constituent financial objects and risk factors (replicating portfolio) understand the basics of object oriented programming (OOP) applied to the design of structured cash flows objects build your own objects and to understand FpML data structures available for standard products gauge risk exposures of the objects in structured products to: risk factors, their volatilities and the correlation among them (which factor are you long/short? Are you long/short volatility? Are you long/short correlation?) update your risk management system to accommodate structured products with non linear exposures and to design objects to represent, price and hedge, counterparty risk

A practical guide to building fully operational financial cash flow models for structured finance transactions Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called «Model Builder,» in which Allman translates the theory into functions and formulas. In addition, the companion website features all of the modeling exercises, as well as a final version of the model that is created in the text. Note: Companion website and other supplementary materials are not included as part of eBook file.

Comprehensive instruction on developing real-world financial models This book, designed for self-study, classroom use, and reference, presents a com-prehensive approach to developing simple to sophisticated financial models in all major areas of finance. The approach is based on the author's 20 years of experience of developing such models in the business world and teaching a popular MBA class in financial modeling. The book assumes only basic knowledge of Excel and teaches all advanced features of Excel and VBA from scratch using a unique simple method. A companion CD includes all working versions of all the models presented in the book and additional useful reference material. Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at Fordham University's Graduate School of Business. Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. He is also the author of The Only Proven Road to Investment Success (0-471-44307-7).

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 Modeling using Excel and VBA with DVD provides practitioners with a hands on introduction to credit risk modeling. Instead of just presenting analytical methods it shows how to implement them using Excel and VBA, in addition to a detailed description in the text a DVD guides readers step by step through the implementation. The authors begin by showing how to use option theoretic and statistical models to estimate a borrowers default risk. The second half of the book is devoted to credit portfolio risk. The authors guide readers through the implementation of a credit risk model, show how portfolio models can be validated or used to access structured credit products like CDO’s. The final chapters address modeling issues associated with the new Basel Accord.

A clear and comprehensive guide to financial modeling and valuation with extensive case studies and practice exercises Corporate and Project Finance Modeling takes a clear, coherent approach to a complex and technical topic. Written by a globally-recognized financial and economic consultant, this book provides a thorough explanation of financial modeling and analysis while describing the practical application of newly-developed techniques. Theoretical discussion, case studies and step-by-step guides allow readers to master many difficult modeling problems and also explain how to build highly structured models from the ground up. The companion website includes downloadable examples, templates, and hundreds of exercises that allow readers to immediately apply the complex ideas discussed. Financial valuation is an in-depth process, involving both objective and subjective parameters. Precise modeling is critical, and thorough, accurate analysis is what bridges the gap from model to value. This book allows readers to gain a true mastery of the principles underlying financial modeling and valuation by helping them to: Develop flexible and accurate valuation analysis incorporating cash flow waterfalls, depreciation and retirements, updates for new historic periods, and dynamic presentation of scenario and sensitivity analysis; Build customized spreadsheet functions that solve circular logic arising in project and corporate valuation without cumbersome copy and paste macros; Derive accurate measures of normalized cash flow and implied valuation multiples that account for asset life, changing growth, taxes, varying returns and cost of capital; Incorporate stochastic analysis with alternative time series equations and Monte Carlo simulation without add-ins; Understand valuation effects of debt sizing, sculpting, project funding, re-financing, holding periods and credit enhancements. Corporate and Project Finance Modeling provides comprehensive guidance and extensive explanation, making it essential reading for anyone in the field.

A discussion-based learning approach to corporate finance fundamentals Lessons in Corporate Finance explains the fundamentals of the field in an intuitive way, using a unique Socratic question and answer approach. Written by award-winning professors at M.I.T. and Tufts, this book draws on years of research and teaching to deliver a truly interactive learning experience. Each case study is designed to facilitate class discussion, based on a series of increasingly detailed questions and answers that reinforce conceptual insights with numerical examples. Complete coverage of all areas of corporate finance includes capital structure and financing needs along with project and company valuation, with specific guidance on vital topics such as ratios and pro formas, dividends, debt maturity, asymmetric information, and more. Corporate finance is a complex field composed of a broad variety of sub-disciplines, each involving a specific skill set and nuanced body of knowledge. This text is designed to give you an intuitive understanding of the fundamentals to provide a solid foundation for more advanced study. Identify sources of funding and corporate capital structure Learn how managers increase the firm's value to shareholders Understand the tools and analysis methods used for allocation Explore the five methods of valuation with free cash flow to firm and equity Navigating the intricate operations of corporate finance requires a deep and instinctual understanding of the broad concepts and practical methods used every day. Interactive, discussion-based learning forces you to go beyond memorization and actually apply what you know, simultaneously developing your knowledge, skills, and instincts. Lessons in Corporate Finance provides a unique opportunity to go beyond traditional textbook study and gain skills that are useful in the field.

This new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. The book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is essential for financial practitioners who need to develop their financial modelling skill sets as there is an increase in the need to analyse and develop ever more complex 'what if' scenarios. Specifically applies Excel and VBA to the financial markets Packaged with a CD containing the software from the examples throughout the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Essential guidance for the corporate finance professional – advisor, Board Director, CFO, Treasurer, business development executive, or M&A expert—to ask the right questions and make the critical decisions. Strategic Corporate Finance is a practical guide to the key issues, their context, and their solutions. From performance measurement and capital planning to risk management and capital structure, Strategic Corporate Finance, translates principles of corporate finance theory into practical methods for implementing them. Filled with in-depth insights, expert advice, and detailed case studies, Strategic Corporate Finance will prepare you for the issues involved in raising, allocating and managing capital, and its associated risks. Justin Pettit (New York, NY) draws on his 15 years of senior advisory experience as an investment banker and management consultant. He advises corporate boards and executives on matters of capital structure, financial policy, valuation, and strategy. He also lectures on topics in advanced corporate finance to graduate and undergraduate students at universities in the New York area.