Fossil Group, Inc. (FOSL) 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
Fossil Group, Inc. (FOSL) Bundle
Enhance your investment choices with the Fossil Group, Inc. (FOSL) DCF Calculator! Explore authentic financial data, adjust growth projections and expenses, and instantly observe how these changes affect the intrinsic value of 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.