Question

In: Accounting

Selected information from the comparative financial statements of Emley Company for the year ended December 31,...

Selected information from the comparative financial statements of Emley Company for the year ended December 31,

                                                                                   2017 2016

Accounts receivable (net)                                 $180,000 $200,000

Inventory                                                                    140,000                 160,000

Total assets                                                             1,200,000                 800,000

Current liabilities                                                       140,000                 110,000

Long-term debt                                                          400,000                 300,000

Net credit sales                                                       1,330,000                 700,000

Cost of goods sold                                                     900,000                 530,000

Interest expense                                                           50,000                   25,000

Income tax expense                                                     60,000                   29,000

Net income                                                                 150,000                   85,000

Compute each of the following ratios and interpret the results:

  1. Inventory turnover
  2. Times interest earned
  3. The debt to assets ratio
  4. Accounts receivable turnover
  5. Return on assets

Solutions

Expert Solution

i. Inventory turnover [Cost of goods sold/Average inventory] = 900000/((140000+160000)/2) = 6.00 The ratio tells that the inventory is turnover 6 times in a year. Another way to look at it is--Days' inventory outstanding [DIO of 365/60] is days, meaning that the stock of inventory represents 61 days requirement.
ii. Times interest earned [Operating income/Interest expense] = (1330000-900000)/50000 = 8.60 Indicates the number of times the interest expense can be paid from the operating income generated. A high ratio highlights the safety of the creditors.
iii. The debt to assets ratio [Total liabilities/Total assets] = (140000+400000)/1200000 = 45.00% The ratio tells the % of assets financed by the debt. It highlights the risk presented by the borrowings.
iv. Accounts receivable turnover [Net credit sales/Average receivables] = 1330000/((180000+200000)/2) = 7.00 The ratio gives the number of times the receivables is turned over by credit sales during the period. From this ratio the Days' sales outstanding [DSO] is 52 days, which, means that the receivables outstanding represents 52 days credit sales. This has to be compared with the credit terms of the firm and with industry average.
v. Return on assets = Net income/Average total assets = 150000/((1200000+800000)/2) = 15.00% The ratio says that the firm is earning a net return of 15% on the assets deployed. It can be compared with earlier figures or with industry standards.

Related Solutions

S Selected information from the comparative financial statements of ZZ Tire Company for the year ended...
S Selected information from the comparative financial statements of ZZ Tire Company for the year ended December 31, appears below: 2014 2013 Accounts receivable (net) $    180,000 $200,000 Inventory 140,000 160,000 Total assets 1,200,000 800,000 Current liabilities 140,000 110,000 Long-term debt 400,000 300,000 Net credit sales 1,330,000 700,000 Cost of goods sold 900,000 530,000 Interest expense 50,000 25,000 Income tax expense 60,000 29,000 Net income 150,000 85,000 There is no preferred stock and the tax rate is 30%. Required: Calculate each...
Selected information from Rockway, Inc.’s U.S. GAAP financial statements for the year ended December 31, included...
Selected information from Rockway, Inc.’s U.S. GAAP financial statements for the year ended December 31, included the following (in $): 2004 2005 Sales 17,000,000 21,000,000 Cost of Goods Sold 11,000,000 15,000,000 Interest Paid 800,000 1,000,000 Current Income Taxes Paid 700,000 1,000,000 Accounts Receivable 3,000,000 2,500,000 Inventory 2,400,000 3,000,000 Property, Plant & Equip 2,000,000 16,000,000 Accounts Payable 1,000,000 1,400,000 Long-term Debt 8,000,000 9,000,000 Common Stock 4,000,000 5,000,000 Cash provided or used by operating activities (CFO) in the year 2005 was closest...
Selected financial information for the Bravo-Zulu Company for the fiscal year ended December 31, 2016 is...
Selected financial information for the Bravo-Zulu Company for the fiscal year ended December 31, 2016 is as follows: Net Income $122,500 Depreciation Expense 50,000 Purchases of plant assets 125,000 Proceeds on Disposals of plant assets 20,000 Loss on Disposal of plant assets 7,500 Accounts receivable increased 2,500 Accounts payable decreased 4,000 Interest expense 5,000 Income tax expense 2,500 Additionally, Bravo-Zulu issued stock in exchange for an outstanding note payable of $72,500. The cash balance on January 1, 2016 was $37,000....
Selected financial information for the Bravo Zulu company for the fiscal year ended December 31, 2016...
Selected financial information for the Bravo Zulu company for the fiscal year ended December 31, 2016 is as follows: Net Income $122,500 Depreciation expense 50,000 Purchases of plant assets 125,000 Disposals of plants assets 20,000 Gain on Disposal of plant assets 7,500 Accounts receivable decreased 2,500 Accounts payable decreased 4,000 Interest expense 5,000 Income tax expense 2,500 Additionally, Bravo-Zulu issued stock in exchange for an outstanding note payable of $72,500. The cash balance on January 1, 2016 was $37,000. The...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and 2017 follows. Prepare a cash flow statement using the indirect method. Properly title the statement. 2018 2017 Cash balance $113,500 $37,500 Net income 142,500 162,000 Depreciation Expense 42,000 35,000 Purchase of Plant Assets 135,000 125,000 Disposal of Plant Assets 40,000 50,000 Gain (Loss) on Disposal of Plant Assets (10,000) 5,000 Accounts Receivable Balance 64,500 58,000 Accounts Payable Balance 42,000 39,000 Interest Expense 8,000 6,000...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and 2017 follows. Prepare a cash flow statement using the indirect method. Properly title the statement. 2018 2017 Cash balance $113,500 $37,500 Net income 142,500 162,000 Depreciation Expense 42,000 35,000 Purchase of Plant Assets 135,000 125,000 Disposal of Plant Assets 40,000 50,000 Gain (Loss) on Disposal of Plant Assets (10,000) 5,000 Accounts Receivable Balance 64,500 58,000 Accounts Payable Balance 42,000 39,000 Interest Expense 8,000 6,000...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and 2017 follows. Prepare a cash flow statement using the indirect method. Properly title the statement. 2018 2017 Cash balance $113,500 $37,500 Net income 142,500 162,000 Depreciation Expense 42,000 35,000 Purchase of Plant Assets 135,000 125,000 Disposal of Plant Assets 40,000 50,000 Gain (Loss) on Disposal of Plant Assets (10,000) 5,000 Accounts Receivable Balance 64,500 58,000 Accounts Payable Balance 42,000 39,000 Interest Expense 8,000 6,000...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and 2017 follows. Prepare a cash flow statement using the indirect method. Properly title the statement. 2017 2018 Net income $142,500 $162,000 Depreciation Expense 42,000 35,000 Purchase of Plant Assets 135,000 125,000 Disposal of Plant Assets 40,000 50,000 Gain (Loss) on Disposal of Plant Assets (10,000) 5,000 Accounts Receivable Balance 64,500 58,000 Accounts Payable Balance 42,000 39,000 Interest Expense 8,000 6,000 Income Taxes Paid 35,000...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and 2017 follows. Prepare a cash flow statement using the indirect method. Properly title the statement. 2018 2017 Net income $142,500 $162,000 Depreciation Expense 42,000 35,000 Purchase of Plant Assets 135,000 125,000 Disposal of Plant Assets 40,000 50,000 Gain (Loss) on Disposal of Plant Assets (10,000) 5,000 Accounts Receivable Balance 64,500 58,000 Accounts Payable Balance 42,000 39,000 Interest Expense 8,000 6,000 Income Taxes Paid 35,000...
The financial statements of Pouchie Co. included the following information for the year ended December 31,...
The financial statements of Pouchie Co. included the following information for the year ended December 31, 2016 (amountsin millions Depreciation and amortization expense $260 Cash dividends declared and paid 343 Purchase of equipment 818 Net income 396 Beginning cash balance 128 Proceeds of common stock issued 171 Proceeds from sale of building (at book value) 215 Accounts receivable increase 16 Ending cash balance 92 Inventory decrease 45 Accounts payable increase 54 Required: Complete the following statement of cash flows, using...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT