Modeling Structured Finance Cash Flows with Microsoft Excel. A Step-by-Step Guide

I've worked with simulation in business for over 20 years, and Allman really nails it with this book. I admit that I own his previous book on structured finance cash flows, but I was surprised by what I found in here. He addresses the fundamental questions of how decision makers react to simulations and his read was very much in accordance with what I've experienced myself. When it came to the nuts and bolts of describing the different types of simulation analysis the book becomes incredibly detailed. There is working code and models for a fantastic array of the most common simulation problems. If you're so inclined, the book very carefully steps through the tricky math needed to really understand the theory behind stochastic modeling in finance. If you're preparing models that include any kind of randomization or stochastic modeling component, this book is a must-read, a tremendous value and time-saver. – David Brode of The Brode Group A practical guide to understanding and implementing financial simulation modeling As simulation techniques become more popular among the financial community and a variety of sub-industries, a thorough understanding of theory and implementation is critical for practitioners involved in portfolio management, risk management, pricing, and capital budgeting. Financial Simulation Modeling in Excel contains the information you need to make the most informed decisions possible in your professional endeavors. Financial Simulation Modeling in Excel contains a practical, hands-on approach to learning complex financial simulation methodologies using Excel and VBA as a medium. Crafted in an easy to understand format, this book is suitable for anyone with a basic understanding of finance and Excel. Filled with in-depth insights and expert advice, each chapter takes you through the theory behind a simulation topic and the implementation of that same topic in Excel/VBA in a step-by-step manner. Organized in an easy-to-follow fashion, this guide effectively walks you through the process of creating and implementing risk models in Excel A companion website contains all the Excel models risk experts and quantitative analysts need to practice and confirm their results as they progress Keith Allman is the author of other successful modeling books, including Corporate Valuation Modeling and Modeling Structured Finance Cash Flows with Microsoft Excel Created for those with some background in finance and experience in Excel, this reliable resource shows you how to effectively perform sound financial simulation modeling, even if you've yet to do extensive modeling up to this point in your professional or academic career.

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.

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

Praise for Computer-Aided Fraud Prevention and Detection: A Step-by-Step Guide «A wonderful desktop reference for anyone trying to move from traditional auditing to integrated auditing. The numerous case studies make it easy to understand and provide a how-to for those?seeking to implement automated tools including continuous assurance. Whether you are just starting down the path or well on your way, it is a valuable resource.» -Kate M. Head, CPA, CFE, CISA Associate Director, Audit and Compliance University of South Florida «I have been fortunate enough to learn from Dave's work over the last fifteen years, and this publication is no exception. Using his twenty-plus years of experience, Dave walks through every aspect of detecting fraud with a computer from the genesis of the act to the mining of data for its traces and its ultimate detection. A complete text that first explains how one prevents and detects fraud regardless of technology and then shows how by automating such procedures, the examiners' powers become superhuman.» -Richard B. Lanza, President, Cash Recovery Partners, LLC «Computer-Aided Fraud Prevention and Detection: A Step-by-Step Guide helps management and auditors answer T. S. Eliot's timeless question, 'Where is the knowledge lost in information?' Data analysis provides a means to mine the knowledge hidden in our information. Dave Coderre has long been a leader in educating auditors and others about Computer Assisted Audit Techniques. The book combines practical approaches with unique data analysis case examples that compel the readers to try the techniques themselves.» -Courtenay Thompson Jr. Consultant, Courtenay Thompson & Associates

