Copeland Company is an investment center and an operating segment of Bobcat International Corporation. Copeland Company is currently earning an ROI of 15.5% on average operating assets of $15,000,000 as of January 1, 2022. On January 1, 2022 the company has the opportunity to make an investment which will cost $3,000,000 and which they believe will yield a 12% return (ROI). Bobcat International Corporation expects its investment centers to earn at least 10% on all new investments.

REQUIRED:

Calculate the operating income Copeland Company is currently earning.

Calculate the operating income the investment is expected to earn.

Calculate the average operating assets Copeland Company will have at year end if they make the investment.

Calculate the operating income Copeland Company will have if they make the investment.

What will Copeland Companys ROI be if they make the investment?

If the CEO of Copeland Company is evaluated based on ROI will Copeland Company make the investment?

Calculate the Residual Income for Copeland Company before making the investment.

Calculate the Residual Income for Copeland Company assuming that they make the investment.

If the CEO of Copeland Company is evaluated based on Residual Income will Copeland Company make the investment?

Rules regarding the completion of the Excel Assignments:

You MUST use Microsoft Excel to complete the assignment. Do NOT use Macs Numbers or Google Sheets to complete the assignment.

You MUST use formulas and links whenever possible. Do not simply type in your solutions rather than use formulas (in ANY part of the assignment).