5 port Chapter 10: Applying Excel [LO10-1, L010-21 Step : Download the Applying Excel form focated on the left hand side under files. If you have trouble, the fie is also located in all under Course Administration Step 2: Then enter formules in all cels that contain question marks Step 3: Check your worksheet by changing the average operating assets in cell 35 to $9.000.000 The ROI should now de 33 and the residual income should now be $750,000If you do not get these answers, find the errors in your work cheet 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: 1 A Chapter 10: Applying Excel 2 5 Data Sales Net operating income Average operating assets Minumum required to return 305.000.000 57,600,000 10.000.000 279 6 7 If your formulas are correct, you should get the correct answers to the following questions a What is the ROR RD D. What is the residual income (Negative amount should be indicated by a minus sign) c. Why is the residual income ostve! 5 port Chapter 10: Applying Excel [LO10-1, L010-21 Step : Download the Applying Excel form focated on the left hand side under files. If you have trouble, the fie is also located in all under Course Administration Step 2: Then enter formules in all cels that contain question marks Step 3: Check your worksheet by changing the average operating assets in cell 35 to $9.000.000 The ROI should now de 33 and the residual income should now be $750,000If you do not get these answers, find the errors in your work cheet 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: 1 A Chapter 10: Applying Excel 2 5 Data Sales Net operating income Average operating assets Minumum required to return 305.000.000 57,600,000 10.000.000 279 6 7 If your formulas are correct, you should get the correct answers to the following questions a What is the ROR RD D. What is the residual income (Negative amount should be indicated by a minus sign) c. Why is the residual income ostve