Discounted Cash Flow (DCF) Analysis Unlevered
Brunel International N.V. (BRNL.AS)
12.56 €
+0.06 (+0.48%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Revenue | 914.58 | 1,041.12 | 892.57 | 899.67 | 1,181.82 | 1,275.56 | 1,376.72 | 1,485.92 | 1,603.77 | 1,730.96 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| EBITDA | 40.61 | 41.07 | 49.81 | 66.01 | 80.44 | 71.71 | 77.40 | 83.54 | 90.16 | 97.31 |
| EBITDA (%) | ||||||||||
| EBIT | 33.23 | 17.47 | 28.99 | 47.55 | 59.11 | 48.08 | 51.89 | 56.01 | 60.45 | 65.24 |
| EBIT (%) | ||||||||||
| Depreciation | 7.39 | 23.60 | 20.82 | 18.46 | 21.33 | 23.63 | 25.51 | 27.53 | 29.71 | 32.07 |
| Depreciation (%) |
Balance Sheet Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Total Cash | 86.02 | 84.63 | 139.90 | 62.86 | 43.76 | 111.99 | 120.87 | 130.45 | 140.80 | 151.97 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | - | - | - | - | - | - | - | - | - | - |
| Account Receivables (%) | ||||||||||
| Inventories | - | - | - | - | - | - | - | - | - | - |
| Inventories (%) | ||||||||||
| Accounts Payable | 16.80 | 16.82 | 15.36 | 19.15 | 22.90 | 23.57 | 25.44 | 27.46 | 29.64 | 31.99 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -7.23 | -6.55 | -7.21 | -6.54 | -11.27 | -9.97 | -10.76 | -11.61 | -12.53 | -13.53 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 12.56 |
|---|---|
| Beta | 1.215 |
| Diluted Shares Outstanding | 50.54 |
| Cost of Debt | |
| Tax Rate | 38.13 |
| After-tax Cost of Debt | 1.13% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 10.279 |
| Total Debt | 64.26 |
| Total Equity | 634.76 |
| Total Capital | 699.02 |
| Debt Weighting | 9.19 |
| Equity Weighting | 90.81 |
| Wacc |
Build Up Free Cash
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Revenue | 914.58 | 1,041.12 | 892.57 | 899.67 | 1,181.82 | 1,275.56 | 1,376.72 | 1,485.92 | 1,603.77 | 1,730.96 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 40.61 | 41.07 | 49.81 | 66.01 | 80.44 | 71.71 | 77.40 | 83.54 | 90.16 | 97.31 |
| EBIT | 33.23 | 17.47 | 28.99 | 47.55 | 59.11 | 48.08 | 51.89 | 56.01 | 60.45 | 65.24 |
| Tax Rate | 36.61% | 99.19% | 45.32% | 33.95% | 38.13% | 50.64% | 50.64% | 50.64% | 50.64% | 50.64% |
| EBIAT | 21.06 | 0.14 | 15.85 | 31.41 | 36.57 | 23.73 | 25.61 | 27.65 | 29.84 | 32.20 |
| Depreciation | 7.39 | 23.60 | 20.82 | 18.46 | 21.33 | 23.63 | 25.51 | 27.53 | 29.71 | 32.07 |
| Accounts Receivable | - | - | - | - | - | - | - | - | - | - |
| Inventories | - | - | - | - | - | - | - | - | - | - |
| Accounts Payable | - | 0.02 | -1.46 | 3.79 | 3.75 | 0.68 | 1.87 | 2.02 | 2.18 | 2.35 |
| Capital Expenditure | -7.23 | -6.54 | -7.21 | -6.54 | -11.27 | -9.97 | -10.76 | -11.61 | -12.53 | -13.53 |
| UFCF | 21.22 | 17.22 | 28 | 47.12 | 50.37 | 38.07 | 42.23 | 45.58 | 49.19 | 53.10 |
| WACC | ||||||||||
| PV UFCF | 34.79 | 35.26 | 34.77 | 34.29 | 33.82 | |||||
| SUM PV UFCF | 172.93 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 9.44 |
| Free cash flow (t + 1) | 54.16 |
| Terminal Value | 727.93 |
| Present Value of Terminal Value | 463.67 |
Intrinsic Value
| Enterprise Value | 636.61 |
|---|---|
| Net Debt | 20.50 |
| Equity Value | 616.11 |
| Shares Outstanding | 50.54 |
| Equity Value Per Share | 12.19 |