Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

(Please Answer Correctly! Or I will not rate!) Wescott Company has three divisio

ID: 2593633 • Letter: #

Question

(Please Answer Correctly! Or I will not rate!)

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:

Wescott is considering an expansion project in the upcoming year that will cost $7.2 million and return $653,000 per year. The project would be implemented by only one of the three divisions.

Required:
1.
Compute the ROI for each division. (Do not round your intermediate calculations. Round your percentage answer to 2 decimal places, (i.e. 0.1234 should be entered as 12.34%.))

3. Compute the new ROI and residual income for each division if the project was implemented within that division. (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%.))

Division A Division B Division C Sales revenue $ 1,210,000 $ 1,281,000 $ 1,316,000 Cost of goods sold 748,000 941,000 956,000 Miscellaneous operating expenses 83,000 71,000 72,000 Interest and taxes 67,000 60,000 60,000 Average invested assets 11,587,000 2,823,000 4,640,000 Answer is complete but not entirely correct. ROI Division Division Division 2.69 % 4.9196

Explanation / Answer

Division A Division B Division C Sales revenue $ 1,210,000 $   1,281,000 $ 1,316,000 Cost of goods sold $    748,000 $      941,000 $     956,000 Miscellaneous operating expenses $      83,000 $       71,000 $      72,000 Average invested assets $11,587,000 $   2,823,000 $ 4,640,000 Net operating income (Sales revenue-COGS-Misc. op. expenses) $      379,000 $        269,000 $       288,000 ROI = NOI/Average invested assets (Answer) 3.27% 9.53% 6.21% NOI $      379,000 $        269,000 $       288,000 Capital cost at 8% on average assets $      926,960 $        225,840 $       371,200 Residual income (Answer) $    (547,960) $           43,160 $       (83,200) Division A Division B Division C Average invested assets $18,787,000 $ 10,023,000 $11,840,000 Net operating income (Sales revenue-COGS-Misc. op. expenses) $   1,032,000 $        922,000 $       941,000 ROI = NOI/Average invested assets (Answer) 5.49% 9.20% 7.95% NOI $   1,032,000 $        922,000 $       941,000 Capital cost at 8% on average assets $   1,502,960 $        801,840 $       947,200 Residual income (Answer) $    (470,960) $        120,160 $         (6,200) ROI Residual Income/ (Loss) Division A 5.49% $      (470,960) Division B 9.20% $        120,160 Division C 7.95% $           (6,200)