Question

In: Accounting

Selected balance sheet and income statement information from CVS Health Corp. for 2014 through 2016 follows...

Selected balance sheet and income statement information from CVS Health Corp. for 2014 through 2016 follows ($ millions).

Total Current Assets Total Current Liabilities EBIT (Operating income) Interest Expense, Gross Total Liabilities Equity
2016 $31,042 $26,250 $10,338 $1,058 $57,628 $36,834
2015 29,158 23,169 9,454 838 55,234 37,203
2014 25,983 19,027 8,799 600 36,224 37,963

a. Compute times interest earned ratio for each year and discuss any trends for each. Round answers to one decimal place.

Year TIE Ratio
2016 Answer
2015 Answer
2014 Answer

Based on your computations above, select the most appropriate answer.

Times interest earned has steadily increased since 2014.

Times interest earned has steadily decreased since 2014.

Times interest earned has remained the same since 2014.

Times interest earned increased in 2015 but then decreased in 2016.


b. Compute the current ratio for each year and discuss any trend in liquidity. Round answers to one decimal place.

Year Current Ratio
2016 Answer
2015 Answer
2014 Answer

Do you believe the company is sufficiently liquid? Explain.

CVS’s current ratio has increased over the past three years and is greater than 1, indicating CVS is liquid.

CVS’s current ratio has decreased over the past three years and it is currently less than 1 indicating CVS is not liquid.

CVS’s current ratio has increased over the past three years, however, it remains less than 1 indicating CVS is not liquid.

CVS’s current ratio has decreased over the past three years, however, it is greater than 1 indicating CVS is liquid.

c. Compute the total liabilities-to-equity ratio for each year and discuss any trends for each.

Round answers to one decimal place.

Year Liabilities to Equity
2016 Answer
2015 Answer
2014 Answer

Based on your computations above, select the most appropriate answer.

CVS's liabilities to equity ratio has increased since 2014, however, the ratio is relatively low, concluding CVS is solvent.

CVS's liabilities to equity ratio has decreased since 2014, remaining relatively low, concluding CVS is solvent.

CVS's liabilities to equity ratio has increased since 2014, and is relatively high, concluding CVS is insolvent.

CVS's liabilities to equity ratio has decreased since 2014, remaining relatively low, concluding CVS is insolvent.

d. What is your overall assessment of the company’s credit risk from the analyses in (a), (b), and (c)?

CVS is a low credit risk as it has a low level of debt, is liquid and can easily meet its interest expenses.

CVS is a low credit risk as its liabilities to equity ratio, current ratio, and times interest earned ratio have all decreased since 2014.

CVS is a medium to high credit risk as its level of debt has increased and its current ratio and times interest ratio have decreased.

CVS is a medium to high credit risk as its liabilities to equity ratio, current ratio, and times interest earned ratio have all increased since 2014.

Solutions

Expert Solution

Answer 1

Particulars 2016 2015 2014
A EBIT $ 10,338 $   9,454 $   8,799
B Interest $   1,058 $      838 $      600
A/B Times interest earned ratio           9.8         11.3         14.7

Times interest earned has steadily decreased since 2014.

Answer 2

Particulars 2016 2015 2014
A Current assets $ 31,042 $ 29,158 $ 25,983
B Current liablites $ 26,250 $ 23,169 $ 19,027
A/B Current Ratio           1.2           1.3           1.4

CVS’s current ratio has decreased over the past three years, however, it is greater than 1 indicating CVS is liquid.

Answer 3

Particulars 2016 2015 2014
A Total liabilities $ 57,628 $ 55,234 $ 36,224
B Equity $ 36,834 $ 37,203 $ 37,963
A/B Total liabilities to Equity 1.6 1.5 1.0

CVS's liabilities to equity ratio has increased since 2014, however, the ratio is relatively low, concluding CVS is solvent.

Answer 4

Based on the above, it is appropriate to say that CVS is a medium to high credit risk as its level of debt has increased and its current ratio and times interest ratio have decreased.

In case of any doubt, please comment.


Related Solutions

Selected balance sheet and income statement information from Verizon Communications Inc. follows. $ millions 2016 2015...
Selected balance sheet and income statement information from Verizon Communications Inc. follows. $ millions 2016 2015 Current assets . . . . . . . . . . . . . . . . . . . . . . . . . $ 26,395 $ 22,355 Current liabilities. . . . . . . . . . . . . . . . . . . . . . . . 30,340 35,052 Total debt . . . ....
Selected are recent balance sheet and income statement information from Coach Inc. and Ann Taylor follows:...
Selected are recent balance sheet and income statement information from Coach Inc. and Ann Taylor follows: ($ millions) Ann Taylor Coach Inc Sales $2,212 $4,763 Cost of goods sold 1,004 1,297 Average accounts receivable 19 159 Average inventory 204 463 Average total assets 907 2,870 Required For each company, compute the following: Accounts receivable turnover Inventory turnover Asset turnover Interpret and comment on any differences you observe between the turnover rates for these two companies, i.e. for each ratio, which...
Below is selected balance sheet and income statement information from Fuller Enterprises. 2017 2016 Current assets...
Below is selected balance sheet and income statement information from Fuller Enterprises. 2017 2016 Current assets $ 26,148 $   29,879 Current liabilities 38,063 36,129 Total debt 123,896 125,545 Total Liabilities 206,493 209,242 Equity 76,434 72,613 Earnings before interest and taxes 27,777 27,476 Interest expense 3,180 3,384 Net cash flow from operating activities 18,812 18,620 Compute the current ratio for each year and discuss any trend in liquidity. Compute times interest earned, liabilities-to-equity, and cash from operations to total debt ratios...
The balance sheet and income statement for the McDonald's are as follows. McDonald's Corporation 2016 Income...
The balance sheet and income statement for the McDonald's are as follows. McDonald's Corporation 2016 Income Statement ($ Millions) Sales $11,508 Cost of goods sold   6,537 Gross profits $ 4,971 Marketing expenses and general     and administrative expenses $ 1,832 Depreciation expense    345 Total operating expenses $ 2,177 Operating profits $ 2,794 Interest expenses      387 Earnings before taxes $ 2,407 Income taxes      765 Net income before preferred stock dividends $ 1,642 Preferred stock dividends        25 Net income available to common...
Selected balance sheet and income statement information follows for Snap Inc. and Golden Eagle Inc. for...
Selected balance sheet and income statement information follows for Snap Inc. and Golden Eagle Inc. for the fiscal year ended January 30, 2020. For Fiscal Year Ended Jan. 30, 2020 ($ millions) Snap Golden Eagle Income statement information: Interest expense $236 $6 Income before interest and taxes 9,296 1,932 Balance sheet information: Cash and cash equivalents 7,946 1,534 Accounts receivable 1,692 478 Current assets 24,309 4,410 Current liabilities 15,971 2,691 Total assets 46,333 9,833 Total liabilities 30,554 3,422 Total stockholders’...
Apply DuPont Disaggregation of ROE Selected balance sheet and income statement information for Home Depot follows....
Apply DuPont Disaggregation of ROE Selected balance sheet and income statement information for Home Depot follows. $ millions Jan. 31, 2016 Feb. 01, 2015 Total assets $43,179 $40,576 Total liabilities 36,413 30,804 Sales 89,599 Net income 7,013 Round answers to two decimal places (ex: 0.12345 = 12.35%) a. Compute ROE and disaggregate the ratio into its DuPont components of ROA and financial leverage. ROE: Answer % ROA: Answer % Financial leverage: Answer b. Disaggregate ROA in to profitability and productivity...
Reorganization The Verbrugge Publishing Company's 2016 balance sheet and income statement are as follows (in millions...
Reorganization The Verbrugge Publishing Company's 2016 balance sheet and income statement are as follows (in millions of dollars). Balance Sheet Current assets $168 Current liabilities $42 Net fixed assets 153 Advance payments 78 Goodwill 15 Reserves 6 $6 preferred stock, $112.50 par value (1,200,000 shares) 135 $10.50 preferred stock, no par, callable at $150 (60,000 shares) 9 Common stock, $1.50 par value (6,000,000 shares) 9 Retained earnings 57 Total assets $336 Total claims $336 Income Net sales $540.0 Operating expense...
Reorganization The Verbrugge Publishing Company's 2016 balance sheet and income statement are as follows (in millions...
Reorganization The Verbrugge Publishing Company's 2016 balance sheet and income statement are as follows (in millions of dollars). Balance Sheet Current assets $168 Current liabilities $42 Net fixed assets 153 Advance payments 78 Goodwill 15 Reserves 6 $6 preferred stock, $112.50 par value (1,200,000 shares) 135 $10.50 preferred stock, no par, callable at $150 (60,000 shares) 9 Common stock, $1.50 par value (6,000,000 shares) 9 Retained earnings 57 Total assets $336 Total claims $336 Income Net sales $540.0 Operating expense...
Reorganization The Verbrugge Publishing Company's 2016 balance sheet and income statement are as follows (in millions...
Reorganization The Verbrugge Publishing Company's 2016 balance sheet and income statement are as follows (in millions of dollars). Balance Sheet Current assets $168 Current liabilities $42 Net fixed assets 153 Advance payments 78 Goodwill 15 Reserves 6 $6 preferred stock, $112.50 par value (1,200,000 shares) 135 $10.50 preferred stock, no par, callable at $150 (60,000 shares) 9 Common stock, $1.50 par value (6,000,000 shares) 9 Retained earnings 57 Total assets $336 Total claims $336 Income Net sales $540.0 Operating expense...
Reorganization The Verbrugge Publishing Company's 2016 balance sheet and income statement are as follows (in millions...
Reorganization The Verbrugge Publishing Company's 2016 balance sheet and income statement are as follows (in millions of dollars). Balance Sheet Current assets $168 Current liabilities $42 Net fixed assets 153 Advance payments 78 Goodwill 15 Reserves 6 $6 preferred stock, $112.50 par value (1,200,000 shares) 135 $10.50 preferred stock, no par, callable at $150 (60,000 shares) 9 Common stock, $1.50 par value (6,000,000 shares) 9 Retained earnings 57 Total assets $336 Total claims $336 Income Net sales $540.0 Operating expense...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT