9.11 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 entitled Target Firm Valuation Model on the companion website accompanying this book (see “Chapter Overview” section at the beginning of this chapter for the 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 7.5% to 8.5% 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 by one percentage point? Explain why these variables increased? (Hint: See Fig. 9.1)