Question

In: Accounting

Ratios (Appendix) Byers Company presents the following condensed income statement for 2016 and condensed December 31,...

Ratios (Appendix)

Byers Company presents the following condensed income statement for 2016 and condensed December 31, 2016, balance sheet:

Income Statement
Sales (net) $267,000
Less:
     Cost of goods sold $160,000
     Operating expenses 62,000
     Interest expense 11,000
     Income taxes 10,000
     Total expenses (243,000)
Net income $24,000
Balance Sheet
Cash $10,000 Current liabilities $40,000
Receivables (net) 22,000 Bonds payable, 10% 110,000
Inventory 56,000 Common stock, $10 par 100,000
Long-term investments 30,000 Additional paid-in capital 95,000
Property and equipment (net) 282,000 Retained earnings 55,000
Total Assets $400,000 Total Liabilities and Shareholders' Equity $400,000


Additional information:

The company's common stock was outstanding the entire year.

Dividends of $1.50 per share on the common stock were declared in 2016.

On December 31, 2016, common stock is selling for $20 per share.

On January 1, 2016, the accounts receivable (net) balance was $24,000, total assets amounted to $380,000, and total shareholders' equity was $241,000.

Of the company's net sales, 78% are on credit.

The company operates on a 365-day business year.

Required

On the basis of the preceding information, compute the following ratios for the Byers Company:

(Round to two decimal places.)

1. Earnings per share: %
2. Gross profit margin: %
3. Operating profit margin: %
4. Net profit margin: %
5. Total asset turnover: times
6. Return on assets (Round tax rate to the nearest whole percent in your intermediate calculations.) %
7. Return on common equity %
8. Receivables turnover (in days): (Round your intermediate calculation to two decimal places.) days
9. Interest coverage: (in times) times

Solutions

Expert Solution

1. EPS = (Net income – preferred dividend)/ Average o/s common stock

        = (24000 - ))/10000

        = $2.4 per share

2. Gross margin ratio = Gross profit/ sales revenue

                                          = 107000/ 267000

                                          = 40.07

3. Operating profit margin = Operating income/ net sales

                                             = 45000/ 267000

                                              = 16.85%

4. Net profit margin = Net income/ total revenue

                                 = 24000/ 267000

                                 = 0.0898 or 8.98%

--------------------------------------------------------------------------------------------------------------------

Hope that helps.

Feel free to comment if you need further assistance J


Related Solutions

