Question

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,010,000
Total assets $ 3,600,000
Current ratio 2.20
Acid-test ratio 1.20
Debt to equity ratio 1.5


Required:
Determine the following 2021 balance sheet items:
current assets

shareholders equity

long term assets

long term liabilites

Homework Answers

Answer #1

Current Assets = $2,222,000

Shareholders Equity = $1,440,000

Long Term Assets = $1,378,000

Long Term Liabilities = $1,150,000

Calculations :

Debt + Shareholders Equity = Total Assets

Debt to equity ratio = 1.5

So debt and equity are in the ratio 1.5 : 1

Total asset = $3,600,000

Total Debt = $3,600,000 * 1.5 /2.5 = $2,160,000

Share holders Equity = $3,600,000 * 1 /2.5 0= $1,440,000

Current ratio = Current Asset (C.A) / Current Liabilities (C.L) = 2.2

So, C.A = 2.2 * C.L (Equation 1 )

Acid Test ratio = Current Asset - Inventories / Current Liabilities = 1.2

C.A - $1,010,000 = 1.2 * C.L

So. C.A = 1.2 * C.L + $1,010,000 ( Equation 2)

From Equation 1 & Equation 2

2.2 * C.L = 1.2 * C.L + $1.010,000

2.2C.L - 1.2C.L = $1,010,000

1 C.L = $1,010,000

So Current Liabilities ( C.L) = $1,010,000

Current Assets (C.A) = 2.2 * C.L = 2.2 * $1,010,000 = $2,222,000

Long Term Assets = Total Assets - Current Assets = $3,600,000 - $2,222,000 = $1,378,000

Long Term Liabilities = Total Debt - Current Liabilities = $2,160,000 - $1,010,000 = $1,150,000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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 $ 890,000 Total assets $ 3,500,000 Current ratio 2.40 Acid-test ratio 1.40 Debt to equity ratio 1.5 Required: Determine the following 2021 balance sheet items: 1. Current Assets 2. Shareholder's Equity 3. Long-term assets 4. 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, 2021, balance sheet revealed the following: Inventories $ 750,000 Total assets $ 2,800,000 Current ratio 2.3 Acid-test ratio 1.05 What amount should be included in the noncurrent asset section of Excalibur Tire’s December 31, 2021, balance sheet?
The current asset section of Guardian Consultant’s balance sheet consists of cash, accounts receivable, and prepaid...
The current asset section of Guardian Consultant’s balance sheet consists of cash, accounts receivable, and prepaid expenses. The 2018 balance sheet reported the following: cash, $1,350,000; prepaid expenses, $410,000; noncurrent assets, $2,900,000; and shareholders’ equity, $3,000,000. The current ratio at the end of the year was 2.6 and the debt to equity ratio was 1.7. Required: Determine the following 2018 amounts and ratios: (Round your "The acid-test ratio" answer to 1 decimal place.)
The current asset section of Guardian Consultant’s balance sheet consists of cash, accounts receivable, and prepaid...
The current asset section of Guardian Consultant’s balance sheet consists of cash, accounts receivable, and prepaid expenses. The 2018 balance sheet reported the following: cash, $1,440,000; prepaid expenses, $500,000; noncurrent assets, $3,800,000; and shareholders’ equity, $3,900,000. The current ratio at the end of the year was 2.0 and the debt to equity ratio was 1.4. Required: Determine the following 2018 amounts and ratios: (Round your "The acid-test ratio" answer to 1 decimal place.)
Information from Gre Company's balance sheet follows Current Assets      Cash $2,100,000      Marketable Securities 7,200,000...
Information from Gre Company's balance sheet follows Current Assets      Cash $2,100,000      Marketable Securities 7,200,000      Accounts Receivable 50,500,000      Inventories 65,000,000      Prepaid expenses 1,000,000                Total current assets $125,800,000 Current Liabilities      Notes payable $1,400,000      Accounts payable 18,000,000      Accrued expenses 11,000,000      Income taxes payable 600,000      Current portion of long-term debt 3,000,000                Total current liabilities $34,000,000 What is the acid-test ratio for Greg Company? Select one: a. 1.60 b. 1.76 c. 2.20 d....
Current Position Analysis The following items are reported on a company's balance sheet: Cash $201,800 Marketable...
Current Position Analysis The following items are reported on a company's balance sheet: Cash $201,800 Marketable securities 157,700 Accounts receivable (net) 85,700 Inventory 185,500 Accounts payable 371,000 Determine (a) the current ratio and (b) the quick ratio. Round to one decimal place. a. Current ratio b. Quick ratio
Bronco Electronics' current assets consist of cash, marketable securities, accounts receivable, and inventories. The following data...
Bronco Electronics' current assets consist of cash, marketable securities, accounts receivable, and inventories. The following data were abstracted from a recent financial statement: Inventories $ 170,000 Total assets $ 1,850,000 Current ratio 4.2 Acid-test ratio 3.20 Debt to equity ratio 1.5 Required: Compute the long-term liabilities for Bronco:
You are analyzing a company and observe marketable securities worth $160,000 listed as current assets on...
You are analyzing a company and observe marketable securities worth $160,000 listed as current assets on the balance sheet. Which of the following statements is true? A: Marketable securities were purchased for $160,000. B: The securities are worth $160,000 as of the balance sheet date. C:Marketable Securities are not current assets, they are long-term assets. D: #1 and #2 could be correct depending on how the securities are classified.
QUESTION 1 Co. XYZ Balance Sheet Assets: Cash and marketable securities                              &nbs
QUESTION 1 Co. XYZ Balance Sheet Assets: Cash and marketable securities                                $300,000 Accounts receivable                                                 1,125,000 Inventories                                                               1,837,500 Prepaid expenses                                                          24,000 Total current assets                                                $3,286,500 Fixed assets                                                              2,700,000 Less: accumulated depreciation                               1,087,500 Net fixed assets                                                      $1,612,500 Total assets                                                             $4,899,000 Liabilities: Accounts payable                                                      $240,000 Notes payable                                                              825,000 Accrued taxes                                                                42,000 Total current liabilities                                           $1,107,000 Long-term debt                                                            975,000 Owner’s equity                                                         2,817,000 Total liabilities and owner’s equity                        $4,899,000 Co. XYZ Income Statement Net sales (all credit)                                                $6,375,000 Less: Cost of goods sold                                           4,312,500 Selling and administrative expense                           1,387,500 Depreciation expense                                                  135,000 Interest expense                                                          127,000 Earnings before taxes                                               $ 412,500 Income taxes                                                                225,000 Net income                                                                $ 188,000 Common stock...
Common-Size Balance Sheet 2016 Cash and marketable securities $ 490 1.5 % Accounts receivable 6,000 18.2...
Common-Size Balance Sheet 2016 Cash and marketable securities $ 490 1.5 % Accounts receivable 6,000 18.2 Inventory 9,490 28.8 Total current assets $ 15,980 48.4 % Net property, plant, and equipment 17,020 51.6 Total assets $ 33,000 100.0 % Accounts payable $ 7,210 21.8 % Short-term notes 6,790 20.6 Total current liabilities $ 14,000 42.4 % Long-term liabilities 6,970 21.1 Total liabilities $ 20,970 63.5 % Total common shareholders’ equity 12,030 36.5 Total liabilities and shareholders’ equity $ 33,000 100.0...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT