Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 results

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Stochastic Filtering With Applications In Finance

Authors: Bhar Ramaprasad

1st Edition

9814304859, 9789814304856

More Books

Students also viewed these Finance questions

Question

LO2 Compare three types of individual incentives.

Answered: 1 week ago