Discounted Cash Flow (DCF) Analysis Unlevered

LACROIX Group SA (LACR.PA)

33.3 €

-0.20 (-0.60%)
All numbers are in Millions, Currency in USD
Stock DCF: 41.95 | 33.3 | undervalue

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.42468.29481.59566.33501.45520.34539.94560.28581.38603.28
Revenue (%)
EBITDA 19.6122.6329.3730.6734.5728.8129.8931.0232.1933.40
EBITDA (%)
EBIT 12.3611.9415.5817.6723.0516.9617.6018.2718.9519.67
EBIT (%)
Depreciation 7.2510.6913.791311.5211.8412.2912.7513.2313.73
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 18.3318.3113.5554.3933.3828.2429.3030.4131.5532.74
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories 67.5378.0482.6175.48120.3689.9693.3596.87100.52104.30
Inventories (%)
Accounts Payable 75.2278.1971.3177.56106.7086.9290.1993.5997.11100.77
Accounts Payable (%)
Capital Expenditure -12.73-13.12-11.72-17.18-30.49-17.93-18.61-19.31-20.04-20.79
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 33.3
Beta 1.084
Diluted Shares Outstanding 4.06
Cost of Debt
Tax Rate 5.97
After-tax Cost of Debt 0.53%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.861
Total Debt 150.39
Total Equity 135.27
Total Capital 285.66
Debt Weighting 52.65
Equity Weighting 47.35
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.42468.29481.59566.33501.45520.34539.94560.28581.38603.28
EBITDA 19.6122.6329.3730.6734.5728.8129.8931.0232.1933.40
EBIT 12.3611.9415.5817.6723.0516.9617.6018.2718.9519.67
Tax Rate 29.19%25.62%30.64%36.72%5.97%25.63%25.63%25.63%25.63%25.63%
EBIAT 8.758.8810.8111.1821.6812.6213.0913.5914.1014.63
Depreciation 7.2510.6913.791311.5211.8412.2912.7513.2313.73
Accounts Receivable ----------
Inventories --10.51-4.587.14-44.8830.40-3.39-3.52-3.65-3.79
Accounts Payable -2.98-6.886.2429.14-19.783.273.403.533.66
Capital Expenditure -12.73-13.12-11.72-17.18-30.49-17.93-18.61-19.31-20.04-20.79
UFCF 3.27-1.091.4220.38-13.0317.146.666.917.177.44
WACC
PV UFCF 16.416.106.066.025.98
SUM PV UFCF 40.56

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 4.47
Free cash flow (t + 1) 7.59
Terminal Value 307.20
Present Value of Terminal Value 246.87

Intrinsic Value

Enterprise Value 287.44
Net Debt 117.04
Equity Value 170.40
Shares Outstanding 4.06
Equity Value Per Share 41.95