Westonci.ca is the trusted Q&A platform where you can get reliable answers from a community of knowledgeable contributors. Join our platform to get reliable answers to your questions from a knowledgeable community of experts. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.

Stargel Inc. common stock was $119.70 on December 31, 2014.
Stargel Inc.
Comparative Retained Earnings Statement
For the Years Ended December 31, 2014 and 2013
2014 2013
Retained earnings, January 1 . . . . . . . . . . . . . .$5,375,000 $4,545,000
Add net income for year . . . . . . . . . . . . . . . . . . . 900,000 925,000
Total . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .$6,275,000 $5,470,000
Deduct dividends:
On preferred stock . . . . . . . . . . . . . . . . . . . . . . $ 45,000 $ 45,000
On common stock. . . . . . . . . . . . . . . . . . . . . . . . .50,000 50,000
Total . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 95,000 $ 95,000
Retained earnings, December 31 . . . . . . . . . . .$6,180,000 $5,375,000
Stargel Inc.
Comparative Income Statement
For the Years Ended December 31, 2014 and 2013
2014 2013
Sales (all on account) . . . . . . . . . . . . . . . . . . . $10,050,000 $9,450,000
Sales returns and allowances . . . . . . . . . . . . . . .50,000 50,000
Net sales. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $10,000,000 $9,400,000
Cost of goods sold. . . . . . . . . . . . . . . . . . . . . . 5,350,000 4,950,000
Gross profit . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 4,650,000 $4,450,000
Selling expenses . . . . . . . . . . . . . . . . . . . . . . .$ 2,000,000 $1,880,000
Administrative expenses . . . . . . . . . . . . . . . . . 1,500,000 1,410,000
Total operating expenses . . . . . . . . . . . . . . . . $ 3,500,000 $3,290,000
Income from operations . . . . . . . . . . . . . . . . . $ 1,150,000 $1,160,000
Other income . . . . . . . . . . . . . . . . . . . . . . . . . . .150,000 140,000
$ 1,300,000 $1,300,000
Other expense (interest) . . . . . . . . . . . . . . . . . . 170,000 150,000
Income before income tax . . . . . . . . . . . . . . . $ 1,130,000 $1,150,000
Income tax expense . . . . . . . . . . . . . . . . . . . . . .230,000 225,000
Net income . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 900,000 $ 925,000
Stargel Inc.
Comparative Balance Sheet
December 31, 20Y2 and 20Y1.
20Y2 20Y1
Assets
Current assets:
Cash $500,000 $400,000
Marketable securities 1,010,000 1,000,000
Accounts receivable (net) 740,000 510,000
Inventories 1,190,000 950,000
Prepaid expenses 250,000 229,000
Total current assets $3,690,000 $3,089,000
Long-term investments 2,350,000 2,300,000
Property, plant, and equipment (net) 3,740,000 3,366,000
Total assets $9,780,000 $8,755,000
Liabilities
Current liabilities $900,000 $880,000
Long-term liabilities:
Mortgage note payable, 10% $200,000 $0
Bonds payable, 10% 1,500,000 1,500,000
Total long-term liabilities $1,700,000 $1,500,000
Total liabilities $2,600,000 $2,380,000
Required:
Determine the following measures for 20Y2, rounding to one decimal place, except dollar amounts which should be rounded to the nearest cent. Assume 365 days a year.
Return on total assets %
Return on stockholders’ equity %
Return on common stockholders’ equity %


Sagot :

Answer 1.

Working Capital = Current Assets - Current Liabilities
Working Capital = $36,90,000 - $900000
Working Capital = $27,90,000

Answer 2.

Current Ratio = Current Assets / Current Liabilities
Current Ratio = $36,90,000 / $900000
Current Ratio = 4.1

7) Number days' sales in inventory = (Inventory/Cost of goods sold) * 365 days

=(11,90,000 / 53,50,000) * 365 days = 81.18 days approx

8) Ratio of fixed assets to long-term liabilities = Fixed Assets/Long Term Liabilities

=(2350000+3740000) / 1700000= 3.58 times

9) Ratio of liabilities to stockholders' equity = Total Liabilities/stockholders' equity

=26,00,000 / 71,80,000

=0.36211 times

10) Number of times interest charges are earned = Earnings Before Interest & Tax / Interest Expense

= 1300000 / 170000 = 7.64 times

11) Number of times preferred dividends are earned = Dividend on preferred stock/preferred stock

= 45000 / 500000

=0.09 times

12) Ratio of sales to assets = Net Sales (Total Sales-Sales Return)/Total Assets

= 10,000,000 / 9780000

= 1.022 times

13 ) Rate earned on total assets = Net Income/Average Total Assets(Opening+closing Total Assets)/2

=900000 /(8755000+ 97,80,000)/2

=900000/ 9267500

=0.09711 times or 9.711 %

14) Rate earned on stockholders' equity = Net Income/Average Stockholders' Equity(opening+closing stockholders' Equity)/2

=900,000/(6375000+7180000)/2

=900000/6777500

=0.132 or 13.27 %

15) Rate earned on common stockholders' equity=

(Net Income - Dividend on Preferred stock)/Average Common Stock(opening + closing common stockholders' equity)

=(900000-45000)/(500000+500000)/2

=855000/500000

=1.71 times

16. Earnings per share on common stock = (Net Income - Dividend on Preferred stock)/Common Stock(in numbers)

=(900000-45000)/100000

=8.55 times

17) Price-earnings ratio = Market Price per share/ Earnings per share

=119.70(given)/8.55

=14 times

18) Dividends per share of common stock = Dividend to common stock/common stock (in number)

=50000 / 100000

=0.5 times

19) Dividend yield = Dividends per share of common stock/Market Price per share

=(0.5 /119.70) * 100

= 0.835%

if you have any doubt comment in the comment box