In: Accounting
Measures of liquidity, solvency, and profitability
The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $82.60 on December 31, 20Y2.
| Marshall Inc. | ||
| Comparative Retained Earnings Statement | ||
| For the Years Ended December 31, 20Y2 and 20Y1 | ||
| 20Y2 | 20Y1 | |
| Retained earnings, January 1 | $3,704,000 | $3,264,000 |
| Net income | $ 600,000 | $ 550,000 |
| Dividends: | ||
| On preferred stock | (10,000) | (10,000) |
| On common stock | (100,000) | (100,000) |
| Increase in retained earnings | $ 490,000 | $ 440,000 |
| Retained earnings, December 31 | $4,194,000 | $3,704,000 |
| Marshall Inc. | ||
| Comparative Income Statement | ||
| For the Years Ended December 31, 20Y2 and 20Y1 | ||
| 20Y2 | 20Y1 | |
| Sales | $ 10,850,000 | $10,000,000 |
| Cost of goods sold | (6,000,000) | (5,450,000) |
| Gross profit | $ 4,850,000 | $ 4,550,000 |
| Selling expenses | $ (2,170,000) | $ (2,000,000) |
| Administrative expenses | (1,627,500) | (1,500,000) |
| Total operating expenses | $(3,797,500) | $ (3,500,000) |
| Operating income | $ 1,052,500 | $ 1,050,000 |
| Other revenue and expense: | ||
| Other revenue | 99,500 | 20,000 |
| Other expense (interest) | (132,000) | (120,000) |
| Income before income tax expense | $ 1,020,000 | $ 950,000 |
| Income tax expense | (420,000) | (400,000) |
| Net income | $ 600,000 | $ 550,000 |
| Marshall Inc. | ||
| Comparative Balance Sheet | ||
| December 31, 20Y2 and 20Y1 | ||
| 20Y2 | 20Y1 | |
| Assets | ||
| Current assets: | ||
| Cash | $1,050,000 | $ 950,000 |
| Marketable securities | 301,000 | 420,000 |
| Accounts receivable (net) | 585,000 | 500,000 |
| Inventories | 420,000 | 380,000 |
| Prepaid expenses | 108,000 | 20,000 |
| Total current assets | $ 2,464,000 | $2,270,000 |
| Long-term investments | 800,000 | 800,000 |
| Property, plant, and equipment (net) | 5,760,000 | 5,184,000 |
| Total assets | $ 9,024,000 | $8,254,000 |
| Liabilities | ||
| Current liabilities | $ 880,000 | $ 800,000 |
| Long-term liabilities: | ||
| Mortgage note payable, 6% | $ 200,000 | $ 0 |
| Bonds payable, 4% | 3,000,000 | 3,000,000 |
| Total long-term liabilities | $ 3,200,000 | $3,000,000 |
| Total liabilities | $ 4,080,000 | $3,800,000 |
| Stockholders’ Equity | ||
| Preferred 4% stock, $5 par | $ 250,000 | $ 250,000 |
| Common stock, $5 par | 500,000 | 500,000 |
| Retained earnings | 4,194,000 | 3,704,000 |
| Total stockholders’ equity | $ 4,944,000 | $4,454,000 |
| Total liabilities and stockholders’ equity | $ 9,024,000 | $8,254,000 |
Determine the following measures for 20Y2. Round to one decimal place, including percentages, except for per-share amounts, which should be rounded to the nearest cent.
| 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 | % |
Solution:
|
1) |
Working Capital |
20Y2 |
|
Total Current Assets (A) |
$2,464,000 |
|
|
Total Current Liabilities (B) |
$880,000 |
|
|
Working Capital (Total Current Assets - Total Current Liabilities) |
$1,584,000 |
|
|
2) |
Current Ratio |
|
|
Total Current Assets |
$2,464,000 |
|
|
Total Current Liabilities |
$880,000 |
|
|
Current Ratio (Current Assets / Current Liabilities) |
2.8 |
|
|
Times |
||
|
3) |
Quick Ratio |
|
|
Quick Assets |
||
|
Total Current Assets |
$2,464,000 |
|
|
Less: Inventory |
-$420,000 |
|
|
Less: Prepaid Expenses |
-$108,000 |
|
|
Quick Assets |
$1,936,000 |
|
|
Current Liabilities |
$880,000 |
|
|
Acid Test Ratio (Quick Assets / Current Liabilities) |
2.2 |
|
|
Times |
||
|
4) |
Accounts Receivable Turnover |
|
|
Net Credit Sales (A) |
$10,850,000 |
|
|
Avg Accounts Receivable ((585,000+500,000)/2) (B) |
$542,500 |
|
|
Accounts Receivable Turnover (A/B) |
20.0 |
|
|
Times |
Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you
Pls ask separate question for other parts problems