NIKE, Inc. (NKE) DCF Valuation
- ✓ 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
NIKE, Inc. (NKE) Bundle
Evaluate NIKE, Inc.'s (NKE) financial outlook like an expert! This (NKE) DCF Calculator provides you with pre-filled financial data and full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 37,403.0 | 44,538.0 | 46,710.0 | 51,217.0 | 51,362.0 | 55,713.0 | 60,432.5 | 65,551.9 | 71,104.9 | 77,128.3 |
Revenue Growth, % | 0 | 19.08 | 4.88 | 9.65 | 0.28311 | 8.47 | 8.47 | 8.47 | 8.47 | 8.47 |
EBITDA | 3,115.0 | 6,937.0 | 6,675.0 | 5,915.0 | 7,155.0 | 7,094.9 | 7,695.9 | 8,347.8 | 9,055.0 | 9,822.0 |
EBITDA, % | 8.33 | 15.58 | 14.29 | 11.55 | 13.93 | 12.73 | 12.73 | 12.73 | 12.73 | 12.73 |
Depreciation | 721.0 | 744.0 | 717.0 | 703.0 | 844.0 | 908.0 | 984.9 | 1,068.4 | 1,158.9 | 1,257.0 |
Depreciation, % | 1.93 | 1.67 | 1.54 | 1.37 | 1.64 | 1.63 | 1.63 | 1.63 | 1.63 | 1.63 |
EBIT | 2,394.0 | 6,193.0 | 5,958.0 | 5,212.0 | 6,311.0 | 6,186.9 | 6,711.0 | 7,279.5 | 7,896.1 | 8,565.0 |
EBIT, % | 6.4 | 13.9 | 12.76 | 10.18 | 12.29 | 11.1 | 11.1 | 11.1 | 11.1 | 11.1 |
Total Cash | 8,787.0 | 13,476.0 | 12,997.0 | 10,675.0 | 11,582.0 | 13,924.6 | 15,104.2 | 16,383.7 | 17,771.6 | 19,277.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2,749.0 | 4,463.0 | 4,667.0 | 4,131.0 | 4,427.0 | 4,907.9 | 5,323.7 | 5,774.7 | 6,263.9 | 6,794.5 |
Account Receivables, % | 7.35 | 10.02 | 9.99 | 8.07 | 8.62 | 8.81 | 8.81 | 8.81 | 8.81 | 8.81 |
Inventories | 7,367.0 | 6,854.0 | 8,420.0 | 8,454.0 | 7,519.0 | 9,388.4 | 10,183.7 | 11,046.4 | 11,982.2 | 12,997.2 |
Inventories, % | 19.7 | 15.39 | 18.03 | 16.51 | 14.64 | 16.85 | 16.85 | 16.85 | 16.85 | 16.85 |
Accounts Payable | 2,248.0 | 2,836.0 | 3,358.0 | 2,862.0 | 2,851.0 | 3,421.4 | 3,711.2 | 4,025.6 | 4,366.6 | 4,736.5 |
Accounts Payable, % | 6.01 | 6.37 | 7.19 | 5.59 | 5.55 | 6.14 | 6.14 | 6.14 | 6.14 | 6.14 |
Capital Expenditure | -1,086.0 | -695.0 | -758.0 | -969.0 | -812.0 | -1,065.2 | -1,155.4 | -1,253.3 | -1,359.5 | -1,474.6 |
Capital Expenditure, % | -2.9 | -1.56 | -1.62 | -1.89 | -1.58 | -1.91 | -1.91 | -1.91 | -1.91 | -1.91 |
Tax Rate, % | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 | 14.93 |
EBITAT | 2,105.4 | 5,324.6 | 5,416.0 | 4,261.4 | 5,369.1 | 5,341.3 | 5,793.8 | 6,284.6 | 6,816.9 | 7,394.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -6,127.6 | 4,760.6 | 4,127.0 | 4,001.4 | 6,029.1 | 3,404.1 | 4,702.0 | 5,100.3 | 5,532.4 | 6,001.0 |
WACC, % | 8.83 | 8.82 | 8.84 | 8.81 | 8.82 | 8.83 | 8.83 | 8.83 | 8.83 | 8.83 |
PV UFCF | ||||||||||
SUM PV UFCF | 18,931.8 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 6,241 | |||||||||
Terminal Value | 129,332 | |||||||||
Present Terminal Value | 84,732 | |||||||||
Enterprise Value | 103,664 | |||||||||
Net Debt | 2,092 | |||||||||
Equity Value | 101,572 | |||||||||
Diluted Shares Outstanding, MM | 1,530 | |||||||||
Equity Value Per Share | 66.40 |
What You Will Get
- Editable Forecast Inputs: Adjust key assumptions (growth %, margins, WACC) effortlessly to explore various scenarios.
- Real-World Data: NIKE, Inc.'s (NKE) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Real-Life NKE Data: Pre-filled with Nike’s historical financials and future growth projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Develop multiple forecasting scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, structured, and suitable for both professionals and newcomers.
How It Works
- Download: Obtain the pre-built Excel file containing NIKE, Inc.'s (NKE) financial data.
- Customize: Tailor your forecasts, including sales growth, operating margin, and discount rate.
- Update Automatically: The intrinsic value and net present value calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment strategies.
Why Choose This Calculator for NIKE, Inc. (NKE)?
- Precision: Utilizes authentic NIKE financials to guarantee data integrity.
- Adaptability: Built for users to easily experiment with and adjust inputs.
- Efficiency: Avoid the complexities of constructing a DCF model from the ground up.
- Expert-Level: Crafted with the accuracy and functionality expected by CFOs.
- Intuitive: Simple to navigate, even for those lacking advanced financial modeling skills.
Who Should Use This Product?
- Finance Students: Master valuation strategies and apply them with real-time data.
- Academics: Integrate professional valuation models into your teaching or research projects.
- Investors: Validate your assumptions and evaluate valuation results for NIKE, Inc. (NKE) stock.
- Analysts: Enhance your efficiency with a ready-to-use, customizable DCF model.
- Small Business Owners: Understand the analytical approaches used for evaluating large public companies like NIKE.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled NIKE, Inc. historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for NIKE, Inc. (NKE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.