Question

Exercise 17-10 Efficiency and profitability analysis LO P3 [The following information applies to the questions displayed...

Exercise 17-10 Efficiency and profitability analysis LO P3

[The following information applies to the questions displayed below.]

Simon Company’s year-end balance sheets follow.

At December 31 2017 2016 2015
Assets
Cash $ 32,000 $ 36,250 $ 37,600
Accounts receivable, net 89,400 61,500 51,000
Merchandise inventory 111,000 82,400 53,500
Prepaid expenses 10,700 9,200 5,300
Plant assets, net

280,000

250,500 228,000
Total assets $ 523,100 $ 439,850 $ 375,400
Liabilities and Equity
Accounts payable $ 128,000 $ 73,500 $ 51,600
Long-term notes payable secured by
mortgages on plant assets
95,500 98,500 81,200
Common stock, $10 par value 161,000 161,000 161,000
Retained earnings 138,600 106,850 81,600
Total liabilities and equity $ 523,100 $ 439,850 $ 375,400


The company’s income statements for the years ended December 31, 2017 and 2016, follow.

For Year Ended December 31 2017 2016
Sales $ 685,000 $ 590,000
Cost of goods sold $ 411,000 $ 371,700
Other operating expenses 198,650 141,600
Interest expense 11,600 12,800
Income taxes 9,450 8,550
Total costs and expenses 630,700 534,650
Net income $ 54,300 $ 55,350
Earnings per share $ 3.37 $ 3.44


Evaluate the company's efficiency and profitability by computing the following for 2017 and 2016.

(1) Profit margin ratio

Profit Margin Ratio
Choose Numerator: / Choose Denominator: = Profit Margin Ratio
/ = Profit margin ratio
2017 / = %
2016 / = %

(2) Total asset turnover.

Total Asset Turnover
Choose Numerator: / Choose Denominator: = Total Asset Turnover
/ = Total asset turnover
2017 / = times
2016 / = times

(3) Return on total assets.

Return On Total Assets
Choose Numerator: / Choose Denominator: = Return On Total Assets
/ = Return on total assets
2017 / = %
2016 / = %

Homework Answers

Answer #1

Note: Final answers rounded to 1 decimal being it is not mentioned in question.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Required information Exercise 13-10 Efficiency and profitability analysis LO P3 [The following information applies to the...
Required information Exercise 13-10 Efficiency and profitability analysis LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 32,200 $ 35,000 $ 37,400 Accounts receivable, net 86,100 63,500 50,500 Merchandise inventory 112,000 82,400 53,500 Prepaid expenses 10,550 9,400 4,800 Plant assets, net 278,000 249,500 229,000 Total assets $ 518,850 $ 439,800 $ 375,200 Liabilities and Equity Accounts payable $ 128,400 $ 74,250 $ 50,400...
Exercise 13-9 Risk and capital structure analysis LO P3 [The following information applies to the questions...
Exercise 13-9 Risk and capital structure analysis LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,883 $ 36,172 $ 38,810 Accounts receivable, net 89,689 64,580 50,239 Merchandise inventory 116,184 85,338 52,964 Prepaid expenses 9,965 9,495 4,187 Plant assets, net 282,074 261,135 234,400 Total assets $ 529,795 $ 456,720 $ 380,600 Liabilities and Equity Accounts payable $ 134,557 $ 77,958 $ 51,244 Long-term...
Problem 17-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation...
Problem 17-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $56,900; total assets, $249,400; common stock, $81,000; and retained earnings, $51,308.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 453,600 Cost of goods sold 298,350 Gross profit 155,250 Operating expenses 99,000 Interest expense 4,100 Income before taxes 52,150 Income taxes 21,008 Net income $...
Required information Problem 17-5A Comparative ratio analysis LO A1, P3 [The following information applies to the...
Required information Problem 17-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 800,000 $ 912,200 Cash $ 18,000 $ 34,000 Cost of goods sold 596,100 650,500 Accounts receivable, net 37,400 56,400 Interest expense...
Exercise 13-11 Profitability analysis LO P3 Simon Company’s year-end balance sheets follow. At December 31 2017...
Exercise 13-11 Profitability analysis LO P3 Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,200 $ 34,000 $ 36,300 Accounts receivable, net 89,800 62,100 58,800 Merchandise inventory 88,271 84,200 51,400 Prepaid expenses 10,746 10,491 4,247 Plant assets, net 339,983 294,209 239,253 Total assets $ 560,000 $ 485,000 $ 390,000 Liabilities and Equity Accounts payable $ 136,651 $ 80,326 $ 50,450 Long-term notes payable secured by mortgages on plant assets 102,122 110,434 83,604 Common...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 30,400 $ 35,750 $ 37,800 Accounts receivable, net 89,700 63,500 50,500 Merchandise inventory 112,000 82,000 53,000 Prepaid expenses 10,850 9,300 4,700 Plant assets, net 278,000 256,500 227,000 Total assets $ 520,950 $ 447,050 $ 373,000 Liabilities and Equity Accounts payable $ 129,200 $ 74,500 $ 50,800 Long-term notes payable secured by mortgages on plant assets 95,500 101,750 81,600 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 31,200 $ 36,000 $ 37,800 Accounts receivable, net 89,800 61,500 49,000 Merchandise inventory 110,000 83,800 54,000 Prepaid expenses 10,700 9,300 4,300 Plant assets, net 280,000 258,000 230,000 Total assets $ 521,700 $ 448,600 $ 375,100 Liabilities and Equity Accounts payable $ 129,200 $ 75,750 $ 51,200 Long-term notes payable secured by mortgages on plant assets 97,500 101,750 84,000 Common stock,...
Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet...
Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $51,900; total assets, $179,400; common stock, $85,000; and retained earnings, $48,534.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 451,600 Cost of goods sold 297,250 Gross profit 154,350 Operating expenses 98,600 Interest expense 4,900 Income before taxes 50,850 Income taxes 20,484 Net income $ 30,366 CABOT CORPORATION Balance Sheet December 31, 2017 Assets...
[The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At...
[The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 29,123 $ 34,042 $ 35,105 Accounts receivable, net 89,200 62,300 50,700 Merchandise inventory 110,500 83,500 59,000 Prepaid expenses 9,378 8,936 3,901 Plant assets, net 255,402 236,742 205,894 Total assets $ 493,603 $ 425,520 $ 354,600 Liabilities and Equity Accounts payable $ 122,907 $ 71,913 $ 46,807 Long-term notes payable secured by...
Required information [The following information applies to the questions displayed below.] Selected comparative financial statements of...
Required information [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow: KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 Sales $ 517,275 $ 396,275 $ 275,000 Cost of goods sold 311,400 250,050 176,000 Gross profit 205,875 146,225 99,000 Selling expenses 73,453 54,686 36,300 Administrative expenses 46,555 34,872 22,825 Total expenses 120,008 89,558 59,125 Income before taxes 85,867 56,667 39,875 Income taxes 15,971 11,617...