Allbirds, Inc. (BIRD) 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
Allbirds, Inc. (BIRD) Bundle
Evaluate Allbirds, Inc.'s (BIRD) financial outlook like an expert! This (BIRD) DCF Calculator provides pre-filled financial data while allowing you complete flexibility to modify revenue growth, WACC, margins, and other essential 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 | 193.7 | 219.3 | 277.5 | 297.8 | 254.1 | 274.6 | 296.9 | 320.9 | 346.9 | 375.0 |
Revenue Growth, % | 0 | 13.23 | 26.53 | 7.31 | -14.68 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 |
EBITDA | -7.4 | -22.6 | -34.4 | -83.9 | -97.8 | -51.2 | -55.3 | -59.8 | -64.7 | -69.9 |
EBITDA, % | -3.81 | -10.3 | -12.38 | -28.19 | -38.51 | -18.64 | -18.64 | -18.64 | -18.64 | -18.64 |
Depreciation | 3.4 | 7.1 | 10.2 | 16.2 | 21.0 | 12.3 | 13.3 | 14.4 | 15.5 | 16.8 |
Depreciation, % | 1.74 | 3.23 | 3.68 | 5.44 | 8.27 | 4.47 | 4.47 | 4.47 | 4.47 | 4.47 |
EBIT | -10.8 | -29.7 | -44.6 | -100.1 | -118.9 | -63.5 | -68.6 | -74.2 | -80.2 | -86.7 |
EBIT, % | -5.55 | -13.53 | -16.06 | -33.63 | -46.78 | -23.11 | -23.11 | -23.11 | -23.11 | -23.11 |
Total Cash | 74.3 | 126.6 | 288.6 | 167.1 | 130.0 | 166.6 | 180.1 | 194.7 | 210.5 | 227.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 11.1 | 23.7 | 11.0 | 9.2 | 8.2 | 14.7 | 15.9 | 17.2 | 18.6 | 20.1 |
Account Receivables, % | 5.74 | 10.81 | 3.96 | 3.09 | 3.22 | 5.36 | 5.36 | 5.36 | 5.36 | 5.36 |
Inventories | 44.3 | 59.2 | 106.9 | 116.8 | 57.8 | 82.6 | 89.3 | 96.5 | 104.3 | 112.8 |
Inventories, % | 22.89 | 27.01 | 38.52 | 39.22 | 22.74 | 30.07 | 30.07 | 30.07 | 30.07 | 30.07 |
Accounts Payable | 29.8 | 20.2 | 30.7 | 12.2 | 5.9 | 23.1 | 25.0 | 27.0 | 29.2 | 31.6 |
Accounts Payable, % | 15.4 | 9.23 | 11.07 | 4.11 | 2.3 | 8.42 | 8.42 | 8.42 | 8.42 | 8.42 |
Capital Expenditure | -13.1 | -14.4 | -24.2 | -31.4 | -10.9 | -20.2 | -21.9 | -23.6 | -25.6 | -27.6 |
Capital Expenditure, % | -6.78 | -6.54 | -8.71 | -10.53 | -4.28 | -7.37 | -7.37 | -7.37 | -7.37 | -7.37 |
Tax Rate, % | -0.21956 | -0.21956 | -0.21956 | -0.21956 | -0.21956 | -0.21956 | -0.21956 | -0.21956 | -0.21956 | -0.21956 |
EBITAT | -14.4 | -25.6 | -45.4 | -101.4 | -119.1 | -61.7 | -66.7 | -72.1 | -78.0 | -84.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -49.8 | -69.9 | -83.8 | -143.1 | -55.3 | -83.8 | -81.3 | -87.9 | -95.0 | -102.7 |
WACC, % | 12.2 | 12.15 | 12.2 | 12.2 | 12.2 | 12.19 | 12.19 | 12.19 | 12.19 | 12.19 |
PV UFCF | ||||||||||
SUM PV UFCF | -319.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -105 | |||||||||
Terminal Value | -1,029 | |||||||||
Present Terminal Value | -579 | |||||||||
Enterprise Value | -898 | |||||||||
Net Debt | -36 | |||||||||
Equity Value | -862 | |||||||||
Diluted Shares Outstanding, MM | 152 | |||||||||
Equity Value Per Share | -5.68 |
What You Will Get
- Pre-Filled Financial Model: Allbirds' actual data provides an accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates ensure you see results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, allowing for repeated use in detailed forecasts.
Key Features
- Real-Life BIRD Data: Pre-filled with Allbirds’ historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop multiple forecast scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and tailored for both professionals and novices.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Allbirds, Inc.'s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions regarding Allbirds, Inc. (BIRD).
Why Choose This Calculator for Allbirds, Inc. (BIRD)?
- Designed for Experts: A sophisticated tool favored by financial analysts, CFOs, and industry consultants.
- Accurate Data: Allbirds’ historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use Allbirds, Inc. (BIRD)?
- Eco-Conscious Consumers: Choose sustainable footwear that aligns with your values.
- Fashion Enthusiasts: Enjoy stylish designs that are both trendy and comfortable.
- Outdoor Adventurers: Experience versatile shoes that perform well in various environments.
- Health and Wellness Advocates: Benefit from shoes that prioritize comfort and foot health.
- Retailers: Explore innovative products that attract a growing market of sustainable shoppers.
What the Template Contains
- Preloaded BIRD 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.