Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to MrFahrenheit,SalvorHardin,Anonymous,johnhemming,Anonymous, for Donating to support the site

PYAD HYP 2019_04 REINVEST – Year Two

For discussion of the practicalities of setting up and operating income-portfolios which follow the HYP Group Guidelines. READ Guidelines before posting
Forum rules
Tight HYP discussions only please - OT please discuss in strategies
IanTHughes
Lemon Quarter
Posts: 1206
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 593 times
Been thanked: 557 times

PYAD HYP 2019_04 REINVEST – Year Two

#299931

Postby IanTHughes » April 11th, 2020, 5:23 pm

PYAD HYP 2019_04 REINVEST – Year Two

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

IanTHughes
Lemon Quarter
Posts: 1206
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 593 times
Been thanked: 557 times

PYAD HYP 2019_04 REINVEST - Year 2

#300707

Postby IanTHughes » April 14th, 2020, 7:16 pm

Update 14 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 Top-Up indicated in the previous post viewtopic.php?p=299931 has now been made as follows:

Date      | Business  | EPIC | Shares | Price (p) | Total (£)  | Yield (%)
14-Apr-20 | Oil | RDSB | 148 |1,440.8139 | -2,144.56 | 10.21%

Current Portfolio

As at the Close of Business on 14 April 2020 the portfolio 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 | 910.2000 | 3,495.17 | 1.61% | -11,484.62 | 0.00 | 610.18 | 610.18 | -10,874.44 | 13.48% | 471.03
IMB | Imperial Brands | 719 | 18,148.31 | 1,622.0000 | 11,662.18 | 5.36% | -6,486.13 | 0.00 | 1,438.00 | 1,438.00 | -5,048.13 | 12.73% | 1,485.16
RDSB | Royal Dutch Shell | 457 | 9,626.22 | 1,421.0000 | 6,493.97 | 2.99% | -3,132.25 | 0.00 | 454.55 | 454.55 | -2,677.70 | 10.82% | 702.61
BP | BP | 1,347 | 7,496.10 | 321.1000 | 4,325.22 | 1.99% | -3,170.88 | 0.00 | 436.33 | 436.33 | -2,734.55 | 10.70% | 462.64
SLA | Standard Life Aberdeen | 6,389 | 17,397.08 | 221.9000 | 14,177.19 | 6.52% | -3,219.89 | 913.62 | 1,188.63 | 2,102.25 | -1,117.64 | 9.73% | 1,380.02
BHP | BHP Group | 838 | 14,992.51 | 1,312.6000 | 10,999.59 | 5.06% | -3,992.92 | 0.00 | 944.08 | 944.08 | -3,048.84 | 8.91% | 979.99
BATS | British American Tobacco | 211 | 6,015.65 | 2,918.5000 | 6,158.04 | 2.83% | 142.39 | 110.98 | 107.08 | 218.06 | 360.45 | 7.21% | 443.94
LAND | Land Securities Group | 818 | 7,499.19 | 659.6000 | 5,395.53 | 2.48% | -2,103.66 | 0.00 | 285.05 | 285.05 | -1,818.61 | 7.04% | 379.96
VOD | Vodafone Group | 10,077 | 14,998.48 | 111.9800 | 11,284.22 | 5.19% | -3,714.26 | 0.00 | 758.07 | 758.07 | -2,956.19 | 6.82% | 769.75
BLND | British Land Company | 1,273 | 7,494.24 | 399.3000 | 5,083.09 | 2.34% | -2,411.15 | 0.00 | 301.87 | 301.87 | -2,109.28 | 6.00% | 304.85
IGG | IG Group Holdings | 2,762 | 14,999.32 | 726.5000 | 20,065.93 | 9.23% | 5,066.61 | 0.00 | 1,193.17 | 1,193.17 | 6,259.78 | 5.95% | 1,193.18
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,570.0000 | 14,773.70 | 6.79% | -225.67 | 0.00 | 969.23 | 969.23 | 743.56 | 5.10% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 427.4500 | 10,365.66 | 4.77% | -4,632.61 | 0.00 | 573.99 | 573.99 | -4,058.62 | 4.02% | 416.46
WPP | WPP | 1,780 | 14,997.55 | 573.4000 | 10,206.52 | 4.69% | -4,791.03 | 0.00 | 1,068.00 | 1,068.00 | -3,723.03 | 3.96% | 404.06
PNN | Pennon Group | 1,975 | 16,014.00 | 1,104.0000 | 21,804.00 | 10.03% | 5,790.00 | 0.00 | 269.78 | 269.78 | 6,059.78 | 3.79% | 827.13
AV | Aviva | 4,820 | 19,699.29 | 256.1000 | 12,344.02 | 5.68% | -7,355.27 | 0.00 | 1,153.67 | 1,153.67 | -6,201.60 | 3.71% | 457.90
SMDS | DS Smith | 4,310 | 14,997.11 | 300.0000 | 12,930.00 | 5.95% | -2,067.11 | 0.00 | 698.22 | 698.22 | -1,368.89 | 3.67% | 474.10
ITV | ITV | 11,652 | 14,999.08 | 72.5000 | 8,447.70 | 3.89% | -6,551.38 | 0.00 | 932.15 | 932.15 | -5,619.23 | 3.59% | 302.95
IBST | Ibstock | 5,849 | 14,999.47 | 176.6000 | 10,329.33 | 4.75% | -4,670.14 | 0.00 | 859.79 | 859.79 | -3,810.35 | 1.81% | 187.16
BA | BAE Systems | 3,043 | 14,995.20 | 528.8000 | 16,091.38 | 7.40% | 1,096.18 | 0.00 | 687.71 | 687.71 | 1,783.89 | 1.78% | 286.04
| | | | | | | | | | | | |
| Sub Total: | | | | £216,432.44 | 99.53% | -£57,913.79 | £1,024.60 | | | | 5.86% | £12,681.73
| Cash Balance: | | | | £7.18 | 0.00% | | | | | | |
| Ex-Dividend: | | | | £1,024.60 | 0.47% | | | | | | |
| | | | | | | | | | | | |
| Total: | | | | £217,464.22 | | | | | | | |
| 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: | | | | -£57,913.79 | | 0.00 | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £217,464.22 | -14.12% | | | | | | |

