Discounted Cash Flow (DCF) Analysis Levered

Cloudera, Inc. (CLDR)

-15.98 (-%)
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.03367.44479.94794.19869.261,187.221,621.492,214.603,024.674,131.05
Revenue (%)
Operating Cash Flow -116.56-42.2734.27-36.83155.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.2224.19-44.03145.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 7.945
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.03367.44479.94794.19869.261,187.221,621.492,214.603,024.674,131.05
Operating Cash Flow -116.56-42.2734.27-36.83155.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.2224.19-44.03145.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 -