Discounted Cash Flow (DCF) Analysis Unlevered

Ivy Funds - Delaware Ivy High Incom... (IVH)

$11.18

-0.41 (-3.54%)
All numbers are in Millions, Currency in USD
Stock DCF: 35,619.36 | 11.18 | 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 29.9328.74-3.1938.90-46.39145.19-454.341,421.83-4,449.4913,924.29
Revenue (%)
EBITDA 7.34-7.01-2.3039.30-45.4078.70-246.29770.76-2,412.027,548.19
EBITDA (%)
EBIT -----78.70-246.29770.76-2,412.027,548.19
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 1.361.040.780.111.84-5.7718.05-56.49176.78-553.22
Total Cash (%)
Account Receivables 1.541.035.605.976.35-47.90149.89-469.061,467.88-4,593.61
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 9.310.347.275.221.66-53.82168.43-527.081,649.45-5,161.82
Accounts Payable (%)
Capital Expenditure ----------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 11.18
Beta 0.000
Diluted Shares Outstanding 16.57
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt 1.55%
Risk-Free Rate
Market Risk Premium
Cost of Equity 3.714
Total Debt 87
Total Equity 185.25
Total Capital 272.25
Debt Weighting 31.96
Equity Weighting 68.04
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 29.9328.74-3.1938.90-46.39145.19-454.341,421.83-4,449.4913,924.29
EBITDA 7.34-7.01-2.3039.30-45.4078.70-246.29770.76-2,412.027,548.19
EBIT -----78.70-246.29770.76-2,412.027,548.19
Tax Rate 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
EBIAT -----78.70-246.29770.76-2,412.027,548.19
Depreciation ----------
Accounts Receivable -0.51-4.57-0.37-0.3754.24-197.78618.95-1,936.946,061.50
Inventories ----------
Accounts Payable --8.976.93-2.05-3.56-55.48222.25-695.512,176.53-6,811.27
Capital Expenditure ----------
UFCF -----77.47-221.83694.20-2,172.436,798.42
WACC
PV UFCF 75.20-209.01634.92-1,928.675,858.69
SUM PV UFCF 4,431.11

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 3.02
Free cash flow (t + 1) 6,934.39
Terminal Value 679,842.03
Present Value of Terminal Value 585,868.68

Intrinsic Value

Enterprise Value 590,299.80
Net Debt 87
Equity Value 590,212.80
Shares Outstanding 16.57
Equity Value Per Share 35,619.36