Data table The company is segmented into five divisions: Paint Stores (branded retail location), Consumer (paint sold through stores such as Home Depot and Lowe's), Automotive (sales to auto manufacturers), International, and Administration. The following is selected hypothetical divisional information for the company's two largest divisions: Paint Stores and Consumer (in thousands of dollars). Operating Income Total Assets Sales Paint Stores... $ 3,920,000 $ Consumer..... $ 1,200,000 $ 490,000 $ 1,400,000 180,000 $ 1,600,000 Requirements Round all calculations to two decimal places. 1. Calculate each division's ROI. 2. Calculate each division's sales margin. Interpret your results.. 3. Calculate each division's capital turnover. Interpret your results. 4. Use the expanded ROI formula to confirm your results from Requirement 1. Interpret your results. 5. Calculate each division's RI. Interpret your results and offer recommendations for any division with negative RI. 6. Total asset data were provided in this problem. If you were to gather this information from an annual report, how would you measure total assets? Describe your measurement choices and some of the pros and cons of those choices. 7. Describe some of the factors that management considers when setting its minimum target rate of return. 8. Explain why some firms prefer to use RI rather than ROI for performance measurement. 9. Explain why budget versus actual performance reports are insufficient for evaluating the performance of investment centers. Requirement 1. Calculate each division's ROI. First enter the formula, then calculate the ROI for each division. (Enter the ROI as a percent rounded to the nearest hundredth of a percentage, XXX%) Paint Stores + Consumer Requirement 2. Calculate each division's sales margin. Interpret your results. ROI % Enter the formula, then calculate the sales margin for each division. (Enter the sales margin as a percent rounded to the nearest hundredth of a percentage, XXX%) Paint Stores Consumer Interpret your results. The Division is more profitable on each dollar of sales.) = Sales margin % Requirement 3. Calcutate each division's capital turnover Interpret your results First enter the formula, then calculate the capital tumover for each division, (Round to two decimal places) Pavit Stores Consumer The Division is more efficient in generating sales with its assets Capital tumover times times Requirement 4. Use the expanded ROI formula to confirm your results from Requirement 1. Interpret your results First enter the expanded ROI formula, then calculate the ROI for each division. (Exder the HOT as a percent rounded to the hearest hundredth of a percentage XX Paint Stores Consumer % The Consumer Division's profitability on each dollar of sales in These results cause the Paint Stores Division's ROI to be RO than the Paint Stores Division's profitability. However, the Paint Store Division's efficiency is significantly the Consumer Division's ROL than the Consumer Dior's hany Requirement 5. Calculate each division's Ri, Interpret your results and offer recommendations for any division with negative R First enter the formula, then calculate the Rl for each division. (Enter the amount in thousands, Use parentheses or a minus sign for negative residual incumes) Paint Stor Consumer Interpret your results and offer recommendations for any division with negative R income meeting management's target rate of return. The Ri should work on improving its Improving this may help the divic achieve positive resul Requirement 6. Total asset data were provided in this problem. If you were to gather this information bom an annual report, how would you measure tolal assens? Describe your menement chees and some of the pros and cons of those choices Most companies use the asset balance since the income used in the ROI calculation is earned over the year Management must also decide whether they wish to use the gross book value of assets or the net book value of assets. The book value in oben used because it is easily pulled from the balance sheet. However, ROI using that value will artificially me over time due to book value is often used because it is easily pulled from the balance sheet. However, ROIl using that value will artificially rise over time due to Requirement 7. Describe some of the factors that management considers when setting its minimum target rate of retur The Requirement 8. Explain why some firms prefer to use Ri rather than ROI for performance measurement. RI does a better job of Requirement 9. Explain why budget versus actual performance reports are insufficient for evaluating the performance of investment centers. Investment centers are responsible for Budget versus actual performance reports are insufficient because they do not measure