PYAD HYP 2019_04 REINVEST – Year 1

IanTHughes · #225860

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

SuperCally · #226471

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

Vinny

IanTHughes · #228475

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 · #241371

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 · #241899

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 · #241915

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 · #244045

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 · #256090

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 · #256989

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 · #262631

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 · #263090

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 · #263538

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

IanTHughes · #283053

PYAD HYP 2019_04 REINVEST – Year 1

Update 8 February 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 (£)
IMB  | Imperial Brands          |    719  | 18,148.31  | 1,832.2000  |   13,173.52  |     4.60% |  -4,974.79  |      0.00  |       920.25  |    920.25  |  -4,054.54  |      11.27% |    1,485.23 
AV   | Aviva                    |  4,200  | 17,168.46  |   407.8000  |   17,127.60  |     5.98% |     -40.86  |      0.00  |     1,153.67  |  1,153.67  |   1,112.81  |       7.42% |    1,270.50 
RDSB | Royal Dutch Shell        |    309  |  7,481.66  | 1,986.0000  |    6,136.74  |     2.14% |  -1,344.92  |      0.00  |       342.08  |    342.08  |  -1,002.84  |       7.18% |      440.32 
SLA  | Standard Life Aberdeen   |  6,389  | 17,397.08  |   317.1000  |   20,259.52  |     7.08% |   2,862.44  |      0.00  |     1,188.63  |  1,188.63  |   4,051.07  |       6.81% |    1,380.02 
BP   | BP                       |  1,347  |  7,496.10  |   470.0000  |    6,330.90  |     2.21% |  -1,165.20  |      0.00  |       326.48  |    326.48  |    -838.72  |       6.77% |      428.80 
HSBA | HSBC Holdings            |  2,425  | 14,998.27  |   581.3000  |   14,096.53  |     4.92% |    -901.74  |      0.00  |       573.99  |    573.99  |    -327.75  |       6.65% |      937.42 
IGG  | IG Group Holdings        |  2,762  | 14,999.32  |   669.4000  |   18,488.83  |     6.46% |   3,489.51  |    357.95  |       835.22  |  1,193.17  |   4,682.68  |       6.45% |    1,193.18 
WPP  | WPP                      |  1,780  | 14,997.55  |   968.8000  |   17,244.64  |     6.02% |   2,247.09  |      0.00  |     1,068.00  |  1,068.00  |   3,315.09  |       6.19% |    1,068.00 
BHP  | BHP Group                |    838  | 14,992.51  | 1,673.6000  |   14,024.77  |     4.90% |    -967.74  |      0.00  |       528.19  |    528.19  |    -439.55  |       6.02% |      844.79 
ITV  | ITV                      | 11,652  | 14,999.08  |   134.6000  |   15,683.59  |     5.48% |     684.51  |      0.00  |       932.15  |    932.15  |   1,616.66  |       5.94% |      932.16 
BATS | British American Tobacco |    211  |  6,015.65  | 3,444.0000  |    7,266.84  |     2.54% |   1,251.19  |      0.00  |       107.08  |    107.08  |   1,358.27  |       5.89% |      428.33 
BLND | British Land Company     |  1,273  |  7,494.24  |   559.2000  |    7,118.62  |     2.49% |    -375.62  |      0.00  |       301.87  |    301.87  |     -73.75  |       5.71% |      406.46 
LAND | Land Securities Group    |    818  |  7,499.19  |   940.8000  |    7,695.74  |     2.69% |     196.55  |      0.00  |       285.05  |    285.05  |     481.60  |       4.94% |      379.96 
CCL  | Carnival Corporation     |    384  | 14,979.79  | 3,114.0000  |   11,957.76  |     4.18% |  -3,022.03  |      0.00  |       460.02  |    460.02  |  -2,562.01  |       4.87% |      582.12 
VOD  | Vodafone Group           | 10,077  | 14,998.48  |   153.0400  |   15,421.84  |     5.39% |     423.36  |      0.00  |       758.07  |    758.07  |   1,181.43  |       4.75% |      733.15 
GSK  | GlaxoSmithKline          |    941  | 14,999.37  | 1,700.2000  |   15,998.88  |     5.59% |     999.51  |      0.00  |       536.37  |    536.37  |   1,535.88  |       4.71% |      752.80 
SMDS | DS Smith                 |  4,310  | 14,997.11  |   366.7000  |   15,804.77  |     5.52% |     807.66  |      0.00  |       698.22  |    698.22  |   1,505.88  |       4.47% |      706.84 
PNN  | Pennon Group             |  1,975  | 16,014.00  | 1,117.5000  |   22,070.63  |     7.71% |   6,056.63  |    269.78  |         0.00  |    269.78  |   6,326.41  |       3.75% |      827.13 
BA   | BAE Systems              |  3,043  | 14,995.20  |   655.0000  |   19,931.65  |     6.96% |   4,936.45  |      0.00  |       687.71  |    687.71  |   5,624.16  |       3.45% |      687.71 
IBST | Ibstock                  |  5,849  | 14,999.47  |   295.4000  |   17,277.95  |     6.04% |   2,278.48  |      0.00  |       859.79  |    859.79  |   3,138.27  |       3.28% |      567.35 
     |                          |         |            |             |              |           |             |            |               |            |             |             |             
     | Sub Total:               |         |            |             | £283,111.32  |    98.90% | £13,440.48  |   £627.73  |               |            |             |       5.67% |  £16,052.27 
     | Cash Balance:            |         |            |             |   £2,532.29  |     0.89% |             |            |               |            |             |             |             
     | Ex-Dividend:             |         |            |             |     £627.73  |     0.22% |             |            |               |            |             |             |             
     |                          |         |            |             |              |           |             |            |               |            |             |             |             
     | Total:                   |         |            |             | £286,271.34  |           |             |            |               |            |             |             |             
     | From:                    |         |            |             |              |           |             |            |               |            |             |             |             
     | Cash In:                 |         |            |             | £254,904.77  |           |             |            |               |            |             |             |             
     | LESS Cash Out:           |         |            |             |       £0.00  |           |             |            |               |            |             |             |             
     | Dividends Received:      |         |            |             |  £13,110.07  |           |             |            |               |            |             |             |             
     | Ex-Dividend:             |         |            |             |     £627.73  |           |             |            |               |            |             |             |             
     | Realised P/L:            |         |            | GNK         |   £4,188.29  |           |             |            |               |            |             |             |             
     | Un-Realised P/L:         |         |            |             |  £13,440.48  |           |             |            |               |            |             |             |             
     |                          |         |            |             |              | XIRR      |             |            |               |            |             |             |             
     | Total:                   |         |            |             | £286,271.34  |    14.44% |             |            |               |            |             |             |

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  | 22,070.63  |     7.71% |  6,056.63  |    269.78  |         0.00  |       269.78  |   6,326.41  |       3.75% |      827.13 
Tobacco      | 24,163.96  | 20,440.36  |     7.14% | -3,723.60  |      0.00  |     1,027.33  |     1,027.33  |  -2,696.27  |       9.36% |    1,913.56 
Fund Manager | 17,397.08  | 20,259.52  |     7.08% |  2,862.44  |      0.00  |     1,188.63  |     1,188.63  |   4,051.07  |       6.81% |    1,380.02 
Weapons      | 14,995.20  | 19,931.65  |     6.96% |  4,936.45  |      0.00  |       687.71  |       687.71  |   5,624.16  |       3.45% |      687.71 
Gambling     | 14,999.32  | 18,488.83  |     6.46% |  3,489.51  |    357.95  |       835.22  |     1,193.17  |   4,682.68  |       6.45% |    1,193.18 
Bricks       | 14,999.47  | 17,277.95  |     6.04% |  2,278.48  |      0.00  |       859.79  |       859.79  |   3,138.27  |       3.28% |      567.35 
Advertising  | 14,997.55  | 17,244.64  |     6.02% |  2,247.09  |      0.00  |     1,068.00  |     1,068.00  |   3,315.09  |       6.19% |    1,068.00 
Insurance    | 17,168.46  | 17,127.60  |     5.98% |    -40.86  |      0.00  |     1,153.67  |     1,153.67  |   1,112.81  |       7.42% |    1,270.50 
Pharma       | 14,999.37  | 15,998.88  |     5.59% |    999.51  |      0.00  |       536.37  |       536.37  |   1,535.88  |       4.71% |      752.80 
Television   | 14,999.08  | 15,683.59  |     5.48% |    684.51  |      0.00  |       932.15  |       932.15  |   1,616.66  |       5.94% |      932.16 
Packaging    | 14,997.11  | 15,804.77  |     5.52% |    807.66  |      0.00  |       698.22  |       698.22  |   1,505.88  |       4.47% |      706.84 
Telecom      | 14,998.48  | 15,421.84  |     5.39% |    423.36  |      0.00  |       758.07  |       758.07  |   1,181.43  |       4.75% |      733.15 
Property     | 14,993.43  | 14,814.36  |     5.17% |   -179.07  |      0.00  |       586.92  |       586.92  |     407.85  |       5.31% |      786.42 
Mining       | 14,992.51  | 14,024.77  |     4.90% |   -967.74  |      0.00  |       528.19  |       528.19  |    -439.55  |       6.02% |      844.79 
Banks        | 14,998.27  | 14,096.53  |     4.92% |   -901.74  |      0.00  |       573.99  |       573.99  |    -327.75  |       6.65% |      937.42 
Oil          | 14,977.76  | 12,467.64  |     4.36% | -2,510.12  |      0.00  |       668.56  |       668.56  |  -1,841.56  |       6.97% |      869.12 
Cruise Ships | 14,979.79  | 11,957.76  |     4.18% | -3,022.03  |      0.00  |       460.02  |       460.02  |  -2,562.01  |       4.87% |      582.12

