Using the M&A Valuation & Deal Structuring Model on the Website

Essay

Using the M&A Valuation & Deal Structuring Model on the website accompanying this text 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) Close model but do not save results.