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: 
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...
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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT