The Purpose of This Practice Exercise Is to Illustrate How

question 21

Essay

The purpose of this practice exercise is to illustrate how a change in an input cell impacts variables on other financial statements. Using the Excel spreadsheet model in the file folder entitled Target Valuation Model on the companion website accompanying this book (see the beginning of this chapter for website address), note the values for 2018 of Target's net income (Target IS Worksheet), cash balance and shareholders' equity (Target's BS Worksheet), and enterprise value and equity value (Target Valuation Worksheet).
Change the Target's revenue growth rate assumption by one percentage point in 2014. On the Target's Assumptions Worksheet, increase the growth rate from 5.5 to 6.5 percent in the yellow input cell on the Sales Growth line for the year 2014. What are the new values in 2018 for net income, cash balance, shareholders' equity, enterprise value, and equity value following the increase in the growth rate assumption in the base case is increased by one percentage point? Explain why these variables increased (Hint: See Figure 9.1)? When done, click the undo command or close the model but do not save the output to restore the base case model results.