1stdibs.Com, Inc. (DIBS) 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
1stdibs.Com, Inc. (DIBS) Bundle
Explore 1stdibs.Com, Inc.'s (DIBS) financial outlook with our user-friendly DCF Calculator! Enter your predictions for growth, margins, and expenses to calculate 1stdibs.Com, Inc.'s (DIBS) intrinsic value and shape your investment approach.
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 | 70.6 | 81.9 | 102.7 | 96.8 | 84.7 | 89.6 | 94.8 | 100.3 | 106.1 | 112.3 |
| Revenue Growth, % | 0 | 16.01 | 25.49 | -5.73 | -12.56 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 |
| EBITDA | -24.6 | -6.5 | -17.8 | -17.2 | -17.8 | -17.7 | -18.8 | -19.8 | -21.0 | -22.2 |
| EBITDA, % | -34.83 | -7.92 | -17.34 | -17.8 | -21.03 | -19.78 | -19.78 | -19.78 | -19.78 | -19.78 |
| Depreciation | 5.2 | 6.0 | 3.1 | 5.3 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.5 |
| Depreciation, % | 7.3 | 7.36 | 3.03 | 5.42 | 5.76 | 5.77 | 5.77 | 5.77 | 5.77 | 5.77 |
| EBIT | -29.7 | -12.5 | -20.9 | -22.5 | -22.7 | -22.9 | -24.2 | -25.6 | -27.1 | -28.7 |
| EBIT, % | -42.12 | -15.27 | -20.37 | -23.22 | -26.79 | -25.56 | -25.56 | -25.56 | -25.56 | -25.56 |
| Total Cash | 55.5 | 54.9 | 168.2 | 153.2 | 139.3 | 79.9 | 84.5 | 89.4 | 94.6 | 100.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5.8 | .9 | .7 | 1.0 | .6 | 2.1 | 2.2 | 2.4 | 2.5 | 2.6 |
| Account Receivables, % | 8.26 | 1.08 | 0.68236 | 1 | 0.75929 | 2.36 | 2.36 | 2.36 | 2.36 | 2.36 |
| Inventories | 1.9 | 3.3 | 4.0 | 5.0 | .0 | 2.8 | 3.0 | 3.1 | 3.3 | 3.5 |
| Inventories, % | 2.64 | 4.01 | 3.85 | 5.17 | 0 | 3.13 | 3.13 | 3.13 | 3.13 | 3.13 |
| Accounts Payable | 3.0 | 4.5 | 4.7 | 2.9 | 10.1 | 5.2 | 5.6 | 5.9 | 6.2 | 6.6 |
| Accounts Payable, % | 4.19 | 5.56 | 4.6 | 3 | 11.93 | 5.86 | 5.86 | 5.86 | 5.86 | 5.86 |
| Capital Expenditure | -6.1 | -1.8 | -2.2 | -2.0 | -1.8 | -3.1 | -3.3 | -3.5 | -3.7 | -3.9 |
| Capital Expenditure, % | -8.65 | -2.23 | -2.18 | -2.03 | -2.12 | -3.44 | -3.44 | -3.44 | -3.44 | -3.44 |
| Tax Rate, % | -0.06171479 | -0.06171479 | -0.06171479 | -0.06171479 | -0.06171479 | -0.06171479 | -0.06171479 | -0.06171479 | -0.06171479 | -0.06171479 |
| EBITAT | -29.3 | -12.5 | -20.9 | -22.5 | -22.7 | -22.8 | -24.2 | -25.6 | -27.0 | -28.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -35.0 | -3.2 | -20.4 | -22.4 | -7.1 | -29.9 | -21.9 | -23.2 | -24.6 | -26.0 |
| WACC, % | 8.47 | 8.48 | 8.48 | 8.48 | 8.48 | 8.48 | 8.48 | 8.48 | 8.48 | 8.48 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -99.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -26 | |||||||||
| Terminal Value | -409 | |||||||||
| Present Terminal Value | -272 | |||||||||
| Enterprise Value | -372 | |||||||||
| Net Debt | -15 | |||||||||
| Equity Value | -356 | |||||||||
| Diluted Shares Outstanding, MM | 40 | |||||||||
| Equity Value Per Share | -8.97 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real 1stdibs.Com, Inc. (DIBS) financials.
- Real-World Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on 1stdibs.Com, Inc. (DIBS) 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 Listings: Access to 1stdibs’ extensive collection of luxury items and antiques.
- Customizable Search Filters: Tailor your search by category, price range, and location.
- Real-Time Inventory Updates: Stay informed with live updates on available products.
- Engaging Visual Displays: High-quality images and detailed descriptions enhance the shopping experience.
- Designed for Connoisseurs: A premium platform catering to collectors, designers, and discerning buyers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review 1stdibs.Com, Inc.'s (DIBS) 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 the assumptions.
- Step 5: Analyze the results and leverage the outputs for your investment strategies.
Why Choose This Calculator for 1stdibs.Com, Inc. (DIBS)?
- Accurate Data: Real 1stdibs financials provide dependable valuation results.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the effort of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the luxury market.
- User-Friendly: Easy-to-navigate layout and clear instructions make it accessible for all users.
Who Should Use 1stdibs.Com, Inc. (DIBS)?
- Interior Designers: Discover unique luxury items to elevate your design projects.
- Collectors: Explore rare and vintage pieces to enhance your collection.
- Homeowners: Find exclusive decor and furniture to personalize your living space.
- Real Estate Professionals: Utilize high-end furnishings to stage properties effectively.
- Art Enthusiasts: Access a curated selection of art and design objects from around the world.
What the Template Contains
- Pre-Filled DCF Model: 1stdibs.Com, Inc.’s (DIBS) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate 1stdibs.Com, Inc.’s (DIBS) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.