Discounted Cash Flow (DCF) Analysis Unlevered

Galimmo SCA (GALIM.PA)

13.3 €

0.00 (0.00%)
All numbers are in Millions, Currency in USD
Stock DCF: -67.81 | 13.3 | 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 34.8937.2041.6535.7341.8044.0346.3848.8551.4654.21
Revenue (%)
EBITDA 74.1938.3438.21-44.2610.4627.1828.6330.1531.7633.46
EBITDA (%)
EBIT 73.7038.2038.04-45.029.8226.6628.0929.5831.1632.83
EBIT (%)
Depreciation 0.500.130.170.760.640.510.540.570.600.63
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 71.392865.6640.5249.7258.9962.1465.4568.9572.63
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 13.8714.8012.9211.8617.3216.3117.1818.0919.0620.08
Accounts Payable (%)
Capital Expenditure -14.30-21.67-54.55-27.42-32.08-33.79-35.59-37.49-39.50-41.60
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 13.3
Beta 0.074
Diluted Shares Outstanding 29.94
Cost of Debt
Tax Rate 20.03
After-tax Cost of Debt 1.73%
Risk-Free Rate
Market Risk Premium
Cost of Equity 3.200
Total Debt 201.71
Total Equity 398.14
Total Capital 599.85
Debt Weighting 33.63
Equity Weighting 66.37
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 34.8937.2041.6535.7341.8044.0346.3848.8551.4654.21
EBITDA 74.1938.3438.21-44.2610.4627.1828.6330.1531.7633.46
EBIT 73.7038.2038.04-45.029.8226.6628.0929.5831.1632.83
Tax Rate 5.64%30.36%29.58%22.81%20.03%21.69%21.69%21.69%21.69%21.69%
EBIAT 69.5426.6026.79-34.757.8520.882223.1724.4125.71
Depreciation 0.500.130.170.760.640.510.540.570.600.63
Accounts Receivable ----------
Inventories ----------
Accounts Payable -0.94-1.88-1.075.46-1.010.870.920.971.02
Capital Expenditure -14.30-21.67-54.55-27.42-25.19-33.79-35.59-37.49-39.50-41.60
UFCF 55.736-29.48-62.48-18.12-13.41-12.19-12.84-13.52-14.25
WACC
PV UFCF -13.06-11.56-11.85-12.16-12.47
SUM PV UFCF -61.09

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 2.70
Free cash flow (t + 1) -14.53
Terminal Value -2,075.81
Present Value of Terminal Value -1,816.92

Intrinsic Value

Enterprise Value -1,878.01
Net Debt 152
Equity Value -2,030.01
Shares Outstanding 29.94
Equity Value Per Share -67.81