With the breakdown by Business, by decreasing value, as follows:

Business     | Cost (£)   | Value (£)  | Value (%) | P/L (£)     | Ex-Div (£) | Div Rec'd (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Water | 16,014.00 | 21,804.00 | 10.03% | 5,790.00 | 0.00 | 269.78 | 269.78 | 6,059.78 | 3.79% | 827.13
Gambling | 14,999.32 | 20,065.93 | 9.23% | 5,066.61 | 0.00 | 1,193.17 | 1,193.17 | 6,259.78 | 5.95% | 1,193.18
Tobacco | 24,163.96 | 17,820.22 | 8.19% | -6,343.74 | 110.98 | 1,545.08 | 1,656.06 | -4,687.68 | 10.83% | 1,929.10
Weapons | 14,995.20 | 16,091.38 | 7.40% | 1,096.18 | 0.00 | 687.71 | 687.71 | 1,783.89 | 1.78% | 286.04
Pharma | 14,999.37 | 14,773.70 | 6.79% | -225.67 | 0.00 | 969.23 | 969.23 | 743.56 | 5.10% | 752.80
Fund Manager | 17,397.08 | 14,177.19 | 6.52% | -3,219.89 | 913.62 | 1,188.63 | 2,102.25 | -1,117.64 | 9.73% | 1,380.02
Packaging | 14,997.11 | 12,930.00 | 5.95% | -2,067.11 | 0.00 | 698.22 | 698.22 | -1,368.89 | 3.67% | 474.10
Insurance | 19,699.29 | 12,344.02 | 5.68% | -7,355.27 | 0.00 | 1,153.67 | 1,153.67 | -6,201.60 | 3.71% | 457.90
Telecom | 14,998.48 | 11,284.22 | 5.19% | -3,714.26 | 0.00 | 758.07 | 758.07 | -2,956.19 | 6.82% | 769.75
Mining | 14,992.51 | 10,999.59 | 5.06% | -3,992.92 | 0.00 | 944.08 | 944.08 | -3,048.84 | 8.91% | 979.99
Oil | 17,122.32 | 10,819.19 | 4.98% | -6,303.13 | 0.00 | 890.88 | 890.88 | -5,412.25 | 10.77% | 1,165.25
Property | 14,993.43 | 10,478.62 | 4.82% | -4,514.81 | 0.00 | 586.92 | 586.92 | -3,927.89 | 6.54% | 684.81
Banks | 14,998.27 | 10,365.66 | 4.77% | -4,632.61 | 0.00 | 573.99 | 573.99 | -4,058.62 | 4.02% | 416.46
Bricks | 14,999.47 | 10,329.33 | 4.75% | -4,670.14 | 0.00 | 859.79 | 859.79 | -3,810.35 | 1.81% | 187.16
Advertising | 14,997.55 | 10,206.52 | 4.69% | -4,791.03 | 0.00 | 1,068.00 | 1,068.00 | -3,723.03 | 3.96% | 404.06
Television | 14,999.08 | 8,447.70 | 3.88% | -6,551.38 | 0.00 | 932.15 | 932.15 | -5,619.23 | 3.59% | 302.95
Cruise Ships | 14,979.79 | 3,495.17 | 1.61% | -11,484.62 | 0.00 | 610.18 | 610.18 | -10,874.44 | 13.48% | 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 clearly indicated otherwise.

