Discounted Cash Flow (DCF) Analysis Unlevered

Advent Convertible and Income Fund (AVK)

$11.44

+0.22 (+1.96%)
All numbers are in Millions, Currency in USD
Stock DCF: -7.73 | 11.44 | overvalue

Operating Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 60.76-13.3556.9543.13193.7036.917.031.340.260.05
Revenue (%)
EBITDA 63.21-7.3967.5250.98198.8636.827.011.340.250.05
EBITDA (%)
EBIT -----36.827.011.340.250.05
EBIT (%)
Depreciation ----------
Depreciation (%)

Balance Sheet Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 0.01-00.0100.0200000
Total Cash (%)
Account Receivables 6.6828.0618.0715.5336.59-8.31-1.58-0.30-0.06-0.01
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 2.5521.4716.0828.2121.72-3.82-0.73-0.14-0.03-0.01
Accounts Payable (%)
Capital Expenditure ----------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 11.44
Beta 1.327
Diluted Shares Outstanding 34.53
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt 2.87%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.956
Total Debt 324.03
Total Equity 395
Total Capital 719.03
Debt Weighting 45.07
Equity Weighting 54.93
Wacc

Build Up Free Cash

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 60.76-13.3556.9543.13193.7036.917.031.340.260.05
EBITDA 63.21-7.3967.5250.98198.8636.827.011.340.250.05
EBIT -----36.827.011.340.250.05
Tax Rate 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
EBIAT -----36.827.011.340.250.05
Depreciation ----------
Accounts Receivable --21.389.982.54-21.0644.90-6.73-1.28-0.24-0.05
Inventories ----------
Accounts Payable -18.92-5.3912.13-6.49-25.543.090.590.110.02
Capital Expenditure ----------
UFCF -----56.173.380.640.120.02
WACC
PV UFCF 52.622.970.530.090.02
SUM PV UFCF 56.23

Terminal Value

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

Intrinsic Value

Enterprise Value 56.59
Net Debt 323.37
Equity Value -266.78
Shares Outstanding 34.53
Equity Value Per Share -7.73