Discounted Cash Flow (DCF) Analysis Unlevered

Sogeclair SA (SOG.PA)

19.95 €

+0.25 (+1.27%)
All numbers are in Millions, Currency in USD
Stock DCF: 0.25 | 19.95 | overvalue

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 147.32159.44184.97123.05121.04117.75114.55111.44108.41105.46
Revenue (%)
EBITDA 12.5912.4215.682.014.977.1976.816.626.44
EBITDA (%)
EBIT 8.808.568-13.694.521.951.901.851.801.75
EBIT (%)
Depreciation 3.783.867.6715.690.465.245.104.964.834.70
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 24.2219.4718.9645.8827.8423.3622.7222.1021.5020.92
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories 8.6512.1312.5610.8510.768.948.708.468.238.01
Inventories (%)
Accounts Payable 13.3018.7021.1815.7815.6813.6513.2812.9212.5712.23
Accounts Payable (%)
Capital Expenditure -4.36-4.26-3.64-3.92-4.49-3.41-3.32-3.23-3.14-3.06
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 19.95
Beta 1.653
Diluted Shares Outstanding 107.49
Cost of Debt
Tax Rate 43.21
After-tax Cost of Debt 1.12%
Risk-Free Rate
Market Risk Premium
Cost of Equity 11.300
Total Debt 29.75
Total Equity 2,144.35
Total Capital 2,174.10
Debt Weighting 1.37
Equity Weighting 98.63
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 147.32159.44184.97123.05121.04117.75114.55111.44108.41105.46
EBITDA 12.5912.4215.682.014.977.1976.816.626.44
EBIT 8.808.568-13.694.521.951.901.851.801.75
Tax Rate 34.33%21.66%36.41%2.84%43.21%27.69%27.69%27.69%27.69%27.69%
EBIAT 5.786.705.09-13.302.561.411.371.331.301.26
Depreciation 3.783.867.6715.690.465.245.104.964.834.70
Accounts Receivable ----------
Inventories --3.48-0.441.720.091.810.240.240.230.22
Accounts Payable -5.402.48-5.40-0.10-2.02-0.37-0.36-0.35-0.34
Capital Expenditure -4.36-4.26-3.64-3.92-4.49-3.41-3.32-3.23-3.14-3.06
UFCF 5.218.2211.17-5.21-1.473.033.032.942.862.79
WACC
PV UFCF 2.732.452.141.881.64
SUM PV UFCF 10.83

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 11.16
Free cash flow (t + 1) 2.84
Terminal Value 31.01
Present Value of Terminal Value 18.27

Intrinsic Value

Enterprise Value 29.11
Net Debt 1.92
Equity Value 27.19
Shares Outstanding 107.49
Equity Value Per Share 0.25