The following financial ratios and information relate to Starbucks Corporation for the period 2003 to 2012.

Required
a. Represent the 2012 horizontal analysis of the asset section of the balance sheet in a pie chart and comment on Starbucks’ asset composition.
b. Represent the 2012 horizontal analysis of the liability and equity sections of the balance sheet in a pie chart and comment on Starbucks’ financing of its assets.
c. Prepare a trend line chart of Starbucks’ liquidity and capital structure ratios. Discuss what this trend reveals how it assists decision making.
d. Prepare a trend line chart of Starbucks’ efficiency ratios. Discuss what this trend reveals and how it assists decision making.

Transcribed Image Text:

Balance sheet items (in %) Cash and short-term investments Accounts receivable Inventory Other current assets Total current assets Net PPE Intangibles Other long-term assets Total assets Accounts payable Short-term debt Taxes payable Accrued liabilities Other short-term liabilities Total current liabilities Long-term debt Other long-term liabilities Total liabilities Total stockholders' equity Total liabilities and equity Liquidity/Capital structure Current ratio Quick ratio Financial leverage Debt/equity Balance sheet items (in %) Efficiency ratios Days inventory Payables period Receivables turnover Inventory turnover Fixed assets turnover Asset turnover 2003 12.82 100 2004 2005 19.62 8.74 6.19 0.03 4.19 4.21 5.43 12.56 12.7 15.55 4.27 4.58 4.7 4.87 5.21 7.11 33.85 41.12 34.41 34.54 31.75 50.73 44.21 52.42 51.66 54.09 3.23 4.82 12.18 9.34 100 2.88 3.64 4.5 11.79 9.53 9.3 100 6.29 7.7 7.9 5.99 0.02 2006 10.24 100 2003 2004 1.52 0.76 1.31 Horizontal analysis 2007 2008 2009 2010 8.21 5.68 11.94 22.7 5.06 4.86 4.74 5.25 5.39 5.81 14.37 12.94 12.21 11.92 8.51 13.12 7.21 5.32 7.78 30.81 36.5 43.16 51.56 52.12 45.48 37.84 32 5.87 5.87 11.2 12.14 2005 100 7.31 15.82 13.31 13.39 13.87 2.69 3.65 22.3 23.53 34.92 0.16 0.11 0.08 1.26 1.65 5.51 23.71 25.28 40.51 76.29 74.72 59.49 100 100 100 100 100 15.74 14.95 14.16 4.98 5.24 5.56 9.18 43.7 40.34 38.6 0.04 10.29 9.69 5.93 6.63 7.8 49.68 57.26 56.09 42.74 50.32 43.91 2006 0.99 0.79 0.79 1.75 1.01 0.41 0.35 0.34 1.34 1.68 1.99 2.34 0.24 2007 100 5.73 12.58 2.29 11.11 11.53 100 100 2008 4.79 5.22 5.89 13.78 10.56 100 100 4.43 7.34 2011 27.86 1.57 1.48 13.09 11.3 8.77 8.08 9.74 28.35 27.86 28.2 7.47 9.85 8.6 7.19 5.99 4.76 45.39 42.46 40.43 54.61 57.54 59.57 100 100 100 2009 0.8 1.29 0.3 0.59 0.99 2.28 1.83 0.22 0.18 2010 2011 1.55 1.83 1.17 1.74 1.68 0.15 0.13 Horizontal analysis 2003 2004 2005 2006 2007 2008 2009 2010 2003 2004 2005 2006 2007 2008 65.61 33.58 35.59 35.22 33.59 30.11 57.29 18.51 15.57 24.98 33.01 16.16 15.44 16.74 38.44 41.58 38.49 5.56 10.87 10.25 37.52 36.75 33.63 32.55 10.36 10.87 12.12 6.37 3.77 3.64 3.08 3.71 3.55 3.84 1.75 1.86 1.96 1.62 1.93 1.89 2012 24.78 5.91 15.1 5.29 51.09 32.35 6.6 9.95 100 4.84 1.68 10.2 10.16 26.89 6.69 4.27 37.84 62.16 100 2012 1.9 1.14 1.61 0.11 2011 2012 2009 2010 2011 2012 49.45 55.65 69.29 22.5 30.33 29.45 37.33 33.95 30.49 7.38 6.56 5.27 3.56 4.32 4.9 5.31 1.74 1.79 1.7 1.71