|
Destino XL Group, Inc. (DXLG) Valoración de DCF
US | Consumer Cyclical | Apparel - Retail | 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
Destination XL Group, Inc. (DXLG) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (DXLG)! Utilizando datos reales de Destination XL Group, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valor (DXLG) al igual que un inversor experimentado.
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 | 474.0 | 318.9 | 505.0 | 545.8 | 521.8 | 560.0 | 601.1 | 645.1 | 692.4 | 743.1 |
Revenue Growth, % | 0 | -32.72 | 58.34 | 8.08 | -4.4 | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 |
EBITDA | 20.2 | -39.0 | 76.9 | 73.8 | 55.9 | 35.2 | 37.8 | 40.6 | 43.6 | 46.8 |
EBITDA, % | 4.25 | -12.24 | 15.22 | 13.52 | 10.71 | 6.29 | 6.29 | 6.29 | 6.29 | 6.29 |
Depreciation | 24.6 | 21.5 | 17.2 | 15.4 | 13.8 | 23.3 | 25.0 | 26.8 | 28.8 | 30.9 |
Depreciation, % | 5.18 | 6.73 | 3.41 | 2.82 | 2.65 | 4.16 | 4.16 | 4.16 | 4.16 | 4.16 |
EBIT | -4.4 | -60.5 | 59.6 | 58.4 | 42.1 | 12.0 | 12.8 | 13.8 | 14.8 | 15.9 |
EBIT, % | -0.92693 | -18.97 | 11.81 | 10.7 | 8.06 | 2.13 | 2.13 | 2.13 | 2.13 | 2.13 |
Total Cash | 4.3 | 19.0 | 15.5 | 52.1 | 60.0 | 34.7 | 37.3 | 40.0 | 42.9 | 46.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 6.2 | 6.4 | 2.1 | 1.7 | 3.9 | 5.4 | 5.8 | 6.2 | 6.7 | 7.1 |
Account Receivables, % | 1.31 | 2.01 | 0.4178 | 0.31511 | 0.75122 | 0.96154 | 0.96154 | 0.96154 | 0.96154 | 0.96154 |
Inventories | 102.4 | 85.0 | 81.8 | 93.0 | 81.0 | 108.7 | 116.6 | 125.2 | 134.3 | 144.2 |
Inventories, % | 21.61 | 26.66 | 16.19 | 17.04 | 15.52 | 19.4 | 19.4 | 19.4 | 19.4 | 19.4 |
Accounts Payable | 31.8 | 27.1 | 25.2 | 27.5 | 17.4 | 32.0 | 34.3 | 36.8 | 39.5 | 42.4 |
Accounts Payable, % | 6.7 | 8.49 | 4.98 | 5.05 | 3.33 | 5.71 | 5.71 | 5.71 | 5.71 | 5.71 |
Capital Expenditure | -13.4 | -4.2 | -5.3 | -9.6 | -17.4 | -11.5 | -12.4 | -13.3 | -14.3 | -15.3 |
Capital Expenditure, % | -2.83 | -1.33 | -1.04 | -1.77 | -3.34 | -2.06 | -2.06 | -2.06 | -2.06 | -2.06 |
Tax Rate, % | 27.45 | 27.45 | 27.45 | 27.45 | 27.45 | 27.45 | 27.45 | 27.45 | 27.45 | 27.45 |
EBITAT | -4.5 | -60.6 | 58.7 | 89.3 | 30.5 | 11.3 | 12.1 | 13.0 | 13.9 | 14.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -70.2 | -30.9 | 76.3 | 86.5 | 26.6 | 8.5 | 18.7 | 20.1 | 21.5 | 23.1 |
WACC, % | 7.84 | 7.84 | 7.81 | 7.84 | 7.28 | 7.72 | 7.72 | 7.72 | 7.72 | 7.72 |
PV UFCF | ||||||||||
SUM PV UFCF | 71.9 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 23 | |||||||||
Terminal Value | 321 | |||||||||
Present Terminal Value | 221 | |||||||||
Enterprise Value | 293 | |||||||||
Net Debt | 127 | |||||||||
Equity Value | 166 | |||||||||
Diluted Shares Outstanding, MM | 64 | |||||||||
Equity Value Per Share | 2.59 |
What You Will Get
- Pre-Filled Financial Model: Destination XL Group's actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Instant Calculations: Automatic updates provide real-time results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, making it suitable for multiple detailed forecasts.
Key Features
- Comprehensive DXLG Data: Pre-loaded with Destination XL Group’s historical performance metrics and future growth estimates.
- Customizable Financial Inputs: Modify revenue forecasts, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Framework: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- User-Centric Interface: Intuitive layout designed for both industry experts and novices.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Destination XL Group, Inc.'s (DXLG) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation possibilities.
- 5. Present with Confidence: Share professional valuation insights to back your strategic decisions.
Why Choose This Calculator for Destination XL Group, Inc. (DXLG)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Observe immediate updates to DXLG's valuation as you modify inputs.
- Pre-Loaded Data: Comes with Destination XL's actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Fashion Enthusiasts: Discover trends and styles while utilizing real-time data from DXLG.
- Retail Analysts: Integrate industry models into your research or business strategies.
- Investors: Validate your investment strategies and assess valuation metrics for Destination XL Group, Inc. (DXLG).
- Market Researchers: Optimize your analysis with a ready-to-use, adaptable financial model.
- Entrepreneurs: Understand how large retail companies like DXLG are evaluated in the market.
What the Template Contains
- Historical Data: Includes Destination XL Group, Inc.'s (DXLG) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Destination XL Group, Inc.'s (DXLG) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Destination XL Group, Inc.'s (DXLG) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.