Discounted Cash Flow (DCF) Analysis Levered
Avaya Holdings Corp. (AVYA)
$0.2753
0.00 (0.00%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Revenue | 3,272 | 2,887 | 2,887 | 2,873 | 2,973 | 2,886.08 | 2,801.70 | 2,719.79 | 2,640.28 | 2,563.09 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 291 | 241 | 241 | 147 | 30 | 183.06 | 177.71 | 172.52 | 167.47 | 162.58 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -59 | -113 | -113 | -98 | -106 | -95.86 | -93.06 | -90.34 | -87.70 | -85.13 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 232 | 128 | 128 | 49 | -76 | 87.20 | 84.65 | 82.18 | 79.77 | 77.44 |
Weighted Average Cost Of Capital
Share price | $ 0.2,753 |
---|---|
Beta | 0.000 |
Diluted Shares Outstanding | 84.50 |
Cost of Debt | |
Tax Rate | 750.00 |
After-tax Cost of Debt | -48.69% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 3.745 |
Total Debt | 2,964 |
Total Equity | 23.26 |
Total Capital | 2,987.26 |
Debt Weighting | 99.22 |
Equity Weighting | 0.78 |
Wacc |
Build Up Free Cash Flow
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
Revenue | 3,272 | 2,887 | 2,887 | 2,873 | 2,973 | 2,886.08 | 2,801.70 | 2,719.79 | 2,640.28 | 2,563.09 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 291 | 241 | 241 | 147 | 30 | 183.06 | 177.71 | 172.52 | 167.47 | 162.58 |
Capital Expenditure | -59 | -113 | -113 | -98 | -106 | -95.86 | -93.06 | -90.34 | -87.70 | -85.13 |
Free Cash Flow | 232 | 128 | 128 | 49 | -76 | 87.20 | 84.65 | 82.18 | 79.77 | 77.44 |
WACC | ||||||||||
PV LFCF | 325.99 | 611.86 | 1,148.44 | 2,155.59 | 4,045.95 | |||||
SUM PV LFCF | 4,286.47 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | -48.28 |
Free cash flow (t + 1) | 78.99 |
Terminal Value | -157.10 |
Present Value of Terminal Value | -4,245.06 |
Intrinsic Value
Enterprise Value | 41.41 |
---|---|
Net Debt | 2,466 |
Equity Value | -2,424.59 |
Shares Outstanding | 84.50 |
Equity Value Per Share | -28.69 |