Exhibit 5.27 presents risk ratios for Starbucks for 2010 and 2011. Exhibits 1.26, 1.27, and 1.28 in Chapter 1 present the financial statements for Starbucks.
REQUIRED
a. Compute the values of each of the ratios in Exhibit 5.27 for Starbucks for 2012. Starbucks had 749.3 million common shares outstanding at the end of fiscal 2012, and the market price per share was $50.71. For days accounts receivable outstanding, use only specialty revenues in your calculations, because accounts receivable are primarily related to licensing and food service operations, not the retail operations.
b. Interpret the changes in Starbucks risk ratios during the three-year period, indicating areas of concern.

1.26

1.27

1.28

1.28 Cont.

  

Exhibit 5.27 Starbucks Risk Ratios (Integrative Case 5.1) 2012 2011 2010 Current ratio 1.83 155 Quick ratio 1.17 0.98 Operating cash flow to current liabilities ratio Days accounts receivable outstanding Days inventory held Days accounts payable outstanding Net days of working capital financing needed Liabilities to assets ratio 0.84 1.01 61 60 56 50 28 23 89 87 0.40 042 Liabilities to shareholders' equity ratio Long-term debt to long-term capital ratio Long-term debt to shareholders' equity ratio Interest coverage ratio Operating cash flow to total liabilities ratio Altman's Z-score 0.68 0.73 0.11 0.13 0.13 0.15 47.9 54.3 057 0.65 9.094 7.577 Probability of bankruptcy 0.0% 0.0%