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 |