In: Accounting
The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $82.40 on December 31, 20Y2.
|
Marshall Inc. |
|
Comparative Retained Earnings Statement |
|
For the Years Ended December 31, 20Y2 and 20Y1 |
|
1 |
20Y2 |
20Y1 |
|
|
2 |
Retained earnings, January 1 |
$3,712,000.00 |
$3,262,000.00 |
|
3 |
Net income |
631,000.00 |
560,000.00 |
|
4 |
Total |
$4,343,000.00 |
$3,822,000.00 |
|
5 |
Dividends: |
||
|
6 |
On preferred stock |
$10,000.00 |
$10,000.00 |
|
7 |
On common stock |
100,000.00 |
100,000.00 |
|
8 |
Total dividends |
$110,000.00 |
$110,000.00 |
|
9 |
Retained earnings, December 31 |
$4,233,000.00 |
$3,712,000.00 |
|
Marshall Inc. |
|
Comparative Income Statement |
|
For the Years Ended December 31, 20Y2 and 20Y1 |
|
1 |
20Y2 |
20Y1 |
|
|
2 |
Sales |
$10,860,000.00 |
$10,000,000.00 |
|
3 |
Cost of goods sold |
6,000,000.00 |
5,440,000.00 |
|
4 |
Gross profit |
$4,860,000.00 |
$4,560,000.00 |
|
5 |
Selling expenses |
$2,160,000.00 |
$2,000,000.00 |
|
6 |
Administrative expenses |
1,627,500.00 |
1,500,000.00 |
|
7 |
Total operating expenses |
$3,787,500.00 |
$3,500,000.00 |
|
8 |
Income from operations |
$1,072,500.00 |
$1,060,000.00 |
|
9 |
Other income |
99,500.00 |
20,000.00 |
|
10 |
$1,172,000.00 |
$1,080,000.00 |
|
|
11 |
Other expense (interest) |
131,000.00 |
120,000.00 |
|
12 |
Income before income tax |
$1,041,000.00 |
$960,000.00 |
|
13 |
Income tax expense |
410,000.00 |
400,000.00 |
|
14 |
Net income |
$631,000.00 |
$560,000.00 |
|
Marshall Inc. |
|
Comparative Balance Sheet |
|
December 31, 20Y2 and 20Y1 |
|
1 |
20Y2 |
20Y1 |
|
|
2 |
Assets |
||
|
3 |
Current assets: |
||
|
4 |
Cash |
$1,050,000.00 |
$950,000.00 |
|
5 |
Marketable securities |
301,000.00 |
420,000.00 |
|
6 |
Accounts receivable (net) |
586,000.00 |
500,000.00 |
|
7 |
Inventories |
410,000.00 |
380,000.00 |
|
8 |
Prepaid expenses |
107,000.00 |
20,000.00 |
|
9 |
Total current assets |
$2,454,000.00 |
$2,270,000.00 |
|
10 |
Long-term investments |
800,000.00 |
800,000.00 |
|
11 |
Property, plant, and equipment (net) |
5,750,000.00 |
5,184,000.00 |
|
12 |
Total assets |
$9,004,000.00 |
$8,254,000.00 |
|
13 |
Liabilities |
||
|
14 |
Current liabilities |
$821,000.00 |
$792,000.00 |
|
15 |
Long-term liabilities: |
||
|
16 |
Mortgage note payable, 6%, |
$200,000.00 |
$0.00 |
|
17 |
Bonds payable, 4%, |
3,000,000.00 |
3,000,000.00 |
|
18 |
Total long-term liabilities |
$3,200,000.00 |
$3,000,000.00 |
|
19 |
Total liabilities |
$4,021,000.00 |
$3,792,000.00 |
|
20 |
Stockholders’ Equity |
||
|
21 |
Preferred 4% stock, $5 par |
$250,000.00 |
$250,000.00 |
|
22 |
Common stock, $5 par |
500,000.00 |
500,000.00 |
|
23 |
Retained earnings |
4,233,000.00 |
3,712,000.00 |
|
24 |
Total stockholders’ equity |
$4,983,000.00 |
$4,462,000.00 |
|
25 |
Total liabilities and stockholders’ equity |
$9,004,000.00 |
$8,254,000.00 |
Determine the following measures for 20Y2 (round to one decimal place, including percentages, except for per-share amounts): Assume a 365-day year.
Answer 1-18
| 1. |
working capital |
| 2. | Current ratio |
| 3. | Quick ratio |
| 4. | Accounts receivable turnover |
| 5. | Number of days’ sales in receivables. |
| 6. | Inventory turnover |
| 7. | Number of days’ sales in inventory |
| 8. | Ratio of fixed assets to long-term liabilities |
| 9. | Ratio of liabilities to stockholders’ equity |
| 10. | Times interest earned |
| 11. | Asset turnover |
| 12. | Return on total assets |
| 13. | Return on stockholders’ equity |
| 14. | Return on common stockholders’ equity. |
| 15. | Earnings per share on common stock |
| 16. | Price-earnings ratio |
| 17. | Dividends per share of common stock |
| 18. | Dividend yield |
| 1.working capital | Current assets-current liabilities | 2454000-821000 | 1633000 | |||||||||
| 2.Current ratio | Current assets/current liabilities | 2454000/821000 | 2.99 | |||||||||
| 3.Quick ratio | (total current assets-inventory)/Total current liabilities | (2454000-410000)/821000 | 2.49 | |||||||||
| 4.Accounts receivable turnover | Net credit sales/average trade receivables | 10860000*2/(586000+500000) | 20 | |||||||||
| 5.Number of days’ sales in receivables. | Accounts receivable* no of days/Credut sales | 586000*365/10860000 | 19.70 | |||||||||
| 6.Inventory turnover | Cost of goods sold/Average Inventory | 6000000*2/(410000+380000) | 15.19 | |||||||||
| 7.Number of days’ sales in inventory | Inventory*365/Cost of sales | 410000*365/6000000 | 24.94 | |||||||||
| 8.Ratio of fixed assets to long-term liabilities | Fixed assets/long term liabilities | (5750000+800000)/3200000 | 2.05 | |||||||||
| 9.Ratio of liabilities to stockholders’ equity | Liabilities/stockholders equity | 9004000/4983000 | 1.81 | |||||||||
| 10.Times interest earned | EBIT/Interest expense | 1172000/131000 | 8.95 | |||||||||
| 11.Asset turnover | Cost of sales/Assets | 6000000/9004000 | 0.67 | |||||||||
| 12.Return on total assets | Net income/total assets | 631000/9004000 | 0.07 | |||||||||
| 13.Return on stockholders’ equity | Net Income/Total shareholders equity | 631000/4983000 | 0.13 | |||||||||
| 14.Return on common stockholders’ equity. | Net Income/Total common shareholders equity | 631000/500000 | 1.26 | |||||||||
| 15.Earnings per share on common stock | Net profit available for common stock/No of Equity shares | (4343000-10000)/(500000/5) | 43.33 | |||||||||
| 16.Price-earnings ratio | Share price/Earnings per share | 82.4/43.33 | 1.90 | |||||||||
| 17.Dividends per share of common stock | Dividend amount/No of equity shares | 100000/(500000/5) | 1 | |||||||||
| 18.Dividend yield | Annual dividend/Current stock price | 1/82.4 | 0.01 | |||||||||