Zevia PBC (ZVIA) 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
Zevia PBC (ZVIA) Bundle
Explore Zevia PBC's (ZVIA) financial prospects with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and expenses to calculate Zevia PBC's (ZVIA) intrinsic value and enhance your investment strategy.
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 | 85.6 | 110.0 | 138.2 | 163.2 | 166.4 | 197.3 | 234.0 | 277.4 | 328.9 | 389.9 |
Revenue Growth, % | 0 | 28.59 | 25.58 | 18.1 | 1.99 | 18.57 | 18.57 | 18.57 | 18.57 | 18.57 |
EBITDA | -4.7 | -4.5 | -86.1 | -45.6 | -27.3 | -45.9 | -54.4 | -64.5 | -76.5 | -90.7 |
EBITDA, % | -5.46 | -4.13 | -62.29 | -27.93 | -16.42 | -23.25 | -23.25 | -23.25 | -23.25 | -23.25 |
Depreciation | .8 | 1.4 | 1.6 | 2.0 | 1.6 | 2.2 | 2.6 | 3.1 | 3.7 | 4.3 |
Depreciation, % | 0.91863 | 1.31 | 1.13 | 1.23 | 0.97041 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
EBIT | -5.5 | -6.0 | -87.6 | -47.6 | -28.9 | -48.1 | -57.0 | -67.6 | -80.1 | -95.0 |
EBIT, % | -6.37 | -5.44 | -63.42 | -29.16 | -17.39 | -24.36 | -24.36 | -24.36 | -24.36 | -24.36 |
Total Cash | 3.2 | 14.9 | 73.1 | 47.4 | 32.0 | 46.8 | 55.5 | 65.8 | 78.0 | 92.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4.9 | 6.9 | 9.0 | 11.1 | 11.1 | 12.6 | 15.0 | 17.8 | 21.1 | 25.0 |
Account Receivables, % | 5.7 | 6.31 | 6.55 | 6.79 | 6.68 | 6.41 | 6.41 | 6.41 | 6.41 | 6.41 |
Inventories | 11.4 | 20.8 | 31.5 | 27.6 | 34.6 | 36.6 | 43.4 | 51.4 | 61.0 | 72.3 |
Inventories, % | 13.31 | 18.9 | 22.8 | 16.9 | 20.76 | 18.54 | 18.54 | 18.54 | 18.54 | 18.54 |
Accounts Payable | 5.6 | 9.0 | 13.5 | 8.0 | 21.2 | 16.6 | 19.7 | 23.4 | 27.7 | 32.8 |
Accounts Payable, % | 6.54 | 8.15 | 9.76 | 4.92 | 12.72 | 8.42 | 8.42 | 8.42 | 8.42 | 8.42 |
Capital Expenditure | -.5 | -.8 | -3.1 | -2.6 | -1.6 | -2.4 | -2.9 | -3.4 | -4.0 | -4.8 |
Capital Expenditure, % | -0.53295 | -0.73165 | -2.27 | -1.59 | -0.97582 | -1.22 | -1.22 | -1.22 | -1.22 | -1.22 |
Tax Rate, % | 23.97 | 23.97 | 23.97 | 23.97 | 23.97 | 23.97 | 23.97 | 23.97 | 23.97 | 23.97 |
EBITAT | -5.5 | -6.0 | -87.7 | -47.6 | -22.0 | -45.8 | -54.3 | -64.3 | -76.3 | -90.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -15.8 | -13.5 | -97.5 | -51.8 | -15.9 | -54.1 | -60.6 | -71.8 | -85.1 | -100.9 |
WACC, % | 7.45 | 7.45 | 7.45 | 7.45 | 7.44 | 7.45 | 7.45 | 7.45 | 7.45 | 7.45 |
PV UFCF | ||||||||||
SUM PV UFCF | -295.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -103 | |||||||||
Terminal Value | -1,890 | |||||||||
Present Terminal Value | -1,320 | |||||||||
Enterprise Value | -1,615 | |||||||||
Net Debt | -30 | |||||||||
Equity Value | -1,585 | |||||||||
Diluted Shares Outstanding, MM | 51 | |||||||||
Equity Value Per Share | -31.31 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real Zevia PBC (ZVIA) financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Zevia's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for Zevia PBC (ZVIA).
- WACC Calculator: Includes a pre-structured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily alter growth projections, capital investments, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Zevia PBC (ZVIA).
- Interactive Dashboard and Charts: Visual representations that highlight essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Zevia’s data included.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Zevia’s intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Zevia PBC (ZVIA)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
- Accurate Data: Zevia’s historical and projected financials are preloaded to ensure precision.
- Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Zevia PBC (ZVIA) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Zevia PBC (ZVIA).
- Consultants: Deliver professional valuation insights on Zevia PBC (ZVIA) to clients quickly and accurately.
- Business Owners: Understand how companies like Zevia PBC (ZVIA) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Zevia PBC (ZVIA).
What the Zevia Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations specific to Zevia PBC (ZVIA).
- Real-World Data: Zevia’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results tailored to Zevia PBC (ZVIA).