PLEASE ANSWER THE QUESTION MARKS USING EXCEL FORMULAS ONLY. IF YOU USE FORMULAS I WILL GIVE THUMBS UP IF YOU GIVE JUST NUMBERS I WILL THUMBS DOWN. THANK YOU

1 Chapter 10: 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% 8 9 Enter a formula into each of the cells marked with a ? below 10 Review Problem: Return on Investment (ROI) and Residual Income 11 12 Compute the ROI 13 Margin ? 14 Turnover ? 15 ROI ? 16 17 Compute the residual income 18 Average operating assets 19 Net operating income ? 20 Minimum required return ? 21 Residual income ? 22