Discounted Cash Flow (DCF) Analysis Unlevered

AB Select US Equity Portfolio (AUUCX)

$18.09

+0.14 (+0.78%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 18.09 | undervalue

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 10.1010.2510.4715.0125.4732.9042.5054.9070.9291.60
Revenue (%)
EBITDA 5.993.888.74-58.13-24.14-19.84-25.63-33.10-42.76-55.23
EBITDA (%)
EBIT ------19.84-25.63-33.10-42.76-55.23
EBIT (%)
Depreciation ----------
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 0.480.090.971.320.141.602.072.673.454.46
Total Cash (%)
Account Receivables 2.522.382.348.906.6710.2613.2617.1222.1228.57
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable --0.500.721.221.572.032.623.394.38
Accounts Payable (%)
Capital Expenditure ----------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 18.09
Beta 0.880
Diluted Shares Outstanding 46.80
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt -%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.313
Total Debt -
Total Equity 846.70
Total Capital -
Debt Weighting -
Equity Weighting -
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 10.1010.2510.4715.0125.4732.9042.5054.9070.9291.60
EBITDA 5.993.888.74-58.13-24.14-19.84-25.63-33.10-42.76-55.23
EBIT ------19.84-25.63-33.10-42.76-55.23
Tax Rate 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
EBIAT ------19.84-25.63-33.10-42.76-55.23
Depreciation ----------
Accounts Receivable -0.140.03-6.562.24-3.60-2.99-3.87-5-6.45
Inventories ----------
Accounts Payable ---0.220.500.350.460.590.770.99
Capital Expenditure ----------
UFCF ------23.08-28.16-36.38-46.99-60.70
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

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