Question

In: Accounting

The following data were taken from the financial statements of Gates Inc. for the current fiscal...

The following data were taken from the financial statements of Gates Inc. for the current fiscal year.

Property, plant, and equipment (net) $1,823,800
Liabilities:
Current liabilities $167,000
Note payable, 6%, due in 15 years 829,000
Total liabilities $996,000
Stockholders' equity:
Preferred $4 stock, $100 par (no change during year) $996,000
Common stock, $10 par (no change during year) 996,000
Retained earnings:
Balance, beginning of year $1,062,000
Net income 394,000 $1,456,000
Preferred dividends $39,840
Common dividends 88,160 128,000
Balance, end of year 1,328,000
Total stockholders' equity $3,320,000
Sales $12,505,000
Interest expense $49,740

Assuming that long-term investments totaled $2,158,000 throughout the year and that total assets were $4,100,000 at the beginning of the current fiscal year, determine the following. When required, round to one decimal place.

a. Ratio of fixed assets to long-term liabilities 2.2
b. Ratio of liabilities to stockholders' equity 0.3
c. Asset turnover
d. Return on total assets %
e. Return on stockholders’ equity %
f. Return on common stockholders' equity %

Solutions

Expert Solution

Answer:

a. Ratio of fixed assets to long-term liabilities 2.2
b. Ratio of liabilities to stockholders' equity 0.3
c. Ratio of net sales to assets 6.1
d. Rate earned on total assets 10.6%
e. Rate earned on stockholders' equity 12.4%
f. Rate earned on common stockholders' equity 16.2%

Calculation

a. Ratio of fixed assets to long-term liabilities

The fixed assets includes the property plant and equipment. And the long term liabilities include the notes payable.

Ratio of Fixed Assets to Long-Term Liabilities = Fixes assets / Long term liabilities =

$1,823,800 / 829,000 = 2.2

b. Ratio of liabilities to stockholders' equity

It is also known as debt to equity ratio.

Ratio of Liabilities to Stockholders’ Equity = Total liabilities / Total stockholder's equity

= $996,000 / 3,320,000 = 0.3

c. Ratio of net sales to assets = Net sales / Average total assets

To calculate the average total assets. we need to add the stockholders equity plus the total liabilities and total assets, then divide it with 2.

So, Average total assets = (996,000 + 3,320,000 + 4,100,000) / 2 = 4,208,000

Then we need to deduct the long term investments; that is = 4,208,000 - 2,158,000 = 2,050,000

Hence,

Ratio of net sales to assets = $12,505,000 / 2,050,000 = 6.1

d. Rate earned on total assets = (Net income + interest expense) / Average total assets

So, first we need to add the net income with the interest expense, then divide it with the Average total assets. Average total assets is calculated in required (c).

Rate earned on total assets = ($394,000 + 49,740) / [($4,316,000 + 4,100,000) / 2]

= 443,740 / 4,208,000 = 10.55%

e. Rate earned on stockholders' equity = Net income / Average stockholder's equity

Here, we need to calculate the Average stockholder's equity. For that we need to sum the Preferred shares, Common stock, retained earnings at beginning and the total stock holders equity, then divide by 2

That is: Average stockholder's equity = ($996,000 + 996,000 + 1,062,000+ 3,320,000 ) / 2 = 6,374,000 /2 = $3,187,000

So, the Rate earned on stockholders' equity = $394,000 / 3,187,000 = 12.36%

f. Rate earned on common stockholders' equity = Net income - Preferred stock) / Average common stockholder's equity

First we need to deduct the Preferred stock dividend from the net income, then divide it with the Average common stockholder's equity.

So, Average common stockholder's equity is calculated by adding the Beginning common stockholder's equity and the ending common stockholder's equity and then divide it by 2. Beginning common stockholder's equity includes the Common stock at the beginning and the retained earnings at the beginning. Ending common stockholder's equity includes the ending retained earnings and the common stock which havent changed from beginning.

Common stockholder's equity = (996,000 + 1,062,000 + 996,000 + 1,328,000) / 2 = 4,382,000 / 2 = $2,191,000

($394,000 - 39,840) / $2,191,000 = 16.16 %


Related Solutions

