Celsius Holdings, Inc. (CELH) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Celsius Holdings, Inc. (CELH) Bundle
Whether you’re an investor or analyst, this Celsius Holdings, Inc. (CELH) DCF Calculator is your go-to resource for accurate valuation. Featuring real data from Celsius Holdings, Inc., you can adjust forecasts and observe the effects in real-time.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 75.1 | 130.7 | 314.3 | 653.6 | 1,318.0 | 2,550.2 | 4,934.4 | 9,547.7 | 18,473.8 | 35,745.0 |
| Revenue Growth, % | 0 | 73.96 | 140.41 | 107.97 | 101.65 | 93.49 | 93.49 | 93.49 | 93.49 | 93.49 |
| EBITDA | 12.3 | 9.5 | -2.8 | -157.8 | 269.6 | 97.0 | 187.7 | 363.2 | 702.8 | 1,359.8 |
| EBITDA, % | 16.31 | 7.28 | -0.88704 | -24.14 | 20.45 | 3.8 | 3.8 | 3.8 | 3.8 | 3.8 |
| Depreciation | .9 | 2.1 | 1.3 | 1.9 | 3.2 | 18.9 | 36.6 | 70.9 | 137.1 | 265.3 |
| Depreciation, % | 1.19 | 1.58 | 0.40195 | 0.2933 | 0.24476 | 0.74207 | 0.74207 | 0.74207 | 0.74207 | 0.74207 |
| EBIT | 11.4 | 7.5 | -4.1 | -159.7 | 266.4 | 78.1 | 151.1 | 292.4 | 565.7 | 1,094.6 |
| EBIT, % | 15.12 | 5.7 | -1.29 | -24.44 | 20.21 | 3.06 | 3.06 | 3.06 | 3.06 | 3.06 |
| Total Cash | 23.1 | 43.2 | 16.3 | 614.2 | 756.0 | 1,123.7 | 2,174.2 | 4,206.8 | 8,139.8 | 15,749.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 9.0 | 16.9 | 41.3 | 66.3 | 186.0 | 317.4 | 614.1 | 1,188.3 | 2,299.3 | 4,448.9 |
| Account Receivables, % | 11.92 | 12.91 | 13.15 | 10.14 | 14.11 | 12.45 | 12.45 | 12.45 | 12.45 | 12.45 |
| Inventories | 15.3 | 18.4 | 191.2 | 173.3 | 229.3 | 709.9 | 1,373.6 | 2,657.7 | 5,142.5 | 9,950.2 |
| Inventories, % | 20.35 | 14.08 | 60.85 | 26.51 | 17.4 | 27.84 | 27.84 | 27.84 | 27.84 | 27.84 |
| Accounts Payable | 10.2 | 11.9 | 35.8 | 36.2 | 42.8 | 218.2 | 422.2 | 816.9 | 1,580.7 | 3,058.5 |
| Accounts Payable, % | 13.52 | 9.07 | 11.4 | 5.55 | 3.25 | 8.56 | 8.56 | 8.56 | 8.56 | 8.56 |
| Capital Expenditure | -.1 | -.6 | -3.2 | -8.3 | -17.4 | -21.1 | -40.8 | -78.9 | -152.7 | -295.4 |
| Capital Expenditure, % | -0.10376 | -0.4389 | -1 | -1.26 | -1.32 | -0.82643 | -0.82643 | -0.82643 | -0.82643 | -0.82643 |
| Tax Rate, % | 22.26 | 22.26 | 22.26 | 22.26 | 22.26 | 22.26 | 22.26 | 22.26 | 22.26 | 22.26 |
| EBITAT | 11.4 | 7.4 | 3.9 | -195.9 | 207.1 | 58.8 | 113.7 | 220.1 | 425.9 | 824.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1.9 | -.5 | -171.3 | -208.9 | 23.7 | -380.0 | -646.8 | -1,251.6 | -2,421.7 | -4,685.7 |
| WACC, % | 13.16 | 13.16 | 13.15 | 13.16 | 13.16 | 13.15 | 13.15 | 13.15 | 13.15 | 13.15 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -5,707.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -4,779 | |||||||||
| Terminal Value | -42,845 | |||||||||
| Present Terminal Value | -23,096 | |||||||||
| Enterprise Value | -28,804 | |||||||||
| Net Debt | -754 | |||||||||
| Equity Value | -28,050 | |||||||||
| Diluted Shares Outstanding, MM | 237 | |||||||||
| Equity Value Per Share | -118.37 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled actual CELH financials.
- Authentic Data: Historical figures and forward-looking projections (highlighted in the yellow cells).
- Forecast Customization: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs influence Celsius Holdings' valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Layout: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Authentic Celsius Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells for WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Users: An easy-to-navigate layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based CELH DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically recalculate Celsius Holdings’ intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation impacts.
- Analyze and Decide: Leverage the results to inform your investment or financial decisions.
Why Choose This Calculator for Celsius Holdings, Inc. (CELH)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: Celsius's historical and projected financials preloaded for reliable analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Detailed step-by-step instructions to assist you throughout the process.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Celsius Holdings, Inc. (CELH) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Celsius Holdings, Inc. (CELH).
- Consultants: Deliver professional valuation insights on Celsius Holdings, Inc. (CELH) to clients quickly and accurately.
- Business Owners: Understand how companies like Celsius Holdings, Inc. (CELH) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Celsius Holdings, Inc. (CELH).
What the Template Contains
- Preloaded CELH Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.