4.24 Selected balance sheet and income statement information from CVS Caremark C
ID: 2771264 • Letter: 4
Question
4.24
Selected balance sheet and income statement information from CVS Caremark Corp. for 2010 through 2012 follows ($ millions).
Total Total
Current Current Pretax Interest
Assets Liabilities Income Expense Total Liabilities Equity
2012 . . . . . . $19,852 $13,790 $6,323 $557 $28,208 $37,704
2011 . . . . . . 18,594 11,956 5,746 584 26,492 38,051
2010 . . . . . . 17,706 11,070 5,601 536 24,469 37,700
Required
a. Compute times interest earned ratio for each year and discuss any trends for each.
b. Compute the current ratio for each year and discuss any trend in liquidity. Do you believe the company is sufficiently liquid? Explain. What additional information about the accounting numbers comprising this ratio might be useful in helping you assess liquidity? Explain.
c. Compute the total liabilities-to-equity ratio for each year and discuss any trends for each.
d. What is your overall assessment of the company’s credit risk from the analyses in (a), (b), and (c)?
4-28
Compute and Interpret Altman’s Z-scores (LO5)
Following is selected financial information for eBay Inc., for its fiscal years 2013 and 2012.
($ millions, except per share data) 2013 2012
Current assets ............................................... $23,283 $21,398
Current liabilities...........................................12,639 10,924
Total assets.................................................. 41,488 37,074
Total liabilities ..............................................17,841 16,209
Shares outstanding .......................................1,294 1,286
Retained earnings ..........................................18,854 15,998
Stock price per share ......................................54.87 51.00
Sales....................................................... 16,047 14,072
Earnings before interest and taxes.................. 3,371 2,888
Required
a. Compute and compare the Altman Z-scores for both years. What explains the apparent trend?
b. Is the company more likely to go bankrupt given the Z-score in 2013 compared to 2012? Explain
4-31
Assess Credit Risk (LO2, 3)
Balance sheets and income statements for NextEra Energy, Inc. follow. Refer to these financial state-ments to answer the requirements
Required
a. Use the financial statements and the information below to compute the following profitability and coverage, liquidity and solvency ratios for 2012 and 2011: RNOA, ROE, times interest earned, free cash flow to debt, current ratio, quick ratio, liabilities-to-equity ratio, and total debt-to-equity ratio. (For simplicity here, use year-end balances for the denominator of RNOA and ROE.) Comment on any observed trends
b. Summarize your findings in a conclusion about the company’s credit risk. Do you have any concerns about the company’s ability to meet its debt obligations?
*** Show ALL Work Please To Be Voted Best Answer ***
Balance Sheets As of December 31 (in millions) 2011 $329 $377 Customer receivables, net of allowances of $10 and $11, respectively Materials, supplies and fossil fuel inventory Regulatory assets: Deferred clause and franchise expenses Electric plant in service and other property Construction work in progres:s Less accurmulated depreciation and amortization... Current maturities of long-term debt taxes. Liabilities associated with assets held for sale 8.879Explanation / Answer
Answer:4.24
(a) Time interest earned ratio=Annual interest expense/Net operating income
2010=536/5601=0.0957 times
2011=584/5746=0.1016
2012=557/6323=0.08809
From 2010 to 2011 its increasing trend and from 2011 to 2012 its decreasing trend.
(b) Current Ratio=Current Asset/Current Liability
2010=17706/11070=1.599 times
2011=18594/11956=1.555 times
2012=19852/13790=1.439 times
Its decreasing trend.
No company is not sufficiently liquid. because ideal current ratio is 2:1
(c)Total liability to equity ratio=Total Liability/Total Equity
2010=24469/37700=0.65 times
2011=26492/38051=0.696 times
2012=28208/37704=0.748 times
Its increasing trend
(d) Overall recommendation is that company have higher burden so it should be reduced.
Answer:4.28
(a) Current ratio=Current Asset/Current Liability
2012=21398/10924=1.96 times
2013=23283/12639=1.842 times
Total liability to total asset ratio=Total Liability/Total Asset
2012=16209/37074=0.437 times
2013=17841/41488=0.4300 times
Its decreasing trend.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.