Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I preformed a horizontal analysis on the following data. I guess my confusion exactly is what this means. What do you see from the data
I preformed a horizontal analysis on the following data. I guess my confusion exactly is what this means. What do you see from the data
Income Statement
Oct 2 | Sep 27, | Sep 28, | % Change | % Change | ||||
2016 | 2015 | 2014 | 2016-2015 | 2015-2014 | ||||
Net revenues: | ||||||||
Company-operated stores | 16,844.10 | $15,197.30 | $12,977.90 | 10.84% | 17.10% | |||
Licensed stores | 2,154.20 | 1,861.90 | 1,588.60 | 15.70% | 17.20% | |||
CPG, foodservice and other | 2,317.60 | 2,103.50 | 1,881.30 | 10.18% | 11.81% | |||
Total net revenues | 21,315.90 | 19,162.70 | 16,447.80 | 11.24% | 16.51% | |||
Cost of sales including occupancy costs | 8,511.10 | 7,787.50 | 6,858.80 | 9.29% | 13.54% | |||
Store operating expenses | 6,064.30 | 5,411.10 | 4,638.20 | 12.07% | 16.66% | |||
Other operating expenses | 545.40 | 522.40 | 457.30 | 4.40% | 14.24% | |||
Depreciation and amortization expenses | 980.80 | 893.90 | 709.60 | 9.72% | 25.97% | |||
General and administrative expenses | 1,360.60 | 1,196.70 | 991.30 | 13.70% | 20.72% | |||
Litigation charge/(credit) | - | - | (20.20) | #DIV/0! | -100.00% | |||
Total operating expenses | 17,462.20 | 15,811.60 | 13,635.00 | 10.44% | 15.96% | |||
Income from equity investees | 318.20 | 249.90 | 268.30 | 27.33% | -6.86% | |||
Operating income/(loss) | 4,171.90 | 3,601.00 | 3,081.10 | 15.85% | 16.87% | |||
Gain resulting from acquisition of joint venture | - | 390.60 | - | -100.00% | #DIV/0! | |||
Loss on extinguishment of debt | - | (61.10) | - | -100.00% | #DIV/0! | |||
Interest income and other, net | 108.00 | 43.00 | 142.70 | 151.16% | -69.87% | |||
Interest expense | (81.30) | (70.50) | (64.10) | 15.32% | 9.98% | |||
Earnings/(loss) before income taxes | 4,198.60 | 3,903.00 | 3,159.70 | 7.57% | 23.52% | |||
Income tax expense/(benefit) | 1,379.70 | 1,143.70 | 1,092.00 | 20.63% | 4.73% | |||
Net earnings including noncontrolling interests | 2,818.90 | 2,759.30 | 2,067.70 | 2.16% | 33.45% | |||
Net earnings/(loss) attributable to noncontrolling interests | 1.20 | 1.90 | (0.40) | -36.84% | -575.00% | |||
Net earnings attributable to Starbucks | 2,817.70 | $2,757.40 | $2,068.10 | 2.19% | 33.33% | |||
Earnings per share basic | 1.91 | 1.84 | 1.37 | 3.80% | 34.31% | |||
Earnings per share diluted | 1.90 | 1.82 | 1.35 | 4.40% | 34.81% | |||
Weighted average shares outstanding: | ||||||||
Basic | 1,471.60 | 1,495.90 | 1,506.30 | -1.62% | -0.69% | |||
Diluted | 1,486.70 | 1,513.40 | 1,526.30 | -1.76% | -0.85% |
Balance Sheet
Oct 2 | Sep 27 | Sep 28, | % Change | % Change | ||||
2016 | 2015 | 2014 | 2016-2015 | 2015-2014 | ||||
ASSETS | ||||||||
Current assets: | ||||||||
Cash and cash equivalents | $2,128.80 | $1,530.10 | $1,708.40 | 39.13% | -10.44% | |||
Short-term investments | 134.40 | 81.30 | 135.40 | 65.31% | -39.96% | |||
Accounts receivable, net | 768.80 | 719.00 | 631.00 | 6.93% | 13.95% | |||
Inventories | 1,378.50 | 1,306.40 | 1,090.90 | 5.52% | 19.75% | |||
Prepaid expenses and other current assets | 350.00 | 334.20 | 285.60 | 4.73% | 17.02% | |||
Total current assets | 4,760.50 | 3,971.00 | 3,851.30 | 19.88% | 3.11% | |||
Long-term investments | 1,141.70 | 312.50 | 318.40 | 265.34% | -1.85% | |||
Equity and cost investments | 354.50 | 352.00 | 514.90 | 0.71% | -31.64% | |||
Property, plant and equipment, net | 4,533.80 | 4,088.30 | 3,519.00 | 10.90% | 16.18% | |||
Deferred income taxes, net | 885.40 | 1,180.80 | 1,220.70 | -25.02% | -3.27% | |||
Other long-term assets | 417.70 | 415.90 | 198.90 | 0.43% | 109.10% | |||
Other intangible assets | 516.30 | 520.40 | 273.50 | -0.79% | 90.27% | |||
Goodwill | 1,719.60 | 1,575.40 | 856.20 | 9.15% | 84.00% | |||
TOTAL ASSETS | $14,329.50 | $12,416.30 | $10,752.90 | 15.41% | 15.47% | |||
LIABILITIES AND EQUITY | ||||||||
Current liabilities: | ||||||||
Accounts payable | $730.60 | $684.20 | $533.70 | 6.78% | 28.20% | |||
Accrued liabilities | 1,999.10 | 1,755.30 | 1,514.40 | 13.89% | 15.91% | |||
Insurance reserves | 246.00 | 224.80 | 196.10 | 9.43% | 14.64% | |||
Stored value card liability | 1,171.20 | 983.80 | 794.50 | 19.05% | 23.83% | |||
Current portion of long-term debt | 400.00 | - | - | #DIV/0! | #DIV/0! | |||
Total current liabilities | 4,546.90 | 3,648.10 | 3,038.70 | 24.64% | 20.05% | |||
Long-term debt | 3,202.20 | 2,347.50 | 2,048.30 | 36.41% | 14.61% | |||
Other long-term liabilities | 689.70 | 600.90 | 392.20 | 14.78% | 53.21% | |||
Total liabilities | 8,438.80 | 6,596.50 | 5,479.20 | 27.93% | 20.39% | |||
Shareholders equity: | ||||||||
Common stock ($0.001 par value) authorized, | 1.50 | 1.50 | 0.70 | 0.00% | 114.29% | |||
2,400.0 shares; issued and outstanding, | ||||||||
1,460.5 and 1,485.1 shares, respectively | ||||||||
Additional paid-in capital | 41.10 | 41.10 | 39.40 | 0.00% | 4.31% | |||
Retained earnings | 5,949.80 | 5,974.80 | 5,206.60 | -0.42% | 14.75% | |||
Accumulated other comprehensive income/(loss) | (108.40) | (199.40) | 25.30 | -45.64% | -888.14% | |||
Total shareholders equity | 5,884.00 | 5,818.00 | 5,272.00 | 1.13% | 10.36% | |||
Noncontrolling interest | 6.70 | 1.80 | 1.70 | 272.22% | 5.88% | |||
Total equity | 5,890.70 | 5,819.80 | 5,273.70 | 1.22% | 10.36% | |||
TOTAL LIABILITIES AND EQUITY | $14,329.50 | $12,416.30 | $10,752.90 | 15.41% | 15.47% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started