The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $1,414,800 Liabilities: Current liabilities $156,000 Note payable, 6%, due in 15 years 786,000 Total liabilities $942,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $942,000 Common stock, $10 par (no change during year) 942,000 Retained earnings: Balance, beginning of year $1,004,000 Net income 357,000 $1,361,000 Preferred dividends $37,680 Common dividends 67,320 105,000 Balance, end of...
The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $1,598,400 Liabilities: Current liabilities $201,000 Note payable, 6%, due in 15 years 999,000 Total liabilities $1,200,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $1,800,000 Common stock, $10 par (no change during year) 1,800,000 Retained earnings: Balance, beginning of year $1,920,000 Net income 674,000 $2,594,000 Preferred dividends $72,000 Common dividends 122,000 194,000 Balance, end of...
The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $1,286,900 Liabilities: Current liabilities $152,000 Note payable, 6%, due in 15 years 757,000 Total liabilities $909,000 Stockholders' equity: Preferred $2 stock, $100 par (no change during year) $909,000 Common stock, $10 par (no change during year) 909,000 Retained earnings: Balance, beginning of year $970,000 Net income 381,000 $1,351,000 Preferred dividends $18,180 Common dividends 120,820 139,000 Balance, end of...
The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $1,887,000 Liabilities: Current liabilities $222,000 Note payable, 6%, due in 15 years 1,110,000 Total liabilities $1,332,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $1,998,000 Common stock, $10 par (no change during year) 1,998,000 Retained earnings: Balance, beginning of year $2,132,000 Net income 779,000 $2,911,000 Preferred dividends $79,920 Common dividends 167,080 247,000 Balance, end of...
The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $2,444,400 Liabilities: Current liabilities $234,000 Note payable, 6%, due in 15 years 1,164,000 Total liabilities $1,398,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $2,097,000 Common stock, $10 par (no change during year) 2,097,000 Retained earnings: Balance, beginning of year $2,236,000 Net income 661,000 $2,897,000 Preferred dividends $83,880 Common dividends 17,120 101,000 Balance, end of...
The following data were taken from the financial statements of Gates Inc. for the current fiscal...
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $1,752,600 Liabilities: Current liabilities $153,000 Note payable, 6%, due in 15 years 762,000 Total liabilities $915,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $549,000 Common stock, $10 par (no change during year) 549,000 Retained earnings: Balance, beginning of year $586,000 Net income 298,000 $884,000 Preferred dividends $21,960 Common dividends 130,040 152,000 Balance, end of...
he following data were taken from the financial statements of Gates Inc. for the current fiscal...
he following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) $969,800 Liabilities: Current liabilities $148,000 Note payable, 6%, due in 15 years 746,000 Total liabilities $894,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $536,400 Common stock, $10 par (no change during year) 536,400 Retained earnings: Balance, beginning of year $572,000 Net income 285,000 $857,000 Preferred dividends $21,456 Common dividends 120,344 141,800 Balance, end of...
The following data were taken from the financial statements of Woodwork Enterprises Inc. for the current...
The following data were taken from the financial statements of Woodwork Enterprises Inc. for the current fiscal year. Assuming that there are no intangible assets. Property, plant, and equipment (net) $1,662,900 Liabilities: Current liabilities $144,000 Mortgage note payable, 10%, ten-year note issued two years ago 723,000 Total liabilities $867,000 Stockholders' equity: Preferred $4 stock, $100 par (no change during year) $650,250 Common stock, $10 par (no change during year) 650,250 Retained earnings: Balance, beginning of year $694,000 Net income 258,000...
The following data were taken from the financial statements of Hunter Inc. for December 31 of...
The following data were taken from the financial statements of Hunter Inc. for December 31 of two recent years: Current Year Previous Year Accounts payable $510,000 $130,000 Current maturities of serial bonds payable 320,000 320,000 Serial bonds payable, 10% 1,270,000 1,590,000 Common stock, $1 par value 60,000 80,000 Paid-in capital in excess of par 660,000 660,000 Retained earnings 2,280,000 1,810,000 The income before income tax was $588,300 and $514,800 for the current and previous years, respectively. a. Determine the ratio...
The following data were taken from the financial statements of Hunter Inc. for December 31 of...
The following data were taken from the financial statements of Hunter Inc. for December 31 of two recent years: Current Year Previous Year Accounts payable $360,000 $110,000 Current maturities of serial bonds payable 240,000 240,000 Serial bonds payable, 10% 1,020,000 1,260,000 Common stock, $1 par value 60,000 70,000 Paid-in capital in excess of par 590,000 600,000 Retained earnings 2,050,000 1,630,000 The income before income tax was $415,800 and $363,800 for the current and previous years, respectively. a. Determine the ratio...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT