Required information Chapter 10: Applying Excel (LO10-1, LO10-2] Step 1: Download the Applying Excel form located on the left-hand side, under files. If you have trouble, the file is also located in D2L under Course Administration. Step 2: Then enter formulas in all cells that contain question marks. Step 3: Check your worksheet by changing the average operating assets in cell B6 to $9,000,000. The ROI should now be 33% and the residual income should now be $750,000. If you do not get these answers, find the errors in your worksheet and correct them. Step 4: Proceed to the requirements below only after completing your worksheet as it will be used to answer the following questions. Chapter 10: Applying Excel: Exercise Requirement 2: Revise the data in your worksheet as follows: B 1 Chapter 10: Applying Excel 2 3 3 Data 4 Sales 5 Net operating income 6 Average operating assets 7 Minumum required rate of return $ 34,000,000 $ 3,060,000 $ 17,000,000 11% If your formulas are correct, you should get the correct answers to the following questions. a. What is the ROI? ROI % b. What is the residual income? (Negative amount should be indicated by a minus sign.) Residual income c. Why is the residual income positive