Discounted Cash Flow (DCF) Analysis Levered

Wheeler Real Estate Investment Trus... (WHLRW)

- (-%)
All numbers are in Millions, Currency in USD
Stock DCF: -1.27 | | overvalue

Free Cash Flow

Year
A/P
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Revenue 27,734.2144,160.4158.5458.5463.1656.2750.1344.6639.7935.45
Revenue (%)
Operating Cash Flow -9.3010.4424.762215.2511.7110.439.298.287.37
Operating Cash Flow (%)
Capital Expenditure -0.53-1.96-7.37-5.57-2.71-2.97-2.65-2.36-2.10-1.87
Capital Expenditure (%)
Free Cash Flow -9.848.4817.3916.4412.548.747.786.936.185.50

Weighted Average Cost Of Capital

Share price $ -
Beta 0.000
Diluted Shares Outstanding 9.69
Cost of Debt
Tax Rate 1.11
After-tax Cost of Debt 63.00%
Risk-Free Rate
Market Risk Premium
Cost of Equity 4.251
Total Debt 29.80
Total Equity -
Total Capital 29.80
Debt Weighting 100.00
Equity Weighting 0.00
Wacc

Build Up Free Cash Flow

Year
A/P
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Projected
2021
Projected
2022
Projected
2023
Projected
2024
Projected
Revenue 27,734.2144,160.4158.5458.5463.1656.2750.1344.6639.7935.45
Operating Cash Flow -9.3010.4424.762215.2511.7110.439.298.287.37
Capital Expenditure -0.53-1.96-7.37-5.57-2.71-2.97-2.65-2.36-2.10-1.87
Free Cash Flow -9.848.4817.3916.4412.548.747.786.936.185.50
WACC
PV LFCF 5.362.931.600.880.48
SUM PV LFCF 11.24

Terminal Value

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

Intrinsic Value

Enterprise Value 12.04
Net Debt 24.35
Equity Value -12.31
Shares Outstanding 9.69
Equity Value Per Share -1.27