Discounted Cash Flow (DCF) Analysis Unlevered

Nutanix, Inc. (NTNX)

$35.4201

+0.52 (+1.49%)
All numbers are in Millions, Currency in USD
Stock DCF: -66.97 | 35.4201 | 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 1,236.141,307.681,394.361,580.801,862.902,066.102,291.472,541.422,818.633,126.09
Revenue (%)
EBITDA -520.43-735.15-566.41-369.49-130.76-699.72-776.04-860.69-954.58-1,058.70
EBITDA (%)
EBIT -598.04-828.92-660.78-457.44-207.15-823.20-912.99-1,012.58-1,123.03-1,245.53
EBIT (%)
Depreciation 77.6193.7794.3787.9576.39123.48136.95151.89168.45186.83
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 908.83719.781,213.731,324.281,437.391,555.941,725.661,913.902,122.672,354.20
Total Cash (%)
Account Receivables 245.47242.52180.78124.56157.25279.71310.22344.05381.58423.21
Account Receivables (%)
Inventories 46.2468.69110.94171.71120141.54156.98174.11193.10214.16
Inventories (%)
Accounts Payable 74.0554.0347.0644.9329.9374.1582.2491.21101.16112.20
Accounts Payable (%)
Capital Expenditure -118.45-89.49-58.65-49.06-65.40-112.59-124.87-138.49-153.59-170.35
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 35.4,201
Beta 1.297
Diluted Shares Outstanding 233.25
Cost of Debt
Tax Rate -8.98
After-tax Cost of Debt 5.00%
Risk-Free Rate
Market Risk Premium
Cost of Equity 10.646
Total Debt 1,316.67
Total Equity 8,261.63
Total Capital 9,578.30
Debt Weighting 13.75
Equity Weighting 86.25
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 1,236.141,307.681,394.361,580.801,862.902,066.102,291.472,541.422,818.633,126.09
EBITDA -520.43-735.15-566.41-369.49-130.76-699.72-776.04-860.69-954.58-1,058.70
EBIT -598.04-828.92-660.78-457.44-207.15-823.20-912.99-1,012.58-1,123.03-1,245.53
Tax Rate -1.32%-2.07%-1.82%-2.48%-8.98%-3.33%-3.33%-3.33%-3.33%-3.33%
EBIAT -605.96-846.04-672.81-468.77-225.75-850.63-943.42-1,046.33-1,160.46-1,287.04
Depreciation 77.6193.7794.3787.9576.39123.48136.95151.89168.45186.83
Accounts Receivable -2.9661.7456.22-32.69-122.46-30.51-33.84-37.53-41.62
Inventories --22.46-42.24-60.7851.71-21.54-15.44-17.12-18.99-21.06
Accounts Payable --20.02-6.97-2.13-1544.238.098.979.9511.03
Capital Expenditure -118.45-89.49-58.65-49.06-65.40-112.59-124.87-138.49-153.59-170.35
UFCF -646.80-881.27-624.56-436.55-210.75-939.51-969.20-1,074.92-1,192.17-1,322.21
WACC
PV UFCF -855.11-802.89-810.47-818.13-825.86
SUM PV UFCF -4,112.45

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 9.87
Free cash flow (t + 1) -1,348.65
Terminal Value -17,136.64
Present Value of Terminal Value -10,703.61

Intrinsic Value

Enterprise Value -14,816.06
Net Debt 803.74
Equity Value -15,619.80
Shares Outstanding 233.25
Equity Value Per Share -66.97