Discounted Cash Flow (DCF) Analysis Unlevered

Lumibird SA (LBIRD.PA)

14.06 €

+0.08 (+0.57%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 14.06 | undervalue

Operating Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 112.65129.50166.39190.96203.60236.60274.94319.50371.28431.45
Revenue (%)
EBITDA 20.7519.8532.7930.68203.6080.2193.21108.32125.87146.27
EBITDA (%)
EBIT 12.2410.1420.4116.37188.3462.4872.6184.3798.05113.94
EBIT (%)
Depreciation 8.509.7112.3814.3115.2617.7320.6023.9427.8232.33
Depreciation (%)

Balance Sheet Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Total Cash 50.3080.3397.1361.68100.45116.73135.65157.64183.18212.87
Total Cash (%)
Account Receivables 22.2544.3739.9058.7755.3664.3374.7686.87100.95117.32
Account Receivables (%)
Inventories 26.2637.2045.8566.5058.2467.6778.6491.39106.20123.41
Inventories (%)
Accounts Payable 9.1011.9513.1918.1217.6720.5323.8627.7332.2237.45
Accounts Payable (%)
Capital Expenditure -11.28-12.38-20.11-29.44-23.96-27.84-32.36-37.60-43.69-50.77
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 14.06
Beta 1.252
Diluted Shares Outstanding -
Cost of Debt
Tax Rate 20.20
After-tax Cost of Debt 3.99%
Risk-Free Rate
Market Risk Premium
Cost of Equity 10.194
Total Debt -
Total Equity -
Total Capital -
Debt Weighting -
Equity Weighting -
Wacc

Build Up Free Cash

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 112.65129.50166.39190.96203.60236.60274.94319.50371.28431.45
EBITDA 20.7519.8532.7930.68203.6080.2193.21108.32125.87146.27
EBIT 12.2410.1420.4116.37188.3462.4872.6184.3798.05113.94
Tax Rate 16.58%21.59%21.27%21.36%20.20%20.20%20.20%20.20%20.20%20.20%
EBIAT 10.217.9516.0612.88150.3049.8657.9467.3378.2490.92
Depreciation 8.509.7112.3814.3115.2617.7320.6023.9427.8232.33
Accounts Receivable --22.124.47-18.873.41-8.97-10.43-12.12-14.08-16.36
Inventories --10.95-8.65-20.658.26-9.44-10.97-12.75-14.81-17.21
Accounts Payable -2.851.234.93-0.442.863.333.874.495.22
Capital Expenditure -11.28-12.38-20.11-29.45-23.96-27.84-32.36-37.60-43.69-50.77
UFCF 7.43-24.935.40-36.86152.8224.2028.1232.6837.9844.13
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

Enterprise Value -
Net Debt -
Equity Value -
Shares Outstanding -
Equity Value Per Share -