Discounted Cash Flow (DCF) Analysis Levered

NexPoint Residential Trust, Inc. (NXRT)

$40.64

+0.31 (+0.77%)
All numbers are in Millions, Currency in USD
Stock DCF: -0.27 | 40.64 | overvalue

Free Cash Flow

Year
A/P
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 204.80219.24263.95-18.08-13.29-9.77-7.19-5.28-3.89
Revenue (%)
Operating Cash Flow 57.2373.2779.10-5.50-4.05-2.98-2.19-1.61-1.18
Operating Cash Flow (%)
Capital Expenditure ---------
Capital Expenditure (%)
Free Cash Flow -----4.05-2.98-2.19-1.61-1.18

Weighted Average Cost Of Capital

Share price $ 40.64
Beta 1.090
Diluted Shares Outstanding 25.61
Cost of Debt
Tax Rate 0.31
After-tax Cost of Debt 4.98%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.955
Total Debt -
Total Equity 1,040.79
Total Capital 1,040.79
Debt Weighting 0.00
Equity Weighting 100.00
Wacc

Build Up Free Cash Flow

Year
A/P
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 204.80219.24263.95-18.08-13.29-9.77-7.19-5.28-3.89
Operating Cash Flow 57.2373.2779.10-5.50-4.05-2.98-2.19-1.61-1.18
Capital Expenditure ---------
Free Cash Flow -----4.05-2.98-2.19-1.61-1.18
WACC
PV LFCF -4.05-2.73-1.84-1.24-0.84
SUM PV LFCF -9.82

Terminal Value

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

Intrinsic Value

Enterprise Value -21.11
Net Debt -14.14
Equity Value -6.97
Shares Outstanding 25.61
Equity Value Per Share -0.27