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 2017 2016 2015 Assets Cash $ 32,096...
Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 32,096 $ 37,517 $ 38,306 Accounts receivable, net 89,700 62,100 54,700 Merchandise inventory 115,000 83,500 54,000 Prepaid expenses 10,336 9,848 4,256 Plant assets, net 291,476 271,352 231,838 Total assets $ 538,608 $ 464,317 $ 383,100 Liabilities and Equity Accounts payable $ 135,455 $ 79,254 $ 51,075 Long-term notes payable secured by mortgages on plant assets 102,271 107,861 85,512 Common stock, $10 par value 162,500 162,500...
Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions displayed below.]...
Problem 13-5A Comparative ratio analysis LO 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 $ 770,000 $ 890,200 Cash $ 19,500 $ 32,000 Cost of goods sold 590,100 642,500 Accounts receivable, net 36,400 51,400 Interest expense 9,300 17,000 Merchandise...
Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies...
Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [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 $505,425 $387,197 $268,700 Cost of goods sold 304,266 243,547 171,968 Gross profit 201,159 143,650 96,732 Selling expenses 71,770 53,433 35,468 Administrative expenses 45,488 34,073 22,302 Total expenses 117,258 87,506 57,770 Income before taxes...
Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies...
Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [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 $505,425 $387,197 $268,700 Cost of goods sold 304,266 243,547 171,968 Gross profit 201,159 143,650 96,732 Selling expenses 71,770 53,433 35,468 Administrative expenses 45,488 34,073 22,302 Total expenses 117,258 87,506 57,770 Income before taxes...