Discounted Cash Flow (DCF) Analysis Levered

ID Logistics Group SA (IDL.PA)

241.5 €

+8.50 (+3.65%)
All numbers are in Millions, Currency in USD
Stock DCF: -Infinity | 241.5 | overvalue

Free Cash Flow

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 1,410.301,534.241,642.831,910.872,481.322,866.143,310.643,824.074,417.135,102.17
Revenue (%)
Operating Cash Flow 61.67182.14212.03271.28343.33327.80378.64437.36505.18583.53
Operating Cash Flow (%)
Capital Expenditure -58.74-67.09-59.31-83.67-67.54-110.34-127.45-147.22-170.05-196.42
Capital Expenditure (%)
Free Cash Flow 2.93115.05152.72187.61275.79217.46251.18290.14335.14387.11

Weighted Average Cost Of Capital

Share price $ 241.5
Beta 0.881
Diluted Shares Outstanding -
Cost of Debt
Tax Rate 43.26
After-tax Cost of Debt 1.43%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.765
Total Debt 1,225.56
Total Equity -
Total Capital 1,225.56
Debt Weighting 100.00
Equity Weighting 0.00
Wacc

Build Up Free Cash Flow

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 1,410.301,534.241,642.831,910.872,481.322,866.143,310.643,824.074,417.135,102.17
Operating Cash Flow 61.67182.14212.03271.28343.33327.80378.64437.36505.18583.53
Capital Expenditure -58.74-67.09-59.31-83.67-67.54-110.34-127.45-147.22-170.05-196.42
Free Cash Flow 2.93115.05152.72187.61275.79217.46251.18290.14335.14387.11
WACC
PV LFCF 211.37240.71274.12312.17355.50
SUM PV LFCF 1,413.80

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 1.43
Free cash flow (t + 1) 394.85
Terminal Value -69,272.56
Present Value of Terminal Value -64,525.17

Intrinsic Value

Enterprise Value -63,111.36
Net Debt 1,041.92
Equity Value -64,153.29
Shares Outstanding -
Equity Value Per Share -Infinity