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.
A serious source of information for those looking to reverse engineer business deals It’s clear from the current turbulence on Wall Street that the inner workings of its most complex transactions are poorly understood. Wall Street deals parse risk using intricate legal terminology that is difficult to translate into an analytical model. Reverse Engineering Deals on Wall Street: A Step-By-Step Guide takes readers through a detailed methodology of deconstructing the public deal documentation of a modern Wall Street transaction and applying the deconstructed elements to create a fully dynamic model that can be used for risk and investment analysis. Appropriate for the current market climate, an actual residential mortgage backed security (RMBS) transaction is taken from prospectus to model by the end of the book. Step by step, Allman walks the reader through the reversing process with textual excerpts from the prospectus and discussions on how it directly transfers to a model. Each chapter begins with a discussion of concepts with exact references to an example prospectus, followed by a section called «Model Builder,» in which Allman translates the theory into a fully functioning model for the example deal. Also included is valuable VBA code and detailed explanation that shows proper valuation methods including loan level amortization and full trigger modeling. Aside from investment analysis this text can help anyone who wants to keep track of the competition, learn from others public transactions, or set up a system to audit one’s own models. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
A critical guide to corporate valuation modeling Valuation is at the heart of everything that Wall Street does. Every day, millions of transactions to purchase or sell companies take place based on prices created by the activities of all market participants. In this book, author Keith Allman provides you with a core model to value companies. Corporate Valuation Modeling takes you step-by-step through the process of creating a powerful corporate valuation model. Each chapter skillfully discusses the theory of the concept, followed by Model Builder instructions that inform you of every step necessary to create the template model. Many chapters also include a validation section that shows techniques and implementations that you can employ to make sure the model is working properly. Walks you through the full process of constructing a fully dynamic corporate valuation model A Tool Box section at the end of each chapter assists readers who may be less skilled in Excel techniques and functions Complete with a companion CD-ROM that contains constructed models, this book is an essential guide to understanding the intricacies of corporate valuation modeling. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Apply a rigorous investment process and integrate social impact analyses to successfully select and invest in social impact investments Impact Investment: A Practical Guide to Investment Process and Social Impact Analysis is a must-read guide for investors and wealth managers entering the social finance investment space known as «impact investing.» This book walks readers through the demanding task of properly executing an impact investment strategy, providing solutions to some of the most vexing challenges that arise when investing for both financial return and social impact. Readers will learn how impact investing is different from other strategies, how the organization's mission affects investment decisions and structures, and what to look for in an organization prior to investing. A running example of a village distribution company illustrates the methods and concepts in action, and a full-fledged case study utilizing downloadable professional level analytical tools consolidates all examples into a real-world setting. Impact investing is generating significant momentum, but many individuals operating in this space come from alternative backgrounds and lack the knowledge to form a rigorous investment process. Disparate funding sources, immature markets, variations in fund economics, and the need to generate and report social impact all complicate the industry even further, creating a barrier for curious investors. This book is a guide to applying standard investment processes and social impact analyses to impact investing, helping readers: Adjust standard analysis techniques to suit the particularities of impact investing Discover how social mission influences the entire investment from entry to exit Plan and execute a robust custom impact investment strategy Understand social impact entities and the management of impact investments Investing with the goal of social impact doesn't remove the need for rigorous investment techniques and diligent processes. Impact Investment: A Practical Guide to Investment Process and Social Impact Analysis is a guide to putting it all together, for a more targeted approach to impact investing.