14.15 Using the M&A Valuation and Deal Structuring Model on the website accompanying this text (see the website address in the Chapter Overview section at the beginning of this chapter) and the data contained in the cells as a starting point, complete the following:

a. What is the enterprise and equity value of Target on the Valuation Worksheet?

b. Increase the sales growth rate by one percentage point (i.e., to 6.5%) on the Target Assumptions Worksheet. What is the impact on the Target’s enterprise and equity values? (Hint: See Valuation Worksheet.) Undo change or close model but do not save results in order to restore the model’s original data.