For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979
For the activity during Year Four of this portfolio please see this thread: viewtopic.php?f=15&t=34041
Top-Up Decision – 08 May 2023
This is an update on the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.
Further details of how updates are to be made to this portfolio can be found on this thread: viewtopic.php?p=218513#p218513
Current Portfolio: Holdings
EPIC | Company | Shares | Cost (£) | Price (p) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB | Imperial Brands | 1,283 | 26,121.51 | 1,900.0000 | 24,377.00 | 8.07% | -1,744.51 | 0.00 | 6,396.60 | 4,652.09 | 7.43% | 1,811.21
BATS | British American Tobacco | 299 | 8,359.04 | 2,804.0000 | 8,383.96 | 2.78% | 24.92 | 0.00 | 1,924.54 | 1,949.46 | 8.23% | 690.33
WPP | WPP | 1,780 | 14,997.55 | 889.0000 | 15,824.20 | 5.24% | 826.65 | 0.00 | 2,317.56 | 3,144.21 | 4.43% | 701.32
ITV | ITV | 11,652 | 14,999.08 | 79.0000 | 9,205.08 | 3.05% | -5,794.00 | 384.51 | 1,514.74 | -3,894.75 | 6.33% | 582.60
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 599.8000 | 14,545.15 | 4.82% | -453.12 | 0.00 | 1,935.67 | 1,482.55 | 5.31% | 771.98
IGG | IG Group Holdings | 2,762 | 14,999.32 | 728.0000 | 20,107.36 | 6.66% | 5,108.04 | 0.00 | 4,808.59 | 9,916.63 | 6.11% | 1,229.09
ABDN | Abrdn PLC | 6,389 | 17,397.08 | 207.4000 | 13,250.78 | 4.39% | -4,146.30 | 466.39 | 4,434.20 | 754.29 | 7.04% | 932.79
MNG | M & G PLC | 3,505 | 7,189.84 | 202.9000 | 7,111.64 | 2.36% | -78.20 | 0.00 | 1,387.48 | 1,309.28 | 9.66% | 686.98
AV | Aviva | 3,663 | 14,970.64 | 414.6000 | 15,186.80 | 5.03% | 216.16 | 758.24 | 3,895.64 | 4,870.04 | 7.48% | 1,135.53
DLG | Direct Line Insurance Grp | 8,882 | 20,716.58 | 164.3500 | 14,597.57 | 4.83% | -6,119.01 | 0.00 | 356.51 | -5,762.50 | 4.62% | 675.03
GSK | GSK PLC | 752 | 11,986.74 | 1,462.4000 | 10,997.24 | 3.64% | -989.50 | 0.00 | 2,719.14 | 1,729.64 | 3.86% | 424.88
HLN | Haleon PLC | 941 | 2,723.59 | 341.5000 | 3,213.52 | 1.06% | 489.93 | 0.00 | 22.58 | 512.51 | 1.41% | 45.16
BA | BAE Systems | 3,043 | 14,995.20 | 990.2000 | 30,131.79 | 9.98% | 15,136.59 | 505.13 | 2,909.07 | 18,550.79 | 2.73% | 821.60
SMDS | DS Smith | 4,310 | 14,997.11 | 316.2000 | 13,628.22 | 4.51% | -1,368.89 | 0.00 | 2,124.83 | 755.94 | 5.69% | 775.80
IBST | Ibstock | 5,849 | 14,999.47 | 174.6000 | 10,212.35 | 3.38% | -4,787.12 | 321.69 | 1,292.60 | -3,172.83 | 5.04% | 514.71
BLND | British Land Company | 1,273 | 7,494.24 | 398.3000 | 5,070.36 | 1.68% | -2,423.88 | 0.00 | 920.01 | -1,503.87 | 5.82% | 295.33
LAND | Land Securities Group | 818 | 7,499.19 | 665.8000 | 5,446.24 | 1.80% | -2,052.95 | 0.00 | 1,026.15 | -1,026.80 | 5.95% | 323.92
BHP | BHP Group | 838 | 14,992.51 | 2,393.0000 | 20,053.34 | 6.64% | 5,060.83 | 0.00 | 5,402.17 | 10,463.00 | 8.81% | 1,767.36
RIO | Rio Tinto | 173 | 9,833.07 | 4,992.0000 | 8,636.16 | 2.86% | -1,196.91 | 0.00 | 1,705.53 | 508.62 | 8.15% | 704.07
SHEL | Shell | 457 | 9,626.22 | 2,390.5000 | 10,924.59 | 3.62% | 1,298.37 | 0.00 | 1,375.29 | 2,673.66 | 3.83% | 418.26
BP | BP | 1,347 | 7,496.10 | 492.3000 | 6,631.28 | 2.20% | -864.82 | 0.00 | 1,190.77 | 325.95 | 4.27% | 283.44
WDS | Woodside Energy Group Ltd | 272 | 4,853.84 | 1,797.0000 | 4,887.84 | 1.62% | 34.00 | 0.00 | 325.49 | 359.49 | 11.20% | 547.68
VOD | Vodafone Group | 10,077 | 14,998.48 | 95.0200 | 9,575.17 | 3.17% | -5,423.31 | 0.00 | 3,115.82 | -2,307.49 | 8.31% | 795.33
CCL | Carnival Corporation | 384 | 14,979.79 | 702.4000 | 2,697.22 | 0.89% | -12,282.57 | 0.00 | 610.18 | -11,672.39 | 0.00% | 0.00
PNN | Pennon Group | 1,316 | 10,670.59 | 872.0000 | 11,475.52 | 3.80% | 804.93 | 0.00 | 1,971.32 | 2,776.25 | 4.81% | 552.19
| | | | | | | | | | | |
| Sub Total: | | | | £296,170.38 | 98.06% | -£20,724.67 | £2,435.96 | | | 5.90% | £17,486.59
| Cash Balance: | | | | £3,424.05 | 1.13% | | | | | |
| Ex-Dividend: | | | | £2,435.96 | 0.81% | | | | | |
| | | | | | | | | | | |
| Current Portfolio Value: | | | | £302,030.39 | 18.49% | | | | | |
| From: | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | |
| LESS Cash Out: | | | | £0.00 | | | | | | |
| Dividends Received: | | | | £56,235.39 | 22.06% | | | | | |
| Ex-Dividend: | | | | £2,435.96 | | | | | | |
| Realised Profit/Loss: | [2] | | | £9,178.94 | | | | | | |
| Un-Realised Profit/Loss: | | | | -£20,724.67 | | | | | | |
| | | | | | XIRR | | | | | |
| Total: | | | | £302,030.39 | 4.19% | | | | | |
Current Portfolio: Business Sectors
Business | Cost (£) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
Tobacco | 34,480.55 | 32,760.96 | 10.85% | -1,719.59 | 0.00 | 8,321.14 | 6,601.55 | 7.64% | 2,501.54
Weapons | 14,995.20 | 30,131.79 | 9.98% | 15,136.59 | 505.13 | 2,909.07 | 18,550.79 | 2.73% | 821.60
Mining | 24,825.58 | 28,689.50 | 9.50% | 3,863.92 | 0.00 | 7,107.70 | 10,971.62 | 8.61% | 2,471.43
Oil | 21,976.16 | 22,443.71 | 7.43% | 467.55 | 0.00 | 2,891.55 | 3,359.10 | 5.57% | 1,249.38
Fund Manager | 24,586.92 | 20,362.42 | 6.74% | -4,224.50 | 466.39 | 5,821.68 | 2,063.57 | 7.95% | 1,619.77
Gambling | 14,999.32 | 20,107.36 | 6.66% | 5,108.04 | 0.00 | 4,808.59 | 9,916.63 | 6.11% | 1,229.09
Advertising | 14,997.55 | 15,824.20 | 5.24% | 826.65 | 0.00 | 2,317.56 | 3,144.21 | 4.43% | 701.32
Insurance: Life | 14,970.64 | 15,186.80 | 5.03% | 216.16 | 758.24 | 3,895.64 | 4,870.04 | 7.48% | 1,135.53
Insurance: Non-Life | 20,716.58 | 14,597.57 | 4.83% | -6,119.01 | 0.00 | 356.51 | -5,762.50 | 4.62% | 675.03
Banks | 14,998.27 | 14,545.15 | 4.82% | -453.12 | 0.00 | 1,935.67 | 1,482.55 | 5.31% | 771.98
Packaging | 14,997.11 | 13,628.22 | 4.51% | -1,368.89 | 0.00 | 2,124.83 | 755.94 | 5.69% | 775.80
Utility: Water | 10,670.59 | 11,475.52 | 3.80% | 804.93 | 0.00 | 1,971.32 | 2,776.25 | 4.81% | 552.19
Pharma | 11,986.74 | 10,997.24 | 3.64% | -989.50 | 0.00 | 2,719.14 | 1,729.64 | 3.86% | 424.88
Real Estate IT | 14,993.43 | 10,516.60 | 3.48% | -4,476.83 | 0.00 | 1,946.16 | -2,530.67 | 5.89% | 619.25
Bricks | 14,999.47 | 10,212.35 | 3.38% | -4,787.12 | 321.69 | 1,292.60 | -3,172.83 | 5.04% | 514.71
Telecom: Mobile | 14,998.48 | 9,575.17 | 3.17% | -5,423.31 | 0.00 | 3,115.82 | -2,307.49 | 8.31% | 795.33
Television | 14,999.08 | 9,205.08 | 3.05% | -5,794.00 | 384.51 | 1,514.74 | -3,894.75 | 6.33% | 582.60
Medical Products | 2,723.59 | 3,213.52 | 1.06% | 489.93 | 0.00 | 22.58 | 512.51 | 1.41% | 45.16
Cruising | 14,979.79 | 2,697.22 | 0.89% | -12,282.57 | 0.00 | 610.18 | -11,672.39 | 0.00% | 0.00
[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 (£) | Comment
20-Sep-19 | IBST | Ibstock | 292.45 | Return of Capital
09-Oct-19 | GNK | Greene King | 4,188.29 | Sale – Pending Takeover
16-Jul-21 | PNN | Pennon Group | 1,676.05 | Return of Capital - Share Consolidation
21-Sep-21 | BHP | BHP Group | 550.49 | Return of Capital
16-May-22 | AV | Aviva | 173.70 | Return of Capital - Share Consolidation
01-Jun-22 | BHP | BHP Group | 2,565.55 | Return of Capital - Woodside Energy Group (WDS) shares
19-Jul-22 | GSK | GSK PLC | -275.74 | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation
19-Jul-22 | WDS | Woodside Energy Group Ltd | 8.15 | Return of Capital - Woodside Energy Group (WDS) shares - Share Consolidation
| | | |
| | Total | £9,178.94 |
Top-Up: 10 May 2023
As at the close of business on Tuesday 09 May 2023, the amount available for re-investment will be £3,424.05. This amount will be used to top-up one holding on Friday 10 May 2023.
Candidates
From the point of view of searching for the current “Highest Sustainable Yield” the following candidates were considered:
EPIC | Company | Reward (%) | Decision | Comments
WDS | Woodside Energy Group Ltd | 11.20% | Possible | Resultant Sector Value Concentration (8.56%)
MNG | M & G PLC | 9.66% | Possible | Resultant Sector Value Concentration (7.87%)
PHNX | Phoenix Group Holdings | 8.80% | Possible | Resultant Sector Value Concentration (6.16%)
VOD | Vodafone Group | 8.31% | Possible | Resultant Sector Value Concentration (4.30%)
BATS | British American Tobacco | 8.23% | Disqualified | Resultant Sector Value Concentration (11.97%) too high
RIO | Rio Tinto | 8.15% | Disqualified | Resultant Sector Value Concentration (10.63%) too high
Decision
Ignoring those that are disqualified in order to avoid over-concentration by Business Sector, we end up with …..
Woodside Energy Group Ltd (WDS) – Yield 11.20%
The only potential downside that I can see with WDS is that, with profits being boosted by the recent high price of oil, which has already dropped somewhat, there may be pressure on the dividend next year. I am also still somewhat bemused as to why the yield for WDS is so far ahead of that for BP PLC (BP) or Shell PLC (SHEL). However, apart from the afore-mentioned possibility of a future drop in oil price, I can see no reason not to take advantage of the 11.20% yield now on offer.
I will be having a further quick review tomorrow - 09 May 2023 - but for now …..
Oil – Woodside Energy Group Ltd (WDS) – Yield 11.20% - is the decision for this top-up.
The Sector Value Concentration after purchase (8.56%) will leave the Oil Business Sector holding as number four by that measure, well below the maximum allowed – 10% - but who knows, there may be further purchases to come.
As it happens, I am intending to purchase WDS for one of the “real” portfolios under my control, and therefore the price to be applied for this “virtual” purchase will be the same as that achieved for the “real” portfolio’s purchase. I shall post an update when the details of the purchase are known.
Should anyone wish to comment on this or any prior top-ups, as well as any other 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=39072
The intention is to keep this thread simply recording the events of the Portfolio during its fifth year.
Enjoy!
Ian