G-III Apparel Group, Ltd. (GIII) 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
G-III Apparel Group, Ltd. (GIII) Bundle
Looking to assess the intrinsic value of G-III Apparel Group, Ltd.? Our GIII DCF Calculator integrates real-world data with extensive customization features, allowing you to adjust forecasts and enhance your investment strategies.
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 | 3,160.5 | 2,055.1 | 2,766.5 | 3,226.7 | 3,098.2 | 3,193.5 | 3,291.6 | 3,392.8 | 3,497.1 | 3,604.5 |
| Revenue Growth, % | 0 | -34.97 | 34.62 | 16.63 | -3.98 | 3.07 | 3.07 | 3.07 | 3.07 | 3.07 |
| EBITDA | 285.8 | 139.3 | 345.8 | .7 | 307.7 | 244.4 | 252.0 | 259.7 | 267.7 | 275.9 |
| EBITDA, % | 9.04 | 6.78 | 12.5 | 0.02125993 | 9.93 | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 |
| Depreciation | 112.0 | 110.0 | 71.0 | 82.3 | 27.5 | 95.2 | 98.1 | 101.1 | 104.2 | 107.4 |
| Depreciation, % | 3.54 | 5.35 | 2.57 | 2.55 | 0.88834 | 2.98 | 2.98 | 2.98 | 2.98 | 2.98 |
| EBIT | 173.8 | 29.3 | 274.8 | -81.6 | 280.2 | 149.3 | 153.9 | 158.6 | 163.5 | 168.5 |
| EBIT, % | 5.5 | 1.43 | 9.93 | -2.53 | 9.04 | 4.67 | 4.67 | 4.67 | 4.67 | 4.67 |
| Total Cash | 197.4 | 351.9 | 466.0 | 191.7 | 507.8 | 399.5 | 411.7 | 424.4 | 437.4 | 450.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 530.1 | 492.7 | 605.5 | 675.0 | 562.4 | 649.6 | 669.5 | 690.1 | 711.3 | 733.2 |
| Account Receivables, % | 16.77 | 23.97 | 21.89 | 20.92 | 18.15 | 20.34 | 20.34 | 20.34 | 20.34 | 20.34 |
| Inventories | 551.9 | 416.5 | 512.2 | 709.3 | 520.4 | 606.9 | 625.6 | 644.8 | 664.6 | 685.0 |
| Inventories, % | 17.46 | 20.27 | 18.51 | 21.98 | 16.8 | 19 | 19 | 19 | 19 | 19 |
| Accounts Payable | 204.8 | 139.2 | 236.9 | 169.5 | 182.5 | 210.5 | 217.0 | 223.7 | 230.5 | 237.6 |
| Accounts Payable, % | 6.48 | 6.77 | 8.56 | 5.25 | 5.89 | 6.59 | 6.59 | 6.59 | 6.59 | 6.59 |
| Capital Expenditure | -40.1 | -20.1 | -31.5 | -21.6 | -24.7 | -31.0 | -31.9 | -32.9 | -33.9 | -35.0 |
| Capital Expenditure, % | -1.27 | -0.9794 | -1.14 | -0.66978 | -0.79655 | -0.97062 | -0.97062 | -0.97062 | -0.97062 | -0.97062 |
| Tax Rate, % | 26.78 | 26.78 | 26.78 | 26.78 | 26.78 | 26.78 | 26.78 | 26.78 | 26.78 | 26.78 |
| EBITAT | 137.2 | 19.3 | 203.4 | -79.3 | 205.2 | 116.3 | 119.8 | 123.5 | 127.3 | 131.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -668.1 | 216.5 | 132.2 | -352.7 | 522.5 | 34.7 | 153.8 | 158.6 | 163.4 | 168.5 |
| WACC, % | 11.83 | 11.6 | 11.74 | 12.16 | 11.73 | 11.81 | 11.81 | 11.81 | 11.81 | 11.81 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 468.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 172 | |||||||||
| Terminal Value | 1,751 | |||||||||
| Present Terminal Value | 1,002 | |||||||||
| Enterprise Value | 1,470 | |||||||||
| Net Debt | 145 | |||||||||
| Equity Value | 1,325 | |||||||||
| Diluted Shares Outstanding, MM | 47 | |||||||||
| Equity Value Per Share | 28.20 |
What You Will Receive
- Pre-Filled Financial Model: G-III Apparel Group’s actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Instantaneous Calculations: Automatic updates provide real-time results as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
- Customizable and Reusable: Designed for versatility, enabling repeated use for in-depth forecasts.
Key Features
- Accurate G-III Financials: Access reliable pre-loaded historical data and future projections for G-III Apparel Group, Ltd. (GIII).
- Customizable Forecast Assumptions: Modify highlighted cells such as WACC, growth rates, and profit margins to suit your analysis.
- Dynamic Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Visual Dashboard: User-friendly charts and summaries to help you visualize your valuation outcomes.
- Designed for All Users: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based G-III Apparel DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh G-III Apparel's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the findings to inform your investment or financial assessments.
Why Choose This Calculator for G-III Apparel Group, Ltd. (GIII)?
- User-Friendly Interface: Perfectly crafted for both novice and experienced users.
- Customizable Inputs: Adjust parameters easily to suit your specific analysis.
- Real-Time Adjustments: Observe immediate changes to G-III's valuation as you modify inputs.
- Preloaded Data: Comes with G-III's actual financial metrics for swift evaluations.
- Relied Upon by Experts: A go-to tool for investors and analysts aiming for well-informed choices.
Who Should Use This Product?
- Investors: Accurately estimate G-III Apparel Group, Ltd.’s (GIII) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis specific to GIII.
- Consultants: Quickly adapt the template for valuation reports tailored to G-III Apparel Group, Ltd. (GIII) clients.
- Entrepreneurs: Gain insights into financial modeling practices utilized by leading apparel companies like GIII.
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to the apparel industry.
What the G-III Apparel Group, Ltd. (GIII) Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations tailored for G-III Apparel Group.
- Real-World Data: G-III Apparel Group’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into G-III Apparel Group's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to G-III Apparel Group.
- Dashboard with Visual Outputs: Visual representations such as charts and tables for clear, actionable insights.