Dividend Re-Investments and other Transactions since initial portfolio set up

Transactions | Since Set Up   |      |         |             |             | Bought    |                               
Date | Business | EPIC | Shares | Price (p) | Total (£) | Yield (%) | Comment

14-Apr-20 | Oil | RDSB | 148 | 1,440.8139 | -2,144.56 | 10.21% | Routine Dividend Re-Investment
10-Feb-20 | Insurance | AV | 620 | 405.9278 | -2,530.83 | 7.45% | Routine Dividend Re-Investment
11-Nov-19 | Tobacco | BATS | 69 | 2,880.0000 | -1,998.64 | 7.05% | Routine Dividend Re-Investment
10-Oct-19 | Fund Manager | SLA | 886 | 269.3000 | -2,399.43 | 8.02% | Routine Dividend Re-Investment
10-Oct-19 | Tobacco | BATS | 142 | 2,813.7500 | -4,017.01 | 7.21% | Replace Greene King Holding
09-Oct-19 | Water | PNN | 1,975 | 806.3000 | -16,014.00 | 5.09% | Replace Greene King Holding
09-Oct-19 | Brewing & Pubs | GNK | -2,266 | 847.0000 | 19,183.07 | | Sale Pending Imminent Takeover
12-Aug-19 | Insurance | AV | 563 | 383.6500 | -2,172.25 | 7.88% | Routine Dividend Re-Investment
10-Jun-19 | Tobacco | IMB | 151 | 2,081.0000 | -3,159.52 | 9.30% | Routine Dividend Re-Investment

Future Top-Up Dates

Top-Ups for this Portfolio will be made on the 10th day of each month or, should that not be a market day, the first market day after the 10th day, just so long as a cash balance of at least £2,000.00 is available the day before. Therefore, based on current dividend expectations, the anticipated Top-Up timetable going forward is as follows:

  Date    | Balance   | Re-Invest? | To Date   | Div Rec'd
11-May-20 | 7.18 | N | 11-May-20 | 0.00
10-Jun-20 | 1,031.78 | N | 10-Jun-20 | 1,024.60
10-Jul-20 | 1,726.78 | N | 10-Jul-20 | 695.00
10-Aug-20 | 2,293.44 | Y | 10-Aug-20 | 566.66
10-Sep-20 | 668.32 | N | 10-Sep-20 | 668.32
12-Oct-20 | 3,261.20 | Y | 12-Oct-20 | 2,592.88
10-Nov-20 | 1,814.99 | N | 10-Nov-20 | 1,814.99
10-Dec-20 | 2,514.96 | Y | 10-Dec-20 | 699.97
11-Jan-21 | 1,060.88 | N | 11-Jan-21 | 1,060.88
10-Feb-21 | 1,852.24 | N | 10-Feb-21 | 791.36
10-Mar-21 | 2,210.19 | Y | 10-Mar-21 | 357.95
12-Apr-21 | 1,992.54 | N | 10-Aug-21 | 1,992.54

