viewtopic.php?f=15&t=16868&start=140
In the future there will be two portfolios as follows:
PYAD HYP 2019_04 REINVEST
PYAD HYP 2019_04 DRAWDOWN
But for now, as there have been no dividends to drawdown or reinvest, this single update will do.
The portfolio currently looks like this:
EPIC | Company Name | Shares | Cost | Price | Value | Value % | Profit/Loss | Business | Annual Inc | Yield | Inc To Date | Ex-Dividend | Total
AV | Aviva | 3,637 | 14,996.21 | 429.5000 | 15,620.92 | 6.05% | 624.71 | Insurance | 1,091.10 | 6.98% | 0.00 | 754.67 | 754.67
BA | BAE Systems | 3,043 | 14,995.20 | 494.0000 | 15,032.42 | 5.82% | 37.22 | Weapons | 675.54 | 4.49% | 0.00 | 401.67 | 401.67
BHP | BHP Group | 838 | 14,992.51 | 1,809.4000 | 15,162.77 | 5.87% | 170.26 | Mining | 764.70 | 5.04% | 0.00 | 0.00 | 0.00
BLND | British Land Company | 1,280 | 7,497.95 | 594.0000 | 7,603.20 | 2.94% | 105.25 | Property | 393.85 | 5.18% | 0.00 | 0.00 | 0.00
BP | BP | 1,347 | 7,496.10 | 559.0000 | 7,529.73 | 2.92% | 33.63 | Oil | 427.08 | 5.67% | 0.00 | 0.00 | 0.00
CCL | Carnival Corporation | 384 | 14,979.79 | 4,035.0000 | 15,494.40 | 6.00% | 514.61 | Cruise Ships | 593.92 | 3.83% | 0.00 | 0.00 | 0.00
GNK | Greene King | 2,266 | 14,994.78 | 641.0000 | 14,525.06 | 5.62% | -469.72 | Brewing & Pubs | 752.31 | 5.18% | 0.00 | 0.00 | 0.00
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,573.4000 | 14,805.69 | 5.73% | -193.68 | Pharma | 752.80 | 5.08% | 0.00 | 0.00 | 0.00
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 667.1000 | 16,177.18 | 6.26% | 1,178.91 | Bank | 956.42 | 5.91% | 0.00 | 0.00 | 0.00
IBST | Ibstock | 5,849 | 14,999.47 | 261.2000 | 15,277.59 | 5.91% | 278.12 | Bricks | 555.65 | 3.64% | 0.00 | 0.00 | 0.00
IGG | IG Group Holdings | 2,762 | 14,999.32 | 509.8000 | 14,080.68 | 5.45% | -918.64 | Gambling | 1,283.50 | 9.12% | 0.00 | 0.00 | 0.00
IMB | Imperial Brands | 568 | 14,988.79 | 2,436.0000 | 13,836.48 | 5.36% | -1,152.31 | Tobacco | 1,066.64 | 7.71% | 0.00 | 0.00 | 0.00
ITV | ITV | 11,652 | 14,999.08 | 136.6500 | 15,922.46 | 6.16% | 923.38 | Television | 932.16 | 5.85% | 0.00 | 629.20 | 629.20
LAND | Land Securities Group | 818 | 7,499.19 | 923.0000 | 7,550.14 | 2.92% | 50.95 | Property | 397.13 | 5.26% | 0.00 | 0.00 | 0.00
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,464.5000 | 7,615.31 | 2.95% | 133.65 | Oil | 449.24 | 5.90% | 0.00 | 0.00 | 0.00
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 278.9000 | 15,347.87 | 5.94% | 350.22 | Fund Manager | 1,188.64 | 7.74% | 0.00 | 786.92 | 786.92
SMDS | DS Smith | 4,310 | 14,997.11 | 357.0000 | 15,386.70 | 5.96% | 389.59 | Packaging | 646.50 | 4.20% | 0.00 | 224.12 | 224.12
VOD | Vodafone Group | 10,077 | 14,998.48 | 142.0000 | 14,309.34 | 5.54% | -689.14 | Telecom | 1,310.27 | 9.16% | 0.00 | 0.00 | 0.00
WPP | WPP | 1,780 | 14,997.55 | 956.4000 | 17,023.92 | 6.59% | 2,026.37 | Advertising | 1,068.00 | 6.27% | 0.00 | 0.00 | 0.00
| | | | | | | | | | | | |
| Sub Total: | | | | 258,301.86 | | 3,393.38 | | 15,305.45 | 5.93% | 0.00 | 2,796.58 | 2,796.58
| Cash: | | | | 0.00 | | | | | | | |
| Ex-Dividend: | | | | 2,796.58 | | | | | | | |
| | | | | | | | | | | | |
| Total: | | | | 261,098.44 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | 254,908.48 | | | | | | | |
| LESS Cash Out: | | | | 0.00 | | | | | | | |
| Dividends: | | | | 0.00 | | | | | | | |
| UnRealised Profit/Loss: | | | | 3,393.38 | | | | | | | |
| Ex-Dividend: | | | | 2,796.58 | | | | | | | |
| | | | | | | | | | | | |
| Total: | | | | 261,098.44 | | | | | | | |
With the breakdown by Business as follows:
Business | Cost | Value | Value % | Profit/Loss | Annual Inc | Yield | Inc To Date | Ex-Dividend | Total
Advertising | 17,023.92 | 17,023.92 | 6.59% | 2,026.37 | 1,068.00 | 6.27% | 0.00 | 0.00 | 0.00
Television | 15,922.46 | 15,922.46 | 6.16% | 923.38 | 932.16 | 5.85% | 0.00 | 629.20 | 629.20
Bank | 16,177.18 | 16,177.18 | 6.26% | 1,178.91 | 956.42 | 5.91% | 0.00 | 0.00 | 0.00
Insurance | 15,620.92 | 15,620.92 | 6.05% | 624.71 | 1,091.10 | 6.98% | 0.00 | 754.67 | 754.67
Packaging | 15,386.70 | 15,386.70 | 5.96% | 389.59 | 646.50 | 4.20% | 0.00 | 224.12 | 224.12
Cruise Ships | 15,494.40 | 15,494.40 | 6.00% | 514.61 | 593.92 | 3.83% | 0.00 | 0.00 | 0.00
Fund Manager | 15,347.87 | 15,347.87 | 5.94% | 350.22 | 1,188.64 | 7.74% | 0.00 | 786.92 | 786.92
Property | 15,153.34 | 15,153.34 | 5.87% | 156.20 | 790.98 | 5.22% | 0.00 | 0.00 | 0.00
Bricks | 15,277.59 | 15,277.59 | 5.91% | 278.12 | 555.65 | 3.64% | 0.00 | 0.00 | 0.00
Mining | 15,162.77 | 15,162.77 | 5.87% | 170.26 | 764.70 | 5.04% | 0.00 | 0.00 | 0.00
Oil | 15,145.04 | 15,145.04 | 5.86% | 167.28 | 876.32 | 5.79% | 0.00 | 0.00 | 0.00
Weapons | 15,032.42 | 15,032.42 | 5.82% | 37.22 | 675.54 | 4.49% | 0.00 | 401.67 | 401.67
Pharma | 14,805.69 | 14,805.69 | 5.73% | -193.68 | 752.80 | 5.08% | 0.00 | 0.00 | 0.00
Brewing & Pubs | 14,525.06 | 14,525.06 | 5.62% | -469.72 | 752.31 | 5.18% | 0.00 | 0.00 | 0.00
Telecom | 14,309.34 | 14,309.34 | 5.54% | -689.14 | 1,310.27 | 9.16% | 0.00 | 0.00 | 0.00
Gambling | 14,080.68 | 14,080.68 | 5.45% | -918.64 | 1,283.50 | 9.12% | 0.00 | 0.00 | 0.00
Tobacco | 13,836.48 | 13,836.48 | 5.36% | -1,152.31 | 1,066.64 | 7.71% | 0.00 | 0.00 | 0.00
| | | | | | | | |
Sub Total: | | 258,301.86 | | 3,393.38 | 15,305.45 | 5.93% | 0.00 | 2,796.58 | 2,796.58
Cash: | | 0.00 | | | | | | |
Ex-Dividend: | | 2,796.58 | | | | | | |
| | | | | | | | |
Total: | | 261,098.44 | | | | | | |
From: | | | | | | | | |
Cash In: | | 254,908.48 | | | | | | |
LESS Cash Out: | | 0.00 | | | | | | |
Dividends: | | 0.00 | | | | | | |
UnRealised Profit/Loss: | | 3,393.38 | | | | | | |
Ex-Dividend: | | 2,796.58 | | | | | | |
| | | | | | | | |
Total: | | 261,098.44 | | | | | | |
PYAD HYP 2019_04 REINVEST
The Reinvestment will take place on the 10th of each month, or first business day after the 10th, when the Cash Balance is equal to or greater than £2,000.00. This date in the month has been chosen simply because that is the day I use my broker’s “Regular Dealing” for my own HYP so making an occasional further selection for this virtual HYP should not prove too onerous. The amount £2,000.00 - 13.33% of the original holding cost - has been chosen to ensure that any purchase made is of a reasonable size.
I will advise the details of the intended top-up in this monthly update and of course will welcome any comments and/or advice. However, this selection process will not be a full democratic exercise as I just do not have the time to organise the necessary polling. Even if I am swayed by comments/advice received on here, I may still amend/cancel that decision if further news is received – profit warnings and the like – before the trade date.
For now the anticipated top-up schedule is as follows:
Date | Balance | Top-Up?
10-May-19 | 224.12 | N
10-Jun-19 | 3,176.76 | Y
10-Jul-19 | 1,380.54 | N
12-Aug-19 | 2,664.86 | Y
10-Sep-19 | 0.00 | N
10-Oct-19 | 2,683.80 | Y
11-Nov-19 | 2,029.97 | Y
10-Dec-19 | 764.35 | N
10-Jan-20 | 1,774.94 | N
10-Feb-20 | 2,494.35 | Y
10-Mar-20 | 357.95 | N
14-Apr-20 | 2,156.42 | Y
PYAD HYP 2019_04 DRAWDOWN
All income received within any month will be transferred out on the last day of that month. I will also publish the following:
Year | Jan - Mar | Apr - Jun | Jul - Sep | Oct - Dec | Total
2019 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
2020 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Of course there is nothing to report as yet as the first dividend - for D S Smith (SMDS) - is only due tomorrow, 1 May.
The currently forecast monthly dividend receipts are as follows:
Date | Dividend
30-Apr-19 | 0.00
31-May-19 | 2,394.91
30-Jun-19 | 1,310.92
31-Jul-19 | 1,150.09
31-Aug-19 | 985.70
30-Sep-19 | 2,591.37
31-Oct-19 | 1,196.76
30-Nov-19 | 1,113.17
31-Dec-19 | 1,316.19
31-Jan-20 | 470.62
29-Feb-20 | 877.96
31-Mar-20 | 1,095.79
So, there it is. I know there is as yet not a lot to report but I did just want to try out the format and if anyone has any suggestions for adding to or changing the regular updates to either of these two virtual portfolios, then please let me know. As long as it is possible within Excel, it can be done.
See you again on the 31 May 2019, or shortly thereafter
Ian