25 F7 Undo Paste 4 X Cut Copy Format Painter Clipboard VX fx 1 Problem 1 2 E Arial BIU Font 12 AA Wrap Text AMERE OMerge & Center C Alignment D General 4 $ % 9 60 000 00 Conditional Format as Formatting Table Number 5 G 3 The sales, income from operations, invested assets, and residual income for each division of Marcus Company are as follows: 4 5 6 Division X 7 Division Y 8 Division Z 9 Sales Income from Operations Invested Assets $5,000,000 6,800,000 3,750,000 $645,000 777,000 760,000 $4,100,000 4,000,000 7,600,000 Formulae: Profit margi Investment ROI using D Residual inc Operating in 10 Marcus's Minimum desired ROI is: 11 12 Required: 13 Determine the following for each division: 14 A. Profit margin 15 B. Investment Turn-over 16 C. ROI using DuPont Formula 17 D. Residual Income 18 19 Solution: 20 21 22 Division X 23 Division Y 24 Division Z 25 26 27 28 29 30 31 32 33 34 35 36 37 Problem1 Problem2 Accessibility: Good to go Ready 71F Sunny 10% Profit Margin Investment Turnover ROI Residual Income a