The legal, financial, and business primer to the M&A process Mergers and Acquisitions offers accessible step-by-step guidance through the M&A process to provide the legal and financial background required to navigate these deals successfully. From the initial engagement letter to the final acquisition agreement, this book delves into the mechanics of the process from beginning to end, favoring practical advice and actionable steps over theoretical concepts. Coverage includes deal structure, corporate structuring considerations, tax issues, public companies, leveraged buyouts, troubled businesses and more, with a uniquely solution-oriented approach to the M&A process. This updated second edition features new discussion on cross-border transactions and «pseudo» M&A deals, and the companion websites provides checklists and sample forms to facilitate organization and follow-through. Mergers and acquisitions are complex, and problems can present themselves at each stage of the process; even if the deal doesn't fall through, you may still come out with less than you bargained for. This book is a multi-disciplinary primer for anyone navigating an M&A, providing the legal, financial, and business advice that helps you swing the deal your way. Understand the legal mechanics of an M&A deal Navigate the process with step-by-step guidance Compare M&A structures, and the rationale behind each Solve common issues and avoid transactional missteps Do you know what action to take when you receive an engagement letter, confidentiality agreement, or letter of intent? Do you know when to get the banker involved, and how? Simply assuming the everything will work out well guarantees that it will—for the other side. Don't leave your M&A to chance; get the information and tools you need to get it done right. Mergers and Acquisitions guides you through the process step-by-step with expert insight and real-world advice.

A comprehensive guide to building financial models Building Financial Models with Microsoft Excel + CD-ROM provides beginning or intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow readers to build their own financial models. This comprehensive resource also covers important topics such as the concept of valuation, the concept of sensitivity analysis, the concepts of contribution margin and financial ratios and the basics of building and using a Capitalization Table. K. Scott Proctor, CFA, is the Director of Investor Analytics at SNL Financial, a financial information provider.

The book is a step-by-step guide to derivative products. By distilling the complex mathematics and theory that underlie the subject, Chisholm explains derivative products in straightforward terms, focusing on applications and intuitive explanations wherever possible. Case studies and examples of how the products are used to solve real-world problems, as well as an extensive glossary and material on the latest derivative products make this book a must have for anyone working with derivative products.

A very accessible and concise guide to Islamic finance Contracts and Deals in Islamic Finance provides a clear breakdown of Islamic financial contracts and deal structures for beginners. The embedded requirements within selected Islamic financial contracts, such as risk weightage, capital structures, creations of cash flows, and balance sheets, are explained fully to provide a solid understanding of the backbone of the industry. Aimed primarily at beginners and those with a background in conventional banking, this book guides readers through the major contracts, how they're applied, and how to discern a contract's legitimacy. Case studies and interviews with bankers and global regulators provide real-life examples of contract application, and the author's own experiences provide deep insight into the everyday issues that arise. Ancillary instructor's materials include PowerPoint slides and lecture notes that facilitate use in the classroom. Literature describing the application of Islamic financial contracts is few and far between, and those providing a basic breakdown of these contracts and questioning their validity are rarer still. This book is the first of its kind, offering a basic approach to understanding Islamic contracts, designed for the true beginner. Understand the current contracts applied in Islamic banking Learn how contracts are applied across different jurisdictions Identify illegitimate contracts and those not in the spirit of Shariah law Examine the current economic realities surrounding Islamic finance By highlighting the underlying themes in Islamic finance and assessing the current practices, this book gives readers the solid understanding and up-to-date perspective that form a solid foundation upon which successful Islamic finance is practiced. For a solid introduction to the Islamic finance industry, Contracts and Deals in Islamic Finance is an accessible, practical guide.

Derivatives are everywhere in the modern world and it is important for everyone in banking, investment and finance to have a good understanding of the subject. Derivatives Demystified provides a step-by-step guide to the subject, enabling the reader to have a solid, working understanding of key derivative products. Adopting a highly accessible approach, the author explains derivative products in straightforward terms and without the complex mathematics that underlie the subject, focusing on practical applications, case studies and examples of how the products are used to solve real-world problems. Derivatives Demystified follows a sequence that is designed to show that, although there are many applications of derivatives, there are only a small number of basic building blocks, namely forwards and futures, swaps and options. The book shows how each building block is applied to different markets and to the solution of various risk management and trading problems. This new edition will be fully revised to reflect the many changes the derivatives markets have seen over the last three years. New material will include a comprehensive history of derivatives, leading up to their use and abuse in the current credit crisis. It will also feature new chapters on regulation and control of derivatives, commodity derivatives, credit derivatives and structured products and new derivative markets including inflation linked and insurance linked products. Derivatives Demystified is essential reading for everyone who operates in the financial markets or within the corporate environment who requires a good understanding of these important financial instruments.