Discounted Cash Flow (DCF) Analysis Unlevered
Extreme Networks, Inc. (EXTR)
$19.77
-0.13 (-0.65%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Revenue | 983.14 | 995.79 | 948.02 | 1,009.42 | 1,112.32 | 1,148.92 | 1,186.72 | 1,225.76 | 1,266.09 | 1,307.74 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| EBITDA | 16.33 | 39.60 | -32.92 | 88.36 | 105.14 | 46.81 | 48.35 | 49.94 | 51.58 | 53.28 |
| EBITDA (%) | ||||||||||
| EBIT | -32.72 | -13.28 | -96.74 | 33.04 | 64.98 | -13.22 | -13.65 | -14.10 | -14.56 | -15.04 |
| EBIT (%) | ||||||||||
| Depreciation | 49.06 | 52.87 | 63.82 | 55.32 | 40.16 | 60.02 | 62 | 64.04 | 66.15 | 68.32 |
| Depreciation (%) |
Balance Sheet Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Total Cash | 121.14 | 169.61 | 193.87 | 246.89 | 194.52 | 210.83 | 217.77 | 224.93 | 232.33 | 239.97 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 212.42 | 174.41 | 122.73 | 156.48 | 184.10 | 193.29 | 199.65 | 206.22 | 213.01 | 220.01 |
| Account Receivables (%) | ||||||||||
| Inventories | 63.87 | 63.59 | 62.59 | 32.89 | 49.23 | 62.43 | 64.48 | 66.60 | 68.79 | 71.06 |
| Inventories (%) | ||||||||||
| Accounts Payable | 75.69 | 65.70 | 48.44 | 60.14 | 84.34 | 75.71 | 78.20 | 80.77 | 83.43 | 86.17 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -40.41 | -22.73 | -15.27 | -17.18 | -15.43 | -25.49 | -26.33 | -27.19 | -28.09 | -29.01 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 19.77 |
|---|---|
| Beta | 2.086 |
| Diluted Shares Outstanding | 133.49 |
| Cost of Debt | |
| Tax Rate | 15.18 |
| After-tax Cost of Debt | 3.09% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 13.625 |
| Total Debt | 351.13 |
| Total Equity | 2,639.18 |
| Total Capital | 2,990.31 |
| Debt Weighting | 11.74 |
| Equity Weighting | 88.26 |
| Wacc |
Build Up Free Cash
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Revenue | 983.14 | 995.79 | 948.02 | 1,009.42 | 1,112.32 | 1,148.92 | 1,186.72 | 1,225.76 | 1,266.09 | 1,307.74 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 16.33 | 39.60 | -32.92 | 88.36 | 105.14 | 46.81 | 48.35 | 49.94 | 51.58 | 53.28 |
| EBIT | -32.72 | -13.28 | -96.74 | 33.04 | 64.98 | -13.22 | -13.65 | -14.10 | -14.56 | -15.04 |
| Tax Rate | -0.31% | 0.08% | -5.27% | 80.99% | 15.18% | 18.13% | 18.13% | 18.13% | 18.13% | 18.13% |
| EBIAT | -32.83 | -13.27 | -101.84 | 6.28 | 55.12 | -10.82 | -11.17 | -11.54 | -11.92 | -12.31 |
| Depreciation | 49.06 | 52.87 | 63.82 | 55.32 | 40.16 | 60.02 | 62 | 64.04 | 66.15 | 68.32 |
| Accounts Receivable | - | 38.01 | 51.69 | -33.75 | -27.62 | -9.20 | -6.36 | -6.57 | -6.78 | -7.01 |
| Inventories | - | 0.28 | 1 | 29.70 | -16.35 | -13.20 | -2.05 | -2.12 | -2.19 | -2.26 |
| Accounts Payable | - | -9.98 | -17.26 | 11.70 | 24.20 | -8.63 | 2.49 | 2.57 | 2.66 | 2.74 |
| Capital Expenditure | -40.41 | -22.73 | -15.27 | -17.18 | -15.43 | -25.49 | -26.33 | -27.19 | -28.09 | -29.01 |
| UFCF | -24.18 | 45.18 | -17.87 | 52.08 | 60.08 | -7.31 | 18.57 | 19.19 | 19.82 | 20.47 |
| WACC | ||||||||||
| PV UFCF | -6.50 | 14.70 | 13.51 | 12.42 | 11.41 | |||||
| SUM PV UFCF | 45.55 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 12.39 |
| Free cash flow (t + 1) | 20.88 |
| Terminal Value | 200.94 |
| Present Value of Terminal Value | 112.06 |
Intrinsic Value
| Enterprise Value | 157.61 |
|---|---|
| Net Debt | 156.61 |
| Equity Value | 1 |
| Shares Outstanding | 133.49 |
| Equity Value Per Share | 0.01 |