Question

In: Accounting

Solvency Analysis The following information is available from the balance sheets at the ends of the...

Solvency Analysis

The following information is available from the balance sheets at the ends of the two most recent years and the income statement for the most recent year of Impact Company:

December 31
2017 2016
Accounts payable    $ 65,000    $ 50,000
Accrued liabilities    25,000    35,000
Taxes payable    60,000    45,000
Short-term notes payable    0    75,000
Bonds payable due within next year    200,000    200,000
Total current liabilities    $ 350,000    $ 405,000
Bonds payable    $ 600,000    $ 800,000
Common stock, $10 par    $1,000,000    $1,000,000
Retained earnings    650,000    500,000
Total stockholders’ equity    $1,650,000    $1,500,000
  Total liabilities and stockholders’ equity    $2,600,000    $2,705,000
2017
Sales revenue    $1,600,000
Cost of goods sold    950,000
Gross profit    $ 650,000
Selling and administrative expense    300,000
Operating income    $ 350,000
Interest expense    89,000
Income before tax    $ 261,000
Income tax expense    111,000
Net income    $ 150,000

Other Information:

  1. Short-term notes payable represents a 12-month loan that matured in November 2017. Interest of 12% was paid at maturity.
  2. One million dollars of serial bonds had been issued ten years earlier. The first series of $200,000 matured at the end of 2017, with interest of 8% payable annually.
  3. Cash flow from operations was $185,000 in 2017. The amounts of interest and taxes paid during 2017 were $89,000 and $96,000, respectively.

Required:

1. Compute the following for Impact Company. Round your answers to two decimal places.

2017 2016
a. The debt-to-equity ratio at December 31, 2017, and December 31, 2016 fill in the blank 1 to 1 fill in the blank 2 to 1
b. The times interest earned ratio for 2017 fill in the blank 3 to 1
c. The debt service coverage ratio for 2017 fill in the blank 4 times

2. The company's debt-to equity ratio has (increased/decreased). The ratio is (low/high) with respect to the equity of the company. The times interest earned ratio indicates that Impact's profits before interest and taxes were almost (twice/thrice/four times) the amount of (cash/assets/net income/interest payments). It is not wise to use the times interest earned ratio as the only indicator of solvency because it considers only the payment of (interest/principal) and not the payment of (interest/principal). In addition, these payments must be made with (cash/profits) not (cash/profits). The (accounts receivable turnover ratio/asset turnover ratio/profit margin/debt service coverage ratio) is a much better indication of the company's ability to meet its obligations because it looks at the (profits/cash from operations/assets).
Choose the correct answer.

Solutions

Expert Solution

Answer:

1.   a.   Debt-to-equity ratio: Total liabilities/Total stockholders’ equity

            At 12/31/17:    ($350,000 + $600,000)/$1,650,000

                                    = $950,000/$1,650,000 = 0.58 to 1

            At 12/31/17:    ($405,000 + $800,000)/$1,500,000

                                    = $1,205,000/$1,500,000 = 0.80 to 1

      b.   Times interest earned for 2017 (Net income + Interest expense + Income tax
expense)/Interest expense:

                  ($150,000 + $89,000 + $111,000)/$89,000 = $350,000/$89,000

                  = 3.93 to 1

      c.   Debt service coverage for 2017 (Cash flows from operations before interest and tax payments)/Interest and principal payments:

                  ($185,000 + $89,000 + $96,000*)/($89,000 + $275,000**)

                  = $370,000/$364,000 = 1.02 times

             *Taxes payable, 12/31/17 $    45,000

               Add: Tax expense                                       111,000

               Less: Taxes payable 12/31/17        (60,000)

               Taxes paid during 2017 $    96,000

            **Principal payments:

                  a.   Short-term notes payable               $    75,000

                  b.   Serial bonds                                        200,000

                        Total                                                 $275,000

2.         The company’s debt-to-equity ratio has decreased because of the repayment of the short-term notes and the installment payment on the serial bonds. The ratio at the end of 2017 of almost 0.6 to 1 indicates a relatively conservative balance of debt to stockholders’ equity. The times interest earned ratio indicates that Impact’s profits before interest and taxes were almost four times the amount of interest expense.

     

      Two problems arise, however, in using the times interest earned ratio as the sole measure of solvency. First, it considers the payment of only interest, not principal. Second, principal and interest payments must be made with cash, not profits. The debt service coverage ratio is a much better indication of the company’s ability to meet its obligations. A ratio of 1.02 times indicates that Impact generated just enough cash from operations to meet its principal and interest payments in 2017.


Related Solutions

