Corporate Valuation Modeling: A Step-By-Step Guide
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. Corporate Valuation Modeling takes you step-by-step through the process of creating a powerful corporate valuation model. Each chapter 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.
The following discrepancies and errata have been reported in earlier versions of the text. Later versions may have these issues edited out. If you discover any yourself please forward them to firstname.lastname@example.org.
p.48: Typo in cell D35, enter the following formula: =C46/AVERAGE(C39:C45). Should read: In cell G46, enter the following formula: =C46/AVERAGE(C39:C45)
p. 84 Model Builder 4.1, Step 10: The current text instructs readers to enter the following formulas in the corresponding cells:
E7: =’Income Statement’!E5*Vectors!E19
E8: =’Income Statement’!E5*Vectors!E20
E9: =’Income Statement’!E5*Vectors!E21
The correct entries should be
E7: =’Income Statement’!E7*Vectors!E20
E8: =’Income Statement’!E7*Vectors!E21
E9: =’Income Statement’!E7*Vectors!E22
p. 102 Model Builder 5.2, Step 4: The formula uses the named range inputs_Capex1Dep. The reader should make sure the following cells are named on the Assumptions sheet:
p. 104 Model Builder 5.2, Step 7: The book and the CD-ROM copy and paste the formula instructed in that section, which uses the single named range inputs_Capex1Dep. This should either be switched to a relative reference so that the reference changes for each Capex or each row on the Capex sheet where they are being used (13 through 16), should use inputs_Capex1Dep for row 13, inputs_Capex2Dep for row 14, etc.
p. 138 Model Builder 6.2, Step 2: The current text uses a formula in E18 on the Debt sheet that is inconsistent with the model. The correct formula that is represented in the CD-ROM model is:
=MAX(MIN(‘Income Statement’!E17-‘Income Statement’!E19+’Income Statement’!E25-‘Income Statement’!E28,E17),0)
p. 156 Model Builder 7.1, Step 7: The current text instructs readers to enter the following formula in the corresponding cell:
The correct entry is
p. 153 Model Builder 7.1, Generally Applicable: There are a few named ranges that have not been referenced in detail. Just to make sure this is clear a section on the Assumptions sheet has cells named with the following names:
p. 158 Model Builder 7.1, Step 13: The formula created here includes cell E39 as part of the sum. This is a blank cell in the model and while it does not have any impact, it is not necessary to include.
p.190: The free cash flow to the firm calculation is missing the intangible acquisition costs. On the DCF sheet, after row 11 a row should be inserted called Intangible Acquisition Cost. This is a cash expenditure item that reduces cash. The formula should reference the Intangible sheet where the intangible acquisition cost is calculated. The Free Cash Flow to the Firm calculation that was in row 12, which would be row 13 after inserting a row, needs to be adjusted so it includes the new reduction to FCFF.
p. 203 Model Builder 9.3, Step 2: The formula for this step should be entered in E17, not E16 as the current text instructs.
p. 203 Model Builder 9.3, Step 3: The text “Unsec. Rating” should be entered in I23, not L23 as the current text instructs.
p. 204 Model Builder 9.3, Step 6: The text instructs users to enter the following formula:
=IF(E2=”TV Year”,inputs_LTCostofD,IF(SUM(‘Balance Sheet’!D31,’Balance Sheet’!E35 )<=inputs_Precision,0,((E15*AVERAGE(‘Balance Sheet’!D31:E31)+(Debt!E16*Debt!D53)+(Debt!E26*Debt!D54)+(Debt!D36 *Debt!D55))/(SUM(Debt!D53:D55)+AVERAGE(‘Balance Sheet’!D31:E31)))*(1-E6)))
The correct formula should be:
=IF(E2=”TV Year”,inputs_LTCostofD,IF(SUM(‘Balance Sheet’!D31,’Balance Sheet’!D35 )<=inputs_Precision,0,((E15*AVERAGE(‘Balance Sheet’!D31:E31)+(Debt!E16*Debt!D53)+(Debt!E26*Debt!D54)+(Debt!E36 *Debt!D55))/(SUM(Debt!D53:D55)+AVERAGE(‘Balance Sheet’!D31:E31)))*(1-E6)))
Notice that there are TWO changes in this formula (‘Balance Sheet’!D35) and (Debt!E36)