Discounted Cash Flow (DCF) Analysis Unlevered

Alimera Sciences, Inc. (ALIM)

$3.495

+0.01 (+0.14%)
All numbers are in Millions, Currency in USD
Stock DCF: -12.04 | 3.495 | 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 46.9753.9450.8259.0354.1356.4258.8061.2963.8866.58
Revenue (%)
EBITDA -7.02-2.632.172.38-8.93-3.16-3.30-3.44-3.58-3.73
EBITDA (%)
EBIT -9.67-5.27-0.50-0.20-11.64-6-6.26-6.52-6.80-7.08
EBIT (%)
Depreciation 2.652.642.682.582.712.842.963.083.213.35
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 13.049.4311.2116.515.2711.8512.3512.8713.4213.98
Total Cash (%)
Account Receivables 17.2619.3317.2019.1319.6119.7520.5921.4622.3723.31
Account Receivables (%)
Inventories 2.411.392.752.681.612.322.422.532.632.74
Inventories (%)
Accounts Payable 6.367.087.468.7110.098.438.799.169.559.95
Accounts Payable (%)
Capital Expenditure -0.17-0.17-0.62-0.62-0.26-0.39-0.40-0.42-0.44-0.46
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 3.495
Beta 1.433
Diluted Shares Outstanding 7
Cost of Debt
Tax Rate -0.15
After-tax Cost of Debt 13.27%
Risk-Free Rate
Market Risk Premium
Cost of Equity 11.069
Total Debt 44.33
Total Equity 24.45
Total Capital 68.78
Debt Weighting 64.45
Equity Weighting 35.55
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 46.9753.9450.8259.0354.1356.4258.8061.2963.8866.58
EBITDA -7.02-2.632.172.38-8.93-3.16-3.30-3.44-3.58-3.73
EBIT -9.67-5.27-0.50-0.20-11.64-6-6.26-6.52-6.80-7.08
Tax Rate -0.65%-2.11%1.26%-11.13%-0.15%-2.56%-2.56%-2.56%-2.56%-2.56%
EBIAT -9.73-5.39-0.49-0.22-11.66-6.16-6.42-6.69-6.97-7.26
Depreciation 2.652.642.682.582.712.842.963.083.213.35
Accounts Receivable --2.072.13-1.93-0.48-0.14-0.83-0.87-0.91-0.95
Inventories -1.02-1.360.071.07-0.72-0.10-0.10-0.11-0.11
Accounts Payable -0.720.381.241.38-1.660.360.370.390.40
Capital Expenditure -0.17-0.17-0.62-0.62-0.26-0.39-0.40-0.42-0.44-0.46
UFCF -7.26-3.252.721.12-7.24-6.22-4.44-4.63-4.82-5.03
WACC
PV UFCF -5.53-3.51-3.25-3.01-2.79
SUM PV UFCF -18.09

Terminal Value

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

Intrinsic Value

Enterprise Value -45.22
Net Debt 39.05
Equity Value -84.27
Shares Outstanding 7
Equity Value Per Share -12.04