Analysis IT Use a spreadsheet to construct common-size income statements (which Starbucks calls statements of eamings) and balance sheets for 2013 and 2012. Common-size income statements scale cach income statement line item by total net revenues (sales). Common-size balance sheets are created by dividing! each figure on a given year's balance sheet by that year's total assets, thereby creating a balance sheet on a percent of assets" basis. You will use these common-size statements in answering several of the questions below. (Starbucks' investor relations website investor.starbucks.com-contains a link to SEC filings. The company's Form 10-K can be found under annual filings and contains an Excel spreadsheet with financial statement data that may be helpful in creating the common-size statements). CEGH 12 Months Ended Sep. 29, Sep. 30, Oct. 02, 2013 2012 2011 79.19% 9.14% 11.67% 100.00% 42.86% 28.78% 3.07% 79.21% 9.10% 11.69% 100.00% 43.71% 29.46% 3.23% 82.33% 8.61% 9.06% 100.00% 42.01% 30.72% 3.36% Consolidated Statements Of Earnings In Millions, except Per Share data, unless otherwise specified 3 Net revenues: 4 Company-operated stores 5 Licensed stores 6 CPG, foodservice and other 7 Total net revenues 8 Cost of sales including occupancy 9 Store operating expenses 10 Other operating expenses Depreciation and amortization 11 expenses 12 General and administrative 13 Litigation charge 14 Total operating expenses 15 Gain on sale of properties 16 Income from equity investees 17 Operating income 18 Interest income and other, net 19. Interest expense 20 Earnings before income taxes 21 Income taxes Net earnings including 22 noncontratting interests Net earnings attributable to 23 noncontrolling interest 24 Net earnings attributable to 25 Earnings per share-basic 26 Earnings per share-diluted 27 Weighted average shares outstanding: 28 Basic 29 Diluted 30 Cash dividends declared per share 4.17% 6.30% 18.70% 103.8796 0.00% 1.69% 4.14% 6.02% 0.00% 86.57% 0.00% 1.58% 15.02% 0.7196 -0.25% 15.489 5.079 4.47% 6.40% 0.00% 86.97% 0.26% 1.48% 14.779 0.9996 -0.28% 15.48% 4.8196 -2.19% 0.83 -0.1996 -1.54% -1.60% 0.06% 10.41% 10.67% 0.00% 0.06% 0.01% 10,40% 0.02% 10.65% Consolidated Statements of Ear Consolidated_Balance_Sheets cons C D E F G H Consolidated Balance Sheets (USD $) Sep. 30, In Millions, unless otherwise specified 2012 Current assets: Cash and cash equivalents 22.36% 14.46% Short-term investments 5.71% 10.32% Accounts receivable, net 4.87% 5.91% Inventories 9.65% 15.10% Prepaid expenses and other current assets 2.50% 2.39% Deferred income taxes, net 2.41% 2.90% Total current assets 47.51% 51.09% Long-term investments 0.51% 1.41% Equity and cost investments 4.31% 5.60% Property, plant and equipment, net 27.79% 32.35% Deferred income taxes, net 8.40% 1.18% 5 Other assets 1.61% Other intangible assets 2.39% 1.75% Goodwill 7.49% 4.86% TOTAL ASSETS 100.00% 100.00% Current liabilities: Accounts payable 4.27% 4.8496 Accrued litigation charge 24.17% 0.00% Accrued liabilities 11.02% 13.79% Insurance reserves 1.55% 2.04% Deferred revenue 5.68% 6.21% Total current liabilities 46.69% 26.89% Long-term debt 11.28% 6.69% Other long-term liabilities 3.11% 4.20% Total liabilities 61.08% 37.77% Shareholders' equity: Common stock ($0.001 par value) - authorized, 1,200.0 shares; issued and outstanding. 753.2 and 749.3 shares ... Consolidated_Statements_of_Ear Consolidated Balance Sheets F 4.27% 24.17% 11.02% 1.55% 5.68% 46.69% 11.28% 3.11% 61.08% 4.84% 0.00% 13.79% 2.04% 6.21% 26.89% 6.69% 4.20% 37.77% 19 Current liabilities: 20 Accounts payable 21 Accrued litigation charge 22 Accrued liabilities 23 Insurance reserves 24 Deferred revenue 25 Total current liabilities 26 Long-term debt 27 Other long-term liabilities 28 Total liabilities 29 Shareholders' equity: Common stock ($0.001 par value) - authorized, 1,200.0 shares; issued and outstanding, 753.2 and 749.3 shares (includes 3.4 common stock units). 30 respectively 31 Additional paid-in capital 32 Retained earnings Accumulated other comprehensive 33 income 34 Total shareholders' equity 35 Noncontrolling interests 536 Total equity 37 TOTAL LIABILITIES AND EQUITY 0.01% 2.45% 35.86% 0.01% 0.48% 61.40% 0.58% 0.28% 38.90% 62.16% 0.02% 0.07% 38.9296 62.23% 100.00% 100.00% In conjunction with the change in Consolidated Statements of Ear Consolidated Balance Sheets com