Donate to Remove ads

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

Thanks to Haoma,Gilgongo,Raasu,Wasron,Steffers0, for Donating to support the site

PYAD HYP 2019_04 REINVEST – Year 1

Practical discussions about equity High-Yield Portfolios (HYP) for income
Forum rules
Tight HYP discussions only please - OT please discuss in strategies
IanTHughes
Lemon Slice
Posts: 942
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 438 times
Been thanked: 422 times

PYAD HYP 2019_04 REINVEST – Year 1

#225860

Postby IanTHughes » May 31st, 2019, 7:32 pm

Update 31 May 2019

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
Last edited by csearle on June 1st, 2019, 1:55 pm, edited 1 time in total.

SuperCally
Posts: 29
Joined: August 2nd, 2017, 7:31 am
Has thanked: 436 times
Been thanked: 21 times

Re: PYAD HYP 2019_04 REINVEST – Year 1

#226471

Postby SuperCally » June 3rd, 2019, 12:28 pm

Thank you for taking the time and trouble to post this excellent info.

Vinny

IanTHughes
Lemon Slice
Posts: 942
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 438 times
Been thanked: 422 times

Re: PYAD HYP 2019_04 REINVEST – Year 1

#228475

Postby IanTHughes » June 10th, 2019, 7:03 pm

Update 10 Jun 2019

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 Top-Ups 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 dated 31 May 2019 has now been made as follows:

EPIC | Name             |  #  | Price      |   Amount  | Stamp | Fee   | Total Cost
IMB | Imperial Brands | 151 | 2,081.0000p| £3,142.31 | £15.71| £1.50 | £3,159.52

The portfolio now looks like this:

EPIC | Company Name           | Shares  | Cost (£)    | Price (p)   | Value (£)   | Value (%)| P/L (£)    | Business       | Yearly (£) |Yield * |To Date (£)| Ex-Div (£)| Total (£)    
AV | Aviva | 3,637 | 14,996.21 | 417.9000 | 15,199.02 | 6.00% | 202.81 | Insurance | 1,091.10 | 7.18% | 754.67 | 0.00 | 754.67
BA | BAE Systems | 3,043 | 14,995.20 | 485.0000 | 14,758.55 | 5.83% | -236.65 | Weapons | 675.54 | 4.58% | 401.67 | 0.00 | 401.67
BHP | BHP Group | 838 | 14,992.51 | 1,852.0000 | 15,519.76 | 6.13% | 527.25 | Mining | 775.80 | 5.00% | 0.00 | 0.00 | 0.00
BLND | British Land Company | 1,280 | 7,497.95 | 540.8000 | 6,922.24 | 2.73% | -575.71 | Property | 396.80 | 5.73% | 0.00 | 0.00 | 0.00
BP | BP | 1,347 | 7,496.10 | 555.5000 | 7,482.59 | 2.95% | -13.51 | Oil | 433.60 | 5.79% | 0.00 | 108.64 | 108.64
CCL | Carnival Corporation | 384 | 14,979.79 | 4,008.0000 | 15,390.72 | 6.08% | 410.93 | Cruise Ships | 602.52 | 3.91% | 0.00 | 150.63 | 150.63
GNK | Greene King | 2,266 | 14,994.78 | 655.0000 | 14,842.30 | 5.86% | -152.48 | Brewing & Pubs | 752.31 | 5.07% | 0.00 | 0.00 | 0.00
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,577.0000 | 14,839.57 | 5.86% | -159.80 | Pharma | 752.80 | 5.07% | 0.00 | 178.79 | 178.79
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 658.4000 | 15,966.20 | 6.30% | 967.93 | Bank | 970.30 | 6.08% | 0.00 | 190.25 | 190.25
IBST | Ibstock | 5,849 | 14,999.47 | 240.0000 | 14,037.60 | 5.54% | -961.87 | Bricks | 555.65 | 3.96% | 380.18 | 0.00 | 380.18
IGG | IG Group Holdings | 2,762 | 14,999.32 | 560.2000 | 15,472.72 | 6.11% | 473.40 | Gambling | 1,193.18 | 7.71% | 0.00 | 0.00 | 0.00
IMB | Imperial Brands | 719 | 18,148.31 | 2,040.5000 | 14,671.20 | 5.79% | -3,477.11 | Tobacco | 1,485.16 | 10.12% | 0.00 | 177.67 | 177.67
ITV | ITV | 11,652 | 14,999.08 | 110.0000 | 12,817.20 | 5.06% | -2,181.88 | Television | 932.16 | 7.27% | 629.20 | 0.00 | 629.20
LAND | Land Securities Group | 818 | 7,499.19 | 849.2000 | 6,946.46 | 2.74% | -552.73 | Property | 397.13 | 5.72% | 0.00 | 0.00 | 0.00
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,550.0000 | 7,879.50 | 3.11% | 397.84 | Oil | 455.76 | 5.78% | 0.00 | 113.94 | 113.94
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 277.1000 | 15,248.81 | 6.02% | 251.16 | Fund Manager | 1,188.64 | 7.79% | 786.92 | 0.00 | 786.92
SMDS | DS Smith | 4,310 | 14,997.11 | 332.5000 | 14,330.75 | 5.66% | -666.36 | Packaging | 646.50 | 4.51% | 224.12 | 0.00 | 224.12
VOD | Vodafone Group | 10,077 | 14,998.48 | 130.4000 | 13,140.41 | 5.19% | -1,858.07 | Telecom | 806.16 | 6.13% | 0.00 | 372.62 | 372.62
WPP | WPP | 1,780 | 14,997.55 | 998.4000 | 17,771.52 | 7.02% | 2,773.97 | Advertising | 1,068.00 | 6.01% | 0.00 | 0.00 | 0.00
| | | | | | | | | | | | |
| Sub Total: | | £258,068.00 | | £253,237.12 | | -£4,830.88 | | £15,179.11 | 5.99% | £3,176.76 | £1,292.54 | £4,469.30
| Cash: | | £0.00 | | £17.24 | | | | | | | |
| Ex-Dividend: | | £0.00 | | £1,292.54 | | | | | | | |
| | | | | | | | | | | | |
| Total: | | £258,068.00 | | £254,546.90 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | £254,908.48 | | £254,908.48 | | | | | | | |
| LESS Cash Out: | | £0.00 | | £0.00 | | | | | | | |
| Dividends: | | £0.00 | | £3,176.76 | | | | | | | |
| UnRealised P/L: | | £0.00 | | -£4,830.88 | | | | | | | |
| Ex-Dividend: | | £0.00 | | £1,292.54 | Port | | | | | | |
| | | | | | P/L | | | | | | |
| Total: | | £254,908.48 | | £254,546.90 | -£361.58 | | | | | | |

* - 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 (%)| P/L (£)    | Yearly (£) | Yield  |To Date (£)| Ex-Div (£)| Total (£)
Advertising | 14,997.55 | 17,771.52 | 7.02% | 2,773.97 | 1,068.00 | 6.01% | 0.00 | 0.00 | 0.00
Bank | 14,998.27 | 15,966.20 | 6.30% | 967.93 | 970.30 | 6.08% | 0.00 | 190.25 | 190.25
Mining | 14,992.51 | 15,519.76 | 6.13% | 527.25 | 775.80 | 5.00% | 0.00 | 0.00 | 0.00
Gambling | 14,999.32 | 15,472.72 | 6.11% | 473.40 | 1,193.18 | 7.71% | 0.00 | 0.00 | 0.00
Oil | 14,977.76 | 15,362.09 | 6.07% | 384.33 | 889.36 | 5.79% | 0.00 | 222.58 | 222.58
Insurance | 14,996.21 | 15,199.02 | 6.00% | 202.81 | 1,091.10 | 7.18% | 754.67 | 0.00 | 754.67
Cruise Ships | 14,979.79 | 15,390.72 | 6.08% | 410.93 | 602.52 | 3.91% | 0.00 | 150.63 | 150.63
Fund Manager | 14,997.65 | 15,248.81 | 6.02% | 251.16 | 1,188.64 | 7.79% | 786.92 | 0.00 | 786.92
Tobacco | 18,148.31 | 14,671.20 | 5.79% | -3,477.11 | 1,485.16 | 10.12% | 0.00 | 177.67 | 177.67
Brewing & Pubs | 14,994.78 | 14,842.30 | 5.86% | -152.48 | 752.31 | 5.07% | 0.00 | 0.00 | 0.00
Pharma | 14,999.37 | 14,839.57 | 5.86% | -159.80 | 752.80 | 5.07% | 0.00 | 178.79 | 178.79
Weapons | 14,995.20 | 14,758.55 | 5.83% | -236.65 | 675.54 | 4.58% | 401.67 | 0.00 | 401.67
Packaging | 14,997.11 | 14,330.75 | 5.66% | -666.36 | 646.50 | 4.51% | 224.12 | 0.00 | 224.12
Bricks | 14,999.47 | 14,037.60 | 5.54% | -961.87 | 555.65 | 3.96% | 380.18 | 0.00 | 380.18
Property | 14,997.14 | 13,868.70 | 5.48% | -1,128.44 | 793.93 | 5.72% | 0.00 | 0.00 | 0.00
Telecom | 14,998.48 | 13,140.41 | 5.19% | -1,858.07 | 806.16 | 6.13% | 0.00 | 372.62 | 372.62
Television | 14,999.08 | 12,817.20 | 5.06% | -2,181.88 | 932.16 | 7.27% | 629.20 | 0.00 | 629.20
| | | | | | | | |
Sub Total: | £258,068.00 | £253,237.12 | | -£4,830.88 | £15,179.11 | 5.99% | £3,176.76 | £1,292.54 | £4,469.30
Cash: | £0.00 | £17.24 | | | | | | |
Ex-Dividend: | £0.00 | £1,292.54 | | | | | | |
| | | | | | | | |
Total: | £258,068.00 | £254,546.90 | | | | | | |
From: | | | | | | | | |
Cash In: | £254,908.48 | £254,908.48 | | | | | | |
LESS Cash Out: | £0.00 | £0.00 | | | | | | |
Dividends: | £0.00 | £3,176.76 | | | | | | |
UnRealised P/L: | £0.00 | -£4,830.88 | | | | | | |
Ex-Dividend: | £0.00 | £1,292.54 | Port | | | | | |
| | | P/L | | | | | |
Total: | £254,908.48 | £254,546.90 | -£361.58 | | | | | |


As I stated previously, 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, as long as a cash balance of at least £2,000.00 is then available. Therefore, based on current dividend expectations, the anticipated Top-Up timetable going forward is as follows:

ReInvest  |           | 2,000.00  | Dividend  |          
Date | Balance | Top-Up? | To Date | Div
10-Jul-19 | 1,422.31 | N | 10-Jul-19 | 1,405.07
12-Aug-19 | 2,192.75 | Y | 12-Aug-19 | 770.44
10-Sep-19 | 0.00 | N | 10-Sep-19 | 0.00
10-Oct-19 | 2,761.17 | Y | 10-Oct-19 | 2,939.96
11-Nov-19 | 1,939.65 | N | 11-Nov-19 | 1,760.86
10-Dec-19 | 2,706.72 | Y | 10-Dec-19 | 767.07
10-Jan-20 | 1,161.79 | N | 10-Jan-20 | 1,161.79
10-Feb-20 | 1,893.92 | N | 10-Feb-20 | 732.13
10-Mar-20 | 2,251.87 | Y | 10-Mar-20 | 357.95
14-Apr-20 | 1,960.56 | N | 14-Apr-20 | 1,960.56
11-May-20 | 2,283.88 | Y | 11-May-20 | 323.32
10-Jun-20 | 2,952.64 | Y | 10-Jun-20 | 2,952.64


The next Portfolio update will therefore be on 31 July 2019 with a Top-UP being made on the 12 August 2019


Ian

IanTHughes
Lemon Slice
Posts: 942
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 438 times
Been thanked: 422 times

PYAD HYP 2019_04 REINVEST – Year 1

#241371

Postby IanTHughes » August 2nd, 2019, 7:37 pm

Update 02 August 2019

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 (£)     | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
AV | Aviva | 3,637 | 14,996.21 | 400.8000 | 14,577.10 | 5.74% | -419.11 | 754.67 | 0.00 | 754.67 | 335.56 | 7.49% | 1,091.10
BA | BAE Systems | 3,043 | 14,995.20 | 544.8000 | 16,578.26 | 6.53% | 1,583.06 | 401.67 | 0.00 | 401.67 | 1,984.73 | 4.15% | 687.71
BHP | BHP Group | 838 | 14,992.51 | 1,844.0000 | 15,452.72 | 6.09% | 460.21 | 0.00 | 0.00 | 0.00 | 460.21 | 5.17% | 798.15
BLND | British Land Company | 1,273 | 7,494.24 | 500.4000 | 6,370.09 | 2.51% | -1,124.15 | 98.65 | 0.00 | 98.65 | -1,025.50 | 6.38% | 406.46
BP | BP | 1,347 | 7,496.10 | 526.9000 | 7,097.34 | 2.79% | -398.76 | 108.64 | 0.00 | 108.64 | -290.12 | 6.28% | 445.76
CCL | Carnival Corporation | 384 | 14,979.79 | 3,611.0000 | 13,866.24 | 5.46% | -1,113.55 | 152.57 | 0.00 | 152.57 | -960.98 | 4.47% | 619.88
GNK | Greene King | 2,266 | 14,994.78 | 615.2000 | 13,940.43 | 5.49% | -1,054.35 | 0.00 | 0.00 | 0.00 | -1,054.35 | 5.40% | 752.31
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,691.0000 | 15,912.31 | 6.27% | 912.94 | 178.79 | 0.00 | 178.79 | 1,091.73 | 4.73% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 646.1000 | 15,667.93 | 6.17% | 669.66 | 190.04 | 0.00 | 190.04 | 859.70 | 6.37% | 998.26
IBST | Ibstock | 5,849 | 14,999.47 | 212.8000 | 12,446.67 | 4.90% | -2,552.80 | 380.18 | 0.00 | 380.18 | -2,172.62 | 4.56% | 567.35
IGG | IG Group Holdings | 2,762 | 14,999.32 | 567.2000 | 15,666.06 | 6.17% | 666.74 | 0.00 | 0.00 | 0.00 | 666.74 | 7.62% | 1,193.18
IMB | Imperial Brands | 719 | 18,148.31 | 2,136.0000 | 15,357.84 | 6.05% | -2,790.47 | 177.67 | 0.00 | 177.67 | -2,612.80 | 9.67% | 1,485.16
ITV | ITV | 11,652 | 14,999.08 | 106.7500 | 12,438.51 | 4.90% | -2,560.57 | 629.20 | 0.00 | 629.20 | -1,931.37 | 7.49% | 932.16
LAND | Land Securities Group | 818 | 7,499.19 | 795.2000 | 6,504.74 | 2.56% | -994.45 | 95.29 | 0.00 | 95.29 | -899.16 | 5.84% | 379.96
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,408.5000 | 7,442.27 | 2.93% | -39.39 | 114.23 | 0.00 | 114.23 | 74.84 | 6.30% | 468.90
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 291.5000 | 16,041.25 | 6.32% | 1,043.60 | 786.92 | 0.00 | 786.92 | 1,830.52 | 7.41% | 1,188.64
SMDS | DS Smith | 4,310 | 14,997.11 | 338.2000 | 14,576.42 | 5.74% | -420.69 | 224.12 | 0.00 | 224.12 | -196.57 | 4.79% | 698.22
VOD | Vodafone Group | 10,077 | 14,998.48 | 150.3600 | 15,151.78 | 5.97% | 153.30 | 375.37 | 0.00 | 375.37 | 528.67 | 5.37% | 814.19
WPP | WPP | 1,780 | 14,997.55 | 937.2000 | 16,682.16 | 6.57% | 1,684.61 | 663.94 | 0.00 | 663.94 | 2,348.55 | 6.40% | 1,068.00
| | | | | | | | | | | | |
| Sub Total: | | £258,064.29 | | £251,770.12 | 99.14% | -£6,294.17 | £5,331.95 | £0.00 | £5,331.95 | -£962.22 | 6.10% | £15,348.19
| Cash Bal: | | £2,172.43 | | £2,172.43 | 0.86% | | | | | | |
| Ex-Dividend: | | | | £0.00 | 0.00% | | | | | | |
| Cash Out: | | | | £0.00 | | | | | | | |
| | | | | | | | | | | | |
| Total: | | £260,236.72 | | £253,942.55 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | £254,904.77 | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | £0.00 | | | | | | | | | |
| Dividends: | | £5,331.95 | | | | | | | | | |
| Overall P/L: | | | | -£962.22 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | £260,236.72 | | £253,942.55 | -0.91% | | | | | | |


(*) - 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 (%) | P/L (£)     | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Tobacco | 18,148.31 | 15,357.84 | 6.05% | -2,790.47 | 177.67 | 0.00 | 177.67 | -2,612.80 | 9.67% | 1,485.16
Gambling | 14,999.32 | 15,666.06 | 6.17% | 666.74 | 0.00 | 0.00 | 0.00 | 666.74 | 7.62% | 1,193.18
Television | 14,999.08 | 12,438.51 | 4.90% | -2,560.57 | 629.20 | 0.00 | 629.20 | -1,931.37 | 7.49% | 932.16
Insurance | 14,996.21 | 14,577.10 | 5.74% | -419.11 | 754.67 | 0.00 | 754.67 | 335.56 | 7.49% | 1,091.10
Fund Manager | 14,997.65 | 16,041.25 | 6.32% | 1,043.60 | 786.92 | 0.00 | 786.92 | 1,830.52 | 7.41% | 1,188.64
Advertising | 14,997.55 | 16,682.16 | 6.57% | 1,684.61 | 663.94 | 0.00 | 663.94 | 2,348.55 | 6.40% | 1,068.00
Banks | 14,998.27 | 15,667.93 | 6.17% | 669.66 | 190.04 | 0.00 | 190.04 | 859.70 | 6.37% | 998.26
Oil | 14,977.76 | 14,539.61 | 5.73% | -438.15 | 222.87 | 0.00 | 222.87 | -215.28 | 6.29% | 914.66
Property | 14,993.43 | 12,874.83 | 5.07% | -2,118.60 | 193.94 | 0.00 | 193.94 | -1,924.66 | 6.11% | 786.42
Telecom | 14,998.48 | 15,151.78 | 5.97% | 153.30 | 375.37 | 0.00 | 375.37 | 528.67 | 5.37% | 814.19
Brewing & Pubs | 14,994.78 | 13,940.43 | 5.49% | -1,054.35 | 0.00 | 0.00 | 0.00 | -1,054.35 | 5.40% | 752.31
Mining | 14,992.51 | 15,452.72 | 6.09% | 460.21 | 0.00 | 0.00 | 0.00 | 460.21 | 5.17% | 798.15
Packaging | 14,997.11 | 14,576.42 | 5.74% | -420.69 | 224.12 | 0.00 | 224.12 | -196.57 | 4.79% | 698.22
Pharma | 14,999.37 | 15,912.31 | 6.27% | 912.94 | 178.79 | 0.00 | 178.79 | 1,091.73 | 4.73% | 752.80
Bricks | 14,999.47 | 12,446.67 | 4.90% | -2,552.80 | 380.18 | 0.00 | 380.18 | -2,172.62 | 4.56% | 567.35
Cruise Ships | 14,979.79 | 13,866.24 | 5.46% | -1,113.55 | 152.57 | 0.00 | 152.57 | -960.98 | 4.47% | 619.88
Weapons | 14,995.20 | 16,578.26 | 6.53% | 1,583.06 | 401.67 | 0.00 | 401.67 | 1,984.73 | 4.15% | 687.71
| | | | | | | | | |
Sub Total: | £258,064.29 | £251,770.12 | 99.14% | -£6,294.17 | £5,331.95 | £0.00 | £5,331.95 | -£962.22 | 6.10% | £15,348.19


Top-Up on 12 Aug 2019

Available Balance expected on 12 Aug 2019: £2,172.43

From the point of view of the “Highest Yield” the following candidates were rejected:

Tobacco - Imperial Brands (IMB) – Yield 9.67% - Value Concentration (6.05%) already high enough. Dividend Policy of 10% annual increase ditched
Gambling - IG Group Holdings (IGG) – Yield 7.62% - Value Concentration (6.17%) already high enough
Television - ITV Plc (ITV) – Yield 7.49% - Recent Dividend held

The selection is therefore the fourth highest yielding share in the portfolio:

Insurance - Aviva (AV) – Yield 7.49%

The price has slipped since purchase, mainly due to going ex-dividend with an amount now received. I was toying with an update for ITV (Television) but with a held dividend and the fact that AV, with its recently raised dividend is yielding the same ….. no contest in the end.

The Value Concentration after purchase (6.60%) will make AV and Insurance the highest holding by that measure, but not hugely larger than the current Value leaders.


The price of the purchase, and therefore the number of shares purchased, will be determined by the mid-price on the day, 12 August 2019. I will post an update when the price is known.



Ian

daveh
Lemon Slice
Posts: 633
Joined: November 4th, 2016, 11:06 am
Has thanked: 48 times
Been thanked: 194 times

Re: PYAD HYP 2019_04 REINVEST – Year 1

#241899

Postby daveh » August 5th, 2019, 4:28 pm

Ian, I have a question. So far you have been reinvesting dividends by topping up existing holdings. You have already ruled out ITV as it has held its dividend and ruled out others for top ups as they would then make up too high a percentage of the portfolio. You may run out of top up options. Have you thought of/ or do you plan to invest in any new holdings or would the portfolio then deviate to far from the original as selected by Pyad.

IanTHughes
Lemon Slice
Posts: 942
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 438 times
Been thanked: 422 times

Re: PYAD HYP 2019_04 REINVEST – Year 1

#241915

Postby IanTHughes » August 5th, 2019, 5:22 pm

daveh wrote:Ian, I have a question. So far you have been reinvesting dividends by topping up existing holdings. You have already ruled out ITV as it has held its dividend and ruled out others for top ups as they would then make up too high a percentage of the portfolio. You may run out of top up options. Have you thought of/ or do you plan to invest in any new holdings or would the portfolio then deviate to far from the original as selected by Pyad.

Those ruled out for already being too high a percentage of the portfolio value will not always be so and surely by definition, if there are holdings that are too large, there will also be other holdings too small.

On top of that any share on the “naughty step” may come off that step in due course. For example, ITV PLC (ITV) may increase its final dividend and the new dividend policy for Imperial Brands (IMB) may still produce sizeable dividend increases, even though no longer 10%. In fact I suspect the latter is entirely possible, we shall have to see about ITV though! In fact, currently the only big “naughty step” resident is Vodafone Group (VOD) as a result of its recent dividend cut.

But to answer your question more fully: yes, I am prepared to purchase a completely new holding if one is clearly the Highest Available Yield with a sustainable dividend, diversification etc etc. I say “clearly the Highest Available Yield”, not for any HYP reason you understand, more I don’t want the hassle of having to do the research for such a new holding unless considered absolutely necessary. The discovery of only a slightly higher yield than a current holding, would most probably result in the topping up of the current holding. And no, I have not yet worked out what "sizeable" means, I will play it by ear. Of course if I end up going the route of a new holding, I shall have to keep to pyad’s selection of only FTSE 100 or largest from the FTSE 250, which is different to my own HYP where I am somewhat more cavalier!

By the way, I would welcome any feedback on my selections or any suggestions that others may have for new holdings but perhaps that could be on a separate thread, so as not to make this annual thread too long for future reading. Please also bear in mind that this is a pyad portfolio and any suggestions should be in line with his way of thinking, as much as one can of course.


Ian

IanTHughes
Lemon Slice
Posts: 942
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 438 times
Been thanked: 422 times

PYAD HYP 2019_04 REINVEST – Year 1 - August Top-Up

#244045

Postby IanTHughes » August 13th, 2019, 5:39 pm

Update 12 Aug 2019

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=241371#p241371 has now been made as follows:

EPIC | Name             |  #  | Price      |   Amount  | Stamp | Fee   | Total Cost
AV | Aviva | 563 | 383.6500p| £2,159.95 | £10.80| £1.50 | £2,172.25

As at the Close of Business on 13 Aug 20129 the portfolio looks like this:

Sorted Alphabetically
EPIC | Company                | Shares  | Cost (£)     | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
AV | Aviva | 4,200 | 17,168.46 | 380.2000 | 15,968.40 | 6.35% | -1,200.06 | 754.67 | 0.00 | 754.67 | -445.39 | 7.96% | 1,270.50
BA | BAE Systems | 3,043 | 14,995.20 | 555.4000 | 16,900.82 | 6.72% | 1,905.62 | 401.67 | 0.00 | 401.67 | 2,307.29 | 4.07% | 687.71
BHP | BHP Group | 838 | 14,992.51 | 1,816.0000 | 15,218.08 | 6.05% | 225.57 | 0.00 | 0.00 | 0.00 | 225.57 | 5.35% | 814.73
BLND | British Land Company | 1,273 | 7,494.24 | 477.5000 | 6,078.58 | 2.42% | -1,415.66 | 98.65 | 0.00 | 98.65 | -1,317.01 | 6.69% | 406.46
BP | BP | 1,347 | 7,496.10 | 506.9000 | 6,827.94 | 2.71% | -668.16 | 108.64 | 113.75 | 222.39 | -445.77 | 6.66% | 455.00
CCL | Carnival Corporation | 384 | 14,979.79 | 3,609.0000 | 13,858.56 | 5.51% | -1,121.23 | 152.57 | 0.00 | 152.57 | -968.66 | 4.57% | 632.76
GNK | Greene King | 2,266 | 14,994.78 | 581.0000 | 13,165.46 | 5.23% | -1,829.32 | 0.00 | 552.90 | 552.90 | -1,276.42 | 5.71% | 752.31
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,684.0000 | 15,846.44 | 6.30% | 847.07 | 178.79 | 178.79 | 357.58 | 1,204.65 | 4.75% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 614.3000 | 14,896.78 | 5.92% | -101.49 | 190.04 | 0.00 | 190.04 | 88.55 | 6.84% | 1,018.99
IBST | Ibstock | 5,849 | 14,999.47 | 218.6000 | 12,785.91 | 5.08% | -2,213.56 | 380.18 | 0.00 | 380.18 | -1,833.38 | 4.44% | 567.35
IGG | IG Group Holdings | 2,762 | 14,999.32 | 555.6000 | 15,345.67 | 6.10% | 346.35 | 0.00 | 0.00 | 0.00 | 346.35 | 7.78% | 1,193.18
IMB | Imperial Brands | 719 | 18,148.31 | 2,099.5000 | 15,095.41 | 6.00% | -3,052.90 | 177.67 | 0.00 | 177.67 | -2,875.23 | 9.84% | 1,485.16
ITV | ITV | 13,687 | 17,197.10 | 107.4000 | 14,699.84 | 5.84% | -2,497.26 | 629.20 | 0.00 | 629.20 | -1,868.06 | 7.45% | 1,094.96
LAND | Land Securities Group | 818 | 7,499.19 | 755.4000 | 6,179.17 | 2.46% | -1,320.02 | 95.29 | 0.00 | 95.29 | -1,224.73 | 6.15% | 379.96
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,380.5000 | 7,355.75 | 2.92% | -125.91 | 114.23 | 0.00 | 114.23 | -11.68 | 6.51% | 478.63
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 250.5000 | 13,785.02 | 5.48% | -1,212.63 | 786.92 | 0.00 | 786.92 | -425.71 | 8.62% | 1,188.64
SMDS | DS Smith | 4,310 | 14,997.11 | 333.0000 | 14,352.30 | 5.70% | -644.81 | 224.12 | 0.00 | 224.12 | -420.69 | 4.86% | 698.22
VOD | Vodafone Group | 10,077 | 14,998.48 | 149.6800 | 15,083.25 | 5.99% | 84.77 | 375.37 | 0.00 | 375.37 | 460.14 | 5.50% | 830.06
WPP | WPP | 1,780 | 14,997.55 | 976.0000 | 17,372.80 | 6.90% | 2,375.25 | 663.94 | 0.00 | 663.94 | 3,039.19 | 6.15% | 1,068.00
| | | | | | | | | | | | |
| Sub Total: | | £262,434.56 | | £250,816.18 | 99.66% | -£11,618.38 | £5,331.95 | £845.44 | £6,177.39 | -£5,440.99 | 6.29% | £15,775.42
| Cash Bal: | | | | £0.18 | 0.00% | | | | | | |
| Ex-Dividend: | | | | £845.44 | 0.34% | | | | | | |
| Cash Out: | | | | £0.00 | | | | | | | |
| | | | | | | | | | | | |
| Total: | | | | £251,661.80 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | £0.00 | | | | | | | |
| Dividends: | | | | £5,331.95 | | | | | | | |
| Capital P/L: | | | | -£8,574.92 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £251,661.80 | -3.38% | | | | | | |

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

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

Business       | Cost (£)   | Value (£)  | Value (%) | P/L (£)    | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Tobacco | 18,148.31 | 15,095.41 | 6.00% | -3,052.90 | 177.67 | 0.00 | 177.67 | -2,875.23 | 9.84% | 1,485.16
Fund Manager | 14,997.65 | 13,785.02 | 5.48% | -1,212.63 | 786.92 | 0.00 | 786.92 | -425.71 | 8.62% | 1,188.64
Insurance | 17,168.46 | 15,968.40 | 6.35% | -1,200.06 | 754.67 | 0.00 | 754.67 | -445.39 | 7.96% | 1,270.50
Gambling | 14,999.32 | 15,345.67 | 6.10% | 346.35 | 0.00 | 0.00 | 0.00 | 346.35 | 7.78% | 1,193.18
Television | 17,197.10 | 14,699.84 | 5.84% | -2,497.26 | 629.20 | 0.00 | 629.20 | -1,868.06 | 7.45% | 1,094.96
Banks | 14,998.27 | 14,896.78 | 5.92% | -101.49 | 190.04 | 0.00 | 190.04 | 88.55 | 6.84% | 1,018.99
Oil | 14,977.76 | 14,183.69 | 5.64% | -794.07 | 222.87 | 113.75 | 336.62 | -457.45 | 6.58% | 933.63
Property | 14,993.43 | 12,257.75 | 4.87% | -2,735.68 | 193.94 | 0.00 | 193.94 | -2,541.74 | 6.42% | 786.42
Advertising | 14,997.55 | 17,372.80 | 6.90% | 2,375.25 | 663.94 | 0.00 | 663.94 | 3,039.19 | 6.15% | 1,068.00
Brewing & Pubs | 14,994.78 | 13,165.46 | 5.23% | -1,829.32 | 0.00 | 552.90 | 552.90 | -1,276.42 | 5.71% | 752.31
Telecom | 14,998.48 | 15,083.25 | 5.99% | 84.77 | 375.37 | 0.00 | 375.37 | 460.14 | 5.50% | 830.06
Mining | 14,992.51 | 15,218.08 | 6.05% | 225.57 | 0.00 | 0.00 | 0.00 | 225.57 | 5.35% | 814.73
Packaging | 14,997.11 | 14,352.30 | 5.70% | -644.81 | 224.12 | 0.00 | 224.12 | -420.69 | 4.86% | 698.22
Pharma | 14,999.37 | 15,846.44 | 6.30% | 847.07 | 178.79 | 178.79 | 357.58 | 1,204.65 | 4.75% | 752.80
Cruise Ships | 14,979.79 | 13,858.56 | 5.51% | -1,121.23 | 152.57 | 0.00 | 152.57 | -968.66 | 4.57% | 632.76
Bricks | 14,999.47 | 12,785.91 | 5.08% | -2,213.56 | 380.18 | 0.00 | 380.18 | -1,833.38 | 4.44% | 567.35
Weapons | 14,995.20 | 16,900.82 | 6.72% | 1,905.62 | 401.67 | 0.00 | 401.67 | 2,307.29 | 4.07% | 687.71


Top-Ups to date
Date      | EPIC | Shares | Price (p)   | Cost (£)  | Stamp (£) | Fee (£) | Total (£)
12-Aug-19 | AV | 563 | 383.6500 | 2,159.95 | 10.80 | 1.50 | 2,172.25
10-Jun-19 | IMB | 151 | 2,081.0000 | 3,142.31 | 15.71 | 1.50 | 3,159.52


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, as 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   | Top-Up? | To Date   | Div Rec'd
10-Sep-19 | 0.18 | N | 10-Sep-19 | 0.00
10-Oct-19 | 3,179.55 | Y | 10-Oct-19 | 3,179.37
11-Nov-19 | 1,993.78 | N | 11-Nov-19 | 1,993.78
10-Dec-19 | 2,835.48 | Y | 10-Dec-19 | 841.70
10-Jan-20 | 1,182.94 | N | 10-Jan-20 | 1,182.94
10-Feb-20 | 1,930.34 | N | 10-Feb-20 | 747.40
10-Mar-20 | 2,288.29 | Y | 10-Mar-20 | 357.95
14-Apr-20 | 2,019.90 | Y | 14-Apr-20 | 2,019.90
11-May-20 | 325.73 | N | 11-May-20 | 325.73
10-Jun-20 | 3,505.09 | Y | 10-Jun-20 | 3,179.36
10-Jul-20 | 1,480.23 | N | 10-Jul-20 | 1,480.23
10-Aug-20 | 2,239.59 | Y | 10-Aug-20 | 759.36


The next Portfolio update will therefore be on 30 September 2019 with a Top-Up being made on the 10 October 2019


Ian

IanTHughes
Lemon Slice
Posts: 942
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 438 times
Been thanked: 422 times

PYAD HYP 2019_04 REINVEST – Year 1 - October Top-Up

#256090

Postby IanTHughes » October 5th, 2019, 5:53 pm

Update 05 October 2019

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 (£)      |  Div Rec'd (£)  |  Ex-Div (£)  |  Total Div (£)  |  Overall (£)  |  Yield (%) *  |  Year Div (£)
AV | Aviva | 4,200 | 17,168.46 | 380.0000 | 15,960.00 | 6.10% | -1,208.46 | 1,153.67 | 0.00 | 1,153.67 | -54.79 | 7.96% | 1,270.50
BA | BAE Systems | 3,043 | 14,995.20 | 544.0000 | 16,553.92 | 6.33% | 1,558.72 | 401.67 | 0.00 | 401.67 | 1,960.39 | 4.15% | 687.71
BHP | BHP Group | 838 | 14,992.51 | 1,683.2000 | 14,105.22 | 5.39% | -887.29 | 528.19 | 0.00 | 528.19 | -359.10 | 6.42% | 905.61
BLND | British Land Company | 1,273 | 7,494.24 | 555.6000 | 7,072.79 | 2.70% | -421.45 | 98.65 | 101.61 | 200.26 | -221.19 | 5.75% | 406.46
BP | BP | 1,347 | 7,496.10 | 494.9000 | 6,666.30 | 2.55% | -829.80 | 221.08 | 0.00 | 221.08 | -608.72 | 6.73% | 448.72
CCL | Carnival Corporation | 384 | 14,979.79 | 3,167.0000 | 12,161.28 | 4.65% | -2,818.51 | 312.16 | 0.00 | 312.16 | -2,506.35 | 5.13% | 624.00
GNK | Greene King | 2,266 | 14,994.78 | 846.0000 | 19,170.36 | 7.33% | 4,175.58 | 552.90 | 0.00 | 552.90 | 4,728.48 | 3.92% | 752.31
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,699.0000 | 15,987.59 | 6.11% | 988.22 | 178.79 | 178.79 | 357.58 | 1,345.80 | 4.71% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 601.9000 | 14,596.08 | 5.58% | -402.19 | 384.85 | 0.00 | 384.85 | -17.34 | 6.88% | 1,004.92
IBST | Ibstock | 5,849 | 14,999.47 | 232.2000 | 13,581.38 | 5.19% | -1,418.09 | 859.79 | 0.00 | 859.79 | -558.30 | 4.18% | 567.35
IGG | IG Group Holdings | 2,762 | 14,999.32 | 596.4000 | 16,472.57 | 6.30% | 1,473.25 | 0.00 | 835.22 | 835.22 | 2,308.47 | 7.24% | 1,193.18
IMB | Imperial Brands | 719 | 18,148.31 | 1,820.6000 | 13,090.11 | 5.00% | -5,058.20 | 402.57 | 0.00 | 402.57 | -4,655.63 | 11.35% | 1,485.16
ITV | ITV | 11,652 | 14,999.08 | 123.1000 | 14,343.61 | 5.48% | -655.47 | 629.20 | 0.00 | 629.20 | -26.27 | 6.50% | 932.16
LAND | Land Securities Group | 818 | 7,499.19 | 836.6000 | 6,843.39 | 2.62% | -655.80 | 190.17 | 0.00 | 190.17 | -465.63 | 5.55% | 379.96
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,309.5000 | 7,136.36 | 2.73% | -345.30 | 231.68 | 0.00 | 231.68 | -113.62 | 6.61% | 472.02
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 271.0000 | 14,913.13 | 5.70% | -84.52 | 1,188.63 | 0.00 | 1,188.63 | 1,104.11 | 7.97% | 1,188.64
SMDS | DS Smith | 4,310 | 14,997.11 | 335.0000 | 14,438.50 | 5.52% | -558.61 | 224.12 | 474.10 | 698.22 | 139.61 | 4.84% | 698.22
VOD | Vodafone Group | 10,077 | 14,998.48 | 157.8600 | 15,907.55 | 6.08% | 909.07 | 375.37 | 0.00 | 375.37 | 1,284.44 | 5.07% | 806.59
WPP | WPP | 1,780 | 14,997.55 | 973.8000 | 17,333.64 | 6.63% | 2,336.09 | 663.94 | 404.06 | 1,068.00 | 3,404.09 | 6.16% | 1,068.00
| | | | | | | | | | | | |
| Sub Total: | | £260,236.54 | | £256,333.78 | 97.99% | -£3,902.76 | £8,597.43 | £1,993.78 | £10,591.21 | £6,688.45 | 6.10% | £15,644.31
| Cash Bal: | | | | £3,265.66 | 1.25% | | | | | | |
| Ex-Dividend: | | | | £1,993.78 | 0.76% | | | | | | |
| Cash Out: | | | | £0.00 | 0.00% | | | | | | |
| | | | | | | | | | | | |
| Total: | | £260,236.54 | | £261,593.22 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | £0.00 | | | | | | | |
| Dividends: | | | | £8,597.43 | | | | | | | |
| Realised P/L: | | | | £0.00 | | | | | | | |
| Un-Realised P/L: | | | | -£1,908.98 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £261,593.22 | 5.16% | | | | | | |


With the breakdown by Business as follows:

Business        |  Cost (£)    |  Value (£)   |  Value (%)  |  P/L (£)     |  Div Rec'd (£)  |  Ex-Div (£)  |  Total Inc (£)  |  Overall (£)  |  Yield (%) *  |  Year Inc (£)
Tobacco | 18,148.31 | 13,090.11 | 5.00% | -5,058.20 | 402.57 | 0.00 | 402.57 | -4,655.63 | 11.35% | 1,485.16
Fund Manager | 14,997.65 | 14,913.13 | 5.70% | -84.52 | 1,188.63 | 0.00 | 1,188.63 | 1,104.11 | 7.97% | 1,188.64
Insurance | 17,168.46 | 15,960.00 | 6.10% | -1,208.46 | 1,153.67 | 0.00 | 1,153.67 | -54.79 | 7.96% | 1,270.50
Gambling | 14,999.32 | 16,472.57 | 6.30% | 1,473.25 | 0.00 | 835.22 | 835.22 | 2,308.47 | 7.24% | 1,193.18
Banks | 14,998.27 | 14,596.08 | 5.58% | -402.19 | 384.85 | 0.00 | 384.85 | -17.34 | 6.88% | 1,004.92
Oil | 14,977.76 | 13,802.66 | 5.28% | -1,175.10 | 452.76 | 0.00 | 452.76 | -722.34 | 6.67% | 920.74
Mining | 14,992.51 | 14,105.22 | 5.39% | -887.29 | 528.19 | 0.00 | 528.19 | -359.10 | 6.42% | 905.61
Television | 14,999.08 | 14,343.61 | 5.48% | -655.47 | 629.20 | 0.00 | 629.20 | -26.27 | 6.50% | 932.16
Advertising | 14,997.55 | 17,333.64 | 6.63% | 2,336.09 | 663.94 | 404.06 | 1,068.00 | 3,404.09 | 6.16% | 1,068.00
Property | 14,993.43 | 13,916.18 | 5.32% | -1,077.25 | 288.82 | 101.61 | 390.43 | -686.82 | 5.65% | 786.42
Cruise Ships | 14,979.79 | 12,161.28 | 4.65% | -2,818.51 | 312.16 | 0.00 | 312.16 | -2,506.35 | 5.13% | 624.00
Telecom | 14,998.48 | 15,907.55 | 6.08% | 909.07 | 375.37 | 0.00 | 375.37 | 1,284.44 | 5.07% | 806.59
Packaging | 14,997.11 | 14,438.50 | 5.52% | -558.61 | 224.12 | 474.10 | 698.22 | 139.61 | 4.84% | 698.22
Pharma | 14,999.37 | 15,987.59 | 6.11% | 988.22 | 178.79 | 178.79 | 357.58 | 1,345.80 | 4.71% | 752.80
Bricks | 14,999.47 | 13,581.38 | 5.19% | -1,418.09 | 859.79 | 0.00 | 859.79 | -558.30 | 4.18% | 567.35
Weapons | 14,995.20 | 16,553.92 | 6.33% | 1,558.72 | 401.67 | 0.00 | 401.67 | 1,960.39 | 4.15% | 687.71
Brewing & Pubs | 14,994.78 | 19,170.36 | 7.33% | 4,175.58 | 552.90 | 0.00 | 552.90 | 4,728.48 | 3.92% | 752.31

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

Sale of Greene King PLC (GNK)

The upcoming takeover of GNK means that a decision is needed on a replacement holding. After initially waiting to see if the Hong Kong company’s offer of £8.50 per share would smoke out another higher offer, which of course has not happened, I have now decided to sell GNK to the market rather than wait until the end of the year to receive the funds. This will result in a slightly smaller amount being received but on the other hand it will allow the investment into a dividend producing share at an earlier date. HYP is about the Income after all.

So, the holding of GNK will be sold on 9 October 2019 with the proceeds being used to purchase a replacement the same day as well as two top-ups on 10 October 2019. The sale should provide approximately £19,150.00 which I have decided to re-invest as follows:

Purchase on 9 October 2019

The sale of GNK will reduce the sector diversification from 17 to 16 which I have decided to rectify by investing an amount just over the average currently invested per sector - £16,000 - into a new sector. The choice was between:

Sector       |  EPIC  |  Company Name                 |  Yield
Water | PNN | Pennon Group | 4.96%
Engineering | BAB | Babcock International Group | 5.38%

Pennon Group (PNN)

The owners of South West Water and Viridor Limited

The dividend history over more than a decade is unblemished in my view. Other figures include:

Dividend Cover: 1.32 – reasonably high for what is a regulated sector
P/E Ratio: 15.7 – low, or maybe lowish, when compared with other Utilities

The recent Trading update has already been reported on these boards here:

viewtopic.php?p=254244#p254244 – thanks to idpickering

I do appreciate the much-discussed political risk of nationalisation but, in my opinion, the chances of a future Corbyn led Labour Government with a working majority large enough to push through such a policy are slim. At least slim enough to leave it to Strategic Ignorance.

Babcock International (BAB)

From their website: https://www.babcockinternational.com/
Babcock is a leading provider of critical, complex engineering services which support national defence, save lives and protect communities.
We focus on three highly regulated markets – defence, emergency services and civil nuclear – delivering vital services and managing complex assets in the UK and internationally. We are a trusted partner who understands the key roles that our technology, our expertise, our infrastructure and our assets play in ensuring our customers can deliver. We share risk with them in delivering innovation, and we share the benefits.

The dividend history over the past 5 years shows continuous growth although now slowing. Other figures include:

Dividend Cover: 1.61 – reasonable although reduced from the prior year
P/E Ratio: 12.7 – low, in my view

Year End 31 March 2019 revenue and profits were reduced from the previous year, but the Cash Flow is reported as good.

I was about to go for BAB but, upon reading the latest Annual Report here:

https://www.babcockinternational.com/wp ... tement.pdf

I noticed at the very beginning that the current outlook for the Year End 31 March 2020, as reported by the Company, mentions a reduction in Operating Profit to £515m - £535m (2019: £568m)
Outlook for the year ending 31 March 2020
- As previously highlighted, the year ending 31 March 2020 will be affected by a number of step downs (detailed on page 6). In total,
these step downs will reduce revenue by £410 million and reduce operating profit by £63 million
- The Group’s guidance reflects these step downs and the current market conditions, including the weakness in short cycle contracts
experienced this financial year
- We expect underlying revenue to be around £4.9 billion
- We expect to maintain our underlying margin (incl. JVs) at between 10.7% and 11.0%
- Underlying operating profit is expected to be in the range of £515 million to £535 million
- Free cash flow (post pension payments) is expected to be over £250 million and we expect to continue to reduce net debt
- As with previous years, performance for the group will be weighted to the second half, especially for cash generation

As a result, the dividend does not look quite as sustainable as I would like. Rather a shame in my view, as BAB was otherwise looking like an interesting candidate not normally considered for HYP. Personally, I have put it on my watchlist.

Decision

The decision as to where to invest the bulk of the proceeds from the sale of GNK is therefore PNN

Top-Ups on 10 Oct 2019

After the purchase of PNN, the remaining funds, approximately £3,150 from the sale of GNK together with £3,265.66 from dividends already received by the 9 October 2019 – a total of £6,415.66 - will be used to top-up holdings in existing Business Sectors.

From the point of view of the “Highest Yield” the following candidates were rejected:

Sector      |  EPIC  |  Company            |  Yield   |  Comments
Tobacco | IMB | Imperial Brands | 11.35% | Dividend Policy of 10% annual increase ditched. Recent Profit Warning
Insurance | AV | Aviva | 7.96% | Sector Value Concentration (6.10%) already high enough
Gambling | IGG | IG Group Holdings | 7.24% | Sector Value Concentration (6.30%) already high enough
Banks | HSBA | HSBC Group | 6.54% | Held Dividend for many years
Television | ITV | ITV | 6.34% | Recent Dividend held


The first selection – for just over £2,400 - is therefore:
Sector        |  EPIC  |  Company                 |  Yield
Fund Manager | SLA | Standard Life Aberdeen | 7.97%

The Value Concentration after purchase (6.50%) will leave the Fund Manager holding as one of the top holdings by that measure, but not too large in my opinion.

The second selection – for the remaining funds, about £4,000 - is therefore a new holding:
Sector   |  EPIC  |  Company                   |  Yield
Tobacco | BATS | British American Tobacco | 7.25%

It does not appear that BATS is going through the same pains that are now occurring at IMB. The now quarterly dividend pay-out is still increasing – 203.00p expected for the Year Ending Dec 2019 an increase of 4.00% from 195.30p the year before.

The Value Concentration after purchase (6.50%) will leave the combined Tobacco holdings as one of the largest by that measure, not too large in my opinion and now split between two holdings.


The price of the GNK sale will be determined by the mid-price on the 9 October 2019, as will the price of the PNN purchase. Once the remaining funds from the sale of GNK are known, the details of the two planned top-ups will be determined by the mid-prices on 10 October 2019. I will post an update when the details of all deals are known.

Enjoy!


Ian

IanTHughes
Lemon Slice
Posts: 942
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 438 times
Been thanked: 422 times

PYAD HYP 2019_04 REINVEST – Year 1 - October Top Up details

#256989

Postby IanTHughes » October 10th, 2019, 6:02 pm

Update 10 October 2019

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 sale of Greene King PLC (GNK) and purchase of Pennon PLC (PNN), as well as the two top-ups indicated in the previous post viewtopic.php?p=256090#p256090 have now been made as follows:

EPIC | Shares  | Price (p)   | Cost (£)    | Stamp (£) | Fee (£) | Total (£)  
BATS | 142 | 2,813.7500 | -3,995.53 | -19.98 | -1.50 | -4,017.01
SLA | 886 | 269.3000 | -2,386.00 | -11.93 | -1.50 | -2,399.43
PNN | 1,975 | 806.3000 | -15,924.43 | -79.62 | -9.95 | -16,014.00
GNK | -2,266 | 847.0000 | 19,193.02 | 0.00 | -9.95 | 19,183.07

As at the Close of Business on 10 Oct 2019 the portfolio looks like this:

EPIC | Company                  | Shares  | Cost (£)     | Price (p)   | Value (£)    | Value (%) | P/L (£)     | Div Rec'd (£) | Ex-Div (£) | Total Div (£) | Overall (£) | Yield (%) * | Year Div (£)
AV | Aviva | 4,200 | 17,168.46 | 381.2000 | 16,010.40 | 6.10% | -1,158.06 | 1,153.67 | 0.00 | 1,153.67 | -4.39 | 7.94% | 1,270.50
BA | BAE Systems | 3,043 | 14,995.20 | 553.2000 | 16,833.88 | 6.41% | 1,838.68 | 401.67 | 0.00 | 401.67 | 2,240.35 | 4.09% | 687.71
BATS | British American Tobacco | 142 | 4,017.01 | 2,810.0000 | 3,990.20 | 1.52% | -26.81 | 0.00 | 0.00 | 0.00 | -26.81 | 7.22% | 288.26
BHP | BHP Group | 838 | 14,992.51 | 1,696.6000 | 14,217.51 | 5.41% | -775.00 | 528.19 | 0.00 | 528.19 | -246.81 | 6.37% | 905.46
BLND | British Land Company | 1,273 | 7,494.24 | 548.0000 | 6,976.04 | 2.66% | -518.20 | 98.65 | 101.61 | 200.26 | -317.94 | 5.83% | 406.46
BP | BP | 1,347 | 7,496.10 | 502.0000 | 6,761.94 | 2.57% | -734.16 | 221.08 | 0.00 | 221.08 | -513.08 | 6.64% | 448.64
CCL | Carnival Corporation | 384 | 14,979.79 | 3,146.0000 | 12,080.64 | 4.60% | -2,899.15 | 312.16 | 0.00 | 312.16 | -2,586.99 | 5.16% | 623.92
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,712.0000 | 16,109.92 | 6.13% | 1,110.55 | 357.58 | 0.00 | 357.58 | 1,468.13 | 4.67% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 598.0000 | 14,501.50 | 5.52% | -496.77 | 384.85 | 197.00 | 581.85 | 85.08 | 6.93% | 1,004.75
IBST | Ibstock | 5,849 | 14,999.47 | 231.6000 | 13,546.28 | 5.16% | -1,453.19 | 859.79 | 0.00 | 859.79 | -593.40 | 4.19% | 567.35
IGG | IG Group Holdings | 2,762 | 14,999.32 | 576.6000 | 15,925.69 | 6.06% | 926.37 | 0.00 | 835.22 | 835.22 | 1,761.59 | 7.49% | 1,193.18
IMB | Imperial Brands | 719 | 18,148.31 | 1,872.6000 | 13,463.99 | 5.13% | -4,684.32 | 402.57 | 0.00 | 402.57 | -4,281.75 | 11.03% | 1,485.16
ITV | ITV | 11,652 | 14,999.08 | 121.7500 | 14,186.31 | 5.40% | -812.77 | 629.20 | 0.00 | 629.20 | -183.57 | 6.57% | 932.16
LAND | Land Securities Group | 818 | 7,499.19 | 839.2000 | 6,864.66 | 2.61% | -634.53 | 190.17 | 0.00 | 190.17 | -444.36 | 5.54% | 379.96
PNN | Pennon Group | 1,975 | 16,014.00 | 821.4000 | 16,222.65 | 6.18% | 208.65 | 0.00 | 0.00 | 0.00 | 208.65 | 5.00% | 810.93
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,304.0000 | 7,119.36 | 2.71% | -362.30 | 231.68 | 0.00 | 231.68 | -130.62 | 6.63% | 471.94
SLA | Standard Life Aberdeen | 6,389 | 17,397.08 | 272.3000 | 17,397.25 | 6.62% | 0.17 | 1,188.63 | 0.00 | 1,188.63 | 1,188.80 | 7.93% | 1,380.02
SMDS | DS Smith | 4,310 | 14,997.11 | 341.2000 | 14,705.72 | 5.60% | -291.39 | 224.12 | 474.10 | 698.22 | 406.83 | 4.75% | 698.22
VOD | Vodafone Group | 10,077 | 14,998.48 | 162.8200 | 16,407.37 | 6.25% | 1,408.89 | 375.37 | 0.00 | 375.37 | 1,784.26 | 4.93% | 808.66
WPP | WPP | 1,780 | 14,997.55 | 963.8000 | 17,155.64 | 6.53% | 2,158.09 | 663.94 | 404.06 | 1,068.00 | 3,226.09 | 6.23% | 1,068.00
| | | | | | | | | | | | |
| Sub Total: | | £252,674.65 | | £260,476.95 | 99.16% | -£7,195.25 | £8,223.32 | £2,011.99 | £10,235.31 | £3,040.06 | 6.21% | £16,184.08
| Cash Bal: | | | | £187.13 | 0.07% | | | | | | |
| Ex-Dividend: | | | | £2,011.99 | 0.77% | | | | | | |
| Cash Out: | | | | £0.00 | 0.00% | | | | | | |
| | | | | | | | | | | | |
| Total: | | £252,674.65 | | £262,676.07 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | £0.00 | | | | | | | |
| Dividends: | | | | £8,776.22 | | | | | | | |
| Realised P/L: | | | | £4,188.29 | GNK | | | | | | |
| Un-Realised P/L: | | | | -£5,193.21 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £262,676.07 | 5.81% | | | | | | |

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

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

Business     | Cost (£)   | Value (£)  | Value (%) | P/L (£)    | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Tobacco | 22,165.32 | 17,454.19 | 6.64% | -4,711.13 | 402.57 | 0.00 | 402.57 | -4,308.56 | 10.16% | 1,773.42
Fund Manager | 17,397.08 | 17,397.25 | 6.62% | 0.17 | 1,188.63 | 0.00 | 1,188.63 | 1,188.80 | 7.93% | 1,380.02
Insurance | 17,168.46 | 16,010.40 | 6.10% | -1,158.06 | 1,153.67 | 0.00 | 1,153.67 | -4.39 | 7.94% | 1,270.50
Gambling | 14,999.32 | 15,925.69 | 6.06% | 926.37 | 0.00 | 835.22 | 835.22 | 1,761.59 | 7.49% | 1,193.18
Banks | 14,998.27 | 14,501.50 | 5.52% | -496.77 | 384.85 | 197.00 | 581.85 | 85.08 | 6.93% | 1,004.75
Television | 14,999.08 | 14,186.31 | 5.40% | -812.77 | 629.20 | 0.00 | 629.20 | -183.57 | 6.57% | 932.16
Oil | 14,977.76 | 13,881.30 | 5.28% | -1,096.46 | 452.76 | 0.00 | 452.76 | -643.70 | 6.63% | 920.58
Mining | 14,992.51 | 14,217.51 | 5.41% | -775.00 | 528.19 | 0.00 | 528.19 | -246.81 | 6.37% | 905.46
Advertising | 14,997.55 | 17,155.64 | 6.53% | 2,158.09 | 663.94 | 404.06 | 1,068.00 | 3,226.09 | 6.23% | 1,068.00
Property | 14,993.43 | 13,840.70 | 5.27% | -1,152.73 | 288.82 | 101.61 | 390.43 | -762.30 | 5.68% | 786.42
Cruise Ships | 14,979.79 | 12,080.64 | 4.60% | -2,899.15 | 312.16 | 0.00 | 312.16 | -2,586.99 | 5.16% | 623.92
Water | 16,014.00 | 16,222.65 | 6.18% | 208.65 | 0.00 | 0.00 | 0.00 | 208.65 | 5.00% | 810.93
Telecom | 14,998.48 | 16,407.37 | 6.25% | 1,408.89 | 375.37 | 0.00 | 375.37 | 1,784.26 | 4.93% | 808.66
Packaging | 14,997.11 | 14,705.72 | 5.60% | -291.39 | 224.12 | 474.10 | 698.22 | 406.83 | 4.75% | 698.22
Pharma | 14,999.37 | 16,109.92 | 6.13% | 1,110.55 | 357.58 | 0.00 | 357.58 | 1,468.13 | 4.67% | 752.80
Bricks | 14,999.47 | 13,546.28 | 5.16% | -1,453.19 | 859.79 | 0.00 | 859.79 | -593.40 | 4.19% | 567.35
Weapons | 14,995.20 | 16,833.88 | 6.41% | 1,838.68 | 401.67 | 0.00 | 401.67 | 2,240.35 | 4.09% | 687.71

Transactions and Top-Ups since initial portfolio set up

Date      | EPIC | Shares  | Price (p)   | Cost (£)    | Stamp (£) | Fee (£) | Total (£)  
10-Oct-19 | BATS | 142 | 2,813.7500 | -3,995.53 | -19.98 | -1.50 | -4,017.01
10-Oct-19 | SLA | 886 | 269.3000 | -2,386.00 | -11.93 | -1.50 | -2,399.43
09-Oct-19 | PNN | 1,975 | 806.3000 | -15,924.43 | -79.62 | -9.95 | -16,014.00
09-Oct-19 | GNK | -2,266 | 847.0000 | 19,193.02 | 0.00 | -9.95 | 19,183.07
12-Aug-19 | AV | 563 | 383.6500 | -2,159.95 | -10.80 | -1.50 | -2,172.25
10-Jun-19 | IMB | 151 | 2,081.0000 | -3,142.31 | -15.71 | -1.50 | -3,159.52

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   | Top-Up? | To Date   | Div Rec'd
11-Nov-19 | 2,002.12 | Y | 11-Nov-19 | 1,993.78
10-Dec-19 | 785.99 | N | 10-Dec-19 | 785.99
10-Jan-20 | 1,963.46 | N | 10-Jan-20 | 1,177.47
10-Feb-20 | 2,572.01 | Y | 10-Feb-20 | 608.55
10-Mar-20 | 357.95 | N | 10-Mar-20 | 357.95
14-Apr-20 | 2,614.81 | Y | 14-Apr-20 | 2,256.86
11-May-20 | 325.73 | N | 11-May-20 | 325.73
10-Jun-20 | 3,593.96 | Y | 10-Jun-20 | 3,268.23
10-Jul-20 | 1,471.96 | N | 10-Jul-20 | 1,471.96
10-Aug-20 | 2,221.43 | Y | 10-Aug-20 | 749.47
10-Sep-20 | 629.40 | N | 10-Sep-20 | 629.40
12-Oct-20 | 3,294.66 | Y | 12-Oct-20 | 2,665.26

The next Portfolio update will therefore be soon after 31 October 2019 with a Top-Up being made on the 11 November 2019

Enjoy!


Ian

IanTHughes
Lemon Slice
Posts: 942
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 438 times
Been thanked: 422 times

PYAD HYP 2019_04 REINVEST – Year 1 - November Top Up

#262631

Postby IanTHughes » November 6th, 2019, 5:28 pm

