tableABCDEFChapter : Applying Excel,,,,GData,,,,,Sales,$Netoperating income,$Average operating assets,$Minimum required rate of return,
Enter a formula into each of the gray cells 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
table
Compute the residual income
Average operating assets
Net operating income
Minimum required return
Residual income
table