| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||
2 | 1 | Ticker | celh | Celsius Holdings Inc CELH | End Year | 31Dec | Sector | Consumer Defensive | Industry | Beverages - Non-Alcoholic | ||||||||||||||||
3 | Prev | Prev | Mid Growth | Celsius Holdings plays in the energy drink subsegment of the global nonalcoholic beverage market, with 96% of revenue concentrated in North America. Celsius’ products contain natural ingredients and a metabolism-enhancing formulation, appealing to fitness and active lifestyle enthusiasts. The firm’s portfolio includes its namesake Celsius Originals beverages (including those that are naturally caffeinated with stevia), Celsius Essentials line (containing aminos), and Celsius On-the-Go powder packets. Celsius dedicates its efforts to branding and innovation, while it utilizes third parties for the manufacturing, packaging, and distribution of its products. In 2022, Celsius forged a 20-year distribution agreement with PepsiCo, which holds an 8.5% stake in the business. | <-Desc | |||||||||||||||||||||
4 | Current Price | 63.28 | M* IV | 36.00 | CFRA 12-PX | 65.00 | DateDone | 20-Jun | Done Px | 63.28 | ||||||||||||||||
5 | MktCap | 14.75 | bn | M* Rating | *** | CFRA * | *** | Sheet Ver | 4-May | 41 | Earning Date | Earning Date | ||||||||||||||
6 | 5* Px | $18.00 | HOLD | Major | Minor | 7-May | 5-Aug-2024 - 8-Aug-2024 | |||||||||||||||||||
7 | 1 | 1. Data Collection | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | TTM/2024 | Avg-10 | Avg-5 | ||||||||||
8 | fY | Total Asset Dump | 4951204 | 15265870 | 17717122 | 27110873 | 34627507 | 90382236 | 131289773 | 314018428 | 1222069000 | 1536396000 | 1646140000 | |||||||||||||
9 | Current Liabilities Dump | 1365054 | 2021835 | 2322485 | 6463628 | 14865144 | 26683399 | 26365092 | 93123494 | 161295000 | 276613000 | 315269000 | ||||||||||||||
10 | LT Debt Dump | 10750000 | 4500000 | 4500000 | 3500000 | 7959381 | 239848 | 597238 | 703343 | 488000 | 1148000 | 1095000 | ||||||||||||||
11 | Total Equity Dump | -7163850 | 8744035 | 10894637 | 17147245 | 11802982 | 63458989 | 104327443 | 217045197 | 864579000 | 1088528000 | 1162679000 | ||||||||||||||
12 | Total Rev Dump | 14610090 | 17217944 | 22760987 | 36164064 | 52603986 | 75146546 | 130725777 | 314271559 | 653604000 | 1318014000 | 1413783000 | <-ttm | |||||||||||||
13 | EBIT Dump | -1529933 | -1827460 | -2844960 | -8079967 | -10640744 | -1448443 | 7829500 | -4089516 | -157801000 | 266366000 | 304643000 | ||||||||||||||
14 | Net Income Dump | -2160972 | -2570297 | -3433769 | -8606578 | -11419781 | 10559323 | 8523849 | 3937273 | -198808000 | 182405000 | 215844000 | <-ttm | |||||||||||||
15 | Shares Outstanding Dump | 61177782 | 99527478 | 115704264 | 133257486 | 150152088 | 192550197 | 223330803 | 233065503 | 226947000 | 236964000 | 237275500 | <-TTM | |||||||||||||
16 | ||||||||||||||||||||||||||
17 | fY | Long Term Debt | 11 | 5 | 5 | 4 | 8 | 0 | 1 | 1 | 0 | 1 | 1 | <-TTM | ||||||||||||
18 | fY | Total Revenue | 11 | 15 | 17 | 23 | 36 | 53 | 75 | 131 | 314 | 654 | 1318 | 1414 | <-TTM | |||||||||||
19 | fY | Net Income (diluted) | -2 | -3 | -3 | -9 | -11 | 11 | 9 | 4 | -199 | 182 | 216 | <-TTM | ||||||||||||
20 | fY | Diluted EPS | -0.03 | -0.03 | -0.02 | -0.03 | -0.06 | -0.08 | 0.05 | 0.04 | 0.02 | -0.88 | 0.77 | 0.91 | <-TTM | |||||||||||
21 | fY | Shares Outstanding | 61 | 100 | 116 | 133 | 150 | 193 | 223 | 233 | 227 | 237 | 237 | <-TTM | ||||||||||||
22 | calc | Shares Growth / Shrink | Begin | 61 | End | 237 | Change | 287.85% | ||||||||||||||||||
23 | ||||||||||||||||||||||||||
24 | 2 | 2. Data Collection | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Current | Avg-10 | Avg-5 | Pre-Pandemic | Ori-Avg10 | Ori-Avg5 | |||||||
25 | cy | P/S | –– | –– | 4.54 | 6.73 | 3.59 | 4.36 | 30.73 | 23.56 | 14.19 | 11.13 | 10.62 | 12.16 | 15.77 | <-P/S | 4.81 | |||||||||
26 | cy | P/E | –– | –– | –– | –– | –– | 28.41 | –– | 113.58 | 69.79 | 70.59 | 70.59 | <-P/E | 28.41 | 345.64 | 345.64 | 838.50 | 677.90 | |||||||
27 | cy | P/Book | –– | –– | 13.18 | 11.16 | 17.34 | 5.25 | 36.34 | 28.24 | 133.38 | 59.20 | 43.61 | 38.63 | 51.00 | <-P/B | 11.73 | |||||||||
28 | cy | P/E FWD | –– | –– | –– | –– | –– | –– | 228.68 | 102.15 | 99.27 | 55.35 | 57.22 | 108.53 | 108.53 | <-P/E FWD | #DIV/0! | |||||||||
29 | cy | PEG | –– | –– | –– | –– | –– | –– | –– | 8.13 | –– | 0.60 | 0.42 | 3.05 | 3.05 | <-PEG | #DIV/0! | |||||||||
30 | cy | EV/EBITDA | – | –– | –– | –– | –– | 26.16 | –– | 71.87 | 47.86 | 48.63 | 48.63 | <- EV/EBITDA | 26.16 | 216.28 | 216.28 | 429.91 | 505.62 | |||||||
31 | - | Current | P/B | 43.67 | P/S | 10.62 | P/E | 69.54 | As of Jun 18, 2024 | |||||||||||||||||
32 | Normalized | 67.8 | ||||||||||||||||||||||||
33 | - | Debt Ratios | Quick Ratio | 3.43 | Current Ratio | 4.17 | Interest Coverage | - | Debt/Eq | 0.01 | Debt/NI | 0.01 | years | |||||||||||||
34 | ||||||||||||||||||||||||||
35 | calc | LT Debt/Net Income | -4.97 | -1.75 | -1.31 | -0.41 | -0.70 | 0.02 | 0.07 | 0.18 | 0.00 | 0.01 | 0.01 | <<- How many years of NI is the debt | ||||||||||||
36 | ||||||||||||||||||||||||||
37 | fY | Growth | 8-10 yr | 5 yrs | 3 yrs | 1 yr | CAGR | Pre 2014-2019 | Post 2020-TTM | Additional | 2011 | 2012 | 2013 | |||||||||||||
38 | fY | Revenue, Smoothing | 61.96 | 58.60% | 90.45 | 83.23% | 116.03 | 86.71% | 101.65 | Rev, Smoothing | 38.76% | 34.94% | 104.65% | 81.96% | Revenue | 8.00 | 11.00 | |||||||||
39 | ||||||||||||||||||||||||||
40 | EPS, Smoothing | 175.89 | 93.75% | EPS, Smoothing | -210.76% | -10.87% | 98.10% | 56.02% | EPS | -0.05 | -0.03 | |||||||||||||||
41 | ||||||||||||||||||||||||||
42 | Using Actuals as the centre | Smoothing | Smoothing | Smoothing | Pre-Covid | Post Covid | ||||||||||||||||||||
43 | Smoothing | Smoothing | ||||||||||||||||||||||||
44 | 3 | 3. Data Collection | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | TTM/2024 | TTM | Avg-10 | Avg-5 | Pre-Pandemic | Ori-Avg10 | Ori-Avg5 | ||||||
45 | fY | Gross Margin | 38.32 | 40.89 | 42.75 | 42.67 | 40.04 | 41.65 | 46.64 | 40.78 | 41.44 | 48.04 | 49.62 | <- Current | Gross | 41.05 | ||||||||||
46 | fY | Operating Margin | -10.47 | -10.61 | -12.50 | -22.34 | -20.23 | -1.93 | 5.99 | -1.30 | -24.14 | 20.21 | 21.55 | <- Current | Operating | -13.01 | ||||||||||
47 | fY | Net Margin | -14.79 | -14.93 | -15.09 | -23.80 | -21.71 | 13.27 | 6.52 | 1.25 | -30.42 | 13.81 | 15.23 | <- Current | Net Margin | -12.84 | ||||||||||
48 | ||||||||||||||||||||||||||
49 | fY | ROA | -54.15 | -25.43 | -20.82 | -38.40 | -36.99 | 15.95 | 7.69 | 1.77 | -25.89 | 13.20 | 14.66 | <- Current | -13.49 | 4.56 | ROA | -26.64 | ||||||||
50 | fY | ROE | — | -325.32 | -34.97 | -61.38 | -78.89 | 26.50 | 10.16 | 2.45 | -154.63 | 119.68 | 102.73 | <- Current | -39.37 | 17.82 | ROE | -94.81 | ||||||||
51 | fY | ROIC | — | -26.71 | -22.38 | -46.87 | -55.59 | 21.53 | 10.29 | 2.29 | -156.45 | 104.88 | 90.29 | <- Current | -7.87 | 12.14 | ROIC | -26.00 | ||||||||
52 | ROCE via Asset EBIT/(TA-CL) | -42.66 | -13.80 | -18.48 | -39.13 | -53.84 | -2.27 | 7.46 | -1.85 | -14.88 | 21.14 | 22.89 | -12.31 | 5.42 | ROCE 1 | -28.37 | ||||||||||
53 | ||||||||||||||||||||||||||
54 | 10 yr | with Smooth | 5 yr | with Smooth | 3 yr | with Smooth | yoy | |||||||||||||||||||
55 | fY | Book Value per Share | -0.11 | -0.05 | 0.06 | 0.16 | 0.06 | 0.31 | 0.46 | 0.88 | 0.26 | 0.92 | 1.13 | BV, Smoothing | -226.62% | -228.61% | 72.63% | 34.24% | 25.99% | 11.87% | 253.85% | |||||
56 | fY | FCF per share | -0.05 | -0.04 | -0.04 | -0.03 | -0.10 | -0.02 | 0.02 | -0.24 | 0.52 | 0.24 | 0.52 | FCF, Smoothing | -219.04% | -228.39% | -219.14% | -253.54% | 128.94% | -274.72% | -53.85% | |||||
57 | FCF/SALES % | -20.07 | -4.45 | -10.52 | -23.41 | -22.35 | 1.27 | 2.16 | -31.74 | 15.29 | 9.39 | 19.10 | -5.94 | 2.58 | FCF/SALES % | -13.26 | ||||||||||
58 | fY | EBITDA (M) | -1.49 | -1.79 | -2.82 | -8.06 | -10.95 | 12.26 | 11.40 | -2.79 | -150.75 | 269.59 | 308.55 | |||||||||||||
59 | ||||||||||||||||||||||||||
60 | calc | Dividend Growth | Begin | 10yr | 5 year | |||||||||||||||||||||
61 | Dividend Yield | |||||||||||||||||||||||||
62 | Buy Yield | |||||||||||||||||||||||||
63 | calc | Total Yield | ||||||||||||||||||||||||
64 | Payout Ratio | |||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||
66 | 4 | 4. Level I Estimates of Growth, Multiples and EPS | ||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||
68 | EPS Y! | This Q | Next Q | This Y | Next Y | RevGrowth Y! | This | Next | EPS Growth Y! | Industry | Sector | S&P | ||||||||||||||
69 | No. of Analysts | 13 | 13 | 14 | 14 | 28.10% | 28.10% | Current Qtr. | 41.20% | -- | -- | 8.30% | ||||||||||||||
70 | Avg. Estimate | 0.24 | 0.31 | 1.07 | 1.41 | Next Qtr. | 3.30% | -- | -- | 11.10% | ||||||||||||||||
71 | Low Estimate | 0.19 | 0.27 | 1 | 1.24 | Current Year | 39.00% | -- | -- | 5.10% | ||||||||||||||||
72 | High Estimate | 0.31 | 0.37 | 1.22 | 1.64 | Next Year | 31.80% | -- | -- | 12.10% | ||||||||||||||||
73 | Year Ago EPS | 0.17 | 0.3 | 0.77 | 1.07 | Next 5 Years (per annum) | 32.50% | -- | -- | 11.47% | ||||||||||||||||
74 | Past 5 Years (per annum) | 131.02% | -- | -- | -- | |||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | EPS Seeking Alpha | EPS Growth Seeking Alpha | Growth | Sector | % Diff. to Sector | 5 yr Avg | % Diff. to 5Y Avg. | |||||||||||||||||||
77 | Period | EPS Est | FWD P/E | Low | High | # of Analysts | EPS Diluted Growth (YoY) | NM | 8.90% | NM | NM | NM | ||||||||||||||
78 | Dec 2024 | 1.06 | 59.47 | 0.89 | 1.22 | 15 | EPS Diluted Growth (FWD) | NM | 6.97% | NM | 136.31% | NM | ||||||||||||||
79 | Dec 2025 | 1.44 | 43.96 | 1.24 | 2 | 16 | EPS GAAP Growth (YoY) | NM | 11.93% | NM | - | - | ||||||||||||||
80 | EPS GAAP Growth (FWD) | NM | 10.43% | NM | - | - | ||||||||||||||||||||
81 | EPS FWD Long Term Growth (3-5Y CAGR) | - | 8.13% | - | - | - | ||||||||||||||||||||
82 | EPS CFRA | Analysts | ||||||||||||||||||||||||
83 | Year | EPS | Year | Est | High | Low | # of Est. | Est P/E | ||||||||||||||||||
84 | This | 1.10 | 2025 | 1.49 | 1.64 | 1.33 | 7 | 41.53 | FINWIZ EPS Growth | |||||||||||||||||
85 | Next | 1.50 | 2024 | 1.11 | 1.22 | 1.01 | 7 | 56.00 | This FY | Next | Next 5 | Past 5 Years | Sales past5 | |||||||||||||
86 | 37.42% | 31.92% | 32.50% | - | 93.37% | |||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | Tikr | VI IO | ||||||||||||||||||||||||
89 | Year | EPS | CAGR 2Yr | %Growth | Year | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2&3 Yr CAGR | ||||||||||||||
90 | This | 1.10 | REV | 29.50% | Revenue | 0.3B | 0.7B | 1.3B | 1.7B | 2.2B | 2.8B | |||||||||||||||
91 | Next | 1.48 | EPS | 37.30% | <-%! | Rev Growth | 140.50% | 108.00% | 101.70% | 29.60% | 28.60% | 28.70% | 28.97% | |||||||||||||
92 | EPS | 0.00 | -$0.80 | 1 | 1.1 | 1.5 | 1.9 | |||||||||||||||||||
93 | EPS Growth | -54.10% | -4902.60% | -221.10% | 13.20% | 31.60% | 29.10% | 23.86% | ||||||||||||||||||
94 | MS | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 3 Yr CAGR | 24.63% | |||||||||||||||||
95 | Revenue | 314 | 654 | 1,318 | 1,688 | 2,209 | 2,940 | |||||||||||||||||||
96 | Growth | 28.07% | 30.86% | 33.09% | 30.66% | 30.68% | Rev Gwth | Past 10 | Past 5 | Past 3 | This | Next | Long Term | Mgmt | Pre-Covid-5 | |||||||||||
97 | EPS | 0.02 | -0.88 | 0.77 | 1.06 | 1.44 | 1.98 | Smooth | 58.60% | 83.23% | 86.71% | 28.57% | 29.29% | 29.31% | 34.94% | |||||||||||
98 | Growth | 38.18% | 35.24% | 37.39% | 36.93% | 36.94% | Actual | 61.96% | 90.45% | 116.03% | MGMT-> | 38.76% | ||||||||||||||
99 | ||||||||||||||||||||||||||
100 | EPS | Last Yr | TTM | This | Next | Mgmt Min | Max | Est |