Update 6 November 2019

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 (£)    | Div Rec'd (£) | Ex-Div (£) | Total Div (£) | Overall (£) | Yield (%) * | Year Div (£)
IMB | Imperial Brands | 719 | 18,148.31 | 1,791.0000 | 12,877.29 | 4.63% | -5,271.02 | 402.57 | 0.00 | 402.57 | -4,868.45 | 11.53% | 1,485.23
BATS | British American Tobacco | 142 | 4,017.01 | 2,842.0000 | 4,035.64 | 1.45% | 18.63 | 0.00 | 0.00 | 0.00 | 18.63 | 7.14% | 288.26
AV | Aviva | 4,200 | 17,168.46 | 428.7000 | 18,005.40 | 6.47% | 836.94 | 1,153.67 | 0.00 | 1,153.67 | 1,990.61 | 7.06% | 1,270.50
SLA | Standard Life Aberdeen | 6,389 | 17,397.08 | 307.6000 | 19,652.56 | 7.06% | 2,255.48 | 1,188.63 | 0.00 | 1,188.63 | 3,444.11 | 7.02% | 1,380.02
IGG | IG Group Holdings | 2,762 | 14,999.32 | 654.4000 | 18,074.53 | 6.49% | 3,075.21 | 835.22 | 0.00 | 835.22 | 3,910.43 | 6.60% | 1,193.18
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 598.1000 | 14,503.93 | 5.21% | -494.34 | 384.85 | 187.57 | 572.42 | 78.08 | 6.60% | 956.64
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,337.0000 | 7,221.33 | 2.59% | -260.33 | 231.68 | 0.00 | 231.68 | -28.65 | 6.22% | 449.35
BP | BP | 1,347 | 7,496.10 | 514.1000 | 6,924.93 | 2.49% | -571.17 | 221.08 | 0.00 | 221.08 | -350.09 | 6.17% | 427.16
WPP | WPP | 1,780 | 14,997.55 | 994.0000 | 17,693.20 | 6.36% | 2,695.65 | 1,068.00 | 0.00 | 1,068.00 | 3,763.65 | 6.04% | 1,068.00
ITV | ITV | 11,652 | 14,999.08 | 133.7500 | 15,584.55 | 5.60% | 585.47 | 629.20 | 302.95 | 932.15 | 1,517.62 | 5.98% | 932.16
BHP | BHP Group | 838 | 14,992.51 | 1,763.0000 | 14,773.94 | 5.31% | -218.57 | 528.19 | 0.00 | 528.19 | 309.62 | 5.84% | 862.11
BLND | British Land Company | 1,273 | 7,494.24 | 592.6000 | 7,543.80 | 2.71% | 49.56 | 98.65 | 101.61 | 200.26 | 249.82 | 5.39% | 406.46
LAND | Land Securities Group | 818 | 7,499.19 | 907.8000 | 7,425.80 | 2.67% | -73.39 | 190.17 | 0.00 | 190.17 | 116.78 | 5.12% | 379.96
CCL | Carnival Corporation | 384 | 14,979.79 | 3,234.0000 | 12,418.56 | 4.46% | -2,561.23 | 312.16 | 0.00 | 312.16 | -2,249.07 | 4.78% | 594.04
VOD | Vodafone Group | 10,077 | 14,998.48 | 162.4400 | 16,369.08 | 5.88% | 1,370.60 | 375.37 | 0.00 | 375.37 | 1,745.97 | 4.78% | 783.05
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,722.2000 | 16,205.90 | 5.82% | 1,206.53 | 357.58 | 0.00 | 357.58 | 1,564.11 | 4.65% | 752.80
PNN | Pennon Group | 1,975 | 16,014.00 | 888.8000 | 17,553.80 | 6.31% | 1,539.80 | 0.00 | 0.00 | 0.00 | 1,539.80 | 4.62% | 810.93
SMDS | DS Smith | 4,310 | 14,997.11 | 380.4000 | 16,395.24 | 5.89% | 1,398.13 | 698.22 | 0.00 | 698.22 | 2,096.35 | 4.26% | 698.22
IBST | Ibstock | 5,849 | 14,999.47 | 249.6000 | 14,599.10 | 5.24% | -400.37 | 859.79 | 0.00 | 859.79 | 459.42 | 3.89% | 567.35
BA | BAE Systems | 3,043 | 14,995.20 | 583.0000 | 17,740.69 | 6.37% | 2,745.49 | 401.67 | 286.04 | 687.71 | 3,433.20 | 3.88% | 687.71
| | | | | | | | | | | | |
| Sub Total: | | £252,677.00 | | £275,599.27 | 99.00% | £7,927.07 | £9,936.70 | £878.17 | £10,814.87 | £18,741.94 | 5.80% | £15,993.13
| Cash Bal: | | | | £1,910.46 | 0.69% | | | | | | |
| Ex-Dividend: | | | | £878.17 | 0.32% | | | | | | |
| | | | | | | | | | | | |
| Total: | | £252,677.00 | | £278,387.90 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | £0.00 | | | | | | | |
| Dividends Recieved: | | | | £10,489.60 | | | | | | | |
| Ex-Dividend: | | | | £878.17 | | | | | | | |
| Realised P/L: | | | GNK | £4,188.29 | | | | | | | |
| Un-Realised P/L: | | | | £7,927.07 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £278,387.90 | 15.66% | | | | | | |

With the breakdown by Business as follows:

Business     | Cost (£)   | Value (£)  | Value (%) | P/L (£)    | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Tobacco | 22,165.32 | 16,912.93 | 6.08% | -5,252.39 | 402.57 | 0.00 | 402.57 | -4,849.82 | 10.49% | 1,773.49
Insurance | 17,168.46 | 18,005.40 | 6.47% | 836.94 | 1,153.67 | 0.00 | 1,153.67 | 1,990.61 | 7.06% | 1,270.50
Fund Manager | 17,397.08 | 19,652.56 | 7.06% | 2,255.48 | 1,188.63 | 0.00 | 1,188.63 | 3,444.11 | 7.02% | 1,380.02
Gambling | 14,999.32 | 18,074.53 | 6.49% | 3,075.21 | 835.22 | 0.00 | 835.22 | 3,910.43 | 6.60% | 1,193.18
Banks | 14,998.27 | 14,503.93 | 5.21% | -494.34 | 384.85 | 187.57 | 572.42 | 78.08 | 6.60% | 956.64
Oil | 14,977.76 | 14,146.26 | 5.08% | -831.50 | 452.76 | 0.00 | 452.76 | -378.74 | 6.20% | 876.51
Advertising | 14,997.55 | 17,693.20 | 6.36% | 2,695.65 | 1,068.00 | 0.00 | 1,068.00 | 3,763.65 | 6.04% | 1,068.00
Television | 14,999.08 | 15,584.55 | 5.60% | 585.47 | 629.20 | 302.95 | 932.15 | 1,517.62 | 5.98% | 932.16
Mining | 14,992.51 | 14,773.94 | 5.31% | -218.57 | 528.19 | 0.00 | 528.19 | 309.62 | 5.84% | 862.11
Property | 14,993.43 | 14,969.60 | 5.38% | -23.83 | 288.82 | 101.61 | 390.43 | 366.60 | 5.25% | 786.42
Telecom | 14,998.48 | 16,369.08 | 5.88% | 1,370.60 | 375.37 | 0.00 | 375.37 | 1,745.97 | 4.78% | 783.05
Cruise Ships | 14,979.79 | 12,418.56 | 4.46% | -2,561.23 | 312.16 | 0.00 | 312.16 | -2,249.07 | 4.78% | 594.04
Pharma | 14,999.37 | 16,205.90 | 5.82% | 1,206.53 | 357.58 | 0.00 | 357.58 | 1,564.11 | 4.65% | 752.80
Water | 16,014.00 | 17,553.80 | 6.31% | 1,539.80 | 0.00 | 0.00 | 0.00 | 1,539.80 | 4.62% | 810.93
Packaging | 14,997.11 | 16,395.24 | 5.89% | 1,398.13 | 698.22 | 0.00 | 698.22 | 2,096.35 | 4.26% | 698.22
Bricks | 14,999.47 | 14,599.10 | 5.24% | -400.37 | 859.79 | 0.00 | 859.79 | 459.42 | 3.89% | 567.35
Weapons | 14,995.20 | 17,740.69 | 6.37% | 2,745.49 | 401.67 | 286.04 | 687.71 | 3,433.20 | 3.88% | 687.71

(*) - 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-Ups on 11 Nov 2019

As at the close of business on 8 November 2019 the amount available for re-investment will be £2,012.07 and this amount will be used to top-up one Business Sector holding on Monday 11 November 2019.

From the point of view of the “Highest Yield” the following candidates were considered:

Top-Up       |      |                          |             |          |                                                                      
Business | EPIC | Company | Yield (%) * | Decision | Comments

Tobacco | IMB | Imperial Brands | 11.53% | Rejected | Dividend Policy of 10% annual increase ditched. Recent drop in Profits/Earnings
Tobacco | BATS | British American Tobacco | 7.14% | Selected | Resultant Sector Value Concentration (6.75%)
Insurance | AV | Aviva | 7.06% | Rejected | Resultant Sector Value Concentration (7.14%) too high
Fund Manager | SLA | Standard Life Aberdeen | 7.02% | Rejected | Resultant Sector Value Concentration (7.72%) too high
Gambling | IGG | IG Group Holdings | 6.60% | Rejected | Resultant Sector Value Concentration (7.16%) too high
Banks | HSBA | HSBC Holdings | 6.60% | Selected | Latest Quarterly reports drop in earnings / profits.
Oil | RDSB | Royal Dutch Shell | 6.22% | Rejected | Latest Quarterly reports drop in earnings / profits. Weaker Oil Price
Oil | BP | BP | 6.17% | Rejected | Latest Quarterly reports drop in earnings / profits. Weaker Oil Price
Advertising | WPP | WPP | 6.04% | Rejected | Resultant Sector Value Concentration (7.02%) too high
Television | ITV | ITV | 5.98% | Selected | Resultant Sector Value Concentration (6.27%)
Mining | BHP | BHP Group | 5.84% | Selected | Resultant Sector Value Concentration (5.98%)
Property | BLND | British Land Company | 5.39% | Selected | Resultant Sector Value Concentration (6.05%)
Property | LAND | Land Securities Group | 5.12% | Selected | Resultant Sector Value Concentration (6.05%)
Cruise Ships | CCL | Carnival Corporation | 4.78% | Selected | Resultant Sector Value Concentration (5.14%)


There being no higher yield available from a suitable new holding, the selection is therefore:

Tobacco – British American Tobacco (BATS) – Yield 7.14%

The Value Concentration after purchase (6.75%) will leave the Tobacco holding as the second highest by that measure, but not so far ahead of a group of other holdings and is also split between two individual holdings.

The details of the planned top-up will be determined by the mid-price on 11 November 2019. I will post an update when the details of the deal are known.

Enjoy!


Ian

Gengulphus
Lemon Quarter
Posts: 3101
Joined: November 4th, 2016, 1:17 am
Been thanked: 1606 times

Re: PYAD HYP 2019_04 REINVEST – Year 1

#263090

Postby Gengulphus » November 8th, 2019, 8:04 pm

As a minor, purely administrative suggestion, I think it might be worth reducing the title of the "Transactions and Top-Ups since initial portfolio set up" section of your standard reporting format to just "Transactions since initial portfolio set up" and adding a "Notes" column to the table, to provide a brief reminder of the reason for the transaction. The entries will currently be one "Due to imminent takeover", one "Replacement for GNK" and the rest "Routine top-up", and I doubt that anyone currently needs to be reminded of those reasons - but in say five or ten years time having the quick reminders of the reasons will I think be quite helpful for anyone wanting to know how the then-current state of the portfolio arose.

Gengulphus

IanTHughes
Lemon Slice
Posts: 942
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 438 times
Been thanked: 422 times

Re: PYAD HYP 2019_04 REINVEST – Year 1

#263538

Postby IanTHughes » November 11th, 2019, 5:15 pm

Update 11 November 2019

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 https: viewtopic.php?p=262631#p262631 has now been made as follows:

Date      | Business | EPIC | Shares | Price (p)   | Total (£)  | Yield (%)
11-Nov-19 | Tobacco | BATS | 69 | 2,880.0000 | -1,998.64 | 7.05%

As at the Close of Business on 11 Nov 2019 the portfolio looks like this:

