$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$],[1,$Chapter $11$: Applying Excel,,,,G$,],[2,,,,,,],[3,$Data,,,,,$],[4,$Sales,$$125,000,000,,,,],[5,$Netoperating income,$$23,000,000,,,,],[6,$Average operating assets,$$85,000,000,,,,],[7,$Minimum required rate of return,$20\%,,,,],[8,,,,,,]]$

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

$\backslash$table$[[],[]]$

Compute the residual income

Average operating assets

Net operating income

Minimum required return

Residual income

$\backslash$table$[[],[],[]]$