The assignment direction: (Your mission, should you decide to accept it is: Complete the worksheet as directed.)

Applying Excel To ROI Please do not write in the answer. Excel calculated ONLY Data Sales Net operating income Average operating assets Minimum required rate of return $25,000,000 $3,000,000 10,000,000 25% Enter a formula into each of the cells marked with a? below Review Problem: Retum on Investment (ROl) and Residual Income Compute the ROI Margin Turnover ROI Notes: 1) Calculate ROl based on the Data above first. 2) Change the Average operating assets to $8,000,000 and comment below on the change in ROI with the lower operating assets 3) Now change Sales to $15,000,000 with other Data presented in Note 1 above as shown