EPIC | Company                  | Shares  | Cost (£)     | Price (p)   | Value (£)    | Value (%) | P/L (£)    | Div Rec'd (£) | Ex-Div (£) | Total Div (£) | Overall (£) | Yield (%) * | Year Div (£)
IMB | Imperial Brands | 719 | 18,148.31 | 1,794.8000 | 12,904.61 | 4.64% | -5,243.70 | 402.57 | 0.00 | 402.57 | -4,841.13 | 11.51% | 1,485.23
BATS | British American Tobacco | 211 | 6,015.65 | 2,910.5000 | 6,141.16 | 2.21% | 125.51 | 0.00 | 0.00 | 0.00 | 125.51 | 6.97% | 428.33
AV | Aviva | 4,200 | 17,168.46 | 435.1000 | 18,274.20 | 6.58% | 1,105.74 | 1,153.67 | 0.00 | 1,153.67 | 2,259.41 | 6.95% | 1,270.50
SLA | Standard Life Aberdeen | 6,389 | 17,397.08 | 310.7000 | 19,850.62 | 7.14% | 2,453.54 | 1,188.63 | 0.00 | 1,188.63 | 3,642.17 | 6.95% | 1,380.02
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 586.6000 | 14,225.05 | 5.12% | -773.22 | 384.85 | 189.14 | 573.99 | -199.23 | 6.79% | 966.57
IGG | IG Group Holdings | 2,762 | 14,999.32 | 660.0000 | 18,229.20 | 6.56% | 3,229.88 | 835.22 | 0.00 | 835.22 | 4,065.10 | 6.55% | 1,193.18
BP | BP | 1,347 | 7,496.10 | 506.7000 | 6,825.25 | 2.46% | -670.85 | 221.08 | 107.95 | 329.03 | -341.82 | 6.33% | 431.80
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,323.0000 | 7,178.07 | 2.58% | -303.59 | 231.68 | 0.00 | 231.68 | -71.91 | 6.33% | 454.23
BHP | BHP Group | 838 | 14,992.51 | 1,692.4000 | 14,182.31 | 5.10% | -810.20 | 528.19 | 0.00 | 528.19 | -282.01 | 6.14% | 871.48
WPP | WPP | 1,780 | 14,997.55 | 1,005.5000 | 17,897.90 | 6.44% | 2,900.35 | 1,068.00 | 0.00 | 1,068.00 | 3,968.35 | 5.97% | 1,068.00
ITV | ITV | 11,652 | 14,999.08 | 135.9500 | 15,840.89 | 5.70% | 841.81 | 629.20 | 302.95 | 932.15 | 1,773.96 | 5.88% | 932.16
BLND | British Land Company | 1,273 | 7,494.24 | 573.6000 | 7,301.93 | 2.63% | -192.31 | 200.26 | 0.00 | 200.26 | 7.95 | 5.57% | 406.46
LAND | Land Securities Group | 818 | 7,499.19 | 892.0000 | 7,296.56 | 2.63% | -202.63 | 190.17 | 0.00 | 190.17 | -12.46 | 5.21% | 379.96
VOD | Vodafone Group | 10,077 | 14,998.48 | 160.2800 | 16,151.42 | 5.81% | 1,152.94 | 375.37 | 0.00 | 375.37 | 1,528.31 | 4.84% | 781.44
CCL | Carnival Corporation | 384 | 14,979.79 | 3,238.0000 | 12,433.92 | 4.47% | -2,545.87 | 311.38 | 0.00 | 311.38 | -2,234.49 | 4.83% | 600.48
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,718.2000 | 16,168.26 | 5.82% | 1,168.89 | 357.58 | 0.00 | 357.58 | 1,526.47 | 4.66% | 752.80
PNN | Pennon Group | 1,975 | 16,014.00 | 891.8000 | 17,613.05 | 6.34% | 1,599.05 | 0.00 | 0.00 | 0.00 | 1,599.05 | 4.60% | 810.93
SMDS | DS Smith | 4,310 | 14,997.11 | 376.7000 | 16,235.77 | 5.84% | 1,238.66 | 698.22 | 0.00 | 698.22 | 1,936.88 | 4.30% | 698.22
BA | BAE Systems | 3,043 | 14,995.20 | 571.6000 | 17,393.79 | 6.26% | 2,398.59 | 401.67 | 286.04 | 687.71 | 3,086.30 | 3.95% | 687.71
IBST | Ibstock | 5,849 | 14,999.47 | 253.8000 | 14,844.76 | 5.34% | -154.71 | 859.79 | 0.00 | 859.79 | 705.08 | 3.82% | 567.35
| | | | | | | | | | | | |
| Sub Total: | | £254,671.37 | | £276,988.72 | 99.68% | £7,317.88 | £10,037.53 | £886.08 | £10,923.61 | £18,241.49 | 5.84% | £16,166.85
| Cash Bal: | | | | £12.65 | 0.01% | | | | | | |
| Ex-Dividend: | | | | £886.08 | 0.32% | | | | | | |
| | | | | | | | | | | | |
| Total: | | £254,671.37 | | £277,887.45 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | £0.00 | | | | | | | |
| Dividends Recieved: | | | | £10,590.43 | | | | | | | |
| Ex-Dividend: | | | | £886.08 | | | | | | | |
| Realised P/L: | | | | £4,188.29 | Greene King PLC
| Un-Realised P/L: | | | | £7,317.88 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £277,887.45 | 14.96% | | | | | | |


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

Business     | Cost (£)   | Value (£)  | Value (%) | P/L (£)    | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Tobacco | 24,163.96 | 19,045.77 | 6.85% | -5,118.19 | 402.57 | 0.00 | 402.57 | -4,715.62 | 10.05% | 1,913.56
Insurance | 17,168.46 | 18,274.20 | 6.58% | 1,105.74 | 1,153.67 | 0.00 | 1,153.67 | 2,259.41 | 6.95% | 1,270.50
Fund Manager | 17,397.08 | 19,850.62 | 7.14% | 2,453.54 | 1,188.63 | 0.00 | 1,188.63 | 3,642.17 | 6.95% | 1,380.02
Banks | 14,998.27 | 14,225.05 | 5.12% | -773.22 | 384.85 | 189.14 | 573.99 | -199.23 | 6.79% | 966.57
Gambling | 14,999.32 | 18,229.20 | 6.56% | 3,229.88 | 835.22 | 0.00 | 835.22 | 4,065.10 | 6.55% | 1,193.18
Oil | 14,977.76 | 14,003.32 | 5.04% | -974.44 | 452.76 | 107.95 | 560.71 | -413.73 | 6.33% | 886.03
Mining | 14,992.51 | 14,182.31 | 5.10% | -810.20 | 528.19 | 0.00 | 528.19 | -282.01 | 6.14% | 871.48
Advertising | 14,997.55 | 17,897.90 | 6.44% | 2,900.35 | 1,068.00 | 0.00 | 1,068.00 | 3,968.35 | 5.97% | 1,068.00
Television | 14,999.08 | 15,840.89 | 5.70% | 841.81 | 629.20 | 302.95 | 932.15 | 1,773.96 | 5.88% | 932.16
Property | 14,993.43 | 14,598.49 | 5.25% | -394.94 | 390.43 | 0.00 | 390.43 | -4.51 | 5.39% | 786.42
Telecom | 14,998.48 | 16,151.42 | 5.81% | 1,152.94 | 375.37 | 0.00 | 375.37 | 1,528.31 | 4.84% | 781.44
Cruise Ships | 14,979.79 | 12,433.92 | 4.47% | -2,545.87 | 311.38 | 0.00 | 311.38 | -2,234.49 | 4.83% | 600.48
Pharma | 14,999.37 | 16,168.26 | 5.82% | 1,168.89 | 357.58 | 0.00 | 357.58 | 1,526.47 | 4.66% | 752.80
Water | 16,014.00 | 17,613.05 | 6.34% | 1,599.05 | 0.00 | 0.00 | 0.00 | 1,599.05 | 4.60% | 810.93
Packaging | 14,997.11 | 16,235.77 | 5.84% | 1,238.66 | 698.22 | 0.00 | 698.22 | 1,936.88 | 4.30% | 698.22
Weapons | 14,995.20 | 17,393.79 | 6.26% | 2,398.59 | 401.67 | 286.04 | 687.71 | 3,086.30 | 3.95% | 687.71
Bricks | 14,999.47 | 14,844.76 | 5.34% | -154.71 | 859.79 | 0.00 | 859.79 | 705.08 | 3.82% | 567.35


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

Transactions and Top-Ups since initial portfolio set up

Date      | Business       | EPIC | Shares  | Price (p)   | Total (£)   | Yield (%) | Comment                       
11-Nov-19 | Tobacco | BATS | 69 | 2,880.0000 | -1,998.64 | 7.05% | Routine Top-Up
10-Oct-19 | Fund Manager | SLA | 886 | 269.3000 | -2,399.43 | 8.02% | Routine Top-Up
10-Oct-19 | Tobacco | BATS | 142 | 2,813.7500 | -4,017.01 | 7.21% | Replace GNK
09-Oct-19 | Water | PNN | 1,975 | 806.3000 | -16,014.00 | 5.09% | Replace GNK
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 Top-Up
10-Jun-19 | Tobacco | IMB | 151 | 2,081.0000 | -3,159.52 | 9.30% | Routine Top-Up

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   | Top-Up? | To Date   | Div Rec'd
10-Dec-19 | 790.78 | N | 10-Dec-19 | 778.13
10-Jan-20 | 1,953.75 | N | 10-Jan-20 | 1,162.97
10-Feb-20 | 2,582.68 | Y | 10-Feb-20 | 628.93
10-Mar-20 | 357.95 | N | 10-Mar-20 | 357.95
14-Apr-20 | 2,172.60 | Y | 14-Apr-20 | 1,814.65
11-May-20 | 723.92 | N | 11-May-20 | 723.92
10-Jun-20 | 4,027.17 | Y | 10-Jun-20 | 3,303.25
10-Jul-20 | 1,450.07 | N | 10-Jul-20 | 1,450.07
10-Aug-20 | 2,186.95 | Y | 10-Aug-20 | 736.88
10-Sep-20 | 664.42 | N | 10-Sep-20 | 664.42
12-Oct-20 | 3,287.86 | Y | 12-Oct-20 | 2,623.44
10-Nov-20 | 1,814.99 | N | 10-Nov-20 | 1,814.99


The next Portfolio update will therefore be soon after 31 January 2020 with a Top-Up being made on the 10 February 2020.

Enjoy!


Ian


Return to “High Yield Portfolios (HYP) - Practical”

Who is online

Users browsing this forum: No registered users and 7 guests