Discounted Cash Flow (DCF) Analysis Unlevered

Cloudera, Inc. (CLDR)

-15.98 (-%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 0 | undervalue

Operating Data

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 (%)
EBITDA -175-371.61-169.80-235.73-65.99-571.84-781-1,066.68-1,456.86-1,989.76
EBITDA (%)
EBIT -185.13-383.71-187.23-327.88-155.39-649.47-887.03-1,211.50-1,654.64-2,259.89
EBIT (%)
Depreciation 10.1312.1017.4392.1689.3977.63106.03144.81197.78270.13
Depreciation (%)

Balance Sheet Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 234.96371.09480.68361596.39962.181,314.131,794.812,451.333,347.99
Total Cash (%)
Account Receivables 101.55130.58247.80254.62316.10461.82630.75861.471,176.581,606.96
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 3.552.728.193.862.7110.9314.9320.3927.8538.04
Accounts Payable (%)
Capital Expenditure -7.38-12.95-10.09-7.20-10.05-24.98-34.11-46.59-63.64-86.91
Capital Expenditure (%)

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 9.182
Total Debt 679.57
Total Equity -
Total Capital 679.57
Debt Weighting 100.00
Equity Weighting 0.00
Wacc

Build Up Free Cash

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
EBITDA -175-371.61-169.80-235.73-65.99-571.84-781-1,066.68-1,456.86-1,989.76
EBIT -185.13-383.71-187.23-327.88-155.39-649.47-887.03-1,211.50-1,654.64-2,259.89
Tax Rate -1.18%-0.54%-2.89%-2.65%-4.73%-2.40%-2.40%-2.40%-2.40%-2.40%
EBIAT -187.32-385.79-192.65-336.58-162.73-665.05-908.32-1,240.57-1,694.35-2,314.11
Depreciation 10.1312.1017.4392.1689.3977.63106.03144.81197.78270.13
Accounts Receivable --29.03-117.23-6.81-61.48-145.72-168.93-230.72-315.11-430.38
Inventories ----------
Accounts Payable --0.835.46-4.33-1.148.2245.467.4610.19
Capital Expenditure -7.38-12.95-10.09-7.20-10.05-24.98-34.11-46.59-63.64-86.91
UFCF -184.57-416.50-297.07-262.77-146.02-749.90-1,001.33-1,367.60-1,867.85-2,551.09
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -
Free cash flow (t + 1) -2,602.11
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 -