Question

In: Accounting

Question 5 The Cola Company reported the following comparative information at December 31, 2017, and December...

Question 5
The Cola Company reported the following comparative information at December 31, 2017, and December 31, 2016 (amounts in millions and adapted):
2017 2016
Current Assets $21,579 $17,552
Total Assets 72,921 48,671
Current Liabilities 18,508 13,721
Total Shareholder Equity 31,317 25,346
Net Sales 35,119 30,990
Net Income 11,809 6,824

Requirements
1. Calculate the following ratios for 2017 and 2016: a. Current ratio b. Debt ratio
2. At the end of 2017, The Cola Company issued $1,590 million of long-term debt that was used to retire short-term debt. What would the current ratio and debt ratio have been if this transaction had not been made

Solutions

Expert Solution

1)
Year Current Ratio
Current Assets / Current Liabilities = Current Ratio
2017 $ 21,579 / $ 18,508 = 1.17
2016 $ 17,552 / $ 13,721 = 1.28
Debt Ratio
Total Liabilities
(Total Assets (-) Equity )
/ Total Assets = Debt Ratio
2017 $ 41,604
( $ 72,921 (-) $ 31,317 )
/ $ 72,921 = 0.57
2016 $ 23,325
( $ 48,671 (-) $ 25,346 )
/ $ 48,671 = 0.48
2)
2017 :
Current Ratio    = Current Assets   / Current Liabilities
                               =   $ 21,579 / ( $ 18,508 + $ 1,590 )
                               =   $ 21,579 / $ 20,098
                               =    1.07
Current Ratio    = 1.07
Debt ratio    =   Total Liabilities / Total Assets
                         =   ( $ 72,921 (-) $ 31,317 + $ 1,590 (-) $ 1,590 ) / $ 72,921
                         =    $ 41,604 / $ 72,921
                         = 0.57
Debt Ratio    = 0.57

Related Solutions

