Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please explain in excel -9.12 The purpose of this practice exercise is to underscore how small changes in terminal value assumptions result in disproportionately large
please explain in excel
-9.12 The purpose of this practice 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 entitled Target Valuation Model found on the companion website to this book, locate the present value of the Target's enterprise and equity values on the Valuation Worksheet and write them down. Increase the terminal value growth rate assumption by one percentage point and reduce the discount rate by one percentage point. How does this impact the firm's 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 model but do not save the results -9.12 The purpose of this practice 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 entitled Target Valuation Model found on the companion website to this book, locate the present value of the Target's enterprise and equity values on the Valuation Worksheet and write them down. Increase the terminal value growth rate assumption by one percentage point and reduce the discount rate by one percentage point. How does this impact the firm's 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 model but do not save the resultsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started