Question
I am struggling with what to appeal in the excel sheet. Help please! Provide horizontal analysis of your companys income statement and balance sheet, showing
I am struggling with what to appeal in the excel sheet. Help please!
Provide horizontal analysis of your companys income statement and balance sheet, showing the dollar amount and percent of change using the 2 most recent years (you must use an Excel spreadsheet with formulas).
STARBUCKS CORPORATION
CONSOLIDATED STATEMENTS OF EARNINGS
(in millions, except per share data)
| Fiscal Year Ended | Sep 27, 2020 | Sep 29, 2019 | Sep 30, 2018 | ||||||||||||||
| Net revenues: | |||||||||||||||||
| Company-operated stores | $ | 19,164.6 | $ | 21,544.4 | $ | 19,690.3 | |||||||||||
| Licensed stores | 2,327.1 | 2,875.0 | 2,652.2 | ||||||||||||||
| Other | 2,026.3 | 2,089.2 | 2,377.0 | ||||||||||||||
| Total net revenues | 23,518.0 | 26,508.6 | 24,719.5 | ||||||||||||||
| Product and distribution costs | 7,694.9 | 8,526.9 | 7,930.7 | ||||||||||||||
| Store operating expenses | 10,764.0 | 10,493.6 | 9,472.2 | ||||||||||||||
| Other operating expenses | 430.3 | 371.0 | 554.9 | ||||||||||||||
| Depreciation and amortization expenses | 1,431.3 | 1,377.3 | 1,247.0 | ||||||||||||||
| General and administrative expenses | 1,679.6 | 1,824.1 | 1,708.2 | ||||||||||||||
| Restructuring and impairments | 278.7 | 135.8 | 224.4 | ||||||||||||||
| Total operating expenses | 22,278.8 | 22,728.7 | 21,137.4 | ||||||||||||||
| Income from equity investees | 322.5 | 298.0 | 301.2 | ||||||||||||||
| Operating income | 1,561.7 | 4,077.9 | 3,883.3 | ||||||||||||||
| Gain resulting from acquisition of joint venture | 1,376.4 | ||||||||||||||||
| Net gain resulting from divestiture of certain operations | 622.8 | 499.2 | |||||||||||||||
| Interest income and other, net | 39.7 | 96.5 | 191.4 | ||||||||||||||
| Interest expense | ( 437.0 ) | ( 331.0 ) | ( 170.3 ) | ||||||||||||||
| Earnings before income taxes | 1,164.4 | 4,466.2 | 5,780.0 | ||||||||||||||
| Income tax expense | 239.7 | 871.6 | 1,262.0 | ||||||||||||||
| Net earnings including noncontrolling interests | 924.7 | 3,594.6 | 4,518.0 | ||||||||||||||
| Net loss attributable to noncontrolling interests | ( 3.6 ) | ( 4.6 ) | ( 0.3 ) | ||||||||||||||
| Net earnings attributable to Starbucks | $ | 928.3 | $ | 3,599.2 | $ | 4,518.3 | |||||||||||
| Earnings per share basic | $ | 0.79 | $ | 2.95 | $ | 3.27 | |||||||||||
| Earnings per share diluted | $ | 0.79 | $ | 2.92 | $ | 3.24 | |||||||||||
| Weighted average shares outstanding: | |||||||||||||||||
| Basic | 1,172.8 | 1,221.2 | 1,382.7 | ||||||||||||||
| Diluted | 1,181.8 | 1,233.2 | 1,394.6 | ||||||||||||||
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
Auditing And Assurance Services An Integrated Approach
Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan
18th Edition
0137879199, 9780137879199
