Discounted Cash Flow (DCF) Analysis Unlevered

Cohen & Steers Closed-End Opportuni... (FOF)

$11.28

+0.13 (+1.17%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 11.28 | undervalue

Operating Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 82.794.3065.96-69.17-330.75-1,581.53-7,562.31-36,160.12-172,904.13
Revenue (%)
EBITDA 82.794.3065.96-69.17-330.75-1,581.53-7,562.31-36,160.12-172,904.12
EBITDA (%)
EBIT -----330.75-1,581.53-7,562.31-36,160.12-172,904.12
EBIT (%)
Depreciation ---------
Depreciation (%)

Balance Sheet Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 0.880.480.230.25-10.10-48.29-230.89-1,104.04-5,279.12
Total Cash (%)
Account Receivables 0.832.550.811.20-49.54-236.90-1,132.76-5,416.45-25,899.45
Account Receivables (%)
Inventories 6.677.043.143.52-141.73-677.69-3,240.44-15,494.55-74,089.14
Inventories (%)
Accounts Payable 3.392.7822.65-23.75-113.55-542.95-2,596.17-12,413.93-59,358.74
Accounts Payable (%)
Capital Expenditure ---------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 11.28
Beta 0.000
Diluted Shares Outstanding 27.34
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt -%
Risk-Free Rate
Market Risk Premium
Cost of Equity 4.236
Total Debt -
Total Equity 308.40
Total Capital -
Debt Weighting -
Equity Weighting -
Wacc

Build Up Free Cash

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 82.794.3065.96-69.17-330.75-1,581.53-7,562.31-36,160.12-172,904.13
EBITDA 82.794.3065.96-69.17-330.75-1,581.53-7,562.31-36,160.12-172,904.12
EBIT -----330.75-1,581.53-7,562.31-36,160.12-172,904.12
Tax Rate 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
EBIAT -----330.75-1,581.53-7,562.31-36,160.12-172,904.12
Depreciation ---------
Accounts Receivable --1.731.74-0.3950.74187.36895.864,283.6920,482.99
Inventories --0.373.90-0.38145.24535.962,562.7512,254.1258,594.59
Accounts Payable --0.6119.87-46.39-89.80-429.40-2,053.22-9,817.75-46,944.81
Capital Expenditure ---------
UFCF -----224.57-1,287.62-6,156.92-29,440.06-140,771.34
WACC
PV UFCF -224.57----
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

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