(*) - 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-Up on 10 Feb 2020

As at the close of business on Friday 7 February 2020, the amount available for re-investment is £2,532.29 and this amount will be used to top-up one Business Sector holding on Monday 10 February 2020.

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

Business     | EPIC | Company                | Yield (%) * | Decision | Comments                                             
Tobacco      | IMB  | Imperial Brands        |      11.27% | Rejected | Resultant Sector Value Concentration (7.95%) too high
Insurance    | AV   | Aviva                  |       7.42% | Selected | Resultant Sector Value Concentration (6.80%)         
Oil          | RDSB | Royal Dutch Shell      |       7.18% | Selected | Resultant Sector Value Concentration (5.19%)         
Fund Manager | SLA  | Standard Life Aberdeen |       6.81% | Rejected | Resultant Sector Value Concentration (7.89%) too high

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

Insurance – Aviva (AV) – Yield 7.42%

The Value Concentration after purchase (6.80%) will leave the Insurance Sector holding as the fifth 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 AV for my own HYP on Monday 10th February, the details of the planned top-up will be determined by the price that I receive on 10 February 2020. 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=283054#p283054

The intention is to keep this thread simply recording the history of the Portfolio

Enjoy!

Ian

IanTHughes · #283484

Update 11 February 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 https: viewtopic.php?p=283053#p283053 has now been made as follows:

