Bern Paints is a national paint manufacturer and retailer. The company is segmented into five divisions: Paint Stores The following is selected divisional information for its two largest divisions: Paint Stores and Consumer branded retail locations Consumer tant sold through home improvement stores Automotive to auto Click the loon to view the domation) manufacturers), International and Administration Read the requirements Management has specified a 10% tarpetrate of retum Requirement 1. Calore each division's ROI. Round all of your answers to four decimal places Begin by selecting the formules to calculate retum on investment (RO), and then enter the amounts to calculate each division's ROI. Pound your calculations to four decimal places and enter your answers a percent rounded to two decima places, XXX) ROI Paint Stores - - Consumer Requirement 2. Calcule cach division's profit margine Interpret your Begin by lecting the formula local profit margin ratio, and then enter the amounts to calculate this profit margin rationer och profit margine as a percent rounded to two decimal places XXX) Profit margin Paint Stores Consumer The division is more profitable on each of sales Requirement. Calculeath division's move to interpret your Begin by selecting the formato caloumover ratio, and the enter the amounts to calculate each divisions over at Round your newers to four decimal places, XX.CO) Choose from any or enter any number in the input folds and then continue to the nation stores), Automotive (sales to auto (Click the icon to view the information Click the icon to view the information Management has specified a 19% target ra four decimal places. then enter the amounts to calculate each division's ROI. (Round your calculations to four de i Data Table -results. Net Sales Operating Average Total Revenue Income Assets $ 4,010,000 $ 480,000 $ 1,385,000 1,310,000 180,000 1,605,000 Paint Stores ter the ar ratio as Consumer II II Print Done your results. Management has specified a 19% target rate of return. T of your answers to A Requirements mal places estment (ROI), and ratio. Interpret your 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. n ratio, and then ente a percent Print Done dollar of sales. over ratio. Interpret your results. hover ratio. and then enter the amounts to calculate each division's asset turnover ratio. (Round your answers to four decimal plac Bern Paints is a national paint manufacturer and retailer. The company is segmented into five divisions: Paint Stores (branded retail locations). Consumer (paint sold through home improvement stores). Automotive (sales to auto manufacturers), International, and Administration. Read the requirements The following is selected divisional info (Click the icon to view the informa Management has specified a 19% targ 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 fo places, X.XX%) ROI + % % Paint Stores Average total assets Consumer Net sales revenue Requirement 2. C Operating income t margin ratio. Interpret your results. it margin ratio, and then enter the amounts Begin by selecting Target rate of return calculate each division's profit margin ratio. (Enter each profit margin Total current liabilities Profit margin ratio % Paint Stores % Consumer The division is more profitable on each dollar of sales. Requirement 3. Calculate each division's asset turnover ratio. Interpret your results, Begin by selecting the formula to calculate asset tumover ratio, and then enter the amounts to calculate each division's asset turnover ratio. (Round your answers Choose from any list or enter any number in the input fields and then continue to the next question. Bern Paints is a national paint manufacturer and retailer. The company is segmented into five divisions: Paint Stores (branded retail locations). Consumer (paint sold through home improvement stores). Automotive (sales to auto manufacturers), International, and Administration. The following is selected divisional info (Click the icon to view the informat Management has specified a 19% targ Read the requirements The division is more profitable on each dollar of sales. Req each division's asset turnover ratio. Interpret your results. Consumer Begii mula to calculate asset turnover ratio, and then enter the amounts to calculate each division's asset turnover ratio. (Round your answers to Paint Stores + = Asset turnover ratio Paint Stores + Consumer + The 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. ROI Now calculate ROI for each division using the expanded ROI formula. (Enter your answers as a percent rounded to two 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 % Choose from any list or enter any number in the input fields and then continue to the next question, The following is selected divis (Click the icon to view the Bern Paints is a national paint manufacturer and retailer. The company is segmented into five divisions: Paint Stores (branded retail locations), Consumer (paint sold through home improvement stores), Automotive (sales to auto manufacturers), International, and Administration Read the requirements. Requirement 4. Use the expanded ROI formula to confirm your results from Requirement 1. Interpret your results. First, select the expanded ROI formula Management has specified a ROI N ivision using the expanded ROI formula. (Enter your answers as a percent rounded to two decimal places, X.XX%.) Asset turnover ratio Net sales revenue the ROI for the Paint Stores division is % Profit margin ratio Target rate of return 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 profitability. However, the Paint Stores results cause the Paint Stores division's ROI to be the Consumer division's ROI. Requirement 5. Calculate each division's RI. Interpret your results, and offer a recommendation for any division with negative RI. First, select the formula to calculate residual income (RI). X RI Now calculate each division's RI. (Use a minus sign or parentheses to enter negative residual income.) The Rl for the Paint Stores division is Choose from any list or enter any number in the input fields and then continue to the next question. Bern Paints is a national paint manufacturer and retailer. The company is segmented into five division Paint Stores The following is selected divisional information for its two largest division Paint Stores and Consumer (branded retail locational Consumer paint sold through home improvement stores Automotive (es to auto Cok the icon to view the information) manufacturers International, and Administration Read the moment Management has specified a 197% target rate of retum Using the expanded formula the ROI for the Consumer division is The Consumer division's proftability on each dollar of net sales revenue is than the Paint Stores division's profitability. However, the Paint Stores division's efficiency in significanty than the Consumer division's eficiency These results cause the Paint Stores division's ROI to be the Consumer division's ROI Requirements. Calculate each division's Ruinterpret your results, and offer a recommendation for any division with negative Ri. First, select the formula to calculate residual income (R). Now calculate each division's R. (Use a minus signor parentheses to enter negative residual income) The Rl for the Paint Stores division is The Rifor the Consumer divisions meeting managers target rate of retum. A division with a negative Rihould consider Requirement 6. Describe some of the factors that management considers when setting a minimum target rate of return Management different minimum target rates for different divisions. For example management require a higher rate of return from a division operating in a business environment Management will need to decide for the calculations and whether it should be net of Choose from any list or enter any number in the input fields and then continue to the next question Management has specified a manufacturers), International, and Administration, Read the requirements 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 profitability. However, the Paint Store results cause the Paint Stores division's ROI to be the Consumer division's ROI. Requirement 5. Calculate each division's RI. Interpret your results, and offer a recommendation for any division with negative RI. First, select the formula to calculate residual income (RI). X RI RI. (Use a minus sign or parentheses to enter negative residual income.) ivision is N Asset turnover ratio T Average total assets Net sales revenue T Operating income Target rate of return sion is meeting management's target rate of return. A division with a negative RI should consider 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 higher target rate decide for the calculations and whether it should be net of Choose from any list or enter any number in the input fields and then continue to the next question. 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 profitability. Howeve results cause the Paint Stores division's ROI to be the Consumer division's ROI. Requirement 5. Calculate each division's RI. Interpret your results, and offer a recommendation for any division with negative RI. First, select the formula to calculate residual income (RI). RI Now calculate each division's RI. (Use a minus sign or parentheses to enter negative residual income.) The RI for the Paint Stores division is The RI for the Consumer division is meeting management's target rate of return. A division with a negative RI should consider tors that management considers when setting its minimum target rate of return. Both divisions are mum target rates for different divisions. For example, management require a hi Neither division is for the calculations and whether it should be net of Only the Consumer division is Only the Paint Stores division is er in the input fields and then continue to the next question. ints is a national paint manufacturer and retailer. The company is segmented into five divisions: Paint Stores The following is selected divisional information for its two lar d retail locations), Consumer (paint sold through home improvement stores), Automotive (sales to auto cturers). International, and Administration (Click the icon to view the information.) requirements. Management has specified a 19% target rate of return. me expanded formula, the ROI for the Consumer division is % sumer division's profitability on each dollar of net sales revenue is than the Paint Stores division's profitability. However, the Paint Stores division's efficiency is signific ause the Paint Stores division's ROI to be the Consumer division's ROI. ment 5. Calculate each division's Ri. Interpret your results, and offer a recommendation for any division with negative RI. ect the formula to calculate residual income (RI). RI ulate each division's RI. (Use a minus sign or parentheses to enter negative residual income.) or the Paint Stores division is er the Consumer division is meeting management's target rate of return. A division with a negative RI should consider ment 6. Describe some of the factors that management considers when setting its minimum target rate of return Vision opera rec ment different minimum target rates for different divisions. For example, management for the calculations and whether it should be net of decreasing its long-term debt decreasing its operating income eliminating nonproductive assets om any list or enter any number in the input fields and then continue to the next question. The Consumer division's profitability on each dollar of net sales revenue is than the Paint Stores division's profitability. However, the Paint results cause the Paint Stores division's ROI to be the Consumer division's ROI. Requirement 5. Calculate each division's RI. Interpret your results, and offer a recommendation for any division with negative RI. First, select the formula to calculate residual income (RI). RI Now calculate each division's RI. (Use a minus sign or parentheses to enter negative residual income.) The Rl for the Paint Stores division is The RI for the Consumer division is V meeting mana target rate of return. A division with a negative RI should consider 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 V require a higher target rate decide for the calculations and whether it should be net of Choose what assets to include in total assets fields and then continue to the next question. what liabilities to include in total liabilities MacBook Pro OOO to calculate residual income (RI). RI ach division's RI. (Use a minus sign or parentheses to enter negative residual income.) aint Stores division is Consumer division is meeting management's target rate of return. A division with a negative RI should consider 6. Describe some of the factors that management considers when setting its minimum target rate of return. require a higher target rate different minimum target rates for different divisions. For example, management for the calculations and whether it should be net of any list or enter any number in the input fields and then continue to the next quest accumulated depreciation. income taxes. MacBook Pro