How do I calculate residual income, minimum required return?

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 $3,000,000 $25,000,000 12% Compute the residual income Average operating assets Net operating income Minimum required return Residual income $ 10,000,000 $ 3,000,000 $ 3,000,000 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 $3,000,000 $25,000,000 12% Compute the residual income Average operating assets Net operating income Minimum required return Residual income $ 10,000,000 $ 3,000,000 $ 3,000,000