|
Bassett Furniture Industries, Valoración de DCF Incorporated (BSET)
US | Consumer Cyclical | Furnishings, Fixtures & Appliances | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Bassett Furniture Industries, Incorporated (BSET) Bundle
¡Simplifique la valoración de Bassett Furniture Industries, Incorporated (BSET) con esta calculadora DCF personalizable! Con Bassett Financials reales y entradas de pronóstico ajustable, puede probar escenarios y descubrir el valor razonable de Bassett en minutos.
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 | 452.1 | 385.9 | 486.5 | 485.6 | 390.1 | 381.9 | 373.9 | 366.0 | 358.3 | 350.8 |
| Revenue Growth, % | 0 | -14.65 | 26.09 | -0.19176 | -19.66 | -2.1 | -2.1 | -2.1 | -2.1 | -2.1 |
| EBITDA | 13.0 | -3.3 | 40.6 | 37.0 | 7.7 | 15.2 | 14.9 | 14.6 | 14.3 | 14.0 |
| EBITDA, % | 2.87 | -0.84434 | 8.34 | 7.62 | 1.97 | 3.99 | 3.99 | 3.99 | 3.99 | 3.99 |
| Depreciation | 14.7 | 13.5 | 10.0 | 10.0 | 10.1 | 10.3 | 10.1 | 9.9 | 9.7 | 9.4 |
| Depreciation, % | 3.26 | 3.49 | 2.05 | 2.07 | 2.6 | 2.69 | 2.69 | 2.69 | 2.69 | 2.69 |
| EBIT | -1.7 | -16.7 | 30.6 | 26.9 | -2.5 | 5.0 | 4.9 | 4.8 | 4.7 | 4.6 |
| EBIT, % | -0.38355 | -4.34 | 6.3 | 5.55 | -0.63209 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
| Total Cash | 37.1 | 63.5 | 52.1 | 79.3 | 70.2 | 53.2 | 52.1 | 51.0 | 50.0 | 48.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 21.4 | 32.0 | 20.6 | 20.2 | 16.3 | 19.5 | 19.1 | 18.7 | 18.3 | 18.0 |
| Account Receivables, % | 4.73 | 8.29 | 4.23 | 4.16 | 4.18 | 5.12 | 5.12 | 5.12 | 5.12 | 5.12 |
| Inventories | 66.3 | 54.9 | 78.0 | 85.5 | 63.0 | 60.1 | 58.8 | 57.6 | 56.4 | 55.2 |
| Inventories, % | 14.67 | 14.22 | 16.03 | 17.6 | 16.14 | 15.73 | 15.73 | 15.73 | 15.73 | 15.73 |
| Accounts Payable | 23.7 | 23.4 | 24.0 | 20.4 | 16.3 | 18.8 | 18.4 | 18.0 | 17.6 | 17.3 |
| Accounts Payable, % | 5.24 | 6.07 | 4.93 | 4.19 | 4.19 | 4.92 | 4.92 | 4.92 | 4.92 | 4.92 |
| Capital Expenditure | -17.4 | -6.0 | -10.8 | -21.3 | -17.5 | -12.6 | -12.3 | -12.1 | -11.8 | -11.6 |
| Capital Expenditure, % | -3.84 | -1.56 | -2.21 | -4.39 | -4.48 | -3.3 | -3.3 | -3.3 | -3.3 | -3.3 |
| Tax Rate, % | -27.45 | -27.45 | -27.45 | -27.45 | -27.45 | -27.45 | -27.45 | -27.45 | -27.45 | -27.45 |
| EBITAT | -1.9 | -10.4 | 22.8 | 20.1 | -3.1 | 4.1 | 4.0 | 3.9 | 3.8 | 3.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -68.6 | -2.4 | 10.9 | -1.9 | 11.9 | 3.9 | 3.0 | 2.9 | 2.9 | 2.8 |
| WACC, % | 8.45 | 7.63 | 7.9 | 7.9 | 8.45 | 8.07 | 8.07 | 8.07 | 8.07 | 8.07 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 12.5 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 3 | |||||||||
| Terminal Value | 38 | |||||||||
| Present Terminal Value | 25 | |||||||||
| Enterprise Value | 38 | |||||||||
| Net Debt | 64 | |||||||||
| Equity Value | -26 | |||||||||
| Diluted Shares Outstanding, MM | 9 | |||||||||
| Equity Value Per Share | -2.93 |
What You Will Receive
- Pre-Filled Financial Model: Utilizing Bassett Furniture's actual data for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust parameters.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation analysis.
- Flexible and Reusable: Designed for adaptability, allowing for repeated application in detailed forecasting.
Key Features
- Customizable Market Assumptions: Adjust essential factors such as sales growth, profit margins, and capital investments.
- Instant DCF Calculation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- Industry-Leading Precision: Incorporates Bassett Furniture's actual financial data for accurate valuation results.
- Effortless Scenario Testing: Evaluate various scenarios and analyze results with ease.
- Efficiency Booster: Streamline the valuation process without the hassle of creating complex models from the ground up.
How It Works
- Download: Obtain the pre-configured Excel file featuring Bassett Furniture Industries' (BSET) financial data.
- Customize: Modify projections, such as sales growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment choices.
Why Choose Bassett Furniture Industries, Incorporated (BSET)?
- Quality Craftsmanship: Our furniture is built to last, ensuring durability and style in every piece.
- Wide Selection: From contemporary to traditional designs, we offer a diverse range of furniture to suit any taste.
- Custom Options: Personalize your furniture with a variety of fabrics, finishes, and configurations.
- Exceptional Customer Service: Our knowledgeable team is here to assist you every step of the way.
- Industry Leader: With decades of experience, we are trusted by customers and professionals alike.
Who Should Use Bassett Furniture Industries, Incorporated (BSET)?
- Homeowners: Enhance your living spaces with stylish and high-quality furniture options.
- Interior Designers: Access a wide range of customizable pieces to meet client needs.
- Retailers: Partner with a reputable brand to offer premium furniture selections.
- Investors: Evaluate the growth potential of a well-established company in the furniture market.
- Students and Educators: Utilize the brand's history and business model for case studies in marketing and design courses.
What the Template Contains
- Preloaded BSET 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.