Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services An Integrated Approach

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan

18th Edition

0137879199, 9780137879199

More Books

Students also viewed these Accounting questions

Question

Do you set targets to reduce complaints?

Answered: 1 week ago