Corporate Valuation Modeling: A Step-by-Step Guide

Praise for CORPORATE VALUATION MODELING + CD

"Valuation is regarded as more art than science. Keith has deciphered the complex and technical skills developed over years of investment banking and corporate finance experience into a logical, usable book that I have not seen after years of M&A work. More than a list of formulae, Keith builds the foundations of very robust knowledge of model logic, construction, and customization, while subtly building a library of extremely useful formula combinations and putting the tools in the workshop for you. This is the book I needed ten years ago."—Adam Quinn, Senior Relationship Manager, Professional Services, St. George Institutional andCorporate Bank, and Chief Investment Officer, TAC Capital Investment and Advisory

"This guide enables the user to set out data and assumptions, understand logic, and deliver results. Once you're in control of your model you can apply different scenarios, stress testing, and become the 'go to person' on a deal."—Anthony Ditchburn, Associate Director, Financial Institutions Credit, Wholesale Banking, a division of National Australia Bank Limited

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. Engaging and informative, this reliable resource:

• Provides a comprehensive, integrated approach to modeling a corporate entity with the primary goal of determining a firm value

• Contains a Tool Box section at the end of each chapter that assists those who may be less skilled in Excel techniques and functions

• Walks you through the full process of constructing a fully dynamic corporate valuation model