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

Short Answer

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.