Discounted Cash Flow (DCF) Analysis Unlevered
Luxfer Holdings PLC (LXFR)
$14.62
-0.39 (-2.60%)
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 | 441.30 | 487.90 | 443.50 | 324.80 | 374.10 | 364.63 | 355.40 | 346.40 | 337.63 | 329.08 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| EBITDA | 37.20 | 54.50 | 29.80 | 45.20 | 54 | 39.87 | 38.86 | 37.88 | 36.92 | 35.98 |
| EBITDA (%) | ||||||||||
| EBIT | 18.20 | 35.50 | 14.50 | 31.90 | 38.40 | 25.35 | 24.70 | 24.08 | 23.47 | 22.88 |
| EBIT (%) | ||||||||||
| Depreciation | 19 | 19 | 15.30 | 13.30 | 15.60 | 14.52 | 14.16 | 13.80 | 13.45 | 13.11 |
| 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 | 14.90 | 13.80 | 10.20 | 1.50 | 6.20 | 7.75 | 7.55 | 7.36 | 7.17 | 6.99 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 72.10 | 62.60 | 67.10 | 38.70 | 48.20 | 50.39 | 49.11 | 47.87 | 46.66 | 45.48 |
| Account Receivables (%) | ||||||||||
| Inventories | 82.20 | 93.60 | 94.50 | 68.80 | 90.50 | 76.20 | 74.27 | 72.39 | 70.56 | 68.77 |
| Inventories (%) | ||||||||||
| Accounts Payable | 28.40 | 36.90 | 36.40 | 18.60 | 31.70 | 26.55 | 25.88 | 25.22 | 24.58 | 23.96 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -11.30 | -13.90 | -13.90 | -8 | -9.10 | -9.80 | -9.55 | -9.31 | -9.08 | -8.85 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 14.62 |
|---|---|
| Beta | 0.922 |
| Diluted Shares Outstanding | 28.03 |
| Cost of Debt | |
| Tax Rate | 15.54 |
| After-tax Cost of Debt | 3.62% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 8.237 |
| Total Debt | 72.40 |
| Total Equity | 409.85 |
| Total Capital | 482.25 |
| Debt Weighting | 15.01 |
| Equity Weighting | 84.99 |
| 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 | 441.30 | 487.90 | 443.50 | 324.80 | 374.10 | 364.63 | 355.40 | 346.40 | 337.63 | 329.08 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 37.20 | 54.50 | 29.80 | 45.20 | 54 | 39.87 | 38.86 | 37.88 | 36.92 | 35.98 |
| EBIT | 18.20 | 35.50 | 14.50 | 31.90 | 38.40 | 25.35 | 24.70 | 24.08 | 23.47 | 22.88 |
| Tax Rate | 3.36% | 16.94% | 65.93% | 28.06% | 15.54% | 25.97% | 25.97% | 25.97% | 25.97% | 25.97% |
| EBIAT | 17.59 | 29.49 | 4.94 | 22.95 | 32.43 | 18.76 | 18.29 | 17.83 | 17.38 | 16.94 |
| Depreciation | 19 | 19 | 15.30 | 13.30 | 15.60 | 14.52 | 14.16 | 13.80 | 13.45 | 13.11 |
| Accounts Receivable | - | 9.50 | -4.50 | 28.40 | -9.50 | -2.19 | 1.28 | 1.24 | 1.21 | 1.18 |
| Inventories | - | -11.40 | -0.90 | 25.70 | -21.70 | 14.30 | 1.93 | 1.88 | 1.83 | 1.79 |
| Accounts Payable | - | 8.50 | -0.50 | -17.80 | 13.10 | -5.15 | -0.67 | -0.66 | -0.64 | -0.62 |
| Capital Expenditure | -11.30 | -13.90 | -13.90 | -8 | -9.10 | -9.80 | -9.55 | -9.31 | -9.08 | -8.85 |
| UFCF | 25.29 | 41.19 | 0.44 | 64.55 | 20.83 | 30.44 | 25.42 | 24.78 | 24.15 | 23.54 |
| WACC | ||||||||||
| PV UFCF | 28.31 | 21.98 | 19.93 | 18.06 | 16.37 | |||||
| SUM PV UFCF | 104.65 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 7.54 |
| Free cash flow (t + 1) | 24.01 |
| Terminal Value | 433.45 |
| Present Value of Terminal Value | 301.36 |
Intrinsic Value
| Enterprise Value | 406.01 |
|---|---|
| Net Debt | 66.20 |
| Equity Value | 339.81 |
| Shares Outstanding | 28.03 |
| Equity Value Per Share | 12.12 |