Analysis IT Use a spreadsheet to construct common-size income statements (which Starbucks calls statements of eamings)...

Question

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&#34; 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

 · Answer

Income Statement:   Balance sheet   5 Form Type: 10-K 6 Period End: Sep 29, 2013 7 Date Filed: Nov 18, 2013 8 Table of Contents STARBUCKS CORPORATION CONSOLIDATED STATEMENTS OF EARNINGS (in millions, except per share data) Sep 29, Sep 30, 2013 Oct 2, 2012 2011 % of Net Revenue (2013) % of Net Revenue (2012) % of Net Revenue (2011) 17 18 Fiscal Year Ended Net revenues: Company-operated stores Licensed stores CPG, foodservice and other Total net revenues Cost of sales including occupancy costs Store operating expenses Other operating expenses Depreciation and amortization expenses General and administrative expenses Litigation charge Total operating expenses Gain on sale of properties Income from equity investees Operating income/(loss) Interest income and other, net ... INCOME STATEMENT TABLE32 11,793.20 $ 10,534.50 $ 9,632.40 1,360.50 1,210.30 1,007.50 1,738.50 1,554.70 1,060.50 14,892.20 13,299.50 11,700.40 6,382.30 5,813.30 4,915.50 4,286.10 3,918.10 3,594.90 457.20 429.90 392.80 621.40 550.30 523.30 937.90 801.20 749.30 2,784.10 15,469.00 11,512.80 10,175.80 30.20 251.40 210.70 173.70 -325.40 1,997.40 1,728.50 123.60 94.40 115.90 BALANCE SHEET CASH_FLOW STOCKHOLDERS_EQUITY 79.19% 9.14% 11.67% 100.00% 42.86% 28.78% 3.07% 4.17% 6.30% 18.70% 103.87% 0.00% 1.69% -2.19% 0.83% + 79.21% 9.10% 11.69% 100.00% 43.71% 29.46% 3.23% 4.14% 6.02% 0.00% 86.57% 0.00% 1.58% 15.02% 0.71% 82.33% 8.61% 9.06% 100.00% 42.01% 30.72% 3.36% 4.47% 6.40% 0.00% 86.97% 0.26% 1.48% 14.77% 0.99% 27 28 30 31 .... A B Interest income and other, net Interest expense Earnings/loss) before income taxes Income taxes Net earnings including noncontrolling interests Net earnings attributable to noncontrolling interests Net earnings attributable to Starbucks 123.60 -28.10 -229.90 -238.70 8.80 0.50 8.30 94.40 -32.70 2,059.10 674.40 1,384.70 0.90 1,383.80 115.90 -33.30 1,811.10 563.10 1,248.00 2.30 1,245.70 0.83% -0.19% -1.54% -1.60% 0.06% 0.00% 0.06% 0.71% -0.25% 15.48% 5.07% 10.41% 0.01% 10.40% 0.99% -0.28% 15.48% 4.81% 10.67% 0.02% 10.65% $ $ Om Om ON ... INCOME STATEMENT TABLE32 BALANCE SHEET CASH_FLOW STOCKHOLDERS_EQUITY .... + C D E AA 4 BALANCE SHEET 5 Form Type: 10-K 6 Period End: Sep 29, 2013 7 Date Filed: Nov 18, 2013 3 Table of Contents STARBUCKS CORPORATION CONSOLIDATED BALANCE SHEETS (in millions, except per share data) Sep 29, 2013 Sep 30, 2012 % of Total Assets/Liabilities % of Total Assets/Liabilities ASSETS Current assets: Cash and cash equivalents Short-term investments Accounts receivable, net Inventories Prepaid expenses and other current assets Deferred income taxes, net Total current assets Long-term investments Equity and cost investments Property, plant and equipment, net Deferred income taxes, net Other assets Other intangible assets ...INCOME STATEMENT TABLE32 $ 2,575.70 $ 1,188.60 658.10 848.40 561.40 485.90 1,111.20 1,241.50 287.70 196.50 277.30 238.70 5,471.40 4,199.60 58.30 116.00 496.50 459.90 3,200.50 2,658.90 967.00 97.30 185.30 144.70 274.80 143.70 CASH_FLOW STOCKHOLDERS_EQUITY 22.36% 5.71% 4.87% 9.65% 2.50% 2.41% 47.51% 0.51% 4.31% 27.79% 8.40% 1.61% 2.39% -... 14.46% 10.32% 5.91% 15.10% 2.39% 2.90% 51.09% 1.41% 5.60% 32.35% 1.18% 1.76% 1.75% 26 27 28 29 . BALANCE SHEET T D C 274.80 862.90 11,516.70 $ 143.70 399.10 8,219.20 2.39% 7.49% 100.00% 1.75% 4.86% 100.00% $ $ 398.10 Other intangible assets Goodwill TOTAL ASSETS LIABILITIES AND EQUITY Current liabilities: Accounts payable Accrued litigation charge Accrued liabilities Insurance reserves Deferred revenue Total current liabilities Long-term debt Other long-term liabilities Total liabilities Shareholders' equity: Common stock ($0.001 par value) - authorized, 1,200.0 shares, issued and outstanding, 753.2 shares and 749.3 shares (includes 3.4 common stock units), respectively Additional paid-in capital Retained earnings Accumulated other comprehensive income Total shareholders' equity Noncontrolling interests Total equity TOTAL LIABILITIES AND EQUITY 491.70 2,784.10 1,269.30 178.50 653.70 5,377.30 1,299.40 357.70 7,034.40 1,133.80 167.70 510.20 2,209.80 549.60 345.30 3,104.70 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% 0.80 282. 10 4,130.30 67.00 4,480.20 2.10 4,482.30 11,516.70 0.70 39.40 5,046.20 22.70 5,109.00 5.50 5,114.50 8,219.20 0.01% 2.45% 35.86% 0.58% 38.90% 0.02% 38.92% 100.00% 0.01% 0.48% 61.40% 0.28% 62. 16% 0.07% 62.23% 100.00% 63 $ $ 55| ...INCOME_STATEMENT TABLE32 BALANCE SHEET CASH_FLOW STOCKHOLDERS_EQUITY .... + .

