V.F. Corporation (VFC) 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
V.F. Corporation (VFC) Bundle
Looking to assess V.F. Corporation's intrinsic value? Our V.F.C (VFC) DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine your projections and enhance your investment choices.
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 | 10,488.6 | 9,238.8 | 11,841.8 | 11,612.5 | 10,454.7 | 10,568.4 | 10,683.4 | 10,799.7 | 10,917.2 | 11,035.9 |
Revenue Growth, % | 0 | -11.92 | 28.17 | -1.94 | -9.97 | 1.09 | 1.09 | 1.09 | 1.09 | 1.09 |
EBITDA | 1,555.9 | 861.2 | 1,926.8 | 480.2 | 334.8 | 1,009.6 | 1,020.6 | 1,031.7 | 1,042.9 | 1,054.3 |
EBITDA, % | 14.83 | 9.32 | 16.27 | 4.14 | 3.2 | 9.55 | 9.55 | 9.55 | 9.55 | 9.55 |
Depreciation | 660.3 | 696.7 | 677.1 | 262.3 | 319.2 | 525.6 | 531.3 | 537.1 | 542.9 | 548.8 |
Depreciation, % | 6.3 | 7.54 | 5.72 | 2.26 | 3.05 | 4.97 | 4.97 | 4.97 | 4.97 | 4.97 |
EBIT | 895.6 | 164.5 | 1,249.7 | 217.9 | 15.6 | 484.0 | 489.3 | 494.6 | 500.0 | 505.4 |
EBIT, % | 8.54 | 1.78 | 10.55 | 1.88 | 0.14911 | 4.58 | 4.58 | 4.58 | 4.58 | 4.58 |
Total Cash | 1,369.0 | 1,414.6 | 1,275.9 | 814.9 | 676.9 | 1,112.4 | 1,124.6 | 1,136.8 | 1,149.2 | 1,161.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,308.1 | 1,298.0 | 1,467.8 | 1,610.3 | 1,276.4 | 1,373.7 | 1,388.7 | 1,403.8 | 1,419.0 | 1,434.5 |
Account Receivables, % | 12.47 | 14.05 | 12.4 | 13.87 | 12.21 | 13 | 13 | 13 | 13 | 13 |
Inventories | 1,293.9 | 1,061.8 | 1,418.7 | 2,292.8 | 1,766.4 | 1,531.4 | 1,548.0 | 1,564.9 | 1,581.9 | 1,599.1 |
Inventories, % | 12.34 | 11.49 | 11.98 | 19.74 | 16.9 | 14.49 | 14.49 | 14.49 | 14.49 | 14.49 |
Accounts Payable | 407.0 | 463.2 | 563.0 | 936.3 | 817.1 | 624.1 | 630.9 | 637.8 | 644.7 | 651.7 |
Accounts Payable, % | 3.88 | 5.01 | 4.75 | 8.06 | 7.82 | 5.91 | 5.91 | 5.91 | 5.91 | 5.91 |
Capital Expenditure | -333.8 | -274.2 | -328.3 | -261.3 | -145.8 | -265.6 | -268.5 | -271.5 | -274.4 | -277.4 |
Capital Expenditure, % | -3.18 | -2.97 | -2.77 | -2.25 | -1.39 | -2.51 | -2.51 | -2.51 | -2.51 | -2.51 |
Tax Rate, % | -314.61 | -314.61 | -314.61 | -314.61 | -314.61 | -314.61 | -314.61 | -314.61 | -314.61 | -314.61 |
EBITAT | 836.8 | 147.0 | 1,137.9 | 597.0 | 64.6 | 458.7 | 463.7 | 468.7 | 473.8 | 479.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,031.7 | 867.8 | 1,059.7 | -45.2 | 979.2 | 663.3 | 701.6 | 709.3 | 717.0 | 724.8 |
WACC, % | 8.19 | 8.11 | 8.14 | 8.33 | 8.33 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,782.5 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 754 | |||||||||
Terminal Value | 17,855 | |||||||||
Present Terminal Value | 12,028 | |||||||||
Enterprise Value | 14,810 | |||||||||
Net Debt | 6,759 | |||||||||
Equity Value | 8,052 | |||||||||
Diluted Shares Outstanding, MM | 388 | |||||||||
Equity Value Per Share | 20.73 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: V.F. Corporation’s (VFC) financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Real-Life VFC Data: Pre-filled with V.F. Corporation’s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic adjustments to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Develop multiple forecasting scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and suitable for both professionals and novices.
How It Works
- 1. Access the Template: Download and open the Excel file featuring V.F. Corporation (VFC)'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: Showcase professional valuation insights to bolster your decision-making.
Why Choose This Calculator for V.F. Corporation (VFC)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses all in one convenient platform.
- Customizable Inputs: Modify yellow-highlighted cells to explore various financial scenarios.
- Detailed Insights: Automatically computes V.F. Corporation’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on VFC.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio management of V.F. Corporation (VFC).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Offer clients precise valuation insights for V.F. Corporation (VFC) stock.
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Fashion Industry Enthusiasts: Gain insights into how apparel companies like V.F. Corporation (VFC) are valued in the marketplace.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for V.F. Corporation (VFC).
- Real-World Data: V.F. Corporation’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to evaluate different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into V.F. Corporation (VFC).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to V.F. Corporation (VFC).
- Dashboard with Visual Outputs: Charts and tables designed to deliver clear, actionable results for V.F. Corporation (VFC).