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 Targets net income (Target IS Worksheet), cash balance and shareholders equity (Targets BS Worksheet), and enterprise value and equity value (Target Valuation Worksheet). On the Targets Assumptions Worksheet, increase the growth rate from 7.5 to 8.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 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.