Book description
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.
Table of contents
- Title Page
- Copyright Page
- Preface
- Acknowledgments
- CHAPTER 1 - Introduction
- CHAPTER 2 - Dates and Timing
-
CHAPTER 3 - Revenue, Costs, and the Income Statement
- REVENUE
- MODEL BUILDER 3.1: THREE METHODS FOR ESTIMATING REVENUE BASED ON HISTORICAL DATA
- COSTS
- ORGANIZING REVENUE AND COST ASSUMPTIONS FOR SCENARIO ANALYSIS
- MODEL BUILDER 3.2: INSTALLING AN EXCEL-BASED SCENARIO SELECTOR SYSTEM
- BRINGING REVENUES AND COSTS TOGETHER: THE INCOME STATEMENT
- MODEL BUILDER 3.3: INTEGRATING THE INCOME STATEMENT
- A WORK IN PROGRESS
- TOOLBOX
- CHAPTER 4 - Capital Structure and Balance Sheet
-
CHAPTER 5 - Capital Expenditures, Depreciation, Intangibles, and Amortization
- CAPITAL EXPENDITURES
- DEPRECIATION
- A BALANCE SHEET OR AN INCOME STATEMENT ITEM?
- CONCEPT STATUS
- MODEL BUILDER 5.1: CAPITAL EXPENDITURE SCHEDULES SETUP
- MODEL BUILDER 5.2: DEPRECIATION SCHEDULES SETUP
- INTANGIBLES
- AMORTIZATION
- MODEL BUILDER 5.3: INTANGIBLES AND AMORTIZATION SCHEDULES
- INCOME STATEMENT AND BALANCE SHEET EFFECTS
- MODEL BUILDER 5.4: INTEGRATING CAPITAL EXPENDITURES, DEPRECIATION, INTANGIBLES, AND AMORTIZATION
- TOOLBOX
-
CHAPTER 6 - Long-Term Debt
- WHAT IS LONG-TERM DEBT ?
- USING DEBT FOR A REASON
- MODELING DEBT: DEBT COMPONENTS IN DETAIL
- MODEL BUILDER 6.1: SETTING UP DEBT AND CALCULATING WHAT IS DUE
- PAYING LIABILITIES
- MODEL BUILDER 6.2: PAYING THE CORRECT LIABILITY AMOUNT
- MODEL BUILDER 6.3: INTEGRATING LONG-TERM DEBT INTO THE INCOME STATEMENT AND BALANCE SHEET
- TOOLBOX
- CHAPTER 7 - Balancing the Model
- CHAPTER 8 - Reconciling Cash Flow
-
CHAPTER 9 - Free Cash Flow, Terminal Value, and Discount Rates and Methods
- FREE CASH FLOW: A MATTER OF PERSPECTIVE
- MODEL BUILDER 9.1: IMPLEMENTING FREE CASH FLOW
- TERMINAL VALUE: BEYOND THE FORECAST PERIOD
- MODEL BUILDER 9.2: CALCULATING AND INTEGRATING A STABLE-GROWTH TERMINAL VALUE
- DISCOUNT RATES AND METHODS
- MODEL BUILDER 9.3: CALCULATING AND IMPLEMENTING THE WEIGHTED AVERAGE COST OF CAPITAL
- MODEL BUILDER 9.4: DISCOUNTING WITH MULTIPLE RATES TO DETERMINE THE CORPORATE VALUE
- AFTER THE CORPORATE VALUATION
- TOOLBOX
- CHAPTER 10 - Output Reporting
-
CHAPTER 11 - Automation Using Visual Basic Applications (VBA)
- THE OBJECT-ORIENTED PROGRAMMING LANGUAGE (OOP)
- FOLLOW THE RULES
- THE VISUAL BASIC EDITOR
- WRITING CODE: SUBROUTINES AND FUNCTIONS
- UNDERSTANDING VBA CODE AND PRACTICING CODING TECHNIQUES
- MODEL BUILDER 11.1: MOVING DATA USING VBA
- MODEL BUILDER 11.2: A FIRST LOOK AT LOOPS AND VARIABLES IN VBA
- COMMON ERRORS FOR FIRST-TIME VBA PROGRAMMERS
- VBA WITHIN A FINANCIAL MODELING CONTEXT
- MODEL BUILDER 11.3: ELIMINATING CIRCULAR REFERENCES
- MODEL BUILDER 11.4: CREATING A SCENARIO GENERATOR
- MODEL BUILDER 11.5: AUTOMATIC SHEET PRINTING
- CONTINUING WITH VBA
- CONCLUSION
- About the CD-ROM
- About the Author
- Index
Product information
- Title: Corporate Valuation Modeling: A Step-by-Step Guide
- Author(s):
- Release date: February 2010
- Publisher(s): Wiley
- ISBN: 9780470481790
You might also like
book
Corporate Valuation
Risk consideration is central to more accurate post-crisis valuation Corporate Valuation presents the most up-to-date tools …
book
The Financial Times Guide to Corporate Valuation
‘Understanding valuation is relevant to everyone with an ambition in business. For us a Cevian Capital …
book
Corporate and Project Finance Modeling
A clear and comprehensive guide to financial modeling and valuation with extensive case studies and practice …
book
Price and Value: A Guide to Equity Market Valuation Metrics
Understand how to use equity market metrics such as the price/earnings ratio (and other multiples) to …