EX 17-19 Six measures of solvency or profitability

The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Assuming that long-term investments totaled $3,000,000 throughout the year and that total assets were $7,000,000 at the beginning of the current fiscal year, determine the following: (a) ratio of fixed assets to long-term liabilities, (b) ratio of liabilities to stockholders’ equity, (c) ratio of net sales to assets, (d) rate earned on total assets, (e) rate earned on stockholders’ equity, and (f) rate earned on common stockholders’ equity. Round to one decimal place.


Property, plant, and equipment (net) . . . . . . . . . . . . . . . . . . . . . . . $ 3,200,000
Liabilities:
Current liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $1,000,000
Mortgage note payable, 6%, issued 2003, due 2019 . . . . . . 2,000,000
Total liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 3,000,000
Stockholders’ equity:
Preferred $10 stock, $100 par (no change during year) . . . . $ 1,000,000
Common stock, $10 par (no change during year) . . . . . . . . . 2,000,000
Retained earnings:
Balance, beginning of year . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $1,570,000
Net income . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 930,000 $2,500,000
Preferred dividends . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 100,000
Common dividends . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400,000 500,000
Balance, end of year . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,000,000
Total stockholders’ equity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 5,000,000
Net sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $18,900,000
Interest expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 120,000


Answer:

a. Ratio of Fixed Assets to
=
Long-Term Liabilities
Fixed Assets (net)
Long-Term Liabilities
$3,200,000
$2,000,000 = 1.6
b. Ratio of Liabilities to
Stockholders’ Equity = Total Liabilities
Total Stockholders’ Equity
$3,000,000
$5,000,000 = 0.6
c. Ratio of Net Sales to Assets = Net Sales
Average Total Assets
(excluding long-term investments)
$18,900,000
$4,500,000 * = 4.2
* [($7,000,000 + $8,000,000) ÷ 2] – $3,000,000. The end-of-period total assets are
equal to the sum of total liabilities ($3,000,000) and stockholders’ equity
($5,000,000).
d. Rate Earned on Total Assets = Net Income + Interest Expense
Average Total Assets
$930,000 + $120,000*
$7,500,000 **
* $2,000,000 × 6%
** ($7,000,000 + $8,000,000) ÷ 2
= 14.0%
e. Rate Earned on
Stockholders’ Equity = Net Income
Average Total Stockholders’ Equity
$930,000
$4,785,000 * = 19.4%
* [($1,570,000 + $2,000,000 + $1,000,000) + $5,000,000] ÷ 2
f. Rate Earned on Common
=
Stockholders’ Equity
Net Income – Preferred Dividends
Average Common Stockholders’ Equity
$930,000 – $100,000 *
$3,785,000 **
* ($1,000,000 ÷ $100) × $10
= 21.9%
** [($2,000,000 + $1,570,000) + ($2,000,000 + $2,000,000)] ÷ 2