E13-4 Computing Profitability Ratios [LO 13-4, LO 13-5) According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2016. Let's see whether these changes are reflected in the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. 2016 $113,000 56.500 46,500 37,300 630 8,57e Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expense Interest Expense Income before Income Tax Expense Income Tax Expense Net Income $139,500 76.700 62,800 39,600 be 6,570 Required: 1. Compute the gross profit percentage for each year. Assuming that the change from 2015 to 2016 is the beginning of a sustained trend, is Computer Tycoonlikely to earn more or less gross profit from each dollar of sales in 2017? 2. Compute the net profit margin for each year Given your calculations here and in requirement 1. explain whether Computer Tycoon did a better or worse job of controlling operating expenses in 2016 relative to 2015 3. Computer Tycoon reported average net fixed assets of $55.500 in 2016 and $46.400 in 2015. Compute the fixed asset turnover ratios for both years. Did the company better utilize its investment in fixed assets to generate revenues in 2016 or 2015? 4. Computer Tycoon reported average stockholders equity of 555.300 in 2016 and 542.100 in 2015. The company has not issued preferred stock Compute the return on equity ratios for both years. Did the company generate greater returns for stockholders in 2016 than in 2015? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 1-a. Compute the gross profit percentage for each year. (Round your answers to 1 decimal place.) 1-b. Assuming that the change from 2015 to 2016 is the beginning of a sustained trend, is Computer Tycoon likely to earn more or less gross profit from each dollar of sales in 2017? Grons Prolit Parcentage 2015 2016 1-5. Likely to earn in 2017? More Gross Profit Less Gross Profit Required 2 > Che preferred stock. Compute the return on equity ratios for both years. Did the company generate greater returns for stockho 2016 than in 2015? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 2-a. Compute the net profit margin for each year. (Round your answers to 1 decimal place.) 2-b. Did Computer Tycoon do a better or worse job of controlling operating expenses in 2016 relative to 2015? elate to 2015 2-3 Net Profit Margin 2015 2016 2-b. Controlling operating expenses in 2016 vs 2015? Better Job Worse Job Required i Required 2 Required 3 Required 4 3-a. Computer Tycoon reported average net fixed assets of $55,500 in 2016 and $46,400 in 2015. Compute the fixed asset turnover ratios for both years. (Round your answers to 2 decimal place.) 3-b. Did the company better utilize its investment in fixed assets to generate revenues in 2016 or 2015? Fixed Asset Turnover 2015 2016 3-b. Investment better utilized? 2015 O2016 Required 2 Required 4 > Required 1 Required 2 Required 3 Required 4 4a. Computer Tycoon reported average stockholders' equity of $55,300 in 2016 and $42,100 in 2015. The company has not Issued preferred stock. Compute the return on equity ratios for both years. (Round your answers to 1 decimal place.) 4-b. Did the company generate greater returns for stockholders in 2016 than in 2015? Return on Equity (ROE) 2015 2016 4-b. Greater returns generated in 2016? O No
