Corporate Valuation Modeling. 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 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.

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.

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

Practical valuation exercises with real-world application and expert insight Financial Valuation Workbook cuts the learning curve in half, with practical training for use with any valuation textbook. Packed with tools, resources, and over 300 exercises, this book helps novices get a handle on the complex valuation process, while helping more experienced practitioners organize their engagements. Checklists, flowcharts, reports, information requests, and other resources help streamline the workflow and ensure thorough review, while in-depth coverage places the complexities of the field front-and-center. This new fourth edition features a brand new expanded case study for real-world insight, accompanied by exercises with explanations that deepen the learning process. Expert tips are highlighted throughout to provide additional insight in specific situations, and exercises from basic to advanced map to established training processes. Valuation is as an art, as well as a science, and simply reading a textbook only goes halfway toward true learning—applying what you learn is critical. This book provides hands-on practice alongside useful tools and valuable insight to help solidify your understanding of the many facets of this complex field. Delve into the intricacies of valuation with a new expanded case study and expert tips Follow checklists and flowcharts for each phase of the valuation process Use reports, information requests, and other tools that help organize your workflow Test your understanding with over 300 exercises organized by major area Organized into standard, recognized, and easily identified sections that lend themselves to quick refreshers as well as start-to-finish study, this book is a truly useful resource for beginner and veteran alike. Whether you're learning valuation for the first time or simply need guidance on an unfamiliar situation, Financial Valuation Workbook provides a key resource for any business valuation professional.

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.

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.

A Step-by-Step Guide to Implementing a Successful ANTI-BullyING Program Bullying can be found in every school system, school, and classroom. It is destructive to the well-being of students, creates unsafe schools, and impacts learning. School personnel, parents, and others are increasingly realizing the importance of putting effective anti-bullying strategies and policies in place that will create safe, caring, and peaceful schools where all students feel a sense of belonging and acceptance. Based on Allan L. Beane's proven Bully Free7reg; Program, Bullying Prevention for Schools is a step-by-step guide to implementing an anti-bullying program in individual schools or throughout a district. In Bullying Prevention for Schools, Dr. Beane details how to: Implement training for school personnel and volunteers and awareness sessions for students, parents, and the community Establish policies, rules, behavioral expectations, discipline rubrics, and response plans Prepare intervention and prevention strategies Develop a plan to actively include, involve, and empower students, parents, and the community And much more Bullying Prevention for Schools also contains a wealth of reproducible documents and forms, such as surveys, statement sheets, and intervention questionnaires.

“…a very useful resource for courses in nonparametric statistics in which the emphasis is on applications rather than on theory. It also deserves a place in libraries of all institutions where introductory statistics courses are taught." –CHOICE This Second Edition presents a practical and understandable approach that enhances and expands the statistical toolset for readers. This book includes: New coverage of the sign test and the Kolmogorov-Smirnov two-sample test in an effort to offer a logical and natural progression to statistical power SPSS® (Version 21) software and updated screen captures to demonstrate how to perform and recognize the steps in the various procedures Data sets and odd-numbered solutions provided in an appendix, and tables of critical values Supplementary material to aid in reader comprehension, which includes: narrated videos and screen animations with step-by-step instructions on how to follow the tests using SPSS; online decision trees to help users determine the needed type of statistical test; and additional solutions not found within the book.

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.