Ratio Analysis Byers Company presents the following condensed income statement for 2019 and condensed December 31,...
Ratio Analysis Byers Company presents the following condensed income statement for 2019 and condensed December 31, 2019, balance sheet: Income Statement Sales (net) $267,000 Less:      Cost of goods sold $160,000      Operating expenses 62,000      Interest expense 11,000      Income taxes 10,000      Total expenses (243,000) Net income $24,000 Balance Sheet Cash $10,000 Current liabilities $40,000 Receivables (net) 22,000 Bonds payable, 10% 110,000 Inventory 56,000 Common stock, $10 par 100,000 Long-term investments 30,000 Additional paid-in capital 95,000 Property and equipment (net) 282,000 Retained earnings...
Ratios (Appendix) Miller Company's condensed income statement for 2016 and December 31, 2016, balance sheet follow:...
Ratios (Appendix) Miller Company's condensed income statement for 2016 and December 31, 2016, balance sheet follow: Income Statement Sales (net) $304,400 Cost of goods sold (183,600) Gross profit $120,800 Operating expenses (82,000) Operating income $38,800 Interest expense (7,000) Income before income taxes $31,800 Income taxes (10,000) Net income 21,800 Balance Sheet Cash $8,200 Accounts payable $18,000 Receivables (net) 14,700 Other current liabilities 6,800 Inventory 19,300 Bonds payable, 10% 70,000 Property, plant, and equipment (net) 195,800 Common stock, $10 par 80,500...
Spreadsheet and Statement The following 2016 information is available for Stewart Company: Condensed Income Statement for...
Spreadsheet and Statement The following 2016 information is available for Stewart Company: Condensed Income Statement for 2016 Sales $9,000 Cost of goods sold (6,000) Other expenses (2,000) Loss on sale of equipment (260) Gain on sale of land 400 Net income $1,140 Comparative Balance Sheets December 31, 2015 December 31, 2016 Cash $700 $1,130 Accounts receivable 450 310 Inventory 350 400 Land 300 500 Equipment 1,600 1,800 Less: Accumulated depreciation (200) (150) Total Assets $3,200 $3,990 Accounts payable $600 $750...
Stepfall Ltd had the following ratios at 31 December 2017 and 31 December 2016: 2017 2016...
Stepfall Ltd had the following ratios at 31 December 2017 and 31 December 2016: 2017 2016 Gross profit margin 27% 31% Return on capital employed 15% 22% Current ratio 1.1:1 0.7:1 Acid test ratio 0.8:1 0.6:1 Trade receivable days 33 days 48 days Inventory holding days 42 days 57 days Which ONE of the following statements is TRUE? a) The company’s profitability, working capital management and liquidity have improved. b) The company’s profitability and working capital management have deteriorated but...
Rembrandt Paint Company had the following income statement items for the year ended December 31, 2016...
Rembrandt Paint Company had the following income statement items for the year ended December 31, 2016 ($ in 000s):   Net sales $ 34,000   Cost of goods sold $ 18,500   Interest income 360   Selling and administrative expenses 4,100   Interest expense 670   Restructuring costs 2,400       In addition, during the year the company completed the disposal of its plastics business and incurred a loss from operations of $3.2 million and a gain on disposal of the component’s assets of $5.2 million. 600,000 shares...
Rembrandt Paint Company had the following income statement items for the year ended December 31, 2016...
Rembrandt Paint Company had the following income statement items for the year ended December 31, 2016 ($ in 000s):   Net sales $ 20,000   Cost of goods sold $ 11,500   Interest income 220   Selling and administrative expenses 2,700   Interest expense 390   Restructuring costs 1,000       In addition, during the year the company completed the disposal of its plastics business and incurred a loss from operations of $1.8 million and a gain on disposal of the component’s assets of $2.4 million. 600,000 shares...
Rembrandt Paint Company had the following income statement items for the year ended December 31, 2016...
Rembrandt Paint Company had the following income statement items for the year ended December 31, 2016 ($ in 000s):   Net sales $ 20,000   Cost of goods sold $ 11,500   Interest income 220   Selling and administrative expenses 2,700   Interest expense 390   Restructuring costs 1,000       In addition, during the year the company completed the disposal of its plastics business and incurred a loss from operations of $1.8 million and a gain on disposal of the component’s assets of $2.4 million. 600,000 shares...
Teal Company’s income statement for the year ended December 31, 2017, contained the following condensed information....
Teal Company’s income statement for the year ended December 31, 2017, contained the following condensed information. Service revenue $845,000 Operating expenses (excluding depreciation) $620,000 Depreciation expense 61,000 Loss on sale of equipment 26,000 707,000 Income before income taxes 138,000 Income tax expense 41,000 Net income $97,000 Teal’s balance sheet contained the following comparative data at December 31. 2017 2016 Accounts receivable $39,000 $56,000 Accounts payable 39,000 33,000 Income taxes payable 4,100 8,400 (Accounts payable pertains to operating expenses.) Prepare the...
Shamrock Company’s income statement for the year ended December 31, 2017, contained the following condensed information....
Shamrock Company’s income statement for the year ended December 31, 2017, contained the following condensed information. Service revenue $837,000 Operating expenses (excluding depreciation) $621,000 Depreciation expense 60,000 Loss on sale of equipment 25,000 706,000 Income before income taxes 131,000 Income tax expense 40,000 Net income $91,000 Shamrock’s balance sheet contained the following comparative data at December 31. 2017 2016 Accounts receivable $36,000 $55,000 Accounts payable 42,000 31,000 Income taxes payable 4,000 8,200 (Accounts payable pertains to operating expenses.) Prepare the...
Walbash Company presents the following December 31, 2016, balance sheet: Walbash Company Sheet of Balances for...
Walbash Company presents the following December 31, 2016, balance sheet: Walbash Company Sheet of Balances for Year Ended December 31, 2016 Current Assets                     $   44,300 Long-term investments            13,600 Property, plant, and equipment            123,500 Intangible assets                       7,700 Other assets                             13,600                                                 ______ Total assets                               $202,700 Current liabilities                      $   66,600 Long-term liabilities                      24,100 Contributed capital                        17,000 Unrealized capital                          22,500 Retained earnings                          72,500                                                        ______ Total equities                                 $202,700 The following information is also available: Current assets include cash, $3,800; accounts receivable,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT