Question

In: Accounting

Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from...

Compute and Interpret Coverage, Liquidity and Solvency Ratios

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 $33,930 $26,250 $10,504 $1,058 $57,628 $39,722
2015 32,046 23,169 9,620 838 55,234 40,091
2014 28,871 19,027 8,965 600 36,224 40,851

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

times interest earned ratio EBIT / interest expenses
2014 ($) 2015 ($) 2016 ($)
EBIT 8965 9620 10504
interest expenses 600 838 1058
times interest earned ratio 14.9 11.5 9.9
ratio has steadily decreased since 2014
current ratio current assets / current liabilities
2014 ($) 2015 ($) 2016 ($)
current assets 28871 32046 33930
current liailities 19027 23169 26250
current ratio 1.5 1.4 1.3
ratio has decreased over the past three years, but is greater than 1 indicating CVS is liquid
total liabilities-to-equity ratio total liabilities / total equity
2014 ($) 2015 ($) 2016 ($)
total liabilities 36224 55234 57628
total equity 40851 40091 39722
total liabilities-to-equity ratio 0.9 1.4 1.5
ratio has increased since 2014, the ratio is relatively low, concluding CVS is solvent

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.


Related Solutions

Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from...
Compute and Interpret Coverage, Liquidity and Solvency Ratios 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...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information from...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information from Verizon Communications follows. ($ millions) 2005 2004 Current assets $ 16,448 $ 19,479 Current liabilities 25,063 23,129 Total debt 39,010 39,267 Total liabilities 101,696 103,345 Equity 66,434 62,613 Earnings before interest and taxes 12,787 12,496 Interest expense 2,180 2,384 Net cash flow from operating activities $ 22,012 $ 21,820 (a) Compute the current ratio for each year and discuss any trend in liquidity. (Round...
Compute and Interpret Coverage, Liquidity and Solvency Ratios Selected balance sheet and income statement information from...
Compute and Interpret Coverage, Liquidity and Solvency Ratios 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 $33,930 $26,250 $10,504 $1,058 $57,628 $39,722 2015 32,046 23,169 9,620 838 55,234 40,091 2014 28,871 19,027 8,965 600 36,224 40,851 a. Compute times interest earned ratio for each year and discuss any trends for each. Round answers to...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for Calpine Corporation for 2004 and 2006 follows. ($ millions) 2004 2006 Cash $ 1,376.73 $ 1,503.36 Accounts receivable 1,097.16 735.30 Current assets 3,563.56 3,168.33 Current liabilities 3,285.39 6,057.95 Long-term debt 16,940.81 3,351.63 Short-term debt 1,033.96 4,568.83 Total liabilities 22,628.42 25,743.17 Interest expense 1,516.90 1,288.29 Capital expenditures 1,545.48 211.50 Equity 4,587.67 (7,152.90) Cash from operations 9.89 155.98 Earnings before interest and taxes 1,589.84 1,877.84 (a)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for Nordstrom, Inc. for 2016 and 2015 follows. ($ millions) 2016 2015 Cash $ 595 $ 827 Accounts receivable 196 2,306 Current assets 3,014 5,224 Current liabilities 2,911 2,800 Long-term debt 2,795 3,123 Short-term debt 10 8 Total liabilities 6,827 6,805 Interest expense 153 156 Capital expenditures 1,082 861 Equity 871 2,440 Cash from operations 2,451 1,220 Earnings before interest and taxes 1,101 1,323 (a)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for Nordstrom, Inc. for 2014 and 2013 follows. ($ millions) 2014 2013 Cash $ 1,194 $ 1,285 Accounts receivable 2,177 2,129 Current assets 5,228 5,081 Current liabilities 2,541 2,226 Long-term debt 3,113 3,131 Short-term debt 0 0 Total liabilities 6,494 6,176 Interest expense 161 160 Capital expenditures 803 513 Equity 2,080 1,913 Cash from operations 1,320 1,110 Earnings before interest and taxes 1,350 1,345 (a)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Information from the balance sheet, income statement, and...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Information from the balance sheet, income statement, and statement of cash flows for Nike follows. Refer to these financial statements to answer the requirements. NIKE, INC. Consolidated Statements of Income Year Ended December 31 (In millions) 2019 2018 Revenues $39,117 $36,397 Cost of sales 21,643 20,441 Gross profit 17,474 15,956 Demand creation expense 3,753 3,577 Operating overhead expense 8,949 7,934 Total selling and administrative expense 12,702 11,511 Interest expense (income), net 49...
Compute and Interpret Liquidity and Solvency Ratios Selected balance sheet and income statement information from Verizon...
Compute and Interpret Liquidity and Solvency Ratios Selected balance sheet and income statement information from Verizon Communications Inc. follows. $ millions 2015 2014 Current assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $22,280 $29,499 Current liabilities. . . . ....
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements. Consolidated Statements of Earnings Year Ended December 31 (In millions) 2016 2015 Net sales Products $ 40,365 $ 34,868 Services 6,883 5,668 Total net sales 47,248 40,536 Cost of sales Products (36,616) (31,091) Services (6,040) (4,824) Severance and other charges (80) (82) Other unallocated costs 550 (47) Total cost of sales (42,186) (36,044)...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements. Income Statement Year Ended December 31 (In millions) 2005 2004 2003 Net sales Products $ 31,518 $ 30,202 $ 27,290 Service 5,695 5,324 4,534 37,213 35,526 31,824 Cost of sales Products 27,882 27,637 25,306 Service 5,073 4,765 4,099 Unallocated coporate costs 803 914 443 33,758 33,316 29,848 3,455 2,210 1,976 Other income (expenses),...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT