Chapter 11: Applying Excel: Exercise (Part 2 of 2) Requirement 2: Revise the data in your worksheet as follows: Chapter 11: Applying Exce 2 3 Data 4 Sales 5 Net operating income 6 Average operating assets 7 Minumum required rate of return $ 6,000,000 $ 300,000 $ 3,000,000 17% a. What is the ROI? ROl 0 b. What is the residual income? (Negative amount should be indicated by a minus sign.) Residual income C. Why is the residual income negative