Spruce Inc. segments its company into four distinct divisions. The net revenues, operating profit and total assets for these divisions are disclosed in the footnotes to Spruce Inc.'s consolidated financial statements. Notes :o Consolidated Financial Statements Requirements 1. What are Spruce Inc 's four business divisions? Fill in the table listing each division, its net revenues, operating profit, and total assets. 2. Use the data you collected in Requirement 1 to calculate each division's profit margin. Interpret your results. 3. Use the data you collected in Requirement 1 to calculate each division's asset turnover. Interpret your results. 4. Use the data you collected in Requirement 1 to calculate each division's ROI. Interpret your results 5. Can you calculate Rl andor EVA using the data presented? Why or why not? Net Revenue and Operating Profit Total Assets & Other Information Net Revenue Operating Profit 2019 2021 2020 2019 2021 2020 $ 11,250 $ 10,150 $ 9,750 $ 3,150 $ 2,875 5 8,750 7.850 7,650 1,575 1,395 12.500 11,300 10.800 1,500 1.356 1,600 1,480 1,370 560 535 2.325 1.335 1.296 515 Home furnishings Office furniture Store displays Health-care furnishings Total division Corporate Total Total Assets Capital Spending 2021 2020 2019 2021 2020 2019 Home furnishings 5 7.500 5 8,350 $ 5,950 $ 475 $ 485 $ 445 Office furniture 7,000 6,450 8,350 470 300 255 Store displays 15,825 14,425 14,025 840 885 545 Health-care furnishings 1,000 800 750 32 32 37 Total division 31,125 28,025 27075 1,817 1,502 1.282 Corporate 1.780 5,340 3,540 180 185 65 5 32,905 $ Total 33,365 3 30.615 $ 1,997 $ 1.687 $ 1,347 Corporate assets consist of cash, short-term investments, and property, plant, and equipment. The corporate property, plant, and equipment includes the headquarters building equipment within, and the surrounding property 34,100 30,780 29,570 8,785 (330) 8,455 $ 6,161 (290) 5,871 $ 5,471 (260) 5.211 $ 34,100 $ 30,780 $ 29,570 $ Notes to Consolidated Financial Statements Print Done Note 1-Basis of Presentation and Our Divisions: We manufacture, market, and sell a variety of products through our divisions, including furniture and fixtures for the home, office, stores, and health-care fac ties. The accounting policies are the same for each division. There is, however, one exception. Spruce Inc. centrally manages commodity derivatives and does not allocate any gains and losses incurred by these contracts to individual divisions. These derivatives are used to hedge the underlying price risk to the commodities used in production. The resulting gains and losses from these contracts are recorded under corporate expenses rather than allocated to specific divisions. Requirement 1. What are Spruce Inc.'s four business divisions? Fill in the table listing each division, its net revenues, operating profit, and total assets for 2021. Net Revenue Operating Profit Total Assets Requirement 2. Use the data you collected in Requirement 1 to calculate each division's profit margin. Interpret your results (Round your final answers to the nearest whole percent, X%.) Profit Margin Interpret your results. (Round your answers to the nearest cent.) The Division of Spruce Inc. has a much lower profit margin than the other divisions. It is only earning on every S1 of sales, whereas the other divisions range from Requirement 3. Use the data you collected in Requirement 1 to calculate each division's asset turnover. Interpret your results. (Round your final answers to two decimal places, X.XX.) Mon every dollar of sales has the highest profit margin Asset Turnover Interpret your results. The divisions have asset turnover rates. This means that the divisions ability to generate sales revenue from their assets. has the highest asset turnover while has the lowest asset turnover Requirement 4. Use the data you collected in Requirement 1 to calculate each division's ROI. Interpret your results. (Round percentages to two decimal places, X.XX%.) ROI = = = Interpret your results profit margins which had the lowest ROI, in part driven by the fact that it had the profit margin of the four divisions. have the highest ROI. Both of these divisions had the Requirement 5. Can you calculate Rl and/or EVA using the data presented? Why or why not? Financial reporting is for the benefit of not Therefore company information is disclosed in the financial statements. Residual income calculations involve Since this information presented, residual income EVA calculations involve the This information presented on a divisional basis, so divisional EVA