For the activity during Year One of this portfolio please see this thread: viewtopic.php?p=225860#p225860
Update - 13 April 2020
This is an update on the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140
Further details of how updates are to be made to this portfolio can be found on this thread: viewtopic.php?p=218513#p218513
The portfolio currently looks like this:
EPIC | Company | Shares | Cost (£) | Price (p) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | To-Date(£) | Overall (£) | Yield (%) * | Year Div (£)
CCL | Carnival Corporation | 384 | 14,979.79 | 965.6000 | 3,707.90 | 1.67% | -11,271.89 | 0.00 | 610.18 | 610.18 | -10,661.71 | 12.70% | 471.03
IMB | Imperial Brands | 719 | 18,148.31 | 1,665.0000 | 11,971.35 | 5.40% | -6,176.96 | 0.00 | 1,438.00 | 1,438.00 | -4,738.96 | 12.41% | 1,485.16
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 1,472.0000 | 4,548.48 | 2.05% | -2,933.18 | 0.00 | 454.55 | 454.55 | -2,478.63 | 10.44% | 475.07
BP | BP | 1,347 | 7,496.10 | 335.7500 | 4,522.55 | 2.04% | -2,973.55 | 0.00 | 436.33 | 436.33 | -2,537.22 | 10.23% | 462.64
SLA | Standard Life Aberdeen | 6,389 | 17,397.08 | 230.2000 | 14,707.48 | 6.64% | -2,689.60 | 913.62 | 1,188.63 | 2,102.25 | -587.35 | 9.38% | 1,380.02
BHP | BHP Group | 838 | 14,992.51 | 1,314.0000 | 11,011.32 | 4.97% | -3,981.19 | 0.00 | 944.08 | 944.08 | -3,037.11 | 8.90% | 979.99
BATS | British American Tobacco | 211 | 6,015.65 | 3,020.5000 | 6,373.26 | 2.88% | 357.61 | 110.98 | 107.08 | 218.06 | 575.67 | 6.97% | 443.94
LAND | Land Securities Group | 818 | 7,499.19 | 677.0000 | 5,537.86 | 2.50% | -1,961.33 | 0.00 | 285.05 | 285.05 | -1,676.28 | 6.86% | 379.96
VOD | Vodafone Group | 10,077 | 14,998.48 | 113.0200 | 11,389.03 | 5.14% | -3,609.45 | 0.00 | 758.07 | 758.07 | -2,851.38 | 6.76% | 769.75
IGG | IG Group Holdings | 2,762 | 14,999.32 | 734.0000 | 20,273.08 | 9.15% | 5,273.76 | 0.00 | 1,193.17 | 1,193.17 | 6,466.93 | 5.89% | 1,193.18
BLND | British Land Company | 1,273 | 7,494.24 | 410.2000 | 5,221.85 | 2.36% | -2,272.39 | 0.00 | 301.87 | 301.87 | -1,970.52 | 5.84% | 304.85
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,544.2000 | 14,530.92 | 6.56% | -468.45 | 0.00 | 969.23 | 969.23 | 500.78 | 5.18% | 752.80
WPP | WPP | 1,780 | 14,997.55 | 573.0000 | 10,199.40 | 4.60% | -4,798.15 | 0.00 | 1,068.00 | 1,068.00 | -3,730.15 | 3.96% | 404.06
PNN | Pennon Group | 1,975 | 16,014.00 | 1,088.5000 | 21,497.88 | 9.70% | 5,483.88 | 0.00 | 269.78 | 269.78 | 5,753.66 | 3.85% | 827.13
AV | Aviva | 4,820 | 19,699.29 | 264.6000 | 12,753.72 | 5.76% | -6,945.57 | 0.00 | 1,153.67 | 1,153.67 | -5,791.90 | 3.59% | 457.90
SMDS | DS Smith | 4,310 | 14,997.11 | 308.3000 | 13,287.73 | 6.00% | -1,709.38 | 0.00 | 698.22 | 698.22 | -1,011.16 | 3.57% | 474.10
ITV | ITV | 11,652 | 14,999.08 | 76.3800 | 8,899.80 | 4.02% | -6,099.28 | 0.00 | 932.15 | 932.15 | -5,167.13 | 3.40% | 302.95
BA | BAE Systems | 3,043 | 14,995.20 | 538.4000 | 16,383.51 | 7.39% | 1,388.31 | 0.00 | 687.71 | 687.71 | 2,076.02 | 1.75% | 286.04
IBST | Ibstock | 5,849 | 14,999.47 | 191.0000 | 11,171.59 | 5.04% | -3,827.88 | 0.00 | 859.79 | 859.79 | -2,968.09 | 1.68% | 187.16
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 428.8500 | 10,399.61 | 4.69% | -4,598.66 | 0.00 | 573.99 | 573.99 | -4,024.67 | 0.00% | 0.00
| | | | | | | | | | | | |
| Sub Total: | | | | £218,388.32 | 98.57% | -£53,813.35 | £1,024.60 | | | | 5.51% | £12,037.73
| Cash Balance: | | | | £2,151.74 | 0.97% | | | | | | |
| Ex-Dividend: | | | | £1,024.60 | 0.46% | | | | | | |
| | | | | | | | | | | | |
| Total: | | | | £221,564.66 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | £0.00 | | | | | | | |
| Dividends Received: | | | | £15,260.35 | | | | | | | |
| Ex-Dividend: | | | | £1,024.60 | | | | | | | |
| Realised P/L: | | | GNK | £4,188.29 | | | | | | | |
| Un-Realised P/L: | | | | -£53,813.35 | | 0.00 | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £221,564.66 | -12.72% | | | | | | |
With the breakdown by Business as follows:
Business | Cost (£) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Water | 16,014.00 | 21,497.88 | 9.70% | 5,483.88 | 0.00 | 269.78 | 269.78 | 5,753.66 | 3.85% | 827.13
Gambling | 14,999.32 | 20,273.08 | 9.15% | 5,273.76 | 0.00 | 1,193.17 | 1,193.17 | 6,466.93 | 5.89% | 1,193.18
Tobacco | 24,163.96 | 18,344.61 | 8.28% | -5,819.35 | 110.98 | 1,545.08 | 1,656.06 | -4,163.29 | 10.52% | 1,929.10
Weapons | 14,995.20 | 16,383.51 | 7.39% | 1,388.31 | 0.00 | 687.71 | 687.71 | 2,076.02 | 1.75% | 286.04
Pharma | 14,999.37 | 14,530.92 | 6.56% | -468.45 | 0.00 | 969.23 | 969.23 | 500.78 | 5.18% | 752.80
Fund Manager | 17,397.08 | 14,707.48 | 6.64% | -2,689.60 | 913.62 | 1,188.63 | 2,102.25 | -587.35 | 9.38% | 1,380.02
Packaging | 14,997.11 | 13,287.73 | 6.00% | -1,709.38 | 0.00 | 698.22 | 698.22 | -1,011.16 | 3.57% | 474.10
Insurance | 19,699.29 | 12,753.72 | 5.76% | -6,945.57 | 0.00 | 1,153.67 | 1,153.67 | -5,791.90 | 3.59% | 457.90
Telecom | 14,998.48 | 11,389.03 | 5.14% | -3,609.45 | 0.00 | 758.07 | 758.07 | -2,851.38 | 6.76% | 769.75
Mining | 14,992.51 | 11,011.32 | 4.97% | -3,981.19 | 0.00 | 944.08 | 944.08 | -3,037.11 | 8.90% | 979.99
Bricks | 14,999.47 | 11,171.59 | 5.04% | -3,827.88 | 0.00 | 859.79 | 859.79 | -2,968.09 | 1.68% | 187.16
Banks | 14,998.27 | 10,399.61 | 4.69% | -4,598.66 | 0.00 | 573.99 | 573.99 | -4,024.67 | 0.00% | 0.00
Property | 14,993.43 | 10,759.71 | 4.86% | -4,233.72 | 0.00 | 586.92 | 586.92 | -3,646.80 | 6.36% | 684.81
Advertising | 14,997.55 | 10,199.40 | 4.60% | -4,798.15 | 0.00 | 1,068.00 | 1,068.00 | -3,730.15 | 3.96% | 404.06
Oil | 14,977.76 | 9,071.03 | 4.09% | -5,906.73 | 0.00 | 890.88 | 890.88 | -5,015.85 | 10.34% | 937.71
Television | 14,999.08 | 8,899.80 | 4.02% | -6,099.28 | 0.00 | 932.15 | 932.15 | -5,167.13 | 3.40% | 302.95
Cruise Ships | 14,979.79 | 3,707.90 | 1.67% | -11,271.89 | 0.00 | 610.18 | 610.18 | -10,661.71 | 12.70% | 471.03
(*) - 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.
Re-Investment planned for 14 April 2020
As at the close of business on Friday 09 April 2020, the amount available for re-investment is £2,151.74 and this amount will be re-invested in one Business Sector holding on Tuesday 14 April 2020.
From the point of view of the “Highest Yield” the following candidates were considered:
[pre]Business | EPIC | Company | Yield (%) * | Decision | Comments
Cruise Ships | CCL | Carnival Corporation | 12.70% | Rejected | Earnings considered at risk
Tobacco | IMB | Imperial Brands | 12.41% | Rejected | Resultant Sector Value Concentration (9.16%) too high
Oil | RDSB | Royal Dutch Shell | 10.44% | Selected | Resultant Sector Value Concentration (5.01%)
Oil | BP | BP | 10.23% | Selected | Resultant Sector Value Concentration (5.01%)
Fund Manager | SLA | Standard Life Aberdeen | 9.38% | Rejected | Resultant Sector Value Concentration (7.53%) too high
Mining | BHP | BHP Group | 8.90% | Selected | Resultant Sector Value Concentration (5.88%)
I did briefly consider an entirely new holding of BT Group PLC (BT-A) which is currently yielding around 12.25%, assuming that the final dividend follows the recently-paid interim as a hold on last year. That final dividend is due to be announced in May and, although this current Covid-19 crisis should not affect a Telecommunications company to the same extent as those entirely dependent on consumer spending, approximately 25% of BT-A’s revenue is from Business Customers. A prolonged shut down of the business economy might very well have an effect, not least because the dividend was already under threat in my opinion.
Anyway, I rejected BT-A and the selection is therefore:
Oil – Royal Dutch Shell (RDSB) – Yield 10.44%
The Value Concentration after purchase (5.01%) will leave the Oil Business Sector holding as the fifteenth highest by that measure, and not so far ahead of a group of other holdings.
As I am intending to purchase a small block of RDSBAV for my own HYP on Tuesday 14 February, the details of the planned top-up will be determined by the price that I receive. I shall post an update when the details of the deal 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?p=299934#p299934
The intention is to keep this thread simply recording the history of the Portfolio
Enjoy!
Ian