Discounted Cash Flow (DCF) Analysis Unlevered

Nuveen Preferred and Income Fund (JPT)

$15.87

+0.11 (+0.70%)
All numbers are in Millions, Currency in USD
Stock DCF: -122,972,862.61 | 15.87 | overvalue

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 -1.2612.210.3024.93-13.15-241.02-4,417.16-80,954-1,483,656.86-27,191,217.25
Revenue (%)
EBITDA -1.4312.070.1524.79-12.55-220-4,031.94-73,893.93-1,354,265.99-24,819,849.99
EBITDA (%)
EBIT ------220-4,031.94-73,893.93-1,354,265.99-24,819,849.99
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 ----000.010.152.8251.66
Total Cash (%)
Account Receivables 2.062.911.952.111.94-244.73-4,485.29-82,202.68-1,506,541.63-27,610,630.09
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 3.020.881.551.860.84-139.20-2,551.14-46,755.12-856,888.59-15,704,334.57
Accounts Payable (%)
Capital Expenditure ----------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 15.87
Beta 0.000
Diluted Shares Outstanding 5.51
Cost of Debt
Tax Rate -96.02
After-tax Cost of Debt 4.29%
Risk-Free Rate
Market Risk Premium
Cost of Equity 4.285
Total Debt 47
Total Equity 87.44
Total Capital 134.44
Debt Weighting 34.96
Equity Weighting 65.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 -1.2612.210.3024.93-13.15-241.02-4,417.16-80,954-1,483,656.86-27,191,217.25
EBITDA -1.4312.070.1524.79-12.55-220-4,031.94-73,893.93-1,354,265.99-24,819,849.99
EBIT ------220-4,031.94-73,893.93-1,354,265.99-24,819,849.99
Tax Rate 0.00%0.00%0.00%0.00%-96.02%-19.20%-19.20%-19.20%-19.20%-19.20%
EBIAT ------262.25-4,806.22-88,084.40-1,614,336.95-29,586,212.16
Depreciation ----------
Accounts Receivable --0.850.95-0.160.17246.674,240.5677,717.381,424,338.9626,104,088.45
Inventories ----------
Accounts Payable --2.140.670.30-1.01-140.04-2,411.94-44,203.98-810,133.47-14,847,445.98
Capital Expenditure ----------
UFCF ------155.62-2,977.60-54,571-1,000,131.46-18,329,569.68
WACC
PV UFCF -149.22-2,737.67-48,109.84-845,447.06-14,857,267.13
SUM PV UFCF -15,753,710.92

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 4.29
Free cash flow (t + 1) -18,696,161.07
Terminal Value -816,426,247.69
Present Value of Terminal Value -661,764,736.75

Intrinsic Value

Enterprise Value -677,518,447.67
Net Debt 47
Equity Value -677,518,494.67
Shares Outstanding 5.51
Equity Value Per Share -122,972,862.61