ThredUp Inc. (TDUP) 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
ThredUp Inc. (TDUP) Bundle
Looking to determine the intrinsic value of ThredUp Inc.? Our (TDUP) DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your projections and enhance your investment choices.
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 | 163.8 | 186.0 | 251.8 | 288.4 | 322.0 | 382.5 | 454.3 | 539.6 | 641.0 | 761.3 |
| Revenue Growth, % | 0 | 13.55 | 35.36 | 14.53 | 11.67 | 18.78 | 18.78 | 18.78 | 18.78 | 18.78 |
| EBITDA | -32.5 | -36.9 | -47.7 | -70.9 | -43.9 | -74.1 | -88.0 | -104.5 | -124.1 | -147.4 |
| EBITDA, % | -19.81 | -19.84 | -18.94 | -24.6 | -13.63 | -19.36 | -19.36 | -19.36 | -19.36 | -19.36 |
| Depreciation | 4.3 | 9.6 | 13.1 | 20.5 | 25.1 | 21.3 | 25.3 | 30.1 | 35.8 | 42.5 |
| Depreciation, % | 2.61 | 5.17 | 5.22 | 7.11 | 7.79 | 5.58 | 5.58 | 5.58 | 5.58 | 5.58 |
| EBIT | -36.7 | -46.5 | -60.8 | -91.4 | -69.0 | -95.4 | -113.3 | -134.6 | -159.9 | -189.9 |
| EBIT, % | -22.42 | -25.01 | -24.16 | -31.71 | -21.42 | -24.94 | -24.94 | -24.94 | -24.94 | -24.94 |
| Total Cash | 85.6 | 64.5 | 205.8 | 104.9 | 64.2 | 172.1 | 204.4 | 242.8 | 288.4 | 342.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2.9 | 1.8 | 4.1 | 4.7 | 7.8 | 6.4 | 7.7 | 9.1 | 10.8 | 12.8 |
| Account Receivables, % | 1.76 | 0.98003 | 1.64 | 1.62 | 2.43 | 1.69 | 1.69 | 1.69 | 1.69 | 1.69 |
| Inventories | 3.9 | 3.5 | 9.8 | 17.5 | 15.7 | 14.6 | 17.4 | 20.6 | 24.5 | 29.1 |
| Inventories, % | 2.38 | 1.89 | 3.9 | 6.07 | 4.87 | 3.82 | 3.82 | 3.82 | 3.82 | 3.82 |
| Accounts Payable | 14.2 | 23.1 | 13.3 | 7.8 | 9.5 | 24.5 | 29.1 | 34.6 | 41.0 | 48.8 |
| Accounts Payable, % | 8.66 | 12.42 | 5.3 | 2.7 | 2.94 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 |
| Capital Expenditure | -9.5 | -19.4 | -19.8 | -43.3 | -16.0 | -33.7 | -40.1 | -47.6 | -56.5 | -67.1 |
| Capital Expenditure, % | -5.8 | -10.44 | -7.87 | -15 | -4.96 | -8.82 | -8.82 | -8.82 | -8.82 | -8.82 |
| Tax Rate, % | -0.02667453 | -0.02667453 | -0.02667453 | -0.02667453 | -0.02667453 | -0.02667453 | -0.02667453 | -0.02667453 | -0.02667453 | -0.02667453 |
| EBITAT | -36.8 | -46.6 | -60.9 | -91.5 | -69.0 | -95.4 | -113.3 | -134.6 | -159.9 | -189.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -34.6 | -46.0 | -86.0 | -128.0 | -59.6 | -90.3 | -127.4 | -151.3 | -179.7 | -213.5 |
| WACC, % | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -612.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -218 | |||||||||
| Terminal Value | -4,559 | |||||||||
| Present Terminal Value | -3,285 | |||||||||
| Enterprise Value | -3,898 | |||||||||
| Net Debt | 20 | |||||||||
| Equity Value | -3,918 | |||||||||
| Diluted Shares Outstanding, MM | 105 | |||||||||
| Equity Value Per Share | -37.36 |
What You Will Get
- Real ThredUp Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for ThredUp Inc. (TDUP).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to ThredUp Inc. (TDUP).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on ThredUp Inc. (TDUP)'s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for ThredUp Inc. (TDUP).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for ThredUp Inc. (TDUP).
Key Features
- 🔍 Real-Life TDUP Financials: Pre-filled historical and projected data for ThredUp Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate ThredUp’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize ThredUp’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based ThredUp Inc. (TDUP) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model will automatically refresh ThredUp Inc.'s (TDUP) intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for ThredUp Inc. (TDUP)?
- Accurate Data: Utilize real ThredUp financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Ready-made calculations save you the effort of building from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focused on ThredUp.
- User-Friendly: An intuitive design and clear instructions facilitate ease of use for everyone.
Who Should Use This Product?
- Investors: Evaluate ThredUp Inc.'s (TDUP) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methods and assess future growth projections for ThredUp Inc. (TDUP).
- Startup Founders: Understand the valuation strategies of successful companies like ThredUp Inc. (TDUP).
- Consultants: Provide comprehensive valuation reports tailored for clients interested in ThredUp Inc. (TDUP).
- Students and Educators: Utilize real-time data from ThredUp Inc. (TDUP) to enhance learning of valuation practices.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled ThredUp Inc. (TDUP) 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 ThredUp Inc. (TDUP).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.