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 litome 12 Compute the ROI 13 Margin 14 Turnover 15 ROI ? ? ? 7 17 Compute the residual income 18 Average operating assets 19 Net operating income 20 Minimum required return 21 Residual income 2 ? 2