|
Valoración de Foot Locker, Inc. (FL) DCF
US | Consumer Cyclical | Apparel - Retail | NYSE
|
- ✓ 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
Foot Locker, Inc. (FL) Bundle
Ya sea que sea un inversor o un analista, esta calculadora DCF de Locker, Inc. (FL) es su herramienta esencial para una valoración precisa. Precedidos con datos reales del Locker Foot, puede ajustar las previsiones y observar los efectos en tiempo real.
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 | 8,005.0 | 7,548.0 | 8,958.0 | 8,759.0 | 8,168.0 | 8,249.7 | 8,332.3 | 8,415.7 | 8,499.9 | 8,584.9 |
Revenue Growth, % | 0 | -5.71 | 18.68 | -2.22 | -6.75 | 1 | 1 | 1 | 1 | 1 |
EBITDA | 892.0 | 606.0 | 1,246.0 | 859.0 | -200.0 | 667.2 | 673.9 | 680.7 | 687.5 | 694.3 |
EBITDA, % | 11.14 | 8.03 | 13.91 | 9.81 | -2.45 | 8.09 | 8.09 | 8.09 | 8.09 | 8.09 |
Depreciation | 179.0 | 176.0 | 197.0 | 208.0 | 199.0 | 191.0 | 192.9 | 194.9 | 196.8 | 198.8 |
Depreciation, % | 2.24 | 2.33 | 2.2 | 2.37 | 2.44 | 2.32 | 2.32 | 2.32 | 2.32 | 2.32 |
EBIT | 713.0 | 430.0 | 1,049.0 | 651.0 | -399.0 | 476.2 | 481.0 | 485.8 | 490.6 | 495.5 |
EBIT, % | 8.91 | 5.7 | 11.71 | 7.43 | -4.88 | 5.77 | 5.77 | 5.77 | 5.77 | 5.77 |
Total Cash | 907.0 | 1,680.0 | 804.0 | 536.0 | 297.0 | 863.2 | 871.9 | 880.6 | 889.4 | 898.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 101.0 | 125.0 | 134.0 | 160.0 | 160.0 | 135.3 | 136.6 | 138.0 | 139.4 | 140.8 |
Account Receivables, % | 1.26 | 1.66 | 1.5 | 1.83 | 1.96 | 1.64 | 1.64 | 1.64 | 1.64 | 1.64 |
Inventories | 1,208.0 | 923.0 | 1,266.0 | 1,643.0 | 1,509.0 | 1,298.2 | 1,311.2 | 1,324.4 | 1,337.6 | 1,351.0 |
Inventories, % | 15.09 | 12.23 | 14.13 | 18.76 | 18.47 | 15.74 | 15.74 | 15.74 | 15.74 | 15.74 |
Accounts Payable | 333.0 | 402.0 | 596.0 | 492.0 | 366.0 | 432.9 | 437.2 | 441.6 | 446.0 | 450.5 |
Accounts Payable, % | 4.16 | 5.33 | 6.65 | 5.62 | 4.48 | 5.25 | 5.25 | 5.25 | 5.25 | 5.25 |
Capital Expenditure | -187.0 | -159.0 | -209.0 | -285.0 | -242.0 | -214.4 | -216.5 | -218.7 | -220.9 | -223.1 |
Capital Expenditure, % | -2.34 | -2.11 | -2.33 | -3.25 | -2.96 | -2.6 | -2.6 | -2.6 | -2.6 | -2.6 |
Tax Rate, % | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 |
EBITAT | 513.3 | 281.2 | 755.4 | 424.9 | -311.3 | 335.9 | 339.2 | 342.6 | 346.1 | 349.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -470.7 | 628.2 | 585.4 | -159.1 | -346.3 | 614.9 | 305.7 | 308.7 | 311.8 | 314.9 |
WACC, % | 6.58 | 6.41 | 6.58 | 6.41 | 6.73 | 6.54 | 6.54 | 6.54 | 6.54 | 6.54 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,573.2 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 317 | |||||||||
Terminal Value | 5,240 | |||||||||
Present Terminal Value | 3,817 | |||||||||
Enterprise Value | 5,390 | |||||||||
Net Debt | 2,646 | |||||||||
Equity Value | 2,744 | |||||||||
Diluted Shares Outstanding, MM | 94 | |||||||||
Equity Value Per Share | 29.13 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: Foot Locker, Inc.'s (FL) financial data pre-filled 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, confirming strategies, and saving time.
Key Features
- Genuine Foot Locker Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Assumptions: Modify yellow-highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help you visualize your valuation outcomes.
- Designed for All Skill Levels: An easy-to-navigate structure tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template with Foot Locker’s data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Foot Locker’s intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose Foot Locker, Inc. (FL)?
- Extensive Selection: A wide variety of footwear, apparel, and accessories for all styles.
- Quality Assurance: Partnered with top brands to ensure high-quality products.
- Customer-Centric Experience: Dedicated support and services tailored to enhance customer satisfaction.
- Exclusive Offers: Access to special promotions and limited-edition releases.
- Community Engagement: Actively involved in local initiatives and youth programs.
Who Should Use This Product?
- Investors: Accurately assess Foot Locker, Inc.'s (FL) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis at Foot Locker, Inc. (FL).
- Consultants: Seamlessly modify the template for valuation reports tailored to Foot Locker, Inc. (FL) clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading retail companies like Foot Locker, Inc. (FL).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to Foot Locker, Inc. (FL).
What the Template Contains
- Pre-Filled Data: Includes Foot Locker'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 Foot Locker'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.