The next top-up will therefore be on 10 August 2020, assuming of course that currently expected dividends are actually received.

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

IanTHughes
Lemon Quarter
Posts: 1206
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 593 times
Been thanked: 557 times

PYAD HYP 2019_04 REINVEST – Year Two

#323792

Postby IanTHughes » July 4th, 2020, 8:57 pm

For the activity during Year One of this portfolio please see this thread: viewtopic.php?p=225860#p225860

Update - 05 July 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

Current Portfolio: Holdings

EPIC | Company                  | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | To-Date(£) | Overall (£) | Yield (%) * | Year Div (£)
AV | Aviva | 4,820 | 19,699.29 | 273.5000 | 13,182.70 | 5.83% | -6,516.59 | 0.00 | 1,153.67 | 1,153.67 | -5,362.92 | 11.30% | 1,489.38
BP | BP | 1,347 | 7,496.10 | 307.5500 | 4,142.70 | 1.83% | -3,353.40 | 0.00 | 548.69 | 548.69 | -2,804.71 | 10.96% | 453.96
IMB | Imperial Brands | 719 | 18,148.31 | 1,486.5000 | 10,687.94 | 4.73% | -7,460.37 | 0.00 | 1,587.91 | 1,587.91 | -5,872.46 | 9.26% | 990.06
SLA | Standard Life Aberdeen | 6,389 | 17,397.08 | 269.0000 | 17,186.41 | 7.60% | -210.67 | 0.00 | 2,102.25 | 2,102.25 | 1,891.58 | 8.03% | 1,380.02
BHP | BHP Group | 838 | 14,992.51 | 1,636.4000 | 13,713.03 | 6.07% | -1,279.48 | 0.00 | 944.08 | 944.08 | -335.40 | 7.01% | 961.59
BATS | British American Tobacco | 211 | 6,015.65 | 3,060.5000 | 6,457.66 | 2.86% | 442.01 | 0.00 | 218.06 | 218.06 | 660.07 | 6.87% | 443.94
VOD | Vodafone Group | 10,077 | 14,998.48 | 129.6400 | 13,063.82 | 5.78% | -1,934.66 | 408.93 | 758.07 | 1,167.00 | -767.66 | 6.26% | 817.86
BLND | British Land Company | 1,273 | 7,494.24 | 389.0000 | 4,951.97 | 2.19% | -2,542.27 | 0.00 | 301.87 | 301.87 | -2,240.40 | 6.16% | 304.85
IBST | Ibstock | 5,849 | 14,999.47 | 173.5000 | 10,148.02 | 4.49% | -4,851.45 | 0.00 | 859.79 | 859.79 | -3,991.66 | 5.59% | 567.35
IGG | IG Group Holdings | 2,762 | 14,999.32 | 844.0000 | 23,311.28 | 10.31% | 8,311.96 | 0.00 | 1,193.17 | 1,193.17 | 9,505.13 | 5.12% | 1,193.18
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,625.8000 | 15,298.78 | 6.77% | 299.41 | 178.79 | 969.23 | 1,148.02 | 1,447.43 | 4.92% | 752.80
BA | BAE Systems | 3,043 | 14,995.20 | 482.2000 | 14,673.35 | 6.49% | -321.85 | 0.00 | 687.71 | 687.71 | 365.86 | 4.81% | 705.97
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 383.5000 | 9,299.88 | 4.11% | -5,698.39 | 0.00 | 573.99 | 573.99 | -5,124.40 | 4.39% | 408.64
RDSB | Royal Dutch Shell | 457 | 9,626.22 | 1,234.4000 | 5,641.21 | 2.50% | -3,985.01 | 0.00 | 516.55 | 516.55 | -3,468.46 | 4.16% | 234.69
LAND | Land Securities Group | 818 | 7,499.19 | 578.0000 | 4,728.04 | 2.09% | -2,771.15 | 0.00 | 285.05 | 285.05 | -2,486.10 | 4.01% | 189.77
CCL | Carnival Corporation | 384 | 14,979.79 | 1,002.0000 | 3,847.68 | 1.70% | -11,132.11 | 0.00 | 610.18 | 610.18 | -10,521.93 | 4.00% | 154.06
PNN | Pennon Group | 1,975 | 16,014.00 | 1,102.0000 | 21,764.50 | 9.63% | 5,750.50 | 0.00 | 269.78 | 269.78 | 6,020.28 | 3.97% | 864.45
WPP | WPP | 1,780 | 14,997.55 | 623.2000 | 11,092.96 | 4.91% | -3,904.59 | 0.00 | 1,068.00 | 1,068.00 | -2,836.59 | 3.64% | 404.06
ITV | ITV | 11,652 | 14,999.08 | 71.9200 | 8,380.12 | 3.71% | -6,618.96 | 0.00 | 932.15 | 932.15 | -5,686.81 | 3.62% | 302.95
SMDS | DS Smith | 4,310 | 14,997.11 | 291.4000 | 12,559.34 | 5.56% | -2,437.77 | 0.00 | 698.22 | 698.22 | -1,739.55 | 1.85% | 232.74
| | | | | | | | | | | | |
| Sub Total: | | | | £224,131.39 | 99.14% | -£50,214.84 | £587.72 | | | | 5.73% | £12,852.32
| Cash Balance: | | | | £1,351.99 | 0.60% | | | | | | |
| Ex-Dividend: | | | | £587.72 | 0.26% | | | | | | |
| | | | | | | | | | | | |
| Current Portfolio Value: | | | | £226,071.10 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | £0.00 | | | | | | | |
| Dividends Received: | | | | £16,605.16 | | | | | | | |
| Ex-Dividend: | | | | £587.72 | | | | | | | |
| Realised P/L: | | | GNK | £4,188.29 | | | | | | | |
| Un-Realised P/L: | | | | -£50,214.84 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £226,071.10 | -9.07% | | | | | | |


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 | 23,311.28 | 10.31% | 8,311.96 | 0.00 | 1,193.17 | 1,193.17 | 9,505.13 | 5.12% | 1,193.18
Water | 16,014.00 | 21,764.50 | 9.63% | 5,750.50 | 0.00 | 269.78 | 269.78 | 6,020.28 | 3.97% | 864.45
Tobacco | 24,163.96 | 17,145.60 | 7.58% | -7,018.36 | 0.00 | 1,805.97 | 1,805.97 | -5,212.39 | 8.36% | 1,434.00
Fund Manager | 17,397.08 | 17,186.41 | 7.60% | -210.67 | 0.00 | 2,102.25 | 2,102.25 | 1,891.58 | 8.03% | 1,380.02
Pharma | 14,999.37 | 15,298.78 | 6.77% | 299.41 | 178.79 | 969.23 | 1,148.02 | 1,447.43 | 4.92% | 752.80
Weapons | 14,995.20 | 14,673.35 | 6.49% | -321.85 | 0.00 | 687.71 | 687.71 | 365.86 | 4.81% | 705.97
Mining | 14,992.51 | 13,713.03 | 6.07% | -1,279.48 | 0.00 | 944.08 | 944.08 | -335.40 | 7.01% | 961.59
Insurance | 19,699.29 | 13,182.70 | 5.83% | -6,516.59 | 0.00 | 1,153.67 | 1,153.67 | -5,362.92 | 11.30% | 1,489.38
Telecom | 14,998.48 | 13,063.82 | 5.78% | -1,934.66 | 408.93 | 758.07 | 1,167.00 | -767.66 | 6.26% | 817.86
Packaging | 14,997.11 | 12,559.34 | 5.56% | -2,437.77 | 0.00 | 698.22 | 698.22 | -1,739.55 | 1.85% | 232.74
Advertising | 14,997.55 | 11,092.96 | 4.91% | -3,904.59 | 0.00 | 1,068.00 | 1,068.00 | -2,836.59 | 3.64% | 404.06
Bricks | 14,999.47 | 10,148.02 | 4.49% | -4,851.45 | 0.00 | 859.79 | 859.79 | -3,991.66 | 5.59% | 567.35
Oil | 17,122.32 | 9,783.91 | 4.33% | -7,338.41 | 0.00 | 1,065.24 | 1,065.24 | -6,273.17 | 7.04% | 688.65
Property | 14,993.43 | 9,680.01 | 4.28% | -5,313.42 | 0.00 | 586.92 | 586.92 | -4,726.50 | 5.11% | 494.62
Banks | 14,998.27 | 9,299.88 | 4.11% | -5,698.39 | 0.00 | 573.99 | 573.99 | -5,124.40 | 4.39% | 408.64
Television | 14,999.08 | 8,380.12 | 3.71% | -6,618.96 | 0.00 | 932.15 | 932.15 | -5,686.81 | 3.62% | 302.95
Cruise Ships | 14,979.79 | 3,847.68 | 1.70% | -11,132.11 | 0.00 | 610.18 | 610.18 | -10,521.93 | 4.00% | 154.06

(*) - 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.

Dividend Re-Investment: Future Schedule

Assuming that the dividends now expected are actually received, the re-investment schedule now looks as follows:

To Date   | Div Rec'd | Date      | Balance   | Re-Invest?
09-Jul-20 | 320.21 | 10-Jul-20 | 1,530.78 | N
07-Aug-20 | 178.79 | 10-Aug-20 | 1,939.71 | N
09-Sep-20 | 1,114.58 | 10-Sep-20 | 2,645.36 | Y
09-Oct-20 | 2,136.81 | 12-Oct-20 | 2,136.81 | Y
09-Nov-20 | 1,340.89 | 10-Nov-20 | 1,340.89 | N
09-Dec-20 | 699.97 | 10-Dec-20 | 2,040.86 | Y
08-Jan-21 | 612.16 | 11-Jan-21 | 612.16 | N
09-Feb-21 | 800.31 | 10-Feb-21 | 1,412.47 | N
09-Mar-21 | 357.95 | 10-Mar-21 | 1,770.42 | N
09-Apr-21 | 1,594.63 | 12-Apr-21 | 3,459.93 | Y
07-May-21 | 837.87 | 10-May-21 | 742.99 | N
09-Jun-21 | 2,856.19 | 10-Jun-21 | 3,599.18 | Y


Dividend Re-Investment: 10 Sep 20

What with the current dividend suspensions and cancellations, it is rather difficult to know what dividends will be received. However, with a current cash balance of £1,351.99, together with the following dividends being expected:

EPIC | Date      | Amount    
GSK | 09-Jul-20 | 178.79
VOD | 07-Aug-20 | 408.93
BATS | 19-Aug-20 | 110.98
PNN | 03-Sep-20 | 594.67
| |
| Total | £1,293.37


I feel confident that the balance will be over £2,000.00 by the 10 September, thus triggering a purchase.

Dividend Re-Investment: 10 Oct 20

Between 10 September and 10 October, the following dividends may, or may not, be received:

EPIC | Date      | Amount    
IBST | 21-Sep-20 | 187.16
RDSB | 23-Sep-20 | 58.67
SLA | 24-Sep-20 | 466.39
BP | 25-Sep-20 | 113.49
BHP | 25-Sep-20 | 524.50
AV | 26-Sep-20 | 457.90
IMB | 30-Sep-20 | 149.91
GSK | 08-Oct-20 | 178.79
| |
| Total | £2,136.81


I doubt very much that all of the above will be received but then again .........

.... forecasting is for the birds!


Should anyone wish to comment on this report, or 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=323790#p323790, the intention is to keep this thread simply recording the history of the Portfolio


Enjoy!


Ian


Return to “HYP Practical (See Group Guidelines)”

Who is online

Users browsing this forum: No registered users and 8 guests