Question

Exercise 18-8 Your answer is partially correct. Try again. Selected comparative statement data for Queen Products Company are presented below. All balance sheet data are as of December 31. 2017 2016 Net sales $760,000 $723,500 Cost of goods sold 481,500 441,000 Interest expense 6,300 6,000 Net Income 50,000 39,000 Accounts receivable 117.500 102,500 Inventory 89,600 76,600 Total assets 581,600 497,700 Total common stockholders' equity 431,300 329,300 Compute the following ratios for 2017. (Round answers to 1 decimal place, e.g. 1.6, or 1.6%.) Profit margin 6.6% Asset turnover 1.3 times Return on assets 2.3 96 Return on common stockholders' equity 3.3% Click if you would like to show Work for this question: Open Show Work

Answer 1

1) Profit margin = Net income / Net sales * 100 = 50,000 / 760,000 * 100 = 6.58% or 6.6%
2) Average asset = [581,600 + 497,700] / 2 = 539,650
Asset turnover = Net sales / Average asset = 760,000 / 539,650 = 1.4
3) Return on assets = Net income / Average asset = 50,000 / 539,650 * 100 = 9.3%
4) Average stockholders' equity = [431,300 + 329,300] / 2 = 380,300
Return on common stockholders' equity = Net income / Average stockholders' equity = 50,000 / 380,300 * 100 = 13.1%