Wescott Company has three divisions: A, B, and C. The company has a hurdle rate of 8 percent. Selected operating data for the three divisions are as follows: Sales revenue Cost of goods sold Miscellaneous operating expenses Interest and taxes Average invested assets Division A $ 1,275,000 Division B $ 996,000 Division C $ 986,000 788,000 731,000 716,000 68,000 52,000 8,992,000 56,000 57,000 45,000 2,118,000 45,000 3,485,000 Wescott is considering an expansion project in the upcoming year that will cost $5.4 million and return $488,000 per year. The project would be implemented by only one of the three divisions. Required: 1. Compute the ROI for each division. 2. Compute the residual income for each division. 3. Rank the divisions according to the ROI and residual income of each. 4-a. Compute the return on investment on the proposed expansion project. 4-b. Is this an acceptable project? 5. Without any additional calculations, state whether the proposed project would increase or decrease each division's ROI. 6. Compute the new ROI and residual income for each division if the project was implemented within that division. Req 1 Req 2 Req 3 Req 4A Req 4B Req 5 Req 6 Compute the ROI for each division. Note: Enter your answers as a percentage rounded to two decimal places, (i.e., 0.1234 should be entered as 12.34%.) ROI Division A % Division B % Division C % Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4A Req 48 Req 5 Compute the residual income for each division. Note: Loss amounts should be indicated by a minus sign. Enter your answers in whole dolla Residual income Division A Division B Division C (Loss) Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4A Req 4B Req 5 Re Rank the divisions according to the ROI and residual income of each. Rank Division A Division B Division C Req 1 Req 2 Req 3 Req 4A Req 48 Req 5 Req 6 Compute the return on investment on the proposed expansion project. Note: Enter your answer as a percentage rounded to two decimal places, (i.e., 0.1234 should be entered Return on Investment of Proposed Expansion Project < Req 3 % Req 48 > Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4A Req 48 Req 5 Re Is this an acceptable project? Is this an acceptable project? Req 1 Req 2 Req 3 Req 4A Req 48 Req 5 Req 6 Without any additional calculations, state whether the proposed project would increase or decrease each division's ROI. Division A Division B Division C Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4A Req 48 Req 5 Req 6 Compute the new ROI and residual income for each division if the project was implemented within that division. Note: Loss amounts should be entered with a minus sign. Enter your ROI percentage answers to 2 decimal places, (i.e., 0.1234 should be entered as 12.34%.). Enter your pnswers in whole dollars not in millions. ROI Residual Income (Loss) Division A % Division B % Division C