Date      | Business  | EPIC | Shares | Price (p) | Total (£)  | Yield (%)
10-Feb-20 | Insurance | AV   |   620  | 405.9278  | -2,530.83  |     7.45%

As at the Close of Business on 10 Feb 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 (£)
IMB  | Imperial Brands          |    719  | 18,148.31  | 1,847.2000  |   13,281.37  |     4.65% |  -4,866.94  |      0.00  |       920.25  |    920.25  |  -3,946.69  |      11.18% |    1,485.23 
AV   | Aviva                    |  4,820  | 19,699.29  |   406.7000  |   19,602.94  |     6.86% |     -96.35  |      0.00  |     1,153.67  |  1,153.67  |   1,057.32  |       7.44% |    1,458.05 
RDSB | Royal Dutch Shell        |    309  |  7,481.66  | 1,964.8000  |    6,071.23  |     2.12% |  -1,410.43  |      0.00  |       342.08  |    342.08  |  -1,068.35  |       7.42% |      450.29 
BP   | BP                       |  1,347  |  7,496.10  |   464.6000  |    6,258.16  |     2.19% |  -1,237.94  |      0.00  |       326.48  |    326.48  |    -911.46  |       7.01% |      438.52 
HSBA | HSBC Holdings            |  2,425  | 14,998.27  |   578.3000  |   14,023.78  |     4.91% |    -974.49  |      0.00  |       573.99  |    573.99  |    -400.50  |       6.84% |      958.64 
SLA  | Standard Life Aberdeen   |  6,389  | 17,397.08  |   320.3000  |   20,463.97  |     7.16% |   3,066.89  |      0.00  |     1,188.63  |  1,188.63  |   4,255.52  |       6.74% |    1,380.02 
IGG  | IG Group Holdings        |  2,762  | 14,999.32  |   665.0000  |   18,367.30  |     6.43% |   3,367.98  |    357.95  |       835.22  |  1,193.17  |   4,561.15  |       6.50% |    1,193.18 
WPP  | WPP                      |  1,780  | 14,997.55  |   963.8000  |   17,155.64  |     6.00% |   2,158.09  |      0.00  |     1,068.00  |  1,068.00  |   3,226.09  |       6.23% |    1,068.00 
BHP  | BHP Group                |    838  | 14,992.51  | 1,657.0000  |   13,885.66  |     4.86% |  -1,106.85  |      0.00  |       528.19  |    528.19  |    -578.66  |       6.22% |      863.91 
ITV  | ITV                      | 11,652  | 14,999.08  |   135.0000  |   15,730.20  |     5.50% |     731.12  |      0.00  |       932.15  |    932.15  |   1,663.27  |       5.93% |      932.16 
BATS | British American Tobacco |    211  |  6,015.65  | 3,450.0000  |    7,279.50  |     2.55% |   1,263.85  |      0.00  |       107.08  |    107.08  |   1,370.93  |       5.88% |      428.33 
BLND | British Land Company     |  1,273  |  7,494.24  |   570.0000  |    7,256.10  |     2.54% |    -238.14  |      0.00  |       301.87  |    301.87  |      63.73  |       5.60% |      406.46 
CCL  | Carnival Corporation     |    384  | 14,979.79  | 3,044.0000  |   11,688.96  |     4.09% |  -3,290.83  |      0.00  |       460.02  |    460.02  |  -2,830.81  |       5.09% |      595.28 
VOD  | Vodafone Group           | 10,077  | 14,998.48  |   150.0000  |   15,115.50  |     5.29% |     117.02  |      0.00  |       758.07  |    758.07  |     875.09  |       4.90% |      740.42 
LAND | Land Securities Group    |    818  |  7,499.19  |   956.2000  |    7,821.72  |     2.74% |     322.53  |      0.00  |       285.05  |    285.05  |     607.58  |       4.86% |      379.96 
GSK  | GlaxoSmithKline          |    941  | 14,999.37  | 1,717.6000  |   16,162.62  |     5.66% |   1,163.25  |      0.00  |       536.37  |    536.37  |   1,699.62  |       4.66% |      752.80 
SMDS | DS Smith                 |  4,310  | 14,997.11  |   366.1000  |   15,778.91  |     5.52% |     781.80  |      0.00  |       698.22  |    698.22  |   1,480.02  |       4.48% |      706.84 
PNN  | Pennon Group             |  1,975  | 16,014.00  | 1,116.0000  |   22,041.00  |     7.71% |   6,027.00  |    269.78  |         0.00  |    269.78  |   6,296.78  |       3.75% |      827.13 
BA   | BAE Systems              |  3,043  | 14,995.20  |   648.6000  |   19,736.90  |     6.91% |   4,741.70  |      0.00  |       687.71  |    687.71  |   5,429.41  |       3.48% |      687.71 
IBST | Ibstock                  |  5,849  | 14,999.47  |   298.6000  |   17,465.11  |     6.11% |   2,465.64  |      0.00  |       859.79  |    859.79  |   3,325.43  |       3.25% |      567.35 
     |                          |         |            |             |              |           |             |            |               |            |             |             |             
     | Sub Total:               |         |            |             | £285,186.57  |    99.78% | £12,984.90  |   £627.73  |               |            |             |       5.72% |  £16,320.28 
     | Cash Balance:            |         |            |             |       £1.46  |     0.00% |             |            |               |            |             |             |             
     | Ex-Dividend:             |         |            |             |     £627.73  |     0.22% |             |            |               |            |             |             |             
     |                          |         |            |             |              |           |             |            |               |            |             |             |             
     | Total:                   |         |            |             | £285,815.76  |           |             |            |               |            |             |             |             
     | From:                    |         |            |             |              |           |             |            |               |            |             |             |             
     | Cash In:                 |         |            |             | £254,904.77  |           |             |            |               |            |             |             |             
     | LESS Cash Out:           |         |            |             |       £0.00  |           |             |            |               |            |             |             |             
     | Dividends Received:      |         |            |             |  £13,110.07  |           |             |            |               |            |             |             |             
     | Ex-Dividend:             |         |            |             |     £627.73  |           |             |            |               |            |             |             |             
     | Realised P/L:            |         |            | GNK         |   £4,188.29  |           |             |            |               |            |             |             |             
     | Un-Realised P/L:         |         |            |             |  £12,984.90  |           |       0.00  |            |               |            |             |             |             
     |                          |         |            |             |              | XIRR      |             |            |               |            |             |             |             
     | Total:                   |         |            |             | £285,815.76  |    14.08% |             |            |               |            |             |             |

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  | 22,041.00  |     7.71% |  6,027.00  |    269.78  |         0.00  |       269.78  |   6,296.78  |       3.75% |      827.13 
Tobacco      | 24,163.96  | 20,560.87  |     7.19% | -3,603.09  |      0.00  |     1,027.33  |     1,027.33  |  -2,575.76  |       9.31% |    1,913.56 
Fund Manager | 17,397.08  | 20,463.97  |     7.16% |  3,066.89  |      0.00  |     1,188.63  |     1,188.63  |   4,255.52  |       6.74% |    1,380.02 
Weapons      | 14,995.20  | 19,736.90  |     6.91% |  4,741.70  |      0.00  |       687.71  |       687.71  |   5,429.41  |       3.48% |      687.71 
Insurance    | 19,699.29  | 19,602.94  |     6.86% |    -96.35  |      0.00  |     1,153.67  |     1,153.67  |   1,057.32  |       7.44% |    1,458.05 
Gambling     | 14,999.32  | 18,367.30  |     6.43% |  3,367.98  |    357.95  |       835.22  |     1,193.17  |   4,561.15  |       6.50% |    1,193.18 
Bricks       | 14,999.47  | 17,465.11  |     6.11% |  2,465.64  |      0.00  |       859.79  |       859.79  |   3,325.43  |       3.25% |      567.35 
Advertising  | 14,997.55  | 17,155.64  |     6.00% |  2,158.09  |      0.00  |     1,068.00  |     1,068.00  |   3,226.09  |       6.23% |    1,068.00 
Pharma       | 14,999.37  | 16,162.62  |     5.65% |  1,163.25  |      0.00  |       536.37  |       536.37  |   1,699.62  |       4.66% |      752.80 
Packaging    | 14,997.11  | 15,778.91  |     5.52% |    781.80  |      0.00  |       698.22  |       698.22  |   1,480.02  |       4.48% |      706.84 
Television   | 14,999.08  | 15,730.20  |     5.50% |    731.12  |      0.00  |       932.15  |       932.15  |   1,663.27  |       5.93% |      932.16 
Telecom      | 14,998.48  | 15,115.50  |     5.29% |    117.02  |      0.00  |       758.07  |       758.07  |     875.09  |       4.90% |      740.42 
Property     | 14,993.43  | 15,077.82  |     5.28% |     84.39  |      0.00  |       586.92  |       586.92  |     671.31  |       5.22% |      786.42 
Banks        | 14,998.27  | 14,023.78  |     4.91% |   -974.49  |      0.00  |       573.99  |       573.99  |    -400.50  |       6.84% |      958.64 
Mining       | 14,992.51  | 13,885.66  |     4.86% | -1,106.85  |      0.00  |       528.19  |       528.19  |    -578.66  |       6.22% |      863.91 
Oil          | 14,977.76  | 12,329.39  |     4.31% | -2,648.37  |      0.00  |       668.56  |       668.56  |  -1,979.81  |       7.21% |      888.81 
Cruise Ships | 14,979.79  | 11,688.96  |     4.09% | -3,290.83  |      0.00  |       460.02  |       460.02  |  -2,830.81  |       5.09% |      595.28

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

Top-Ups and other Transactions since initial portfolio set up

Transactions | Since Set Up   |      |         |             |             | Bought    |                               
Date         | Business       | EPIC | Shares  | Price (p)   | Total (£)   | Yield (%) | Comment                       
10-Feb-20    | Insurance      | AV   |    620  |   405.9278  |  -2,530.83  |     7.45% | Routine Top-Up                
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 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 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-Mar-20 |   359.41  |    N    | 10-Mar-20 |   357.95 
14-Apr-20 | 2,186.52  |    Y    | 14-Apr-20 | 1,827.11 
11-May-20 |   729.08  |    N    | 11-May-20 |   729.08 
10-Jun-20 | 4,160.98  |    Y    | 10-Jun-20 | 3,431.90 
10-Jul-20 | 1,626.61  |    N    | 10-Jul-20 | 1,626.61 
10-Aug-20 | 2,179.18  |    Y    | 10-Aug-20 |   552.57 
10-Sep-20 |   664.42  |    N    | 10-Sep-20 |   664.42 
12-Oct-20 | 3,340.07  |    Y    | 12-Oct-20 | 2,675.65 
10-Nov-20 | 1,814.99  |    N    | 10-Nov-20 | 1,814.99 
10-Dec-20 | 2,699.02  |    Y    | 10-Dec-20 |   884.03 
11-Jan-21 |   983.58  |    N    | 11-Jan-21 |   983.58 
10-Feb-21 | 1,755.80  |    N    | 10-Feb-21 |   772.22

The next top-up will therefore be on 14 Apr 2020 which, because it is into Year 2 of this virtual HYP, will be posted on a new Year 2 thread. Before then, on of just after 3 Apr 2020, the last market day of the current year, I shall post a Year One progress summary here on this thread.

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=283054#p283054, the intention is to keep this thread simply recording the history of the Portfolio

Enjoy!

Ian

IanTHughes · #297551

Annual Report – 05 April 2020

This is the first annual report on the HYP originally constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 which has been subsequently managed as if an HYPer were still building an income pot by the re-investment of all dividends and other monies received.

Further details of how updates are to be made to this portfolio can be found on this thread: viewtopic.php?p=218513#p218513

As at the Close of Business on 03 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  |   614.8000  |    2,360.83  |     1.19% |  -12,618.96  |      0.00  |       610.18  |    610.18  | -12,008.78  |      19.68% |      464.64 
IMB  | Imperial Brands          |    719  | 18,148.31  | 1,563.5000  |   11,241.57  |     5.68% |   -6,906.74  |      0.00  |     1,438.00  |  1,438.00  |  -5,468.74  |      13.21% |    1,485.16 
AV   | Aviva                    |  4,820  | 19,699.29  |   233.6000  |   11,259.52  |     5.69% |   -8,439.77  |      0.00  |     1,153.67  |  1,153.67  |  -7,286.10  |      13.23% |    1,489.38 
RDSB | Royal Dutch Shell        |    309  |  7,481.66  | 1,418.4000  |    4,382.86  |     2.22% |   -3,098.80  |      0.00  |       454.55  |    454.55  |  -2,644.25  |      10.69% |      468.63 
SLA  | Standard Life Aberdeen   |  6,389  | 17,397.08  |   192.9000  |   12,324.38  |     6.23% |   -5,072.70  |    913.62  |     1,188.63  |  2,102.25  |  -2,970.45  |      11.20% |    1,380.02 
BP   | BP                       |  1,347  |  7,496.10  |   337.3000  |    4,543.43  |     2.30% |   -2,952.67  |      0.00  |       436.33  |    436.33  |  -2,516.34  |      10.05% |      456.36 
BHP  | BHP Group                |    838  | 14,992.51  | 1,241.2000  |   10,401.26  |     5.26% |   -4,591.25  |      0.00  |       944.08  |    944.08  |  -3,647.17  |       9.29% |      966.71 
LAND | Land Securities Group    |    818  |  7,499.19  |   514.6000  |    4,209.43  |     2.13% |   -3,289.76  |      0.00  |       285.05  |    285.05  |  -3,004.71  |       6.77% |      285.07 
BLND | British Land Company     |  1,273  |  7,494.24  |   314.5000  |    4,003.59  |     2.02% |   -3,490.65  |      0.00  |       301.87  |    301.87  |  -3,188.78  |       7.61% |      304.85 
BATS | British American Tobacco |    211  |  6,015.65  | 2,940.0000  |    6,203.40  |     3.14% |      187.75  |    110.98  |       107.08  |    218.06  |     405.81  |       7.16% |      443.94 
VOD  | Vodafone Group           | 10,077  | 14,998.48  |   111.0200  |   11,187.49  |     5.66% |   -3,810.99  |      0.00  |       758.07  |    758.07  |  -3,052.92  |       6.97% |      779.37 
IGG  | IG Group Holdings        |  2,762  | 14,999.32  |   667.5000  |   18,436.35  |     9.32% |    3,437.03  |      0.00  |     1,193.17  |  1,193.17  |   4,630.20  |       6.47% |    1,193.18 
SMDS | DS Smith                 |  4,310  | 14,997.11  |   254.7000  |   10,977.57  |     5.55% |   -4,019.54  |      0.00  |       698.22  |    698.22  |  -3,321.32  |       6.44% |      706.84 
GSK  | GlaxoSmithKline          |    941  | 14,999.37  | 1,489.4000  |   14,015.25  |     7.08% |     -984.12  |    216.43  |       536.37  |    752.80  |    -231.32  |       5.37% |      752.80 
BA   | BAE Systems              |  3,043  | 14,995.20  |   500.0000  |   15,215.00  |     7.69% |      219.80  |      0.00  |       687.71  |    687.71  |     907.51  |       1.88% |      286.04 
WPP  | WPP                      |  1,780  | 14,997.55  |   483.7000  |    8,609.86  |     4.35% |   -6,387.69  |      0.00  |     1,068.00  |  1,068.00  |  -5,319.69  |       4.69% |      404.06 
ITV  | ITV                      | 11,652  | 14,999.08  |    54.4200  |    6,341.02  |     3.21% |   -8,658.06  |      0.00  |       932.15  |    932.15  |  -7,725.91  |       4.78% |      302.95 
PNN  | Pennon Group             |  1,975  | 16,014.00  | 1,045.0000  |   20,638.75  |    10.43% |    4,624.75  |      0.00  |       269.78  |    269.78  |   4,894.53  |       4.01% |      827.13 
IBST | Ibstock                  |  5,849  | 14,999.47  |   148.4000  |    8,679.92  |     4.39% |   -6,319.55  |      0.00  |       859.79  |    859.79  |  -5,459.76  |       2.16% |      187.16 
HSBA | HSBC Holdings            |  2,425  | 14,998.27  |   397.2000  |    9,632.10  |     4.87% |   -5,366.17  |      0.00  |       573.99  |    573.99  |  -4,792.18  |       0.00% |        0.00 
     |                          |         |            |             |              |           |              |            |               |            |             |             |             
     | Sub Total:               |         |            |             | £194,663.58  |    98.39% | -£77,538.09  | £1,241.03  |               |            |             |       6.77% |  £13,184.29 
     | Cash Balance:            |         |            |             |   £1,935.31  |     0.98% |              |            |               |            |             |             |             
     | Ex-Dividend:             |         |            |             |   £1,241.03  |     0.63% |              |            |               |            |             |             |             
     |                          |         |            |             |              |           |              |            |               |            |             |             |             
     | Total:                   |         |            |             | £197,839.92  |           |              |            |               |            |             |             |             
     | From:                    |         |            |             |              |           |              |            |               |            |             |             |             
     | Cash In:                 |         |            |             | £254,904.77  |           |              |            |               |            |             |             |             
     | LESS Cash Out:           |         |            |             |       £0.00  |           |              |            |               |            |             |             |             
     | Dividends Received:      |         |            |             |  £15,043.92  |           |              |            |               |            |             |             |             
     | Ex-Dividend:             |         |            |             |   £1,241.03  |           |              |            |               |            |             |             |             
     | Realised P/L:            |         |            | GNK         |   £4,188.29  |           |              |            |               |            |             |             |             
     | Un-Realised P/L:         |         |            |             | -£77,538.09  |           |              |            |               |            |             |             |             
     |                          |         |            |             |              |    XIRR   |              |            |               |            |             |             |             
     | Total:                   |         |            |             | £197,839.92  |   -22.12% |              |            |               |            |             |             |

With the Business diversification, 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  | 20,638.75  |    10.43% |   4,624.75  |      0.00  |       269.78  |       269.78  |   4,894.53  |       4.01% |      827.13 
Gambling     | 14,999.32  | 18,436.35  |     9.32% |   3,437.03  |      0.00  |     1,193.17  |     1,193.17  |   4,630.20  |       6.47% |    1,193.18 
Tobacco      | 24,163.96  | 17,444.97  |     8.82% |  -6,718.99  |    110.98  |     1,545.08  |     1,656.06  |  -5,062.93  |      11.06% |    1,929.10 
Weapons      | 14,995.20  | 15,215.00  |     7.69% |     219.80  |      0.00  |       687.71  |       687.71  |     907.51  |       1.88% |      286.04 
Pharma       | 14,999.37  | 14,015.25  |     7.08% |    -984.12  |    216.43  |       536.37  |       752.80  |    -231.32  |       5.37% |      752.80 
Fund Manager | 17,397.08  | 12,324.38  |     6.23% |  -5,072.70  |    913.62  |     1,188.63  |     2,102.25  |  -2,970.45  |      11.20% |    1,380.02 
Insurance    | 19,699.29  | 11,259.52  |     5.69% |  -8,439.77  |      0.00  |     1,153.67  |     1,153.67  |  -7,286.10  |      13.23% |    1,489.38 
Packaging    | 14,997.11  | 10,977.57  |     5.55% |  -4,019.54  |      0.00  |       698.22  |       698.22  |  -3,321.32  |       6.44% |      706.84 
Telecom      | 14,998.48  | 11,187.49  |     5.65% |  -3,810.99  |      0.00  |       758.07  |       758.07  |  -3,052.92  |       6.97% |      779.37 
Mining       | 14,992.51  | 10,401.26  |     5.26% |  -4,591.25  |      0.00  |       944.08  |       944.08  |  -3,647.17  |       9.29% |      966.71 
Banks        | 14,998.27  |  9,632.10  |     4.87% |  -5,366.17  |      0.00  |       573.99  |       573.99  |  -4,792.18  |       0.00% |        0.00 
Oil          | 14,977.76  |  8,926.29  |     4.51% |  -6,051.47  |      0.00  |       890.88  |       890.88  |  -5,160.59  |      10.36% |      924.99 
Advertising  | 14,997.55  |  8,609.86  |     4.35% |  -6,387.69  |      0.00  |     1,068.00  |     1,068.00  |  -5,319.69  |       4.69% |      404.06 
Bricks       | 14,999.47  |  8,679.92  |     4.39% |  -6,319.55  |      0.00  |       859.79  |       859.79  |  -5,459.76  |       2.16% |      187.16 
Property     | 14,993.43  |  8,213.02  |     4.15% |  -6,780.41  |      0.00  |       586.92  |       586.92  |  -6,193.49  |       7.18% |      589.92 
Television   | 14,999.08  |  6,341.02  |     3.21% |  -8,658.06  |      0.00  |       932.15  |       932.15  |  -7,725.91  |       4.78% |      302.95 
Cruise Ships | 14,979.79  |  2,360.83  |     1.19% | -12,618.96  |      0.00  |       610.18  |       610.18  | -12,008.78  |      19.68% |      464.64

* - 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. However, in view of all the recent dividend suspensions/cancellations, the above Year Div (£) columns should be treated very much as speculative.

Transactions concluded during the year

Transactions |                |      |         |             |             | Bought    |                               
Date         | Business       | EPIC | Shares  | Price (p)   | Total (£)   | Yield (%) | Comment                       
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

Income

Year Start |     Q1     |     Q2     |     Q3     |     Q4     |     Total  
06-Apr-19  | £3,919.13  | £4,671.85  | £3,748.91  | £2,704.03  | £15,043.92

Seven of the original holdings were already Ex-Dividend on purchase, meaning that the income received did not represent a full year.

With regard to the future, I have attempted to keep up with all the suspensions/cancellations over the past few weeks but I do not believe it is currently possible to make a sensible estimate of the income to be received during the next year. We shall have to wait and see but it is I believe certain that there will be a decline.

Capital Value

Everything was going quite well until the Covid-19 virus struck. Now of course the value is well down and who knows when it will recover

Future Top-Up Dates

Dividends received for this Portfolio are invested in further holdings 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
14-Apr-20 | 2,151.74  |     Y      | 14-Apr-20 | 1,792.33 
11-May-20 |   232.74  |     N      | 11-May-20 |   232.74 
10-Jun-20 | 2,288.82  |     Y      | 10-Jun-20 | 2,056.08 
10-Jul-20 |   634.93  |     N      | 10-Jul-20 |   634.93 
10-Aug-20 | 1,206.22  |     N      | 10-Aug-20 |   571.29 
10-Sep-20 | 1,874.54  |     N      | 10-Sep-20 |   668.32 
12-Oct-20 | 4,397.97  |     Y      | 12-Oct-20 | 2,523.43 
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 |   998.68  |     N      | 11-Jan-21 |   998.68 
10-Feb-21 | 1,795.04  |     N      | 10-Feb-21 |   796.36 
10-Mar-21 | 2,152.99  |     Y      | 10-Mar-21 |   357.95

The next top-up will therefore be on 14 Apr 2020 which, because it is into Year 2 of this virtual HYP, will be posted on a new Year 2 thread.

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=283054#p283054

The intention is to keep this thread simply recording the history of the Portfolio

Enjoy!

Ian

Gengulphus · #339250

IanTHughes wrote:The next top-up will therefore be on 14 Apr 2020 which, because it is into Year 2 of this virtual HYP, will be posted on a new Year 2 thread.

To help anyone trying to follow the history of this portfolio in forwards time order, that new thread is viewtopic.php?f=15&t=22901.

Gengulphus

The Lemon Fool

Donate to Remove ads

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