For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
Top Up Update – 09 April 2021
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 (£) | To-Date(£) | Overall (£) | Yield (%) *
IMB | Imperial Brands | 1,139 | 23,765.53 | 1,542.0000 | 17,563.38 | 6.36% | -6,202.15 | 0.00 | 2,831.37 | 2,831.37 | -3,370.78 | 8.93%
MNG | M & G PLC | 1,166 | 2,189.32 | 218.0000 | 2,541.88 | 0.92% | 352.56 | 142.60 | 0.00 | 142.60 | 495.16 | 8.36%
BATS | British American Tobacco | 211 | 6,015.65 | 2,786.0000 | 5,878.46 | 2.13% | -137.19 | 113.72 | 551.00 | 664.72 | 527.53 | 7.74%
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,319.6000 | 12,417.44 | 4.50% | -2,581.93 | 0.00 | 1,505.60 | 1,505.60 | -1,076.33 | 6.06%
VOD | Vodafone Group | 10,077 | 14,998.48 | 134.6400 | 13,567.67 | 4.91% | -1,430.81 | 0.00 | 1,570.34 | 1,570.34 | 139.53 | 5.69%
BHP | BHP Group | 838 | 14,992.51 | 2,150.0000 | 18,017.00 | 6.52% | 3,024.49 | 0.00 | 1,908.57 | 1,908.57 | 4,933.06 | 5.25%
AV | Aviva | 4,820 | 19,699.29 | 404.6000 | 19,501.72 | 7.06% | -197.57 | 674.80 | 1,780.27 | 2,455.07 | 2,257.50 | 5.19%
BP | BP | 1,347 | 7,496.10 | 295.0000 | 3,973.65 | 1.44% | -3,522.45 | 0.00 | 706.67 | 706.67 | -2,815.78 | 5.15%
SLA | Standard Life Aberdeen | 6,389 | 17,397.08 | 301.5000 | 19,262.84 | 6.97% | 1,865.76 | 0.00 | 2,568.64 | 2,568.64 | 4,434.40 | 4.84%
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 437.4000 | 10,606.95 | 3.84% | -4,391.32 | 262.97 | 573.99 | 836.96 | -3,554.36 | 4.71%
BA | BAE Systems | 3,043 | 14,995.20 | 515.0000 | 15,671.45 | 5.67% | 676.25 | 0.00 | 1,393.68 | 1,393.68 | 2,069.93 | 4.60%
IGG | IG Group Holdings | 2,762 | 14,999.32 | 948.0000 | 26,183.76 | 9.48% | 11,184.44 | 0.00 | 2,386.34 | 2,386.34 | 13,570.78 | 4.56%
RDSB | Royal Dutch Shell | 457 | 9,626.22 | 1,335.4000 | 6,102.78 | 2.21% | -3,523.44 | 0.00 | 671.94 | 671.94 | -2,851.50 | 3.76%
LAND | Land Securities Group | 818 | 7,499.19 | 716.6000 | 5,861.79 | 2.12% | -1,637.40 | 0.00 | 432.29 | 432.29 | -1,205.11 | 3.35%
BLND | British Land Company | 1,273 | 7,494.24 | 512.4000 | 6,522.85 | 2.36% | -971.39 | 0.00 | 408.80 | 408.80 | -562.59 | 3.28%
SMDS | DS Smith | 4,310 | 14,997.11 | 414.8000 | 17,877.88 | 6.47% | 2,880.77 | 172.40 | 698.22 | 870.62 | 3,751.39 | 2.89%
WPP | WPP | 1,780 | 14,997.55 | 943.6000 | 16,796.08 | 6.08% | 1,798.53 | 0.00 | 1,246.00 | 1,246.00 | 3,044.53 | 2.54%
PNN | Pennon Group | 1,975 | 16,014.00 | 1,015.5000 | 20,056.13 | 7.26% | 4,042.13 | 0.00 | 998.15 | 998.15 | 5,040.28 | 2.15%
IBST | Ibstock | 5,849 | 14,999.47 | 228.2000 | 13,347.42 | 4.83% | -1,652.05 | 0.00 | 859.79 | 859.79 | -792.26 | 0.70%
ITV | ITV | 11,652 | 14,999.08 | 122.7500 | 14,302.83 | 5.18% | -696.25 | 0.00 | 932.15 | 932.15 | 235.90 | 0.00%
CCL | Carnival Corporation | 384 | 14,979.79 | 1,736.4000 | 6,667.78 | 2.41% | -8,312.01 | 0.00 | 610.18 | 610.18 | -7,701.83 | 0.00%
| | | | | | | | | | | |
| Sub Total: | | | | £272,721.74 | 98.74% | -£9,431.03 | £1,366.49 | | | | 4.17%
| Cash Balance: | | | | £2,128.99 | 0.77% | | | | | |
| Ex-Dividend: | | | | £1,366.49 | 0.50% | | | | | |
| | | | | | | | | | | |
| Current Portfolio Value: | | | | £276,217.22 | | | | | | |
| From: | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | |
| LESS Cash Out: | | | | £0.00 | | | | | | |
| Dividends Received: | | | | £25,188.70 | | | | | | |
| Ex-Dividend: | | | | £1,366.49 | | | | | | |
| Realised Profit/Loss: | | | GNK | £4,188.29 | | | | | | |
| Un-Realised Profit/Loss: | | | | -£9,431.03 | | | | | | |
| | | | | | XIRR | | | | | |
| Total: | | | | £276,217.22 | 3.97% | | | | | |
Current Portfolio: Business Sectors
Business | Cost (£) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Gambling | 14,999.32 | 26,183.76 | 9.48% | 11,184.44 | 0.00 | 2,386.34 | 2,386.34 | 13,570.78 | 4.56% | 1,193.18
Tobacco | 29,781.18 | 23,441.84 | 8.49% | -6,339.34 | 113.72 | 3,382.37 | 3,496.09 | -2,843.25 | 8.63% | 2,023.42
Fund Manager | 19,586.40 | 21,804.72 | 7.89% | 2,218.32 | 142.60 | 2,568.64 | 2,711.24 | 4,929.56 | 5.25% | 1,145.35
Water | 16,014.00 | 20,056.13 | 7.26% | 4,042.13 | 0.00 | 998.15 | 998.15 | 5,040.28 | 2.15% | 431.04
Insurance | 19,699.29 | 19,501.72 | 7.06% | -197.57 | 674.80 | 1,780.27 | 2,455.07 | 2,257.50 | 5.19% | 1,012.20
Mining | 14,992.51 | 18,017.00 | 6.52% | 3,024.49 | 0.00 | 1,908.57 | 1,908.57 | 4,933.06 | 5.25% | 945.11
Packaging | 14,997.11 | 17,877.88 | 6.47% | 2,880.77 | 172.40 | 698.22 | 870.62 | 3,751.39 | 2.89% | 517.20
Advertising | 14,997.55 | 16,796.08 | 6.08% | 1,798.53 | 0.00 | 1,246.00 | 1,246.00 | 3,044.53 | 2.54% | 427.20
Weapons | 14,995.20 | 15,671.45 | 5.67% | 676.25 | 0.00 | 1,393.68 | 1,393.68 | 2,069.93 | 4.60% | 721.18
Television | 14,999.08 | 14,302.83 | 5.18% | -696.25 | 0.00 | 932.15 | 932.15 | 235.90 | 0.00% | 0.00
Mobile Tel | 14,998.48 | 13,567.67 | 4.91% | -1,430.81 | 0.00 | 1,570.34 | 1,570.34 | 139.53 | 5.69% | 772.64
Bricks | 14,999.47 | 13,347.42 | 4.83% | -1,652.05 | 0.00 | 859.79 | 859.79 | -792.26 | 0.70% | 93.58
Pharma | 14,999.37 | 12,417.44 | 4.50% | -2,581.93 | 0.00 | 1,505.60 | 1,505.60 | -1,076.33 | 6.06% | 752.80
Real Estate IT | 14,993.43 | 12,384.64 | 4.48% | -2,608.79 | 0.00 | 841.09 | 841.09 | -1,767.70 | 3.31% | 410.18
Banks | 14,998.27 | 10,606.95 | 3.84% | -4,391.32 | 262.97 | 573.99 | 836.96 | -3,554.36 | 4.71% | 499.65
Oil | 17,122.32 | 10,076.43 | 3.65% | -7,045.89 | 0.00 | 1,378.61 | 1,378.61 | -5,667.28 | 4.30% | 433.77
Cruising | 14,979.79 | 6,667.78 | 2.41% | -8,312.01 | 0.00 | 610.18 | 610.18 | -7,701.83 | 0.00% | 0.00
(*)- 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 indicated otherwise.
Top-Up: 12 Apr 2021
As at the close of business on Friday 9 April 2021, the amount available for re-investment is £2,128.99. This amount will be used to top-up one Business Sector holding on Monday 12 April 2021.
From the point of view of the current “Highest Yield” the following candidates were considered:
Top-Up | | | | |
Business | EPIC | Company | Yield (%) * | Decision | Comments
Tobacco | IMB | Imperial Brands | 8.93% | Rejected | Resultant Sector Value Concentration (9.18%) too high
Fund Manager | MNG | M & G PLC | 8.36% | Selected | Resultant Sector Value Concentration (8.59%)
Tobacco | BATS | British American Tobacco | 7.74% | Rejected | Resultant Sector Value Concentration (9.18%) too high
Pharma | GSK | GlaxoSmithKline | 6.06% | Selected | Resultant Sector Value Concentration (5.22%)
Mobile Tel | VOD | Vodafone Group | 5.69% | Selected | Resultant Sector Value Concentration (5.64%)
A new holding of MNG was created with the Portfolio Top Up two months ago and I see no reason not to go the same way this time also. Indeed, the recent dividend declaration was for an increased payout from this rather new entity.
Fund Manager – M&G PLC (MNG) – Yield 8.36% - is therefore the decision for this top up.
The Value Concentration after purchase (8.59%) will leave the Fund Manager business sector holding as the second highest by that measure, and not so far ahead of the Value Concentrations of a group of other business sectors.
From now on I have decided to increase the limit imposed on Business Value (%) to 10.00% - currently it is 9.00%.
As I am intending to purchase MNG for one of the real portfolios under my control, the price to be applied for this virtual purchase will be the price achieved in reality. 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=28869
The intention is to keep this thread simply recording the history of the Portfolio.
Enjoy!
Ian