Praise for Modeling Structured Finance Cash Flows with Microsoft(R) Excel(R)

"You can roll up your sleeves, dive into this book, and shortly thereafter, you have a full-blown honest-to- goodness working model of a transaction. This sure beats the old method of slaving at the feet of gurus for years in the hopes that they'll throw you a scrap. It almost feels as though Allman has given away a shortcut through the 'hazing' period of learning, but then I am grateful I have a resource with which to train new analysts or remind myself how some things work."
--Omar Haneef, Global Securitized Markets, Citigroup

"Allman has written a book that reveals to the reader/user a robust framework for using Excel to model structured finance transactions. Both seasoned cash flow modelers and those new to, or curious about, how structured finance transactions are analyzed can benefit from this book."
--Henry Wilson, Bond Insurance Company Analyst

"A powerful, concise, and tiered approach. It's a bedrock foundation to build on for both the art and science of structured finance modeling. An excellent platform from which to leverage your financial knowledge and personal capital."
--William Preinitz, Managing Director, Citigroup

"An essential tool for any credit officer wishing to gain a general or in-depth understanding of cash flow modeling for new or existing deals."
--Joseph B. Keener, Structured Portfolio Management, Citigroup London

Written by industry expert Keith Allman, this well-rounded resource provides detailed guidance on constructing one of today's most adaptable models--the cash flow model. Filled with in-depth insight, expert advice, and illustrative examples, Modeling Structured Finance Cash Flows with Microsoft Excel explains individual functions and formulas, while also examining 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 CD-ROM features all of the modeling exercises, as well as a final version of the model that is created in the text.

By combining specific application instruction with theory, Modeling Structured Finance Cash Flows with Microsoft Excel will teach you skills that can be instantly applied to professional-level modeling.

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.

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.