In: Accounting
The current asset section of the Excalibur Tire Company’s
balance sheet consists of cash, marketable securities, accounts
receivable, and inventory. The December 31, 2021, balance sheet
revealed the following:
Inventory | $ | 940,000 | |
Total assets | $ | 3,200,000 | |
Current ratio | 2.20 | ||
Acid-test ratio | 1.20 | ||
Debt to equity ratio | 1.5 | ||
Required:
Determine the following 2021 balance sheet items:
1.Current assets
2.Shareholders' equity
3.Long-term assets
4.Long-term liabilities
Current Assets | $ 2,072,530 | |
Shareholders Equity | $ 903,176 | |
Long-term assets | $ 1,127,470 | |
Long-term liabilities | $ 1,354,765 |
Required 1 | ||||
Current Ratio = | Current Assets | = 2.20 | ||
Current Liabilities | ||||
Current Assets | = 2.20 * Current Liabilities | |||
Acid-test ratio = | Quick Assets | = 1.20 | ||
Current Liabilities | ||||
Quick Assets | = 1.20 * Current Liabilities | |||
Therefore, | ||||
Current Assets | = 2.20 | |||
Quick Assets | 1.20 | |||
We know, Quick Assets = Current Assets - Inventory | ||||
Current Assets | = 1.83 | |||
Current Assets - Inventory | ||||
Current Assets | = 1.83 | |||
Current Assets - 940,000 | ||||
Current Assets | = 1.83 * (Current Assets - 940,000) | |||
Current Assets | = 1.83 Current Assets - 1,720,200 | |||
1.83 Current Assets - Current Assets = 1,720,200 | ||||
0.83 Current Assets = 1,720,200 | ||||
Current Assets | = 1,720,200/0.83 | |||
Current Assets | = $ 2,072,530 | |||
Required 2 | ||||
Current Liabilities = | Current Assets | |||
2.20 | ||||
Current Liabilities = | 2,072,530 | |||
2.20 | ||||
Current Liabilities = | $942,059 | |||
Debt + Equity = | Total assets - Current Liabilities | |||
= | 3,200,000 - 942,059 | |||
Debt + Equity = | 2,257,941 | |||
Debt = | 2,257,941 - Equity | |||
Debt Equity Ratio = | Debt | = 1.5 | ||
Equity | ||||
Debt | = 1.5 * Equity | |||
2,257,941 - Equity | = 1.5 Equity | |||
2,257,941 | = 2.5 Equity | |||
Equity = | 2,257,941/2.5 | |||
Equity = | 903,176 | |||
Required 3 | ||||
Total Assets | 3,200,000 | |||
Current Assets | 2,072,530 | |||
Long Term Assets (3,200,000 - 2,072,530) | 1,127,470 | |||
Required 4 | ||||
Long Term Liabilities = Debt = 2,257,941 - Equity | ||||
= 2,257,941 - 903,176 | ||||
= 1,354,765 |