Bramble Corp. reported the following information for 2017. Bramble Corp. Comparative Balance Sheets December 31 Assets...
Bramble Corp. reported the following information for 2017. Bramble Corp. Comparative Balance Sheets December 31 Assets 2017 2016 Change Increase/Decrease Cash $51,510 $36,090 $15,420 Increase Accounts receivable 61,380 21,880 39,500 Increase Inventory 44,120 –0– 44,120 Increase Prepaid expenses 5,950 3,970 1,980 Increase Land 55,190 69,510 14,320 Decrease Buildings 198,490 198,490 –0– Accumulated depreciation—buildings (20,790 ) (13,860 ) 6,930 Increase Equipment 182,860 68,310 114,550 Increase Accumulated depreciation—equipment (27,700 ) (10,080 ) 17,620 Increase Totals $551,010 $374,310 Liabilities and Stockholders’ Equity Accounts...
Bonita Industries reported the following information for 2017. Bonita Industries Comparative Balance Sheets December 31 Assets...
Bonita Industries reported the following information for 2017. Bonita Industries Comparative Balance Sheets December 31 Assets 2017 2016 Change Increase/Decrease Cash $65,990 $36,180 $29,810 Increase Accounts receivable 62,110 22,220 39,890 Increase Inventory 43,610 –0– 43,610 Increase Prepaid expenses 5,960 3,980 1,980 Increase Land 54,550 70,570 16,020 Decrease Buildings 198,140 198,140 –0– Accumulated depreciation—buildings (21,120 ) (14,080 ) 7,040 Increase Equipment 182,420 68,470 113,950 Increase Accumulated depreciation—equipment (28,360 ) (9,970 ) 18,390 Increase      Totals $563,300 $375,510 Liabilities and Stockholders’ Equity Accounts...
Question 5 The following are Coronado Corp.’s comparative balance sheet accounts at December 31, 2017 and...
Question 5 The following are Coronado Corp.’s comparative balance sheet accounts at December 31, 2017 and 2016, with a column showing the increase (decrease) from 2016 to 2017. Comparative Balance Sheet COMPARATIVE BALANCE SHEETS 2017 2016 Increase (Decrease) Cash $821,300 $698,500 $122,800 Accounts receivable 1,118,800 1,165,800 (47,000 ) Inventory 1,863,300 1,709,100 154,200 Property, plant, and equipment 3,292,300 2,950,900 341,400 Accumulated depreciation (1,153,700 ) (1,030,800 ) (122,900 ) Investment in Myers Co. 307,300 274,600 32,700 Loan receivable 248,800 — 248,800    Total...
Question 3 Level Up reported the following information for 2016 and 2017: Accounts payable, 31 December...
Question 3 Level Up reported the following information for 2016 and 2017: Accounts payable, 31 December 2016 $50 000       Accounts payable, 31 December 2017 $80 000     Inventory, 31 December 2016 $60 000   Inventory, 31 December 2017 $150 000     Cost of goods sold—2017 $1 000 000 Assume that all merchandise purchases are on account. How much cash was paid to suppliers for inventory purchases during 2017?                                $1 085 000                               $1 060 000                                $1 070 000                           $1 115 000 Question 4:...
Sunland Company reported the following information for 2019. Sunland Company Comparative Balance Sheets December 31 Assets...
Sunland Company reported the following information for 2019. Sunland Company Comparative Balance Sheets December 31 Assets 2019 2018 Change Increase/Decrease Cash $68,040 $36,250 $31,790 Increase Accounts receivable 61,900 21,810 40,090 Increase Inventory 44,110 –0– 44,110 Increase Prepaid expenses 6,030 4,010 2,020 Increase Land 54,890 69,300 14,410 Decrease Buildings 200,420 200,420 –0– Accumulated depreciation—buildings (20,805 ) (13,870 ) 6,935 Increase Equipment 181,270 67,510 113,760 Increase Accumulated depreciation—equipment (28,695 ) (10,030 ) 18,665 Increase Totals $567,160 $375,400 Liabilities and Stockholders’ Equity Accounts...
Alex Company reported the following information for 2020. Alex Company Comparative Balance Sheets December 31 Assets...
Alex Company reported the following information for 2020. Alex Company Comparative Balance Sheets December 31 Assets 2020 2019 Change Increase/Decrease Cash $59,000 $36,000 $23,000 Increase Accounts receivable 62,000 22,000 40,000 Increase Inventory 44,000 –0– 44,000 Increase Prepaid expenses 6,000 4,000 2,000 Increase Land 55,000 70,000 15,000 Decrease Buildings 200,000 200,000 –0– Accumulated depreciation—buildings (21,000) (14,000) 7,000 Increase Equipment 183,000 68,000 115,000 Increase Accumulated depreciation—equipment (28,000) (10,000) 18,000 Increase    Totals $560,000 $376,000 Liabilities and Stockholders’ Equity Accounts payable $43,000 $40,000 $3,000...
Diablo Company reported the following information for 2016 and 2017: Prepaid insurance, 31 December 2016 $15...
Diablo Company reported the following information for 2016 and 2017: Prepaid insurance, 31 December 2016 $15 000 Prepaid insurance, 31 December 2017 10 500 Insurance expense—2017 $31 000 How much cash was paid for insurance during 2017? $32 600 $26 500 $23 700 $36 700
At December 31, 2017, Grand Company reported the following as plant assets. Land                             
At December 31, 2017, Grand Company reported the following as plant assets. Land                                                                                                                                                      4,000,000 Building                                                                                                28,500,000 Less: Accumulated depreciation – buildings                          12,100,000                          16,400,000 Equipment                                                                                          48,000,000 Less: Accumulated depreciation – equipment                     5,000,000                           43,000,000                 Total plant assets                                                                                                             63,400,000 During 2018, the following selected cash transactions occurred. April 1   Purchased land for $2,130,000 May 1    Sold equipment that cost $75,000 when purchased on January 1, 2014. The equipment was sold                 for $450,000. June 1   Sold land purchased on June 1,...
A) On December 31, 2017, SPK Corp reported the following information on its balance sheet: Accounts...
A) On December 31, 2017, SPK Corp reported the following information on its balance sheet: Accounts Receivable                                                          $900,000                 Less: Allowance for Doubtful Accounts                 54,000 (credit) During 2018, the company had the following transactions:                 Sales on account                                                                 $3,000,000                 Collections of accounts receivables                      2,850,000                 Write-off of accounts deemed uncollectible                     60,000                 Recovery of Bad debts previously written off                 12,000                             (not included in collections above) If bad debts are estimated to be 1.5% of credit sales, determine the ending balance in the Allowance for Doubtful Accounts...
Holmes Company reported the following balance sheets at December 31, 2017 and 2018: ($ in millions)...
Holmes Company reported the following balance sheets at December 31, 2017 and 2018: ($ in millions) December 31, 2018 2017 Cash $ 45 $ 40 Accounts receivable 170 175 Inventory 250 230 Fixed assets 500 400 Accumulated depreciation (150 ) (120 ) Total assets $ 815 $ 725 Accounts payable $ 100 $ 80 Long-term debt 455 425 Common stock 50 50 Retained earnings 280 200 Treasury stock (70 ) (30 ) Total liabilities and stockholders' equity $ 815 $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT