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 $ 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?

Solutions

Expert Solution

Working :

Current asset ratio = Current asset /current liabilities

2.20 =CA/CL

CA =2.20 CL                   [Equation 1 ]

Now,

Acid-test ratio = [Current asset -inventory ]/current liabilities

     1.40 = [CA - 1,000,000]/CL

     1.40 CL = [CA-1,000,000]

putting the value of CA from equation 1

    1.40 CL = [2.20CL -1,000,000]

    2.20 CL -1.40CL = 1000000

       .80 CL = 1,000,000

         CL = 1,000,000/.80

             = 1,250,000

a)Current asset = 2.20* 1,250,000

               = $ 2,750,000

b)Debt to equity ratio = Total debt /total equity

      1.5 =TD /TE

      TD = 1.5 TE

Nowusing accounting equation

Total asset =Total debt +total equity

4,000,000 = 1.5 TE +TE

4,000,000 = 2.5 TE

TE = 4,000,000 /2.5

        = 1,600,000

Total equity = $ 1,600,000

Shareholder's Equity = 1,600,000

c)Long term assets = Total asset - current asset

            = 4,000,000 - 2,750,000

           = 1,250,000

d)Total asset =Total debt +total equity

      4,000,000 = Ttal debt + 1,600,000

      Toal debt = 4000000-1600000

               = 2400000

Long term liabilities = Total debt -current liabilities

                    = 2400000- 1,250,000

                    = $ 1150000


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 inventories. The December 31, 2018, balance sheet revealed the following: 
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...
Temporary excess cash can be invested in marketable securities. What are the characteristics of marketable securities?...
Temporary excess cash can be invested in marketable securities. What are the characteristics of marketable securities? If excess cash is projected to be continuing rather than temporary, are marketable securities the appropriate investment? Explain your answer.
ABC CORP BALANCE SHEET December 31, 2010 Cash $ 100 Marketable Securities 0 Accounts Receivables 2,000...
ABC CORP BALANCE SHEET December 31, 2010 Cash $ 100 Marketable Securities 0 Accounts Receivables 2,000 Inventory 140 Fixed Assets ( net ) 2,000 Total Assets ===== Accounts Payable $ 2,380 Notes Payable 0 Retained earnings ? Common Stock 1,400 Total of Both Liabilities & Equity ===== For the year ended 12/31/10 ABC CORP generated Sales of $12,000 and Net Income of $120. The net profit margin this year is considered normal by ABC CORP. Cost of Goods Sold was...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT