167. The following selected data were taken from the financial statements of the Berrol Group for December
31, 2012, 2011, and 2010:
Notes payable (10% interest)
Preferred $6 stock, $100 par (no change
during year)
The 2012 net income was $242,000 and the 2011 net income was $308,000. No dividends on common stock were declared between 2010 and 2012.
Required:
(1) Determine the rate earned on total assets, the rate earned on stockholders’ equity, and the rate earned on common stockholders’ equity for the
years 2012 and 2011. Round to one decimal place.
(2) What conclusion can be drawn from these data as to the company’s profitability?
(1)
Rate Earned on Total Assets = (Net Income + Interest Expense ) / Average Total Assets
2012: ($242,000 + $100,000) / $2,850,000* = 12.0%
2011: ($308,000 + $100,000) /$2,550,000** = 16.0%
*($3,000,000 + $2,700,000) 2
**($2,700,000 + $2,400,000) 2
Rate Earned on Stockholders’ Equity = Net Income / Average Stockholders’ Equity
2012: $242,000 / $1,611,000* = 15.0%
2011: $308,000 / $1,348,000** = 22.8%
*($1,726,000 + $1,496,000) 2
**($1,496,000 + $1,200,000) 2
Rate Earned on Common Stockholders’ Equity =
(Net Income – Preferred Dividends) / Average Common Stockholders’ Equity
2012: ($242,000 -$12,000) / $1,411,000* = 16.3%
2011: ($308,000 – $12,000) / $1,148,000** = 25.8%
*($1,526,000 + $1,296,000) 2
**($1,296,000 + $1,000,000) 2