Discounted Cash Flow (DCF) Analysis Levered
creditshelf Aktiengesellschaft (CSQ.DE)
22.2 €
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 | 1.20 | 2.40 | 4.68 | 4.91 | 7.25 | 11.73 | 18.98 | 30.71 | 49.68 | 80.38 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 0.57 | -4.22 | -5.28 | -2.48 | -1.03 | -7.16 | -11.59 | -18.75 | -30.33 | -49.07 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -0.51 | -1.84 | -1.22 | -0.22 | -0.04 | -3.52 | -5.70 | -9.21 | -14.91 | -24.12 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 0.06 | -6.06 | -6.49 | -2.70 | -1.07 | -10.68 | -17.28 | -27.96 | -45.24 | -73.20 |
Weighted Average Cost Of Capital
Share price | $ 22.2 |
---|---|
Beta | 0.169 |
Diluted Shares Outstanding | 1.38 |
Cost of Debt | |
Tax Rate | -0.35 |
After-tax Cost of Debt | 4.67% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 4.318 |
Total Debt | 2.54 |
Total Equity | 30.55 |
Total Capital | 33.09 |
Debt Weighting | 7.67 |
Equity Weighting | 92.33 |
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 | 1.20 | 2.40 | 4.68 | 4.91 | 7.25 | 11.73 | 18.98 | 30.71 | 49.68 | 80.38 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 0.57 | -4.22 | -5.28 | -2.48 | -1.03 | -7.16 | -11.59 | -18.75 | -30.33 | -49.07 |
Capital Expenditure | -0.51 | -1.84 | -1.22 | -0.22 | -0.04 | -3.52 | -5.70 | -9.21 | -14.91 | -24.12 |
Free Cash Flow | 0.06 | -6.06 | -6.49 | -2.70 | -1.07 | -10.68 | -17.28 | -27.96 | -45.24 | -73.20 |
WACC | ||||||||||
PV LFCF | -10.24 | -15.88 | -24.62 | -38.17 | -59.19 | |||||
SUM PV LFCF | -148.09 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 4.34 |
Free cash flow (t + 1) | -74.66 |
Terminal Value | -3,190.58 |
Present Value of Terminal Value | -2,579.97 |
Intrinsic Value
Enterprise Value | -2,728.06 |
---|---|
Net Debt | -1.92 |
Equity Value | -2,726.14 |
Shares Outstanding | 1.38 |
Equity Value Per Share | -1,980.85 |