EXCEL PROJECT #3: ROI vs. RI X Corp. has two divisions: Print and Internet. Financial data (in millions) for 2019 and 2020 are below: PRINT DIVISION: Revenues (2020) = $22,500 Net Operating Income (2020) = $4,500 Operating Assets @ year-end: $18,200 (2019) and $25,000 (2020) INTERNET DIVISION: Revenues (2020) = $23,000 Net Operating Income (2020) = $690 Operating Assets @ year-end: $11,150 (2019) and $10,000 (2020) Top management is considering the use of either ROI [return on investment] or RI [residual income] as a performance measure for its investment centers [divisions]. REQUIRED PART A: 1. Compute the AOA [average operating assets] for each division (both Print and Internet). 2. Compute the Profit Margin ratio (%) for each division (both Print and Internet). 3. Compute the Asset Turnover for each division (both Print and Internet). 4. Using the DuPont model, compute ROI for each division (both Print and Internet). 5. Compute Residual Income [RI] for each division (both Print and Internet) based on average operating assets. Assume the corporate-wide minimum required rate of return is 10%.

---------------------------------------------------------------------------------------------------- Assume the Print division [only] is considering a new investment proposal for next year (2021) with the following estimated data [Ignore the Internet division for this requirement]: Average