Using the M&A Valuation & Deal Structuring Model Accompanying This

Essay

Using the M&A Valuation & Deal Structuring Model accompanying this text and the data contained in thecells as a starting point, complete the following:
a. On the Valuation worksheet, what is the enterprise and equity value of Target on the Valuation Worksheet?
b. On the worksheet named Target Assumptions, decrease COGS (cost of goods sold) as a percent of sales by one percentage point 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.