1 Chapter 11: Applying Excel 2 3 Data 4 Sales 5 Net operating income 6 Average operating assets 7 Minimum required rate of return $25,000,000 $3,000,000 $10,000,000 25% 9 Enter a formula into each of the cells marked with a ? below 10 Review Problem: Return on Investment (ROI) and Residual Income 12. Compute the ROI 13 Margin 14 Turnover 15 ROI ? ? 17 Compute the residual income 18 Average operating assets 19 Net operating income 20 Minimum required retur 21 Residual income