Question

In: Accounting

Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood...

Return Ratios and Leverage

The following selected data are taken from the financial statements of Redwood Enterprises:

Sales revenue $659,000
Cost of goods sold 397,000
Gross profit $262,000
Selling and administrative expense 100,000
Operating income $162,000
Interest expense 50,000
Income before tax $112,000
Income tax expense (40%) 44,800
Net income $67,200
Accounts payable $45,000
Accrued liabilities 70,000
Income taxes payable 10,000
Interest payable 25,000
Short-term loans payable 150,000
Total current liabilities $300,000
Long-term bonds payable $500,000
Preferred stock, 10%, $100 par $250,000
Common stock, no par 600,000
Retained earnings 350,000
Total stockholders' equity $1,200,000
   Total liabilities and stockholders' equity $2,000,000

Required:

1. Compute the following ratios for Redwood Enterprises:

Return on sales

Asset turnover (Assume that total assets at the beginning of the year were $1,600,000.)

Return on assets

Return on common stockholders' equity (Assume that the only changes in stockholders' equity during the year were from the net income for the year and dividends on the preferred stock.)

When computing percentage amounts, carry out calculations to four decimal places, but enter your answers to two decimal places; for example, .17856 rounds to .1786 and would be entered as 17.86.

a. Return on sales %
b. Asset turnover (round to 2 decimal places) times
c. Return on assets %
d. Return on common stockholders' equity %

2. Comment on Evergreen’s use of leverage. Has it successfully employed leverage?

Solutions

Expert Solution

Answer

1.

a. Return on sales = Net income+interest expenses(net of tax) / Net sales

                               =67200 + (50000-20000) / 659000

                               =14.75%

b. Asset turnover = Net sales / Average total assets

                              = 659000 / 1800000

                              =.37 Times

Avg assets 2000000+1600000 / 2 =1800000

c. Return on assets =Net income + interest exp(net of tax) / avg total assets

                                =67200+30000 / 1800000

                                =5%.

d. Return on common stockholders' equity = Net income - pref dividend / avg common stock holders equity

                                                                     =67200-25000 / 600000

                                                                     =7.03%

(pref dividend 250000*10%= 25000)

2.

If return on assets is less than return on stock holder equity then that means the managment has successfully employed the leveraged.

So, in this case return of common stock holder equity is more than the return on assets so the company has successfully employed the leverage.


Related Solutions

Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood Enterprises: Sales revenue $649,000 Cost of goods sold 363,000 Gross profit $286,000 Selling and administrative expense 100,000 Operating income $186,000 Interest expense 50,000 Income before tax $136,000 Income tax expense (40%) 54,400 Net income $81,600 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Return Ratios and Leverage The following selected data are taken from the financial statements of Evergreen...
Return Ratios and Leverage The following selected data are taken from the financial statements of Evergreen Company: Sales revenue $657,000 Cost of goods sold 387,000 Gross profit $270,000 Selling and administrative expense 100,000 Operating income $170,000 Interest expense 50,000 Income before tax $120,000 Income tax expense (40%) 48,000 Net income $72,000 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y720Y620Y5 Total assets$221,000 $199,000 $177,000 Notes payable (8% interest)70,000 70,000 70,000 Common stock28,000 28,000 28,000 Preferred 5% stock, $100 par14,000 14,000 14,000 (no change during year)       Retained earnings70,600 53,100 42,000 The 20Y7 net income was $18,200, and the 20Y6 net income was $11,800. No dividends on common stock were declared between 20Y5 and 20Y7. Preferred dividends...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $320,000 $288,000 $256,000 Notes payable (8% interest) 110,000 110,000 110,000 Common stock 44,000 44,000 44,000 Preferred 6% stock, $100 par 22,000 22,000 22,000 (no change during year) Retained earnings 117,200 80,880 66,000 The 20Y7 net income was $37,640, and the 20Y6 net income was $16,200. No dividends on common stock were...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $255,000 $230,000 $205,000 Notes payable (8% interest) 90,000 90,000 90,000 Common stock 36,000 36,000 36,000 Preferred 5% stock, $100 par 18,000 18,000 18,000 (no change during year) Retained earnings 94,500 68,025 54,000 The 20Y7 net income was $27,375, and the 20Y6 net income was $14,925. No dividends on common stock were...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y720Y620Y5 Total assets$221,000 $199,000 $177,000 Notes payable (8% interest)70,000 70,000 70,000 Common stock28,000 28,000 28,000 Preferred 5% stock, $100 par14,000 14,000 14,000 (no change during year)       Retained earnings70,600 53,100 42,000 The 20Y7 net income was $18,200, and the 20Y6 net income was $11,800. No dividends on common stock were declared between 20Y5 and 20Y7. Preferred dividends...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $254,000 $229,000 $204,000 Notes payable (8% interest) 80,000 80,000 80,000 Common stock 32,000 32,000 32,000 Preferred 5% stock, $100 par 16,000 16,000 16,000 (no change during year) Retained earnings 88,275 60,850 48,000 The 20Y7 net income was $28,225, and the 20Y6 net income was $13,650. No dividends on common stock were...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $172,000 $155,000 $138,000 Notes payable (8% interest) 60,000 60,000 60,000 Common stock 24,000 24,000 24,000 Preferred 7% stock, $100 par 12,000 12,000 12,000 (no change during year) Retained earnings 73,725 51,135 36,000 The 20Y7 net income was $23,430, and the 20Y6 net income was $15,975. No dividends on common stock were...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $291,000 $262,000 $233,000 Notes payable (8% interest) 100,000 100,000 100,000 Common stock 40,000 40,000 40,000 Preferred 5% stock, $100 par 20,000 20,000 20,000 (no change during year) Retained earnings 124,895 86,125 60,000 The 20Y7 net income was $39,770, and the 20Y6 net income was $27,125. No dividends on common stock were...
9. Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc....
9. Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $220,000 $198,000 $176,000 Notes payable (8% interest) 70,000 70,000 70,000 Common stock 28,000 28,000 28,000 Preferred 3% stock, $100 par 14,000 14,000 14,000 (no change during year) Retained earnings 79,080 55,150 42,000 The 20Y7 net income was $24,350, and the 20Y6 net income was $13,570. No dividends on common stock...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT