Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make a Horizontal and Vertical analysis of SBUX balance sheet with four years of camparative data from Yahoo Finance If you can only answer one
Make a Horizontal and Vertical analysis of SBUX balance sheet with four years of camparative data from Yahoo Finance If you can only answer one then please answer the Verical analysis
Starbucks Corporation (SBUX) | ||||
Balance Sheet | ||||
For the year ended Sept 30 | ||||
Breakdown | TTM | 9/30/2019 | 9/30/2018 | 9/30/2017 |
Total Revenue | 24061900 | 26508600 | 24719500 | 22386800 |
Cost of Revenue | 18647800 | 19020500 | 17367700 | 15531500 |
Gross Profit | 5414100 | 7488100 | 7351800 | 6855300 |
Operating Expense | 3534000 | 3572400 | 3545300 | 2958500 |
Operating Income | 1880100 | 3915700 | 3806500 | 3896800 |
Net Non Operating Interest Income Expense | -360800 | -234500 | 21100 | 182800 |
Other Income Expense | 206600 | 785000 | 1952400 | 237900 |
Pretax Income | 1725900 | 4466200 | 5780000 | 4317500 |
Tax Provision | 391500 | 871600 | 1262000 | 1432600 |
Net Income Common Stockholders | 1338500 | 3599200 | 4518300 | 2884700 |
Diluted NI Available to Com Stockholders | 1338500 | 3599200 | 4518300 | 2884700 |
Basic EPS | - | 0.003 | 0.0035 | 0.002 |
Diluted EPS | - | 0.0029 | 0.0032 | 0.002 |
Basic Average Shares | - | 1184600 | 1309100 | 1431600 |
Diluted Average Shares | - | 1233200 | 1394600 | 1461500 |
Total Operating Income as Reported | 2086700 | 4077900 | 3883300 | 4134700 |
Total Expenses | 22181800 | 22592900 | 20913000 | 18490000 |
Net Income from Continuing & Discontinued Operation | 1338500 | 3599200 | 4518300 | 2884700 |
Normalized Income | 1412414 | 3207165 | 3227062 | 2987238 |
Interest Income | 47000 | 96500 | 191400 | 275300 |
Interest Expense | 407800 | 331000 | 170300 | 92500 |
Net Interest Income | -360800 | -234500 | 21100 | 182800 |
EBIT | 2133700 | 4797200 | 5950300 | 4410000 |
EBITDA | 3623400 | - | - | - |
Reconciled Cost of Revenue | 18571200 | 18948500 | 17308800 | 15475800 |
Reconciled Depreciation | 1489700 | 1449300 | 1305900 | 1067100 |
Net Income from Continuing Operation Net Minority Interest | 1338500 | 3599200 | 4518300 | 2884700 |
Total Unusual Items Excluding Goodwill | -95600 | 487000 | 1651200 | -153500 |
Total Unusual Items | -95600 | 487000 | 1651200 | -153500 |
Normalized EBITDA | 3719000 | 5759500 | 5605000 | 5630600 |
Tax Rate for Calcs | 0 | 0 | 0 | 0 |
Tax Effect of Unusual Items | -21686 | 94965 | 359962 | -50962 |
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