Question

In: Accounting

The current asset section of the Excalibur Tire Company’s balance sheet consists of cash, marketable securities,...

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

Solutions

Expert Solution

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

Related Solutions

The current asset section of the Excalibur Tire Company’s balance sheet consists of cash, marketable securities,...
The current asset section of the Excalibur Tire Company’s balance sheet consists of cash, marketable securities, accounts receivable, and inventories. The December 31, 2018, balance sheet revealed the following: Inventories $ 990,000 Total assets $ 3,500,000 Current ratio 2.10 Acid-test ratio 1.20 Debt to equity ratio 1.8 Required: Determine the following 2018 balance sheet items: current assets and long term assets
The current asset section of the Excalibur Tire Company’s balance sheet consists of cash, marketable securities,...
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 $ 910,000 Total assets $ 3,000,000 Current ratio 2.60 Acid-test ratio 1.30 Debt to equity ratio 1.5 Required: Determine the following 2021 balance sheet items: current assets: shareholders' equity: long-term assets: long-term liabilities: please show work for better understanding
The current asset section of the Excalibur Tire Company’s balance sheet consists of cash, marketable securities,...
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 $ 1,000,000 Total assets $ 4,000,000 Current ratio 2.20 Acid-test ratio 1.40 Debt to equity ratio 1.5 Determine the following 2021 balance sheet items: a. Current Assets? b. Shareholder's Equity? c. Long-term assets? d. Long-term liabilities?
The current asset section of the Excalibur Tire Company's balance sheet consists of cash, marketable securities
The current asset section of the Excalibur Tire Company's balance sheet consists of cash, marketable securities, accounts receivable and inventories. The December 31, 2018, balance sheet revealed the following: 
SNIDER CORPORATION Balance Sheet December 31, 20X1 Assets Current assets: Cash $ 57,100 Marketable securities 26,100...
SNIDER CORPORATION Balance Sheet December 31, 20X1 Assets Current assets: Cash $ 57,100 Marketable securities 26,100 Accounts receivable (net) 184,000 Inventory 242,000 Total current assets $ 509,200 Investments 64,500 Plant and equipment $689,000 Less: Accumulated depreciation 256,000 Net plant and equipment 433,000 Total assets $ 1,006,700 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 92,700 Notes payable 76,500 Accrued taxes 17,000 Total current liabilities $ 186,200 Long-term liabilities: Bonds payable 151,000 Total liabilities $ 337,200 Stockholders' equity Preferred stock,...
The following items are reported on a company's balance sheet: Cash $292,600 Marketable securities 93,000 Accounts...
The following items are reported on a company's balance sheet: Cash $292,600 Marketable securities 93,000 Accounts receivable 251,700 Inventory 178,500 Accounts payable 318,800 Determine the (a) current ratio, and (b) quick ratio. Round your answers to one decimal place. a. Current ratio b. Quick ratio
The following items are reported on a company's balance sheet: Cash $247,900 Marketable securities 88,000 Accounts...
The following items are reported on a company's balance sheet: Cash $247,900 Marketable securities 88,000 Accounts receivable 261,900 Inventory 192,700 Accounts payable 278,100 Round your answers to two decimal places. a. Determine the current ratio.       b. Determine the quick ratio.      
The most recent balance sheet is as follow: Cash 1,000,000 Accounts payable 700,000 Marketable securities 800,000...
The most recent balance sheet is as follow: Cash 1,000,000 Accounts payable 700,000 Marketable securities 800,000 Notes Payable 2,000,000 Accounts receivable 1,200,000 Accruals 1,300,000 Inventory 2,000,000 Current liabilities 4,000,000 Current Assets 5,000,000 Long-term debt 5,400,000 Common stock 4,600,000 Fixed assets 15,000,000 Retained earnings 6,000,000 Total assets 20,000,000 Total liabilities and equity 20,000,000 The firm estimates sales will increase from $40 million to $50 million. The firm's profit margin is 5 percent, and its dividend payout ratio is 40 percent. The...
On October 31, the stockholders’ equity section of Pharoah Company’s balance sheet consists of common stock...
On October 31, the stockholders’ equity section of Pharoah Company’s balance sheet consists of common stock $ 680,000 and retained earnings $395,000. Pharoah is considering the following two courses of action: (1) Declaring a  5% stock dividend on the  85,000 $ 8 par value shares outstanding (2) Effecting a 2-for-1 stock split that will reduce par value to $ 4 per share. The current market price is $ 13 per share. Prepare a tabular summary of the effects of the alternative actions...
4) Common-Size Balance Sheet 2016 Cash and marketable securities $ 550 1.7 % Accounts receivable 5,990...
4) Common-Size Balance Sheet 2016 Cash and marketable securities $ 550 1.7 % Accounts receivable 5,990 18.1 Inventory 9,530 28.8 Total current assets $ 16,070 48.6 % Net property, plant, and equipment 16,980 51.4 Total assets $ 33,050 100.0 % Accounts payable $ 7,210 21.8 % Short-term notes 6,790 20.5 Total current liabilities $ 14,000 42.4 % Long-term liabilities 6,950 21.0 Total liabilities $ 20,950 63.4 % Total common shareholders’ equity 12,100 36.6 Total liabilities and shareholders’ equity $ 33,050...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT