Discounted Cash Flow (DCF) Analysis Unlevered
Hexaom S.A. (HEXA.PA)
27.5 €
0.00 (0.00%)
All numbers are in Millions, Currency in USD
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 | 765.60 | 804.23 | 841.95 | 881.90 | 997.46 | 1,066.24 | 1,139.77 | 1,218.37 | 1,302.39 | 1,392.20 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| EBITDA | 46.90 | 40.42 | 41.04 | 43.84 | 52.92 | 56.09 | 59.96 | 64.09 | 68.51 | 73.24 |
| EBITDA (%) | ||||||||||
| EBIT | 42.99 | 36.53 | 28.22 | 29.85 | 31.74 | 42.81 | 45.76 | 48.92 | 52.29 | 55.90 |
| EBIT (%) | ||||||||||
| Depreciation | 3.91 | 3.89 | 12.82 | 13.98 | 21.18 | 13.28 | 14.20 | 15.18 | 16.22 | 17.34 |
| 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 | 147.41 | 155.49 | 130.33 | 171.79 | 167.26 | 192.60 | 205.88 | 220.08 | 235.25 | 251.48 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | - | - | - | - | - | - | - | - | - | - |
| Account Receivables (%) | ||||||||||
| Inventories | 27.98 | 28.40 | 40.79 | 71.28 | 78.43 | 59.66 | 63.78 | 68.17 | 72.87 | 77.90 |
| Inventories (%) | ||||||||||
| Accounts Payable | 136.18 | 143.18 | 171.02 | 188.78 | 202.64 | 208.18 | 222.54 | 237.89 | 254.29 | 271.83 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -6.21 | -11.40 | -1.97 | -5.34 | -6.87 | -8.01 | -8.57 | -9.16 | -9.79 | -10.46 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 27.5 |
|---|---|
| Beta | 1.246 |
| Diluted Shares Outstanding | 6.85 |
| Cost of Debt | |
| Tax Rate | 31.07 |
| After-tax Cost of Debt | 0.74% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 8.732 |
| Total Debt | 137.95 |
| Total Equity | 188.26 |
| Total Capital | 326.21 |
| Debt Weighting | 42.29 |
| Equity Weighting | 57.71 |
| 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 | 765.60 | 804.23 | 841.95 | 881.90 | 997.46 | 1,066.24 | 1,139.77 | 1,218.37 | 1,302.39 | 1,392.20 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 46.90 | 40.42 | 41.04 | 43.84 | 52.92 | 56.09 | 59.96 | 64.09 | 68.51 | 73.24 |
| EBIT | 42.99 | 36.53 | 28.22 | 29.85 | 31.74 | 42.81 | 45.76 | 48.92 | 52.29 | 55.90 |
| Tax Rate | 32.70% | 29.91% | 30.30% | 30.43% | 31.07% | 30.88% | 30.88% | 30.88% | 30.88% | 30.88% |
| EBIAT | 28.93 | 25.60 | 19.67 | 20.77 | 21.88 | 29.59 | 31.63 | 33.81 | 36.14 | 38.64 |
| Depreciation | 3.91 | 3.89 | 12.82 | 13.98 | 21.18 | 13.28 | 14.20 | 15.18 | 16.22 | 17.34 |
| Accounts Receivable | - | - | - | - | - | - | - | - | - | - |
| Inventories | - | -0.42 | -12.39 | -30.49 | -7.15 | 18.77 | -4.11 | -4.40 | -4.70 | -5.03 |
| Accounts Payable | - | 7 | 27.84 | 17.75 | 13.87 | 5.54 | 14.36 | 15.35 | 16.40 | 17.54 |
| Capital Expenditure | -6.21 | -11.40 | -1.97 | -5.34 | -6.87 | -8.01 | -8.57 | -9.16 | -9.79 | -10.46 |
| UFCF | 26.63 | 24.67 | 45.97 | 16.68 | 42.91 | 59.17 | 47.50 | 50.78 | 54.28 | 58.02 |
| WACC | ||||||||||
| PV UFCF | 56.16 | 42.80 | 43.43 | 44.07 | 44.71 | |||||
| SUM PV UFCF | 231.17 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 5.35 |
| Free cash flow (t + 1) | 59.18 |
| Terminal Value | 1,766.69 |
| Present Value of Terminal Value | 1,361.41 |
Intrinsic Value
| Enterprise Value | 1,592.58 |
|---|---|
| Net Debt | -29.32 |
| Equity Value | 1,621.90 |
| Shares Outstanding | 6.85 |
| Equity Value Per Share | 236.92 |