Analysis IT Use a spreadsheet to construct common-size income statements (which Starbucks calls statements of eamings)...

Question:

Answers

Similar Solved Questions

Using the pedigree chart below, determine the genotype of each individual. If you do not know...

Straight-Line and Units-of-Production Methods Assume that Sample Company purchased factory equipment on January 1, 2016, for...

Step 1: Explore View Encounters.  The View Encounters screen allows you to view all the...

How do you solve #2x+8.5=20.4#?

Assume the following information from a schedule of cost of goods manufactured: Cost of goods manufactured...

Required information Exercise 5-5 Effect of inventory cost flow on ending inventory balance and gross margin...

For the following circuit find (15 Points): What is the power factor (PF)? What is the real power (P) delivered by the source (in Watts)? What is the Apparent Power (S) in Volt-Amp? I 6 7 12...

Video Excel Online Structured Activity: Bond valuation An Investor has two bonds in her portfolio, Bond...

Please explain how the total NPP relates to the other two graphs or what all the...

James Smorehourg: Attempt1 Question 2 (1 point)Saved Select the answer below that correctly matches the response...

Urinary retention common post op and after foley removal. Must assess output post removal and post...

At the beginning of 2020, Pharoah Company acquired a mine for $2,762,400. Of this amount, $120,000...

Help 8 A company establishes a petty cash fund on August 3 for $490. The fund...

A waste disposal company is considering the replacement of one of its aging trucks. The key...

Problem 9.08 Part A The two trees in (Fioure 1) are 7.2 m apart. A backpacker...

For the plane stress element below, assume that the material is: a) ductile plastic with yield...

Northwestern Bells stocks a certain switch connector at its central warehouse for supplying field service offices....

3. Why do you think obesity should or should not be treated as a disease? Do...

A bag contains 3 red marbles, 2 green ones, 1 lavender one, 2 yellows, and 4 orange marbles