Question: The purpose of this exercise is to underscore how small changes in terminal value assumptions result in disproportionately large changes in firm value. Using the
-
The purpose of this exercise is to underscore how small changes in terminal value assumptions result in disproportionately large changes in firm value. Using the Excel spreadsheet model in the file folder titled Target Valuation Model found on the companion website to this book, locate the PV of the targets enterprise and equity values on the Valuation Worksheet and write them down. Increase the terminal value growth rate assumption by 1 percentage point and reduce the discount rate by one percentage point. How does this impact the firms enterprise and equity value? Explain how this might happen. (Hint: Consider the definition of the constant growth valuation model.) Click the undo command to eliminate changes to the base case model, or close the model but do not save the results.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
