Discounted Cash Flow (DCF) Analysis Unlevered

NIKE, Inc. (NKE)

$110.27

-0.10 (-0.09%)
All numbers are in Millions, Currency in USD
Stock DCF: 40.74 | 110.27 | overvalue

Operating Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 39,11737,40344,53846,71051,21754,958.3958,973.0963,281.0667,903.7372,864.08
Revenue (%)
EBITDA 4,7723,1156,9376,6755,9156,808.487,305.847,839.538,412.219,026.72
EBITDA (%)
EBIT 4,0521,9966,1405,8355,0565,698.626,114.906,561.597,040.917,555.25
EBIT (%)
Depreciation 7201,1197978408591,109.871,190.951,277.941,371.301,471.47
Depreciation (%)

Balance Sheet Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Total Cash 4,6638,78713,47612,99710,67512,567.7013,485.7614,470.9015,527.9916,662.31
Total Cash (%)
Account Receivables 4,2722,7494,4634,6674,1315,094.485,466.635,865.976,294.486,754.29
Account Receivables (%)
Inventories 5,6227,3676,8548,4208,4549,231.919,906.3010,629.9511,406.4712,239.71
Inventories (%)
Accounts Payable 2,6122,2482,8363,3582,8623,498.903,754.494,028.764,323.064,638.85
Accounts Payable (%)
Capital Expenditure -1,119-1,086-695-758-969-1,191.43-1,278.46-1,371.85-1,472.07-1,579.60
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 110.27
Beta 1.088
Diluted Shares Outstanding 1,569.80
Cost of Debt
Tax Rate 18.24
After-tax Cost of Debt 3.51%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.433
Total Debt 12,144
Total Equity 173,101.85
Total Capital 185,245.85
Debt Weighting 6.56
Equity Weighting 93.44
Wacc

Build Up Free Cash

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 39,11737,40344,53846,71051,21754,958.3958,973.0963,281.0667,903.7372,864.08
EBITDA 4,7723,1156,9376,6755,9156,808.487,305.847,839.538,412.219,026.72
EBIT 4,0521,9966,1405,8355,0565,698.626,114.906,561.597,040.917,555.25
Tax Rate 16.08%12.05%14.02%9.10%18.24%13.90%13.90%13.90%13.90%13.90%
EBIAT 3,400.441,755.405,279.055,304.234,133.844,906.615,265.035,649.646,062.356,505.20
Depreciation 7201,1197978408591,109.871,190.951,277.941,371.301,471.47
Accounts Receivable -1,523-1,714-204536-963.48-372.15-399.34-428.51-459.81
Inventories --1,745513-1,566-34-777.91-674.39-723.65-776.52-833.24
Accounts Payable --364588522-496636.90255.59274.26294.30315.80
Capital Expenditure -1,119-1,086-695-758-969-1,191.43-1,278.46-1,371.85-1,472.07-1,579.60
UFCF 3,001.441,202.404,768.054,138.234,029.843,720.554,386.574,707.015,050.865,419.82
WACC
PV UFCF 3,411.793,688.703,629.683,571.603,514.44
SUM PV UFCF 17,816.21

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 9.05
Free cash flow (t + 1) 5,528.22
Terminal Value 78,414.41
Present Value of Terminal Value 50,847.26

Intrinsic Value

Enterprise Value 68,663.47
Net Debt 4,703
Equity Value 63,960.47
Shares Outstanding 1,569.80
Equity Value Per Share 40.74