olvency Analysis The following information is available from the balance sheets at the ends of the...
olvency Analysis The following information is available from the balance sheets at the ends of the two most recent years and the income statement for the most recent year of Impact Company: December 31 2017 2016 Accounts payable    $ 65,000    $ 50,000 Accrued liabilities    25,000    35,000 Taxes payable    60,000    45,000 Short-term notes payable    0    75,000 Bonds payable due within next year    200,000    200,000 Total current liabilities    $ 350,000   ...
The following financial statements and information are available for Blythe Industries Inc. Balance Sheets As of...
The following financial statements and information are available for Blythe Industries Inc. Balance Sheets As of December 31 Year 3 Year 2 Assets Cash $ 160,200 $ 120,600 Accounts receivable 103,200 85,000 Inventory 186,400 171,800 Marketable securities (available for sale) 284,000 220,000 Equipment 650,000 490,000 Accumulated depreciation (310,000) (240,000) Land 80,000 120,000 Total assets 1,153,800 967,400 Liabilities and equity Liabilities Accounts payable (inventory) $ 36,400 $ 66,200 Notes payable—Long-term 230,000 250,000 Bonds payable 200,000 100,000 Total liabilities 466,400 416,200 Stockholders’...
Analysis and Interpretation of Liquidity and Solvency Balance sheets and income statements for Costco Wholesale Corporation...
Analysis and Interpretation of Liquidity and Solvency Balance sheets and income statements for Costco Wholesale Corporation follow. Costco Wholesale Corporation Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) August 28, 2016 August 30, 2015 August 31, 2014 Revenue Net Sales $116,073 $113,666 $110,212 Membership fees 2,646 2,533 2,428 Total revenue 118,719 116,199 112,640 Operating expenses Merchandise costs 102,901 101,065 98,458 Selling, general and administrative 12,068 11,445 10,899 Preopening expenses 78 65 63 Operating Income 3,672 3,624 3,220 Other...
The following information is available for the Perez Company: Comparative Balance Sheets 2017 2018 Cash $800...
The following information is available for the Perez Company: Comparative Balance Sheets 2017 2018 Cash $800 $1,200 Accounts receivable 440 400 Inventory 740 1,220 Land 500 820 Equipment 4,140 4,400 Less:Accumulated depreciation (620) (800) Total Assets $6,000 $7,240 Accounts payable $1,600 $1,000 Notes payable (long-term) 1,800 1,440 Common stock, no par 1,200 2,000 Retained earnings 1,400 2,800 Total Liabilities and Stockholders' Equity $6,000 $7,240 Partial additional information:The net income for 2018 totaled $3,200. During 2018, the company sold for $780,...
Ivanhoe Company had the following information available at the end of 2020. IVANHOECOMPANY COMPARATIVE BALANCE SHEETS...
Ivanhoe Company had the following information available at the end of 2020. IVANHOECOMPANY COMPARATIVE BALANCE SHEETS AS OF DECEMBER 31, 2020 AND 2019 2020 2019 Cash $10,010 $3,990 Accounts receivable 20,570 12,850 Short-term investments 21,930 30,060 Inventory 41,700 35,280 Prepaid rent 3,000 12,030 Prepaid insurance 2,080 90 Supplies 1,010 75 Land 124,150 175,280 Buildings 349,500 349,500 Accumulated depreciation—buildings (105,270 ) (88,250 ) Equipment 522,870 401,710 Accumulated depreciation—equipment (130,840 ) (111,260 ) Patents 44,830 49,560    Total assets $905,540 $870,915 Accounts payable...
Sandhill Company had the following information available at the end of 2020. SANDHILLCOMPANY COMPARATIVE BALANCE SHEETS...
Sandhill Company had the following information available at the end of 2020. SANDHILLCOMPANY COMPARATIVE BALANCE SHEETS AS OF DECEMBER 31, 2020 AND 2019 2020 2019 Cash $10,100 $4,020 Accounts receivable 20,580 12,830 Short-term investments 22,020 29,750 Inventory 42,390 34,710 Prepaid rent 3,020 12,030 Prepaid insurance 2,100 89 Supplies 1,000 74 Land 125,640 176,140 Buildings 347,130 347,130 Accumulated depreciation—buildings (104,250 ) (87,940 ) Equipment 530,080 398,810 Accumulated depreciation—equipment (130,600 ) (111,650 ) Patents 44,570 49,920    Total assets $913,780 $865,913 Accounts payable...
Sage Company had the following information available at the end of 2017. SAGECOMPANY COMPARATIVE BALANCE SHEETS...
Sage Company had the following information available at the end of 2017. SAGECOMPANY COMPARATIVE BALANCE SHEETS AS OF DECEMBER 31, 2017 AND 2016 2017 2016 Cash $9,950 $3,990 Accounts receivable 20,680 12,890 Short-term investments 22,180 29,970 Inventory 42,300 35,140 Prepaid rent 3,000 11,880 Prepaid insurance 2,080 91 Supplies 1,010 74 Land 124,180 176,410 Buildings 350,770 350,770 Accumulated depreciation—buildings (104,490 ) (86,770 ) Equipment 519,790 398,650 Accumulated depreciation—equipment (129,460 ) (112,570 ) Patents 44,710 49,580    Total assets $906,700 $870,105 Accounts payable...
The following information was drawn from the 2017 balance sheets of the Cedar and Maple companies:...
The following information was drawn from the 2017 balance sheets of the Cedar and Maple companies: Cedar Maple   Current assets $ 48,000 $ 77,000   Current liabilities 43,200 15,400 Required a. Compute the current ratio for each company. (Round your answers to 2 decimal places.) b. Which company has the greater likelihood of being able to pay its bills? c. Assume that both companies have the same amount of total assets. Speculate as to which company would produce the higher return...
The following data is supplied from the comparative balance sheets and income statement information from Westerman,...
The following data is supplied from the comparative balance sheets and income statement information from Westerman, Inc. 2020 2019 Cash              88,000              64,000 Accounts Receivable              48,000              32,000 Inventory              56,000              64,000 Prepaid Insurance              32,000              40,000 Property, plant & equipment              88,000              64,000 Accumulated Depreciation            (24,000)              (16,000) Total            288,000            248,000 Accounts Payable              80,000              64,000 Salaries Payable              56,000              64,000 Long-term notes payable              40,000              48,000 Common...
The following information was drawn from the year-end balance sheets of Fox River, Inc.: Account Title...
The following information was drawn from the year-end balance sheets of Fox River, Inc.: Account Title Year 2 Year 1 Bonds payable $ 685,000 $ 1,035,000 Common stock 213,000 140,000 Treasury stock 31,500 12,000 Retained earnings 86,300 68,400 Additional information regarding transactions occurring during Year 2: Fox River, Inc. issued $49,000 of bonds during Year 2. The bonds were issued at face value. All bonds retired were retired at face value. Common stock did not have a par value. Fox...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT