help quick please

Data table 1. Calculate each division's ROI. Round all of your answers to four decimal places. 2. Calculate each division's profit margin ratio. Interpret your results. 3. Calculate each division's asset turnover ratio. 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 a recommendation for any division with negative RI. 6. Describe some of the factors that management considers when setting its minimum target rate of return. Requirement 1. Calculate each division's ROI. Round all of your answers to four decimal places. Begin by selecting the formula to calculate return on investment (ROI), and then enter the amounts to calculate each division's ROI. (Round your calculations to four decimal places and enter your answer as a percent rounded to two decimal places, XXX\%) Requirement 2. Calculate each division's profit margin ratio. Interpret your results. Begin by selecting the formula to calculate profit margin ratio, and then enter the amounts to calculate each division's profit margin ratio. (Enter each profit margin ratio as a percent rounded to two decimal places, X.XX\%.) The division is more profitable on each dollar of sales. Requirement 3. Calculate each division's asset tumover ratio interpret your resufts. Begin by selecting the formula to calculate asset turnover ratio, and then enter the amounts to calculate each division's asset tumover ratio. (Round your answers lo four decimal places, Xx ) The division is more efficient in generating sales with its average total assets. Requirement 4. Use the expanded ROI formula to confim your results from Requirement 1 . Interpret your results: First, select the expanded ROI formula. Now calculate ROI for each division using the expanded Rol formula. (Enteg your answers as a percent rounded to two decimat places, X% ) Using the expanded formula, the ROL for the Paint Stores division is Using the expanded formula the ROI for the consumer division is The Consumer division's profitability on each dollar of net sales revenue is than the Paint Stores division's profitablity. However the Paint Stores division's efficiency is significantly than the Consumer division's efficency These results cause the Paint Stores division's Ro to be the Consumer division's ROI Requirement 5. Calculate each divisions RI. Interpret your results, and offer a recommendation for any divsion with negative Ri First. select the formula to calculate residual income (Ru). division is more efficient in generating sales with its average total assets. Requirement 4. Use the expanded ROI formula to confirm your results from Requirement 1. Interpret your results. First, select the expanded ROI formula. Now calculate ROI for each division using the expanded ROI formula. (Enter your answers as a percent rounded to tw decimal places, X.XX\%) Using the expanded formula, the ROI for the Paint Stores division is Using the expanded formula, the ROI for the Consumer division is The Consumer division's profitability on each dollar of net sales revenue is profitability. However, the Paint Stores division's efficiency is significantly These results cause the Paint Stores division's Rol to be than the Paint Stores division's % % Requirement 6. Describe some of the factors that management considers when setting its minimum target rate of return. Management different minimum target rates for different divisions. For example, management require a hiaher target rate of return from a division operating in a riskier business environment. Managemont wil need to decide for the calculations and whether it should be net of Data table 1. Calculate each division's ROI. Round all of your answers to four decimal places. 2. Calculate each division's profit margin ratio. Interpret your results. 3. Calculate each division's asset turnover ratio. 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 a recommendation for any division with negative RI. 6. Describe some of the factors that management considers when setting its minimum target rate of return. Requirement 1. Calculate each division's ROI. Round all of your answers to four decimal places. Begin by selecting the formula to calculate return on investment (ROI), and then enter the amounts to calculate each division's ROI. (Round your calculations to four decimal places and enter your answer as a percent rounded to two decimal places, XXX\%) Requirement 2. Calculate each division's profit margin ratio. Interpret your results. Begin by selecting the formula to calculate profit margin ratio, and then enter the amounts to calculate each division's profit margin ratio. (Enter each profit margin ratio as a percent rounded to two decimal places, X.XX\%.) The division is more profitable on each dollar of sales. Requirement 3. Calculate each division's asset tumover ratio interpret your resufts. Begin by selecting the formula to calculate asset turnover ratio, and then enter the amounts to calculate each division's asset tumover ratio. (Round your answers lo four decimal places, Xx ) The division is more efficient in generating sales with its average total assets. Requirement 4. Use the expanded ROI formula to confim your results from Requirement 1 . Interpret your results: First, select the expanded ROI formula. Now calculate ROI for each division using the expanded Rol formula. (Enteg your answers as a percent rounded to two decimat places, X% ) Using the expanded formula, the ROL for the Paint Stores division is Using the expanded formula the ROI for the consumer division is The Consumer division's profitability on each dollar of net sales revenue is than the Paint Stores division's profitablity. However the Paint Stores division's efficiency is significantly than the Consumer division's efficency These results cause the Paint Stores division's Ro to be the Consumer division's ROI Requirement 5. Calculate each divisions RI. Interpret your results, and offer a recommendation for any divsion with negative Ri First. select the formula to calculate residual income (Ru). division is more efficient in generating sales with its average total assets. Requirement 4. Use the expanded ROI formula to confirm your results from Requirement 1. Interpret your results. First, select the expanded ROI formula. Now calculate ROI for each division using the expanded ROI formula. (Enter your answers as a percent rounded to tw decimal places, X.XX\%) Using the expanded formula, the ROI for the Paint Stores division is Using the expanded formula, the ROI for the Consumer division is The Consumer division's profitability on each dollar of net sales revenue is profitability. However, the Paint Stores division's efficiency is significantly These results cause the Paint Stores division's Rol to be than the Paint Stores division's % % Requirement 6. Describe some of the factors that management considers when setting its minimum target rate of return. Management different minimum target rates for different divisions. For example, management require a hiaher target rate of return from a division operating in a riskier business environment. Managemont wil need to decide for the calculations and whether it should be net of