Memo
VYdOlINrON6i
WK2TrendAnalysis.xlsxSheet1
| 1. Horizonal Analysis Net Revenue for Starbucks and Dunkin' Brand | |||||||||||||
| Starbuck Net Revenue (in millions) | |||||||||||||
| 2019 | 2018 | 2017 | 2016 | 2015 | 2019 | 2018 | 2017 | 2016 | 2015 | ||||
| Net Revenue: | 26,508.6 | 24,719.5 | 22,386.8 | 21,315.9 | 19,162.7 | Net Revenue: | 26,508.6 | 24,719.5 | 22,386.8 | 21,315.9 | 19,162.7 | ||
| Net Revenue change | 1.38 | 1.29 | 1.17 | 1.11 | 1.00 | Variance Amount | 7,345.90 | 5,556.80 | 3,224.10 | 2,153.20 | |||
| Net Revenue % | 138% | 129% | 117% | 111% | 100% | Net Revenue % | 38% | 29% | 17% | 11% | 0% | ||
| Dunkin' Brands Net Revenue (in thousands) | |||||||||||||
| 2019 | 2018 | 2017 | 2016 | 2015 | 2019 | 2018 | 2017 | 2016 | 2015 | ||||
| Net Revenue: | 1,370,227 | 1,321,617 | 1,275,551 | 828,889 | 810,933 | Net Revenue: | 1,370,227.0 | 1,321,617.0 | 1,275,551.0 | 828,889.0 | 810,933.0 | ||
| Net Revenue change | 1.69 | 1.63 | 1.57 | 1.02 | 1.00 | Variance Amount | 559,294.00 | 510,684.00 | 464,618.00 | 17,956.00 | |||
| Net Revenue Dunkin'% | 169% | 163% | 157% | 102% | 100% | Net Revenue Dunkin'% | 69% | 63% | 57% | 2% | 0% | ||
| 2. Horizonal Analysis Net Income for Starbucks and Dunkin' Brand | |||||||||||||
| Starbuck Net Income (in millions) | |||||||||||||
| 2019 | 2018 | 2017 | 2016 | 2015 | 2019 | 2018 | 2017 | 2016 | 2015 | ||||
| Net earning attributable to Starbucks: | 3,599.20 | 4,518.30 | 2,844.70 | 2,817.70 | 2,757.40 | Net Revenue: | 3,599.20 | 4,518.30 | 2,844.70 | 2,817.70 | 2,757.40 | ||
| Net Income change | 1.31 | 1.64 | 1.03 | 1.02 | 1.00 | Variance Amount | 841.80 | 1,760.90 | 87.30 | 60.30 | |||
| Net Income Starbuck% | 131% | 164% | 103% | 102% | 100% | Net Income Starbuck% | 31% | 64% | 3% | 2% | 0% | ||
| Dunkin Brands Net Income (in thousands) | |||||||||||||
| 2019 | 2018 | 2017 | 2016 | 2015 | 2019 | 2018 | 2017 | 2016 | 2015 | ||||
| Net income Dunkin' Brand: | 242,024 | 229,906 | 271,209 | 195,576 | 105,229 | Net Revenue: | 242,024 | 229,906 | 271,209 | 195,576 | 105,229 | ||
| Net Income change | 2.30 | 2.18 | 2.58 | 1.86 | 1.00 | Variance Amount | 136,795 | 124,677 | 165,980 | 90,347 | |||
| Net Income Dunkin % | 230% | 218% | 258% | 186% | 100% | Net Income Dunkin% | 130% | 118% | 158% | 86% | 0% | ||
| 3. Horizonal Analysis Net Revenue for Dachshund Coffee | |||||||||||||
| Dachshund Coffee Net Revenue | |||||||||||||
| 2019 | 2018 | 2017 | 2019 | 2018 | 2017 | ||||||||
| Net Revenue: | 8,251,000 | 6,165,000 | 3,576,976 | Net Revenue: | 8,251,000 | 6,165,000 | 3,576,976 | ||||||
| Net Revenue change | 2.31 | 1.72 | 1.00 | Variance Amount | 4,674,024 | 2,588,024 | - 0 | ||||||
| Net Revenue % | 231% | 172% | 100% | Net Income Dunkin% | 131% | 72% | 0% | ||||||
| Dachshund Coffee Net Income | |||||||||||||
| 2019 | 2018 | 2017 | 2019 | 2018 | 2017 | ||||||||
| Net incomeDachshund Coffee: | 1,579,210 | 1,204,750 | 860,155 | Net Revenue: | 8,251,000 | 6,165,000 | 3,576,976 | ||||||
| Net Income change | 1.84 | 1.40 | 1.00 | Variance Amount | 4,674,024 | 2,588,024 | - 0 | ||||||
| Net Income Dachshund Coffee % | 184% | 140% | 100% | Net Income Dunkin% | 131% | 72% | 0% |
Hortizonal Analysis of Net Revenue for Starbucks
(in millions)
Net Revenue: 2019 2018 2017 2016 2015 26508.6 24719.5 22386.799999999999 21315.9 19162.7 Net Revenue % 2019 2018 2017 2016 2015 1.3833436833014137 1.2899800132549171 1.1682487332160916 1.1123641240534998 1 Net Revenue change 2019 2018 2017 2016 2015 1.3833436833014137 1.2899800132549171 1.1682487332160916 1.1123641240534998 1
Hortizonal Analysis of Net Revenue for Dachshund
Net Revenue: 2019 2018 2017 8251000 6165000 3576976 Variance Amount 2019 2018 2017 4674024 2588024 0 Net Income Dunkin% 2019 2018 2017 1.3066970536005833 0.72352288637105755 0
Hortizonal Analysis of Net Income for Dachshund
Net incomeDachshund Coffee: 2019 2018 2017 1579210 1204750 860155 Net Income change 2019 2018 2017 1.8359597979433939 1.4006196557597177 1 Net Income Dachshund Coffee % 2019 2018 2017 1.8359597979433939 1.4006196557597177 1
Hortizonal Analysis of Net Income for Dachshund
Net Revenue: 2019 2018 2017 8251000 6165000 3576976 Variance Amount 2019 2018 2017 4674024 2588024 0 Net Income Dunkin% 2019 2018 2017 1.3066970536005833 0.72352288637105755 0
Hortizonal Analysis of Net Revenue for Dunkin' Brands
(in thousands)
Net Revenue: 2019 2018 2017 2016 2015 1370227 1321617 1275551 828889 810933 Net Revenue Dunkin'% 2019 2018 2017 2016 2015 1.6896919967494233 1.6297486968713815 1.5729425242282655 1.0221423964741847 1
Horizonal Analysis of Net Income for Starbuck
(in millions)
Net earning attributable to Starbucks: 2019 2018 2017 2016 2015 3599.2 4518.3 2844.7 2817.7 2757.4 Net Income Starbuck% 2019 2018 2017 2016 2015 1.3052875897584679 1.638608834409226 1.0316602596649016 1.0218684267788496 1
Hortizonal Analysis of Net Income for Dunkin' Brands
(in thousands)
Net income Dunkin' Brand: 2019 2018 2017 2016 2015 242024 229906 271209 195576 105229 Net Income Dunkin % 2019 2018 2017 2016 2015 2.2999743416738734 2.1848159727831682 2.5773218409373841 1.8585751076224235 1
Hortizonal Analysis of Net Revenue for Starbucks
(in millions)
Net Revenue: 2019 2018 2017 2016 2015 26508.6 24719.5 22386.799999999999 21315.9 19162.7 Variance Amount 2019 2018 2017 2016 2015 7345.8999999999978 5556.7999999999993 3224.0999999999985 2153.2000000000007 Net Revenue % 2019 2018 2017 2016 2015 0.38334368330141355 0.28998001325491707 0.1682487332160916 0.1123641240534998 0
Hortizonal Analysis of Net Revenue for Dunkin' Brands
(in thousands)
Net Revenue: 2019 2018 2017 2016 2015 1370227 1321617 1275551 828889 810933 Variance Amount 2019 2018 2017 2016 2015 559294 510684 464618 17956 Net Revenue Dunkin'% 2019 2018 2017 2016 2015 0.68969199674942316 0.62974869687138146 0.57294252422826542 2.2142396474184672 E-2 0
Horizonal Analysis of Net Income for Starbuck
(in millions)
Net Revenue: 2019 2018 2017 2016 2015 3599.2 4518.3 2844.7 2817.7 2757.4 Variance Amount 2019 2018 2017 2016 2015 841.79999999999973 1760.9 87.299999999999727 60.299999999999727 Net Income Starbuck% 2019 2018 2017 2016 2015 0.30528758975846804 0.63860883440922611 3.1660259664901616E-2 2.186842677884954E-2 0
Hortizonal Analysis of Net Income for Dunkin' Brands
(in thousands)
Net Revenue: 2019 2018 2017 2016 2015 242024 229906 271209 195576 105229 Variance Amount 2019 2018 2017 2016 2015 136795 124677 165980 90347 Net Income Dunkin% 2019 2018 2017 2016 2015 1.2999743416738732 1.1848159727831682 1.5773218409373841 0.85857510762242351 0
Hortizonal Analysis of Net Revenue for Dachshund
Net Revenue: 2019 2018 2017 8251000 6165000 3576976 Net Revenue % 2019 2018 2017 2.3066970536005833 1.7235228863710577 1
