Sweetgreen, Inc. (SG) 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
Sweetgreen, Inc. (SG) Bundle
Evaluate Sweetgreen, Inc.'s (SG) financial outlook like an expert! This (SG) DCF Calculator provides pre-filled financial data and offers total flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
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 | 274.2 | 220.6 | 339.9 | 470.1 | 584.0 | 725.8 | 901.9 | 1,120.9 | 1,392.9 | 1,731.0 |
| Revenue Growth, % | 0 | -19.53 | 54.06 | 38.32 | 24.24 | 24.27 | 24.27 | 24.27 | 24.27 | 24.27 |
| EBITDA | -48.4 | -114.0 | -117.4 | -142.5 | -53.4 | -208.0 | -258.5 | -321.3 | -399.3 | -496.2 |
| EBITDA, % | -17.66 | -51.66 | -34.54 | -30.32 | -9.14 | -28.66 | -28.66 | -28.66 | -28.66 | -28.66 |
| Depreciation | 19.4 | 26.9 | 35.5 | 74.9 | 59.5 | 81.0 | 100.7 | 125.2 | 155.5 | 193.3 |
| Depreciation, % | 7.08 | 12.17 | 10.46 | 15.94 | 10.19 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 |
| EBIT | -67.8 | -140.8 | -152.9 | -217.5 | -112.9 | -289.1 | -359.3 | -446.5 | -554.8 | -689.5 |
| EBIT, % | -24.74 | -63.83 | -45 | -46.26 | -19.33 | -39.83 | -39.83 | -39.83 | -39.83 | -39.83 |
| Total Cash | 249.3 | 102.6 | 472.0 | 331.6 | 257.2 | 511.0 | 635.0 | 789.1 | 980.7 | 1,218.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5.0 | 6.6 | 19.3 | 3.2 | 3.5 | 17.1 | 21.3 | 26.4 | 32.8 | 40.8 |
| Account Receivables, % | 1.82 | 3 | 5.69 | 0.69006 | 0.59962 | 2.36 | 2.36 | 2.36 | 2.36 | 2.36 |
| Inventories | .8 | .6 | .9 | 1.4 | 2.1 | 2.2 | 2.7 | 3.4 | 4.2 | 5.2 |
| Inventories, % | 0.30312 | 0.28103 | 0.26569 | 0.29419 | 0.35426 | 0.29966 | 0.29966 | 0.29966 | 0.29966 | 0.29966 |
| Accounts Payable | 8.3 | 6.2 | 11.2 | 12.2 | 17.4 | 21.4 | 26.6 | 33.0 | 41.0 | 51.0 |
| Accounts Payable, % | 3.04 | 2.82 | 3.29 | 2.6 | 2.98 | 2.95 | 2.95 | 2.95 | 2.95 | 2.95 |
| Capital Expenditure | -44.7 | -56.9 | -92.8 | -102.3 | -95.8 | -156.1 | -194.0 | -241.1 | -299.6 | -372.3 |
| Capital Expenditure, % | -16.3 | -25.79 | -27.3 | -21.75 | -16.4 | -21.51 | -21.51 | -21.51 | -21.51 | -21.51 |
| Tax Rate, % | -0.33538 | -0.33538 | -0.33538 | -0.33538 | -0.33538 | -0.33538 | -0.33538 | -0.33538 | -0.33538 | -0.33538 |
| EBITAT | -67.4 | -141.0 | -153.1 | -219.0 | -113.3 | -288.8 | -358.8 | -445.9 | -554.2 | -688.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -90.2 | -174.5 | -218.4 | -229.7 | -145.4 | -373.5 | -451.6 | -561.2 | -697.4 | -866.7 |
| WACC, % | 14.61 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,884.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -884 | |||||||||
| Terminal Value | -7,007 | |||||||||
| Present Terminal Value | -3,543 | |||||||||
| Enterprise Value | -5,427 | |||||||||
| Net Debt | 46 | |||||||||
| Equity Value | -5,473 | |||||||||
| Diluted Shares Outstanding, MM | 112 | |||||||||
| Equity Value Per Share | -48.91 |
What You Will Get
- Real Sweetgreen Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Sweetgreen, Inc. (SG).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Sweetgreen.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Sweetgreen’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Sweetgreen, Inc. (SG).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Sweetgreen.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Sweetgreen, Inc. (SG).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Sweetgreen.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates according to Sweetgreen's performance.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Sweetgreen, Inc. (SG).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Sweetgreen, Inc. (SG) Excel file.
- Step 2: Review Sweetgreen’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Analyze the outputs and utilize the results for investment decisions.
Why Choose This Calculator?
- Designed for Industry Experts: A specialized tool utilized by analysts, CFOs, and financial consultants.
- Accurate Financial Data: Sweetgreen’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Investors: Evaluate Sweetgreen’s valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts.
- Startup Founders: Discover how leading public companies like Sweetgreen are valued.
- Consultants: Provide comprehensive valuation reports for your clients.
- Students and Educators: Utilize real-world data to practice and teach valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Sweetgreen historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Sweetgreen, Inc. (SG).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.