This is a report on the Drawdown version of the “virtual” HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.
A thread detailing the progress during the Year One can be found here: viewtopic.php?p=225865#p225865
A thread detailing the progress during the Year Two can be found here: viewtopic.php?p=323586#p323586
A thread detailing the progress during the Year Three can be found here: viewtopic.php?f=15&t=33976
A thread detailing the progress during the Year Four can be found here: viewtopic.php?f=15&t=34668
A thread detailing the progress during the Year Five can be found here: viewtopic.php?f=15&t=39747
Further details of how updates are to be made to this portfolio can be found on this thread: viewtopic.php?p=218513#p218513
Progress Review: 05 May 2024
Current Portfolio: Holdings
EPIC | Company | Shares | Cost (£) | Price (p) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£) | Year Div (%)
IMB | Imperial Brands | 988 | 21,739.68 | 1,826.0000 | 18,040.88 | 6.98% | -3,698.80 | 0.00 | 6,086.43 | 2,387.63 | 8.04% | 1,450.58 | 11.00%
WPP | WPP | 1,780 | 14,997.55 | 812.6000 | 14,464.28 | 5.60% | -533.27 | 0.00 | 3,018.88 | 2,485.61 | 4.85% | 701.32 | 5.32%
ITV | ITV | 11,652 | 14,999.08 | 72.0000 | 8,389.44 | 3.25% | -6,609.64 | 384.51 | 2,097.33 | -4,127.80 | 6.94% | 582.60 | 4.42%
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 705.5000 | 17,108.38 | 6.62% | 2,110.11 | 0.00 | 2,708.69 | 4,818.80 | 4.52% | 773.27 | 5.86%
ABDN | Abrdn PLC | 5,503 | 14,997.65 | 155.2000 | 8,540.66 | 3.30% | -6,456.99 | 0.00 | 5,189.23 | -1,267.76 | 9.41% | 803.43 | 6.09%
IGG | IG Grp Holdings | 2,762 | 14,999.32 | 769.5000 | 21,253.59 | 8.22% | 6,254.27 | 0.00 | 6,065.29 | 12,319.56 | 5.91% | 1,256.71 | 9.53%
AV | Aviva | 3,141 | 12,830.98 | 472.0000 | 14,825.52 | 5.74% | 1,994.54 | 700.44 | 4,450.24 | 7,145.22 | 7.08% | 1,049.09 | 7.96%
DLG | Direct Line Insurance Grp | 1,640 | 4,201.94 | 186.5000 | 3,058.60 | 1.18% | -1,143.34 | 65.60 | 124.64 | -953.10 | 2.14% | 65.60 | 0.50%
HLN | Haleon PLC | 941 | 2,723.59 | 329.9000 | 3,104.36 | 1.20% | 380.77 | 39.52 | 39.51 | 459.80 | 1.82% | 56.46 | 0.43%
GSK | GSK PLC | 752 | 11,986.74 | 1,733.5000 | 13,035.92 | 5.04% | 1,049.18 | 0.00 | 3,155.30 | 4,204.48 | 3.46% | 451.20 | 3.42%
IBST | Ibstock | 5,849 | 14,999.47 | 153.0000 | 8,948.97 | 3.46% | -6,050.50 | 0.00 | 1,813.15 | -4,237.35 | 4.58% | 409.43 | 3.10%
SMDS | DS Smith | 4,310 | 14,997.11 | 361.6000 | 15,584.96 | 6.03% | 587.85 | 0.00 | 2,900.63 | 3,488.48 | 4.98% | 775.80 | 5.88%
BA | BAE Systems | 3,043 | 14,995.20 | 1,361.5000 | 41,430.45 | 16.03% | 26,435.25 | 562.95 | 3,764.14 | 30,762.34 | 2.20% | 912.90 | 6.92%
LAND | Land Securities Grp | 818 | 7,499.19 | 667.0000 | 5,456.06 | 2.11% | -2,043.13 | 0.00 | 1,349.25 | -693.88 | 5.92% | 323.11 | 2.45%
BLND | British Land Company | 1,273 | 7,494.24 | 403.6000 | 5,137.83 | 1.99% | -2,356.41 | 0.00 | 1,215.33 | -1,141.08 | 5.75% | 295.33 | 2.24%
BHP | BHP Grp | 838 | 14,992.51 | 2,241.0000 | 18,779.58 | 7.27% | 3,787.07 | 0.00 | 6,410.89 | 10,197.96 | 5.41% | 1,015.43 | 7.70%
BP | BP | 1,717 | 9,379.72 | 510.4000 | 8,763.57 | 3.39% | -616.15 | 0.00 | 1,842.96 | 1,226.81 | 4.54% | 398.04 | 3.02%
SHEL | Shell | 309 | 7,481.66 | 2,858.5000 | 8,832.77 | 3.42% | 1,351.11 | 0.00 | 1,393.25 | 2,744.36 | 3.84% | 338.95 | 2.57%
WDS | Woodside Energy Grp Ltd | 151 | 2,565.55 | 1,424.0000 | 2,150.24 | 0.83% | -415.31 | 0.00 | 491.08 | 75.77 | 7.84% | 168.52 | 1.28%
VOD | Vodafone Grp | 10,077 | 14,998.48 | 68.4400 | 6,896.70 | 2.67% | -8,101.78 | 0.00 | 3,892.64 | -4,209.14 | 11.26% | 776.68 | 5.89%
CCL | Carnival Corp. | 384 | 14,979.79 | 1,059.0000 | 4,066.56 | 1.57% | -10,913.23 | 0.00 | 610.18 | -10,303.05 | 0.00% | 0.00 | 0.00%
PNN | Pennon Grp | 1,266 | 10,265.43 | 698.5000 | 8,843.01 | 3.42% | -1,422.42 | 0.00 | 2,451.07 | 1,028.65 | 6.59% | 582.86 | 4.42%
| | | | | | | | | | | | |
| | | | | | | | | | | | |
| Sub Total: | | | | £256,712.33 | 99.32% | -£6,410.82 | £1,753.02 | | | 5.14% | £13,187.31 |
| Cash Balance: | | | | £0.00 | 0.00% | | | | | | |
| Ex-Dividend: | | | | £1,753.02 | 0.68% | | | | | | |
| | | | | | | | | | | | |
| Current Value: | | | | £258,465.35 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | -£62,905.01 | | | | | | | |
| Dividends Rec'd: | | | | £62,030.89 | | | | | | | |
| Ex-Dividend: | | | | £1,753.02 | | | | | | | |
| Realised P/L: | [2] | | | £9,092.50 | | | | | | | |
| UnRealised P/L: | | | | -£6,410.82 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £258,465.35 | 5.14% | | | | | | |
Current Portfolio: Business Sectors
Business | Cost (£) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£) | Year Div (%)
Weapons | 14,995.20 | 41,430.45 | 16.03% | 26,435.25 | 562.95 | 3,764.14 | 30,762.34 | 2.20% | 912.90 | 6.92%
Gambling | 14,999.32 | 21,253.59 | 8.22% | 6,254.27 | 0.00 | 6,065.29 | 12,319.56 | 5.91% | 1,256.71 | 9.53%
Oil | 19,426.93 | 19,746.58 | 7.64% | 319.65 | 0.00 | 3,727.29 | 4,046.94 | 4.59% | 905.51 | 6.87%
Mining | 14,992.51 | 18,779.58 | 7.27% | 3,787.07 | 0.00 | 6,410.89 | 10,197.96 | 5.41% | 1,015.43 | 7.70%
Tobacco | 21,739.68 | 18,040.88 | 6.98% | -3,698.80 | 0.00 | 6,086.43 | 2,387.63 | 8.04% | 1,450.58 | 11.00%
Banks | 14,998.27 | 17,108.38 | 6.62% | 2,110.11 | 0.00 | 2,708.69 | 4,818.80 | 4.52% | 773.27 | 5.86%
Packaging | 14,997.11 | 15,584.96 | 6.03% | 587.85 | 0.00 | 2,900.63 | 3,488.48 | 4.98% | 775.80 | 5.88%
Insurance: Life | 12,830.98 | 14,825.52 | 5.74% | 1,994.54 | 700.44 | 4,450.24 | 7,145.22 | 7.08% | 1,049.09 | 7.96%
Advertising | 14,997.55 | 14,464.28 | 5.60% | -533.27 | 0.00 | 3,018.88 | 2,485.61 | 4.85% | 701.32 | 5.32%
Pharma | 11,986.74 | 13,035.92 | 5.04% | 1,049.18 | 0.00 | 3,155.30 | 4,204.48 | 3.46% | 451.20 | 3.42%
Real Estate IT | 14,993.43 | 10,593.89 | 4.10% | -4,399.54 | 0.00 | 2,564.58 | -1,834.96 | 5.84% | 618.44 | 4.69%
Bricks | 14,999.47 | 8,948.97 | 3.46% | -6,050.50 | 0.00 | 1,813.15 | -4,237.35 | 4.58% | 409.43 | 3.10%
Utility: Water | 10,265.43 | 8,843.01 | 3.42% | -1,422.42 | 0.00 | 2,451.07 | 1,028.65 | 6.59% | 582.86 | 4.42%
Fund Manager | 14,997.65 | 8,540.66 | 3.30% | -6,456.99 | 0.00 | 5,189.23 | -1,267.76 | 9.41% | 803.43 | 6.09%
Television | 14,999.08 | 8,389.44 | 3.25% | -6,609.64 | 384.51 | 2,097.33 | -4,127.80 | 6.94% | 582.60 | 4.42%
Telecom: Mobile | 14,998.48 | 6,896.70 | 2.67% | -8,101.78 | 0.00 | 3,892.64 | -4,209.14 | 11.26% | 776.68 | 5.89%
Cruising | 14,979.79 | 4,066.56 | 1.57% | -10,913.23 | 0.00 | 610.18 | -10,303.05 | 0.00% | 0.00 | 0.00%
Medical Products | 2,723.59 | 3,104.36 | 1.20% | 380.77 | 39.52 | 39.51 | 459.80 | 1.82% | 56.46 | 0.43%
Insurance: NonLife | 4,201.94 | 3,058.60 | 1.18% | -1,143.34 | 65.60 | 124.64 | -953.10 | 2.14% | 65.60 | 0.50%
[1] - Yield and Forecast Income are based on my own Share Database Spreadsheet and are essentially calculated from the dividends that would have been earned over the previous 12 months, unless the company itself has clearly indicated otherwise.
[2] - Realised Profit and Loss & Return of Capital – To Date
Date | EPIC | Name | Real P&L (£) | Event
20-Sep-19 | BHP | BHP Group | 550.49 | Return of Capital
20-Sep-19 | IBST | Ibstock | 292.45 | Return of Capital
09-Oct-19 | GNK | Greene King | 4,188.29 | Profit from Sale – Pending Takeover
16-Jul-21 | PNN | Pennon Group | 1,612.39 | Return of Capital - Share Consolidation
16-May-22 | AV | Aviva | 150.92 | Return of Capital - Share Consolidation
25-May-22 | BHP | BHP Group | 2,565.55 | Return of Capital - Woodside Energy Group (WDS) shares
18-Jul-22 | GSK | GSK PLC | -275.74 | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation
24-Oct-22 | WDS | Woodside Energy Group Ltd | 8.15 | Return of Capital - Woodside Energy Group (WDS) shares - Share Consolidation
| | | |
| | Total | £9,092.50 |
Portfolio Transactions: Year Six
None
Quarterly Portfolio Income: Withdrawn To-Date
Year Start | 05 Jul | 05 Oct | 05 Jan | 05 Apr | Total | Year End
06-Apr-19 | 3,919.13 | 4,576.80 | 3,671.16 | 2,508.15 | £14,675.24 | 05-Apr-20
06-Apr-20 | 1,304.18 | 2,809.72 | 1,954.66 | 2,497.89 | £8,566.45 | 05-Apr-21
06-Apr-21 | 2,380.96 | 3,470.79 | 2,922.75 | 2,743.56 | £11,518.06 | 05-Apr-22
06-Apr-22 | 3,457.24 | 4,193.51 | 3,136.00 | 2,902.71 | £13,689.46 | 05-Apr-23
06-Apr-23 | 3,480.36 | 4,245.58 | 2,990.75 | 2,538.92 | £13,255.61 | 05-Apr-24
06-Apr-24 | 1,200.19 | | | | £1,200.19 | 05-Apr-25
Portfolio Income: Forecast Monthly Withdrawals
Date | Income (£)
05-Jun-24 | 1,963.58
05-Jul-24 | 1,025.17
05-Aug-24 | 740.69
05-Sep-24 | 405.12
04-Oct-24 | 2,778.55
05-Nov-24 | 1,261.98
05-Dec-24 | 548.02
03-Jan-25 | 1,119.57
05-Feb-25 | 758.88
05-Mar-25 | 374.52
04-Apr-25 | 1,427.17
02-May-25 | 783.89
|
12 Months | £13,187.14
Average | £1,098.93
Portfolio Income: Comments
A further £12,803.25 is currently forecast to be withdrawn during this current financial year – to 05 April 2025 – giving a forecast for the whole year of £13,603.44. This full year forecast amount represents an increase over last year’s total of 2.56%. It should also be noted that such a total in Year Six, welcome as it will be, is still short of the amount received in Year One.
Mind you, my forecasts at this early part of the year are mostly an assumption that last year’s dividend will be simply maintained. We shall see in due course.
Portfolio Value: To Date
The value of the portfolio has been recorded at the end of each quarter as follows:
Year Start | 05 Jul | 05 Oct | 05 Jan | 05 Apr | Year End
06-Apr-19 | 255,788.16 | 253,439.06 | 282,038.76 | 184,255.31 | 05-Apr-20
06-Apr-20 | 210,241.80 | 199,923.48 | 228,333.53 | 243,598.51 | 05-Apr-21
06-Apr-21 | 251,495.87 | 239,861.05 | 252,613.80 | 255,457.52 | 05-Apr-22
06-Apr-22 | 228,631.50 | 224,572.00 | 247,653.54 | 244,503.41 | 05-Apr-23
06-Apr-23 | 229,945.43 | 224,648.53 | 245,696.34 | 251,547.00 | 05-Apr-24
Portfolio Value: Comments
As a High Yield Portfolio (HYP) the Capital Value is very much of secondary interest.
Next Actions Required
1. - HSBA – HSBC PLC: Special Dividend
I recognise such a payment as a Return of Capital (RoC). The amount to be received, around £450.00, is sufficient in my view to be re-invested within the portfolio. This re-investment will take place on 10 May 2024.
2. - SMDS – DS Smith PLC: All-Share Takeover
New York based International Paper Company (IP) has proposed an all-share takeover of SMDS. As I understand it SMDS shareholders will receive 0.1285 shares of IP for each SMDS share held, giving this portfolio an IP holding of 553 shares, plus a small residue. It is intended that IP will have a secondary listing in London, so this holding will be maintained going forward.
Next Progress Review: Year Ending 05 April 2025 - End of Quarter One
A report on the continuing progress of the portfolio will be produced on, or soon after, the 05 July 2024
Should anyone wish to comment on this review, or any actions taken in the management of this virtual HYP Portfolio, then please do so but only on this related thread: viewtopic.php?f=15&t=43329
The intention is to keep this thread simply recording the events and progress of the Portfolio during its fifth year.
Enjoy!
Ian