|
Xcel Brands, Inc. (XELB) Valoración de DCF
US | Consumer Cyclical | Apparel - Manufacturers | 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
Xcel Brands, Inc. (XELB) Bundle
¡Descubra el verdadero valor de Xcel Brands, Inc. (XELB) con nuestra calculadora DCF experta! Ajuste los supuestos críticos, explore varios escenarios y examine cómo los cambios afectan la valoración de Xcel Brands, Inc. (XELB), todo dentro de una sola plantilla de Excel.
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 | 41.7 | 29.4 | 37.9 | 25.8 | 17.8 | 14.9 | 12.5 | 10.5 | 8.9 | 7.4 |
Revenue Growth, % | 0 | -29.43 | 28.81 | -32.03 | -31.13 | -15.95 | -15.95 | -15.95 | -15.95 | -15.95 |
EBITDA | 1.1 | -10.9 | -7.2 | 2.7 | -13.7 | -3.6 | -3.0 | -2.5 | -2.1 | -1.8 |
EBITDA, % | 2.64 | -37.06 | -19.09 | 10.39 | -77.11 | -24.05 | -24.05 | -24.05 | -24.05 | -24.05 |
Depreciation | 3.9 | 5.5 | 6.8 | 7.3 | 7.0 | 3.4 | 2.8 | 2.4 | 2.0 | 1.7 |
Depreciation, % | 9.35 | 18.67 | 18.01 | 28.17 | 39.17 | 22.67 | 22.67 | 22.67 | 22.67 | 22.67 |
EBIT | -2.8 | -16.4 | -14.1 | -4.6 | -20.6 | -6.5 | -5.5 | -4.6 | -3.9 | -3.2 |
EBIT, % | -6.72 | -55.73 | -37.1 | -17.78 | -116.27 | -43.46 | -43.46 | -43.46 | -43.46 | -43.46 |
Total Cash | 4.6 | 5.0 | 4.5 | 4.6 | 3.0 | 2.2 | 1.9 | 1.6 | 1.3 | 1.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 10.6 | 8.9 | 7.6 | 5.1 | 3.5 | 3.4 | 2.9 | 2.4 | 2.0 | 1.7 |
Account Receivables, % | 25.46 | 30.19 | 20.14 | 19.82 | 19.45 | 23.01 | 23.01 | 23.01 | 23.01 | 23.01 |
Inventories | .9 | 1.2 | 3.4 | 2.8 | .5 | .9 | .7 | .6 | .5 | .4 |
Inventories, % | 2.15 | 4.13 | 8.9 | 11.04 | 2.55 | 5.75 | 5.75 | 5.75 | 5.75 | 5.75 |
Accounts Payable | 4.4 | 4.4 | 6.2 | 3.9 | 2.1 | 2.1 | 1.7 | 1.5 | 1.2 | 1.0 |
Accounts Payable, % | 10.52 | 15.08 | 16.26 | 15.01 | 11.98 | 13.77 | 13.77 | 13.77 | 13.77 | 13.77 |
Capital Expenditure | -10.0 | -.7 | -1.1 | -.3 | -.1 | -.9 | -.8 | -.7 | -.5 | -.5 |
Capital Expenditure, % | -23.88 | -2.54 | -2.99 | -1.03 | -0.56322 | -6.2 | -6.2 | -6.2 | -6.2 | -6.2 |
Tax Rate, % | -0.12842 | -0.12842 | -0.12842 | -0.12842 | -0.12842 | -0.12842 | -0.12842 | -0.12842 | -0.12842 | -0.12842 |
EBITAT | -2.4 | -12.2 | -11.4 | -4.2 | -20.7 | -5.6 | -4.7 | -4.0 | -3.3 | -2.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -15.6 | -6.0 | -4.9 | 3.5 | -11.5 | -3.6 | -2.3 | -1.9 | -1.6 | -1.4 |
WACC, % | 7.2 | 6.97 | 7.11 | 7.38 | 7.55 | 7.24 | 7.24 | 7.24 | 7.24 | 7.24 |
PV UFCF | ||||||||||
SUM PV UFCF | -9.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1 | |||||||||
Terminal Value | -26 | |||||||||
Present Terminal Value | -19 | |||||||||
Enterprise Value | -28 | |||||||||
Net Debt | 7 | |||||||||
Equity Value | -35 | |||||||||
Diluted Shares Outstanding, MM | 20 | |||||||||
Equity Value Per Share | -1.76 |
What You Will Get
- Comprehensive XELB Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Xcel Brands' future performance.
- User-Friendly Design: Crafted for industry professionals while remaining approachable for newcomers.
Key Features
- Real-Life XELB Data: Pre-filled with Xcel Brands' historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Step 1: Download the prebuilt Excel template with Xcel Brands, Inc.'s (XELB) data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics related to Xcel Brands, Inc. (XELB).
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins) specific to Xcel Brands, Inc. (XELB).
- Step 4: Instantly view recalculated results, including Xcel Brands, Inc.'s (XELB) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs for Xcel Brands, Inc. (XELB).
Why Choose This Calculator for Xcel Brands, Inc. (XELB)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Xcel Brands.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically determines Xcel's intrinsic value and Net Present Value.
- Data Ready: Comes with historical and projected data for precise calculations.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focused on Xcel Brands.
Who Should Use This Product?
- Investors: Accurately assess Xcel Brands, Inc.’s (XELB) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for client valuation reports.
- Entrepreneurs: Obtain insights into financial modeling practices employed by leading brands.
- Educators: Employ it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Preloaded XELB 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.