|
Fossil Group, Inc. (FOSL) DCF Valoración
US | Consumer Cyclical | Luxury Goods | 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
Fossil Group, Inc. (FOSL) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF de Fossil Group, Inc. (FOSL)! Explore datos financieros auténticos, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estos cambios afectan el valor intrínseco de Fossil Group, Inc. (FOSL).
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 | 2,217.7 | 1,613.3 | 1,870.0 | 1,682.4 | 1,412.4 | 1,280.2 | 1,160.5 | 1,051.9 | 953.5 | 864.3 |
Revenue Growth, % | 0 | -27.25 | 15.91 | -10.03 | -16.05 | -9.36 | -9.36 | -9.36 | -9.36 | -9.36 |
EBITDA | 53.4 | 12.3 | 198.0 | 20.4 | -115.3 | 17.4 | 15.8 | 14.3 | 13.0 | 11.8 |
EBITDA, % | 2.41 | 0.76328 | 10.59 | 1.22 | -8.16 | 1.36 | 1.36 | 1.36 | 1.36 | 1.36 |
Depreciation | 54.8 | 152.5 | 119.9 | 23.3 | 19.1 | 53.9 | 48.9 | 44.3 | 40.2 | 36.4 |
Depreciation, % | 2.47 | 9.45 | 6.41 | 1.39 | 1.35 | 4.21 | 4.21 | 4.21 | 4.21 | 4.21 |
EBIT | -1.4 | -140.1 | 78.1 | -2.9 | -134.4 | -36.5 | -33.1 | -30.0 | -27.2 | -24.6 |
EBIT, % | -0.06308342 | -8.69 | 4.18 | -0.17172 | -9.51 | -2.85 | -2.85 | -2.85 | -2.85 | -2.85 |
Total Cash | 200.2 | 316.0 | 250.8 | 198.7 | 117.2 | 159.1 | 144.2 | 130.7 | 118.5 | 107.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 289.7 | 229.8 | 255.1 | 206.1 | 245.3 | 180.7 | 163.8 | 148.5 | 134.6 | 122.0 |
Account Receivables, % | 13.07 | 14.25 | 13.64 | 12.25 | 17.36 | 14.11 | 14.11 | 14.11 | 14.11 | 14.11 |
Inventories | 452.3 | 295.3 | 346.9 | 376.0 | 252.8 | 249.6 | 226.3 | 205.1 | 185.9 | 168.5 |
Inventories, % | 20.4 | 18.3 | 18.55 | 22.35 | 17.9 | 19.5 | 19.5 | 19.5 | 19.5 | 19.5 |
Accounts Payable | 172.2 | 178.2 | 229.9 | 191.1 | 147.2 | 135.4 | 122.7 | 111.3 | 100.8 | 91.4 |
Accounts Payable, % | 7.76 | 11.05 | 12.29 | 11.36 | 10.42 | 10.58 | 10.58 | 10.58 | 10.58 | 10.58 |
Capital Expenditure | -24.1 | -10.7 | -10.3 | -13.3 | -9.9 | -9.7 | -8.8 | -8.0 | -7.2 | -6.6 |
Capital Expenditure, % | -1.09 | -0.66286 | -0.55043 | -0.78828 | -0.70045 | -0.75816 | -0.75816 | -0.75816 | -0.75816 | -0.75816 |
Tax Rate, % | -0.60908 | -0.60908 | -0.60908 | -0.60908 | -0.60908 | -0.60908 | -0.60908 | -0.60908 | -0.60908 | -0.60908 |
EBITAT | -2.2 | -78.2 | 37.4 | -5.7 | -135.2 | -29.5 | -26.7 | -24.2 | -21.9 | -19.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -541.4 | 286.5 | 121.8 | -14.5 | -85.9 | 70.8 | 41.0 | 37.1 | 33.7 | 30.5 |
WACC, % | 7.47 | 5.49 | 5.14 | 7.47 | 7.47 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 |
PV UFCF | ||||||||||
SUM PV UFCF | 181.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 31 | |||||||||
Terminal Value | 676 | |||||||||
Present Terminal Value | 491 | |||||||||
Enterprise Value | 672 | |||||||||
Net Debt | 271 | |||||||||
Equity Value | 400 | |||||||||
Diluted Shares Outstanding, MM | 52 | |||||||||
Equity Value Per Share | 7.66 |
What You Will Get
- Pre-Filled Financial Model: Fossil Group’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Accurate Fossil Financials: Gain access to reliable pre-loaded historical data and future forecasts for Fossil Group, Inc. (FOSL).
- Customizable Projection Inputs: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Skill Levels: An intuitive format tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file containing Fossil Group, Inc.'s preloaded data.
- 2. Modify Assumptions: Adjust key 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: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Assurance: Share professional valuation insights to bolster your decision-making.
Why Choose This Calculator for Fossil Group, Inc. (FOSL)?
- Accurate Data: Real Fossil Group 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-built calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the retail sector.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately assess Fossil Group’s fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily modify the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading retail companies.
- Educators: Employ it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Pre-Filled Data: Includes Fossil Group's historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Fossil Group's profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.