Discounted Cash Flow (DCF) Analysis Unlevered
Nuveen Preferred and Income Fund (JPT)
$19.56
-0.14 (-0.71%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Projected | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected |
| Revenue | 11.56 | -1.26 | 12.21 | 0.30 | -0.97 | 3.18 | -10.38 | 33.86 | -110.53 |
|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | |||||||||
| EBITDA | 11.80 | -0.42 | 13.39 | 1.02 | -1.43 | 4.66 | -15.21 | 49.64 | -162.01 |
| EBITDA (%) | |||||||||
| EBIT | - | - | - | - | -1.43 | 4.66 | -15.21 | 49.64 | -162.01 |
| EBIT (%) | |||||||||
| Depreciation | - | - | - | - | - | - | - | - | - |
| Depreciation (%) |
Balance Sheet Data
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Projected | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected |
| Total Cash | - | - | - | - | - | - | - | - | - |
|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | |||||||||
| Account Receivables | 2.08 | 2.06 | 2.91 | 1.95 | -1.30 | 4.23 | -13.80 | 45.04 | -147 |
| Account Receivables (%) | |||||||||
| Inventories | - | - | - | - | - | - | - | - | - |
| Inventories (%) | |||||||||
| Accounts Payable | 0.87 | 3.02 | 0.88 | 1.55 | -0.72 | 2.35 | -7.66 | 25 | -81.59 |
| Accounts Payable (%) | |||||||||
| Capital Expenditure | - | - | - | - | - | - | - | - | - |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 19.56 |
|---|---|
| Beta | 0.000 |
| Diluted Shares Outstanding | 6.82 |
| Cost of Debt | |
| Tax Rate | 0.00 |
| After-tax Cost of Debt | 2.34% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 3.532 |
| Total Debt | 37.30 |
| Total Equity | 133.38 |
| Total Capital | 170.68 |
| Debt Weighting | 21.85 |
| Equity Weighting | 78.15 |
| Wacc |
Build Up Free Cash
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Projected | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected |
| Revenue | 11.56 | -1.26 | 12.21 | 0.30 | -0.97 | 3.18 | -10.38 | 33.86 | -110.53 |
|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 11.80 | -0.42 | 13.39 | 1.02 | -1.43 | 4.66 | -15.21 | 49.64 | -162.01 |
| EBIT | - | - | - | - | -1.43 | 4.66 | -15.21 | 49.64 | -162.01 |
| Tax Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
| EBIAT | - | - | - | - | -1.43 | 4.66 | -15.21 | 49.64 | -162.01 |
| Depreciation | - | - | - | - | - | - | - | - | - |
| Accounts Receivable | - | 0.02 | -0.85 | 0.95 | 3.25 | -5.52 | 18.03 | -58.84 | 192.04 |
| Inventories | - | - | - | - | - | - | - | - | - |
| Accounts Payable | - | 2.14 | -2.14 | 0.67 | -2.27 | 3.07 | -10.01 | 32.66 | -106.59 |
| Capital Expenditure | - | - | - | - | - | - | - | - | - |
| UFCF | - | - | - | - | -0.45 | 2.20 | -7.19 | 23.46 | -76.57 |
| WACC | |||||||||
| PV UFCF | -0.45 | 2.13 | -6.74 | 21.30 | -67.32 | ||||
| SUM PV UFCF | -49.46 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 3.27 |
| Free cash flow (t + 1) | -78.10 |
| Terminal Value | -6,149.41 |
| Present Value of Terminal Value | -5,235.55 |
Intrinsic Value
| Enterprise Value | -5,285.01 |
|---|---|
| Net Debt | 37.30 |
| Equity Value | -5,322.31 |
| Shares Outstanding | 6.82 |
| Equity Value Per Share | -780.51 |