Discounted Cash Flow (DCF) Analysis Levered
Cloudera, Inc. (CLDR)
- (-%)
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 | 261.03 | 367.44 | 479.94 | 794.19 | 869.26 | 1,187.22 | 1,621.49 | 2,214.60 | 3,024.67 | 4,131.05 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| Operating Cash Flow | -116.56 | -42.27 | 34.27 | -36.83 | 155.82 | -84.83 | -115.87 | -158.25 | -216.13 | -295.19 |
| Operating Cash Flow (%) | ||||||||||
| Capital Expenditure | -7.38 | -12.95 | -10.09 | -7.20 | -10.05 | -24.98 | -34.11 | -46.59 | -63.64 | -86.91 |
| Capital Expenditure (%) | ||||||||||
| Free Cash Flow | -123.95 | -55.22 | 24.19 | -44.03 | 145.77 | -109.81 | -149.98 | -204.84 | -279.77 | -382.10 |
Weighted Average Cost Of Capital
| Share price | $ - |
|---|---|
| Beta | 1.105 |
| Diluted Shares Outstanding | 302.52 |
| Cost of Debt | |
| Tax Rate | -4.73 |
| After-tax Cost of Debt | -% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 8.963 |
| Total Debt | 679.57 |
| Total Equity | - |
| Total Capital | 679.57 |
| Debt Weighting | 100.00 |
| Equity Weighting | 0.00 |
| 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 | 261.03 | 367.44 | 479.94 | 794.19 | 869.26 | 1,187.22 | 1,621.49 | 2,214.60 | 3,024.67 | 4,131.05 |
|---|---|---|---|---|---|---|---|---|---|---|
| Operating Cash Flow | -116.56 | -42.27 | 34.27 | -36.83 | 155.82 | -84.83 | -115.87 | -158.25 | -216.13 | -295.19 |
| Capital Expenditure | -7.38 | -12.95 | -10.09 | -7.20 | -10.05 | -24.98 | -34.11 | -46.59 | -63.64 | -86.91 |
| Free Cash Flow | -123.95 | -55.22 | 24.19 | -44.03 | 145.77 | -109.81 | -149.98 | -204.84 | -279.77 | -382.10 |
| WACC | ||||||||||
| PV LFCF | - | - | - | - | - | |||||
| SUM PV LFCF | - |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | - |
| Free cash flow (t + 1) | -389.75 |
| Terminal Value | - |
| Present Value of Terminal Value | - |
Intrinsic Value
| Enterprise Value | - |
|---|---|
| Net Debt | 380.90 |
| Equity Value | - |
| Shares Outstanding | 302.52 |
| Equity Value Per Share | - |