Discounted Cash Flow (DCF) Analysis Unlevered

BNY Mellon New York Tax Exempt Bond... (DRNYX)

$13.58

-0.01 (-0.07%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 13.58 | 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 2.182.142.041.841.961.911.861.821.771.73
Revenue (%)
EBITDA 0.60-0.431.43-1.93-5.64-1.21-1.18-1.15-1.12-1.09
EBITDA (%)
EBIT ------1.21-1.18-1.15-1.12-1.09
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.910.511.621.931.221.191.161.131.111.08
Total Cash (%)
Account Receivables 0.721.411.660.600.640.930.910.890.870.85
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable -0.710.680.610.650.630.620.600.590.57
Accounts Payable (%)
Capital Expenditure ----------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 13.58
Beta 0.960
Diluted Shares Outstanding 3.92
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt -%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.858
Total Debt -
Total Equity 53.30
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 2.182.142.041.841.961.911.861.821.771.73
EBITDA 0.60-0.431.43-1.93-5.64-1.21-1.18-1.15-1.12-1.09
EBIT ------1.21-1.18-1.15-1.12-1.09
Tax Rate 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
EBIAT ------1.21-1.18-1.15-1.12-1.09
Depreciation ----------
Accounts Receivable --0.69-0.251.06-0.04-0.300.020.020.020.02
Inventories ----------
Accounts Payable ---0.03-0.070.04-0.02-0.02-0.02-0.01-0.01
Capital Expenditure ----------
UFCF ------1.52-1.17-1.14-1.11-1.09
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

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