Managerial Accounting- ROI and Residual Income

Populate the spreadsheet as indicated in the instructions.

eae1929993f875433e86fc2a02bd2ac18780f69a.xls Chapter 11: Applying Excel 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. Be sure to format the cells appropriatey. For example, if the cell has a dollar amount in it, then the cell should be formatted for dollars. Review Problem: Return on Investment (ROI) and Residual Income Compute the ROI Margin Turnover ROI ? ? ? Compute the residual income Average operating assets Net operating income Minimum required return Residual income ? ? ? ? Page 1