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 Name | Shares | Cost | Price | Value | Value % | Profit/Loss | Business | Annual Inc | Yield (1) | Inc To Date | Ex-Dividend | Total
AV | Aviva | 3,637 | 14,996.21 | 404.6000 | 14,715.30 | 6.08% | -280.91 | Insurance | 1,091.10 | 7.41% | 754.67 | 0.00 | 754.67
BA | BAE Systems | 3,043 | 14,995.20 | 452.4000 | 13,766.53 | 5.69% | -1,228.67 | Weapons | 675.54 | 4.91% | 0.00 | 401.67 | 401.67
BHP | BHP Group | 838 | 14,992.51 | 1,784.6000 | 14,954.95 | 6.18% | -37.56 | Mining | 776.96 | 5.20% | 0.00 | 0.00 | 0.00
BLND | British Land Company | 1,280 | 7,497.95 | 534.0000 | 6,835.20 | 2.82% | -662.75 | Property | 396.80 | 5.81% | 0.00 | 0.00 | 0.00
BP | BP | 1,347 | 7,496.10 | 540.1000 | 7,275.15 | 3.01% | -220.95 | Oil | 433.92 | 5.96% | 0.00 | 108.48 | 108.48
CCL | Carnival Corporation | 384 | 14,979.79 | 3,910.0000 | 15,014.40 | 6.20% | 34.61 | Cruise Ships | 603.44 | 4.02% | 0.00 | 150.86 | 150.86
GNK | Greene King | 2,266 | 14,994.78 | 638.2000 | 14,461.61 | 5.98% | -533.17 | Brewing & Pubs | 752.31 | 5.20% | 0.00 | 0.00 | 0.00
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,527.0000 | 14,369.07 | 5.94% | -630.30 | Pharma | 752.80 | 5.24% | 0.00 | 178.79 | 178.79
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 645.1000 | 15,643.68 | 6.46% | 645.41 | Bank | 971.75 | 6.21% | 0.00 | 190.53 | 190.53
IBST | Ibstock | 5,849 | 14,999.47 | 238.0000 | 13,920.62 | 5.75% | -1,078.85 | Bricks | 555.65 | 3.99% | 0.00 | 380.18 | 380.18
IGG | IG Group Holdings | 2,762 | 14,999.32 | 547.2000 | 15,113.66 | 6.25% | 114.34 | Gambling | 1,193.18 | 7.89% | 0.00 | 0.00 | 0.00
IMB | Imperial Brands | 568 | 14,988.79 | 1,915.0000 | 10,877.20 | 4.49% | -4,111.59 | Tobacco | 1,173.26 | 10.79% | 0.00 | 177.67 | 177.67
ITV | ITV | 11,652 | 14,999.08 | 107.2500 | 12,496.77 | 5.16% | -2,502.31 | Television | 932.16 | 7.46% | 629.20 | 0.00 | 629.20
LAND | Land Securities Group | 818 | 7,499.19 | 828.6000 | 6,777.95 | 2.80% | -721.24 | Property | 397.13 | 5.86% | 0.00 | 0.00 | 0.00
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,473.5000 | 7,643.12 | 3.16% | 161.46 | Oil | 456.44 | 5.97% | 0.00 | 114.11 | 114.11
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 267.3000 | 14,709.52 | 6.08% | -288.13 | Fund Manager | 1,188.64 | 8.08% | 786.92 | 0.00 | 786.92
SMDS | DS Smith | 4,310 | 14,997.11 | 316.0000 | 13,619.60 | 5.63% | -1,377.51 | Packaging | 646.50 | 4.75% | 224.12 | 0.00 | 224.12
VOD | Vodafone Group | 10,077 | 14,998.48 | 129.4200 | 13,041.65 | 5.39% | -1,956.83 | Telecom | 795.83 | 6.10% | 0.00 | 0.00 | 0.00
WPP | WPP | 1,780 | 14,997.55 | 941.2000 | 16,753.36 | 6.92% | 1,755.81 | Advertising | 1,068.00 | 6.37% | 0.00 | 0.00 | 0.00
| | | | | | | | | | | | |
| Sub Total: | | 254,908.48 | | 241,989.34 | | -12,919.14 | | 14,861.41 | 6.14% | 2,394.91 | 1,702.29 | 4,097.20
| Cash: | | 0.00 | | 2,394.91 | | | | | | | |
| Ex-Dividend: | | 0.00 | | 1,702.29 | | | | | | | |
| | | | | | | | | | | | |
| Total: | | 254,908.48 | | 246,086.54 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | 254,908.48 | | 254,908.48 | | | | | | | |
| LESS Cash Out: | | 0.00 | | 0.00 | | | | | | | |
| Dividends: | | 0.00 | | 2,394.91 | | | | | | | |
| UnRealised Profit/Loss: | | 0.00 | | -12,919.14 | | | | | | | |
| Ex-Dividend: | | 0.00 | | 1,702.29 | | | | | | | |
| | | | | | Profit/Loss | | | | | | |
| Total: | | 254,908.48 | | 246,086.54 | -8,821.94 | | | | | | |
(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 indicated otherwise.
With the breakdown by Business as follows:
Business | Cost | Value | Value % | Profit/Loss | Annual Inc | Yield | Inc To Date | Ex-Dividend | Total
Advertising | 14,997.55 | 16,753.36 | 6.92% | 1,755.81 | 1,068.00 | 6.37% | 0.00 | 0.00 | 0.00
Bank | 14,998.27 | 15,643.68 | 6.46% | 645.41 | 971.75 | 6.21% | 0.00 | 190.53 | 190.53
Gambling | 14,999.32 | 15,113.66 | 6.25% | 114.34 | 1,193.18 | 7.89% | 0.00 | 0.00 | 0.00
Cruise Ships | 14,979.79 | 15,014.40 | 6.20% | 34.61 | 603.44 | 4.02% | 0.00 | 150.86 | 150.86
Mining | 14,992.51 | 14,954.95 | 6.18% | -37.56 | 776.96 | 5.20% | 0.00 | 0.00 | 0.00
Oil | 14,977.76 | 14,918.27 | 6.16% | -59.49 | 890.36 | 5.97% | 0.00 | 222.59 | 222.59
Insurance | 14,996.21 | 14,715.30 | 6.08% | -280.91 | 1,091.10 | 7.41% | 754.67 | 0.00 | 754.67
Fund Manager | 14,997.65 | 14,709.52 | 6.08% | -288.13 | 1,188.64 | 8.08% | 786.92 | 0.00 | 786.92
Brewing & Pubs | 14,994.78 | 14,461.61 | 5.98% | -533.17 | 752.31 | 5.20% | 0.00 | 0.00 | 0.00
Pharma | 14,999.37 | 14,369.07 | 5.94% | -630.30 | 752.80 | 5.24% | 0.00 | 178.79 | 178.79
Bricks | 14,999.47 | 13,920.62 | 5.75% | -1,078.85 | 555.65 | 3.99% | 0.00 | 380.18 | 380.18
Weapons | 14,995.20 | 13,766.53 | 5.69% | -1,228.67 | 675.54 | 4.91% | 0.00 | 401.67 | 401.67
Packaging | 14,997.11 | 13,619.60 | 5.63% | -1,377.51 | 646.50 | 4.75% | 224.12 | 0.00 | 224.12
Property | 14,997.14 | 13,613.15 | 5.63% | -1,383.99 | 793.93 | 5.83% | 0.00 | 0.00 | 0.00
Telecom | 14,998.48 | 13,041.65 | 5.39% | -1,956.83 | 795.83 | 6.10% | 0.00 | 0.00 | 0.00
Television | 14,999.08 | 12,496.77 | 5.16% | -2,502.31 | 932.16 | 7.46% | 629.20 | 0.00 | 629.20
Tobacco | 14,988.79 | 10,877.20 | 4.49% | -4,111.59 | 1,173.26 | 10.79% | 0.00 | 177.67 | 177.67
| | | | | | | | |
Sub Total: | 254,908.48 | 241,989.34 | | -12,919.14 | 14,861.41 | 6.14% | 2,394.91 | 1,702.29 | 4,097.20
Cash: | 0.00 | 2,394.91 | | | | | | |
Ex-Dividend: | 0.00 | 1,702.29 | | | | | | |
| | | | | | | | |
Total: | 254,908.48 | 246,086.54 | | | | | | |
From: | | | | | | | | |
Cash In: | 254,908.48 | 254,908.48 | | | | | | |
LESS Cash Out: | 0.00 | 0.00 | | | | | | |
Dividends: | 0.00 | 2,394.91 | | | | | | |
UnRealised Profit/Loss: | 0.00 | -12,919.14 | | | | | | |
Ex-Dividend: | 0.00 | 1,702.29 | | | | | | |
| | | Profit/Loss | | | | | |
Total: | 254,908.48 | 246,086.54 | -8,821.94 | | | | | |
Top-Up on 10 Jun 2019
Available Balance expected on 10 Jun 2019: £3,176.76
Selection: Imperial Brands (IMB)
Although the price continues to slip with a consequent rise in yield, I can as yet see no reason to disallow a top up, coming, as it does, so soon after the recent Interim Results indicating another year of 10% increase to the dividend is ahead of us.
As my own HYP is making a purchase of IMB on the same date, using my broker’s Regular Trading option, the price of the purchase, and therefore the number of shares purchased, will be determined by the purchase for my own HYP. I will post an update when the price is known.
Ian