Capri Holdings Limited (CPRI) 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
Capri Holdings Limited (CPRI) Bundle
Discover the true value of Capri Holdings Limited with our professional-grade DCF Calculator! Adjust key assumptions, test various scenarios, and examine how changes affect Capri Holdings Limited's valuation – all within a single Excel template.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 5,551.0 | 4,060.0 | 5,654.0 | 5,619.0 | 5,170.0 | 5,219.0 | 5,268.5 | 5,318.4 | 5,368.8 | 5,419.7 |
| Revenue Growth, % | 0 | -26.86 | 39.26 | -0.61903 | -7.99 | 0.94782 | 0.94782 | 0.94782 | 0.94782 | 0.94782 |
| EBITDA | 52.0 | 258.0 | 1,187.0 | 1,001.0 | -89.0 | 463.2 | 467.6 | 472.0 | 476.5 | 481.0 |
| EBITDA, % | 0.93677 | 6.35 | 20.99 | 17.81 | -1.72 | 8.88 | 8.88 | 8.88 | 8.88 | 8.88 |
| Depreciation | 249.0 | 212.0 | 193.0 | 179.0 | 188.0 | 208.2 | 210.1 | 212.1 | 214.1 | 216.2 |
| Depreciation, % | 4.49 | 5.22 | 3.41 | 3.19 | 3.64 | 3.99 | 3.99 | 3.99 | 3.99 | 3.99 |
| EBIT | -197.0 | 46.0 | 994.0 | 822.0 | -277.0 | 255.1 | 257.5 | 259.9 | 262.4 | 264.9 |
| EBIT, % | -3.55 | 1.13 | 17.58 | 14.63 | -5.36 | 4.89 | 4.89 | 4.89 | 4.89 | 4.89 |
| Total Cash | 592.0 | 232.0 | 169.0 | 249.0 | 199.0 | 288.6 | 291.3 | 294.1 | 296.9 | 299.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 308.0 | 373.0 | 434.0 | 389.0 | 382.0 | 383.3 | 387.0 | 390.6 | 394.3 | 398.1 |
| Account Receivables, % | 5.55 | 9.19 | 7.68 | 6.92 | 7.39 | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 |
| Inventories | 827.0 | 736.0 | 1,096.0 | 1,057.0 | 862.0 | 917.4 | 926.1 | 934.9 | 943.8 | 952.7 |
| Inventories, % | 14.9 | 18.13 | 19.38 | 18.81 | 16.67 | 17.58 | 17.58 | 17.58 | 17.58 | 17.58 |
| Accounts Payable | 428.0 | 512.0 | 555.0 | 475.0 | 352.0 | 473.9 | 478.4 | 482.9 | 487.5 | 492.1 |
| Accounts Payable, % | 7.71 | 12.61 | 9.82 | 8.45 | 6.81 | 9.08 | 9.08 | 9.08 | 9.08 | 9.08 |
| Capital Expenditure | -223.0 | -111.0 | -131.0 | -226.0 | -189.0 | -174.8 | -176.5 | -178.1 | -179.8 | -181.5 |
| Capital Expenditure, % | -4.02 | -2.73 | -2.32 | -4.02 | -3.66 | -3.35 | -3.35 | -3.35 | -3.35 | -3.35 |
| Tax Rate, % | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 | 19.08 |
| EBITAT | -206.2 | -966.0 | 893.0 | 781.4 | -224.1 | 186.6 | 188.4 | 190.2 | 192.0 | 193.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -887.2 | -755.0 | 577.0 | 738.4 | -146.1 | 285.1 | 214.2 | 216.3 | 218.3 | 220.4 |
| WACC, % | 8.39 | 5.75 | 8.12 | 8.25 | 7.88 | 7.68 | 7.68 | 7.68 | 7.68 | 7.68 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 937.4 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 227 | |||||||||
| Terminal Value | 4,853 | |||||||||
| Present Terminal Value | 3,353 | |||||||||
| Enterprise Value | 4,290 | |||||||||
| Net Debt | 3,376 | |||||||||
| Equity Value | 914 | |||||||||
| Diluted Shares Outstanding, MM | 117 | |||||||||
| Equity Value Per Share | 7.81 |
What You Will Gain
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled financial data for Capri Holdings Limited (CPRI).
- Authentic Data: Access to historical performance and projected estimates (highlighted in the yellow cells).
- Flexible Forecasting: Modify key assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Capri Holdings Limited (CPRI).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for simplicity and ease of navigation, complete with step-by-step guidance.
Key Features
- Real-Life CPRI Data: Pre-filled with Capri Holdings' historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, discount rates, tax rates, and capital expenditures.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Generate multiple forecasting scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and novices.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Capri Holdings Limited (CPRI) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Capri Holdings Limited’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Capri Holdings Limited (CPRI)?
- Accuracy: Utilizes authentic Capri Holdings financial data for precise calculations.
- Flexibility: Built for users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and functionality expected at the CFO level.
- User-Friendly: Intuitive interface designed for users of all financial backgrounds.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Capri Holdings Limited (CPRI) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Capri Holdings Limited (CPRI).
- Consultants: Deliver professional valuation insights on Capri Holdings Limited (CPRI) to clients quickly and accurately.
- Business Owners: Understand how large companies like Capri Holdings Limited (CPRI) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Capri Holdings Limited (CPRI).
What the Capri Holdings Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for Capri Holdings Limited.
- Real-World Data: Capri Holdings’ historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results tailored to Capri Holdings Limited (CPRI).