NIKE, Inc. (NKE) DCF Valuation

NIKE, Inc. (NKE) DCF Valuation
  • Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • Aucune Expertise N'Est Requise; Facile À Suivre

NIKE, Inc. (NKE) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 7.35 10.02 9.99 8.07 8.62
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.