Discounted Cash Flow (DCF) Analysis Unlevered

Galimmo SCA (GALIM.PA)

15.1 €

+0.10 (+0.67%)
All numbers are in Millions, Currency in USD
Stock DCF: -63.09 | 15.1 | overvalue

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 37.2041.6535.7341.8044.6747.0849.6352.3155.1358.11
Revenue (%)
EBITDA 38.4338.63-44.2610.4841.0917.8218.7819.8020.8621.99
EBITDA (%)
EBIT 38.2938.46-45.029.8440.1217.2018.1319.1120.1421.23
EBIT (%)
Depreciation 0.130.170.760.640.970.620.650.690.730.77
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 2865.6638.5248.6864.8756.7359.7963.0266.4270.01
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 14.8112.9211.8617.3219.4017.7818.7519.7620.8321.95
Accounts Payable (%)
Capital Expenditure -21.67-54.56-33.81-39.55-42.27-44.55-46.96-49.50-52.17-54.99
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 15.1
Beta 0.075
Diluted Shares Outstanding 31.59
Cost of Debt
Tax Rate 27.90
After-tax Cost of Debt 1.67%
Risk-Free Rate
Market Risk Premium
Cost of Equity 4.794
Total Debt 204.29
Total Equity 477.07
Total Capital 681.36
Debt Weighting 29.98
Equity Weighting 70.02
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 37.2041.6535.7341.8044.6747.0849.6352.3155.1358.11
EBITDA 38.4338.63-44.2610.4841.0917.8218.7819.8020.8621.99
EBIT 38.2938.46-45.029.8440.1217.2018.1319.1120.1421.23
Tax Rate 30.36%29.58%22.81%20.03%27.90%26.14%26.14%26.14%26.14%26.14%
EBIAT 26.6727.08-34.757.8728.9212.7013.3914.1114.8715.68
Depreciation 0.130.170.760.640.970.620.650.690.730.77
Accounts Receivable ----------
Inventories ----------
Accounts Payable --1.88-1.075.462.08-1.610.961.011.071.12
Capital Expenditure -21.67-54.55-33.81-25.19-19.07-44.55-46.96-49.50-52.17-54.99
UFCF 5.13-29.19-68.87-25.58-10.30-32.84-31.96-33.68-35.50-37.42
WACC
PV UFCF -31.62-29.62-30.06-30.51-30.96
SUM PV UFCF -152.78

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 3.86
Free cash flow (t + 1) -38.17
Terminal Value -2,051.93
Present Value of Terminal Value -1,697.93

Intrinsic Value

Enterprise Value -1,850.71
Net Debt 142.38
Equity Value -1,993.10
Shares Outstanding 31.59
Equity Value Per Share -63.09