Bear Paints is a national paint manufacturer and retailer. The company is The following is selected divisional information for its two largest segmented into ve divisions: Paint Stores (branded retail locations), Consumer . divisions: Paint Stores and Consumer. (paint sold through home improvement stores), Automotive (sales to auto H @ (Click the icon to view the information) manufacturers), International, and Administration. Read the muirements. Management has specied a 20% 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, X.XX%) " ' Operating income + Average total assets = ROI Paint Stores + = % Requirements 1. Calculate each division's ROI. Round all of your answers to four decimal places. 2. Calculate each division's prot margin ratio. Interpret your results. 3. Calculate each division's asset turnover ratio. Interpret your results. 4. Use the expanded ROI formula to conrm 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. Data table Net Sales Operating Average Total Revenue Income Assets Paint Stores $ 4,000,000 $ 480,000 $ 1,400,000 Consumer 1,290,000 195,000 1,575,000