PYAD HYP 2019_04 REINVEST – Year Four

IanTHughes · #492925

Top-Up - 11 April 2022 - Decision

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

Update – 08 April 2022

This is an update on the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.

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

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)     | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 1,677.5000  |   21,522.33  |     7.15% |  -4,599.18  |      0.00  |     4,585.41  |     -13.77  |        8.29% |    1,784.39 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,291.0000  |    9,840.09  |     3.27% |   1,481.05  |    162.80  |     1,100.76  |   2,744.61  |        6.62% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   989.2000  |   17,607.76  |     5.85% |   2,610.21  |      0.00  |     1,717.70  |   4,327.91  |        3.15% |      555.36 
ITV  | ITV                       | 11,652  | 14,999.08  |    79.0800  |    9,214.40  |     3.06% |  -5,784.68  |      0.00  |       932.15  |  -4,852.53  |        6.32% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   530.0000  |   12,852.50  |     4.27% |  -2,145.77  |    332.97  |       959.86  |    -852.94  |        3.60% |      462.46 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   840.5000  |   23,214.61  |     7.71% |   8,215.29  |      0.00  |     3,579.51  |  11,794.80  |        5.14% |    1,193.18 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   207.9000  |   13,282.73  |     4.41% |  -4,114.35  |    466.39  |     3,501.42  |    -146.54  |        7.02% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   212.5000  |    7,448.13  |     2.47% |     258.29  |    427.61  |       272.89  |     958.79  |        8.61% |      641.41 
AV   | Aviva                     |  4,821  | 19,703.37  |   425.8000  |   20,527.82  |     6.82% |     824.45  |    708.68  |     2,809.68  |   4,342.81  |        5.18% |    1,063.03 
DLG  | Direct Line Insurance Grp |      0  |      0.00  |   268.4000  |        0.00  |     0.00% |       0.00  |      0.00  |         0.00  |       0.00  |        8.46% |        0.00 
GSK  | GlaxoSmithKline           |    941  | 14,999.37  | 1,778.6000  |   16,736.63  |     5.56% |   1,737.26  |      0.00  |     2,258.40  |   3,995.66  |        4.36% |      729.27 
BA   | BAE Systems               |  3,043  | 14,995.20  |   743.6000  |   22,627.75  |     7.51% |   7,632.55  |      0.00  |     2,130.07  |   9,762.62  |        3.38% |      763.78 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   308.2000  |   13,283.42  |     4.41% |  -1,713.69  |    413.76  |     1,219.73  |     -80.20  |        4.19% |      555.99 
IBST | Ibstock                   |  5,849  | 14,999.47  |   177.8000  |   10,399.52  |     3.45% |  -4,599.95  |      0.00  |       807.14  |  -3,792.81  |        4.22% |      438.67 
BLND | British Land Company      |  1,273  |  7,494.24  |   530.4000  |    6,751.99  |     2.24% |    -742.25  |      0.00  |       624.69  |    -117.56  |        3.20% |      215.90 
LAND | Land Securities Group     |    818  |  7,499.19  |   783.8000  |    6,411.48  |     2.13% |  -1,087.71  |      0.00  |       702.23  |    -385.48  |        4.21% |      269.94 
BHP  | BHP Group                 |    838  | 14,992.51  | 3,001.0000  |   25,148.38  |     8.35% |  10,155.87  |      0.00  |     3,509.70  |  13,665.57  |        6.58% |    1,655.67 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 6,138.0000  |   10,618.74  |     3.53% |     785.67  |    609.50  |       391.97  |   1,787.14  |        9.41% |      999.17 
SHEL | Shell                     |    457  |  9,626.22  | 2,168.0000  |    9,907.76  |     3.29% |     281.54  |      0.00  |       980.92  |   1,262.46  |        3.38% |      334.67 
BP   | BP                        |  1,347  |  7,496.10  |   391.5000  |    5,273.51  |     1.75% |  -2,222.59  |      0.00  |       921.20  |  -1,301.39  |        4.26% |      224.40 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |   129.2800  |   13,027.55  |     4.33% |  -1,970.93  |      0.00  |     2,335.44  |     364.51  |        5.87% |      764.11 
CCL  | Carnival Corporation      |    384  | 14,979.79  | 1,288.0000  |    4,945.92  |     1.64% | -10,033.87  |      0.00  |       610.18  |  -9,423.69  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  | 1,082.0000  |   14,239.12  |     4.73% |   3,568.53  |      0.00  |     1,447.69  |   5,016.22  |        3.16% |      449.54 
     |                           |         |            |             |              |           |             |            |               |             |              |             
     | Sub Total:                |         |            |             | £294,882.14  |    97.90% | -£1,464.26  | £3,121.71  |               |             |        5.18% |  £15,267.55 
     | Cash Balance:             |         |            |             |   £3,217.30  |     1.07% |             |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £3,121.71  |     1.04% |             |            |               |             |              |             
     |                           |         |            |             |              |           |             |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £301,221.15  |    18.17% |             |            |               |             |              |             
     | From:                     |         |            |             |              |           |             |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |             |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |             |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £37,951.65  |    14.89% |             |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £3,121.71  |           |             |            |               |             |              |             
     | Realised Profit/Loss:     |         |            |             |   £6,707.28  |[2]        |             |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             |  -£1,464.26  |           |             |            |               |             |              |             
     |                           |         |            |             |              | XIRR      |             |            |               |             |              |             
     | Total:                    |         |            |             | £301,221.15  |     5.61% |             |            |               |             |              |

Current Portfolio: Business Sectors

Business         |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Mining           | 24,825.58  |  35,767.12  |      11.87% |  10,941.54  |      609.50  |       3,901.67  |    15,452.71  |        7.42% |      2,654.84 
Tobacco          | 34,480.55  |  31,362.42  |      10.41% |  -3,118.13  |      162.80  |       5,686.17  |     2,730.84  |        7.77% |      2,435.61 
Gambling         | 14,999.32  |  23,214.61  |       7.71% |   8,215.29  |        0.00  |       3,579.51  |    11,794.80  |        5.14% |      1,193.18 
Weapons          | 14,995.20  |  22,627.75  |       7.51% |   7,632.55  |        0.00  |       2,130.07  |     9,762.62  |        3.38% |        763.78 
Fund Manager     | 24,586.92  |  20,730.86  |       6.88% |  -3,856.06  |      894.00  |       3,774.31  |       812.25  |        7.59% |      1,574.20 
Insurance - Life | 19,703.37  |  20,527.82  |       6.81% |     824.45  |      708.68  |       2,809.68  |     4,342.81  |        5.18% |      1,063.03 
Advertising      | 14,997.55  |  17,607.76  |       5.85% |   2,610.21  |        0.00  |       1,717.70  |     4,327.91  |        3.15% |        555.36 
Pharma           | 14,999.37  |  16,736.63  |       5.56% |   1,737.26  |        0.00  |       2,258.40  |     3,995.66  |        4.36% |        729.27 
Oil              | 17,122.32  |  15,181.27  |       5.04% |  -1,941.05  |        0.00  |       1,902.12  |       -38.93  |        3.68% |        559.07 
Utility - Water  | 10,670.59  |  14,239.12  |       4.73% |   3,568.53  |        0.00  |       1,447.69  |     5,016.22  |        3.16% |        449.54 
Packaging        | 14,997.11  |  13,283.42  |       4.41% |  -1,713.69  |      413.76  |       1,219.73  |       -80.20  |        4.19% |        555.99 
Real Estate IT   | 14,993.43  |  13,163.47  |       4.37% |  -1,829.96  |        0.00  |       1,326.92  |      -503.04  |        3.69% |        485.84 
Telecom - Mobile | 14,998.48  |  13,027.55  |       4.32% |  -1,970.93  |        0.00  |       2,335.44  |       364.51  |        5.87% |        764.11 
Banks            | 14,998.27  |  12,852.50  |       4.27% |  -2,145.77  |      332.97  |         959.86  |      -852.94  |        3.60% |        462.46 
Bricks           | 14,999.47  |  10,399.52  |       3.45% |  -4,599.95  |        0.00  |         807.14  |    -3,792.81  |        4.22% |        438.67 
Television       | 14,999.08  |   9,214.40  |       3.06% |  -5,784.68  |        0.00  |         932.15  |    -4,852.53  |        6.32% |        582.60 
Cruising         | 14,979.79  |   4,945.92  |       1.64% | -10,033.87  |        0.00  |         610.18  |    -9,423.69  |        0.00% |          0.00

[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 clearly indicated otherwise. I do now believe that the recent dividend suspensions/cancellations, caused by the Covid Pandemic and Lockdowns, have been played out. Consequently, the above Year Div (£) columns can once again be treated as a reasonable estimate.

[2] - Realised Profit and Loss – To Date

   Date      | Epic |    Name      |  Amount   |      Comment                           
20-Sep-19    | IBST | Ibstock      |    292.45 | Return of Capital / Special Dividend                      
09-Oct-19    | GNK  | Greene King  |  4,188.29 | Sale – Pending Takeover               
16-Jul-21    | PNN  | Pennon Group |  1,676.05 | Return of Capital / Share Consolidation
21-Sep-21    | BHP  | BHP Group    |    550.49 | Return of Capital / Special Dividend   
             |      |              |           |                                        
             |      | Total        | £6,707.28 |

Top-Up: 11 Apr 2022

As at the close of business on Friday 8 April 2022, the amount available for re-investment was £3,217.30. This amount will be used to top-up one holding on Monday 11 April 2022.

Candidates

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

Top-Up               |      |                           |           |          |                                                       
Business             | EPIC | Company                   | Yield (%) | Decision | Comments                                              
Home Construction    | PSN  | Persimmon                 |    10.72% | Selected | New Sector / New Holding                              
Mining               | RIO  | Rio Tinto                 |     9.41% | Rejected | Resultant Sector Value Concentration (12.89%) too high
Fund Manager         | MNG  | M & G PLC                 |     8.61% | Selected | Resultant Sector Value Concentration (8.18%)          
Insurance - Non-Life | DLG  | Direct Line Insurance Grp |     8.46% | Selected | New Sector / New Holding                              
Tobacco              | IMB  | Imperial Brands           |     8.29% | Rejected | Resultant Sector Value Concentration (11.21%) too high

Decision

While it is the case that PSN has the highest yield, some of that has been described as returning capital to the shareholders over the past few years. Indeed, the company has already stated that there will be a further 110p per share later this year. However, I have been unable to determine what the yield would be without such capital returns. As a result, PSN is rejected for now.

Moving down the list, both RIO and IMB are disqualified, so as to avoid the resulting Business Sector Value Concentration from breaching my limit of 10%.
MNG would of course be next on yield, although only just, but I have decided to go for the added diversification, albeit slight, offered by an entirely new holding and new sector - DLG. The yield offered is, to all intents and purposes, the same as that offered by a further purchase of MNG.

Insurance Non-Life – Direct Line Insurance Group PLC (DLG) – Yield 8.46% - is therefore the decision for this top-up.

The Value Concentration after purchase (1.06%) will obviously leave the Insurance – Non-Life Business Sector holding as the smallest by that measure but who knows, there may be further purchases to come.

As I am not intending to purchase DLG for any of the real portfolios under my control, the price to be applied for this virtual purchase will be the average price reported on the day. I shall post an update when the details of the purchase 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?f=15&t=34042

The intention is to keep this thread simply recording the events of the Portfolio during its fourth year.

Enjoy!

Ian

IanTHughes · #493601

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

Update 11 April 2022

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

Top Up Purchase: Transaction Details

The Top-Up indicated in the previous post https: viewtopic.php?f=15&t=34041#p492925 has now been made as follows:

Date      | Business             | EPIC | Shares | Price (p) | Cost (£)   | Stamp (£) | Fee (£) | Total (£)  | Yield (%) |          Comment              
11-Apr-22 | Insurance - Non-Life | DLG  | 1,194  | 267.9000  | -3,198.73  |   -15.99  |  -1.50  | -3,216.22  |   8.47%   | Routine Dividend Re-Investment

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)     | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 1,690.0000  |   21,682.70  |     7.22% |  -4,438.81  |      0.00  |     4,585.41  |     146.60  |        8.23% |    1,784.39 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,282.0000  |    9,813.18  |     3.27% |   1,454.14  |    162.80  |     1,100.76  |   2,717.70  |        6.64% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   973.2000  |   17,322.96  |     5.77% |   2,325.41  |      0.00  |     1,717.70  |   4,043.11  |        3.21% |      555.36 
ITV  | ITV                       | 11,652  | 14,999.08  |    79.1400  |    9,221.39  |     3.07% |  -5,777.69  |      0.00  |       932.15  |  -4,845.54  |        6.32% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   533.3000  |   12,932.53  |     4.30% |  -2,065.74  |    332.97  |       959.86  |    -772.91  |        3.58% |      462.46 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   842.0000  |   23,256.04  |     7.74% |   8,256.72  |      0.00  |     3,579.51  |  11,836.23  |        5.13% |    1,193.18 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   205.7000  |   13,142.17  |     4.37% |  -4,254.91  |    466.39  |     3,501.42  |    -287.10  |        7.10% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   212.8000  |    7,458.64  |     2.48% |     268.80  |    427.61  |       272.89  |     969.30  |        8.60% |      641.41 
AV   | Aviva                     |  4,821  | 19,703.37  |   428.5000  |   20,657.99  |     6.88% |     954.62  |    708.68  |     2,809.68  |   4,472.98  |        5.15% |    1,063.03 
DLG  | Direct Line Insurance Grp |  1,194  |  3,216.22  |   265.3000  |    3,167.68  |     1.05% |     -48.54  |      0.00  |         0.00  |     -48.54  |        8.56% |      271.03 
GSK  | GlaxoSmithKline           |    941  | 14,999.37  | 1,783.8000  |   16,785.56  |     5.59% |   1,786.19  |      0.00  |     2,258.40  |   4,044.59  |        4.34% |      729.27 
BA   | BAE Systems               |  3,043  | 14,995.20  |   765.0000  |   23,278.95  |     7.75% |   8,283.75  |      0.00  |     2,130.07  |  10,413.82  |        3.28% |      763.78 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   308.3000  |   13,287.73  |     4.42% |  -1,709.38  |    413.76  |     1,219.73  |     -75.89  |        4.18% |      555.99 
IBST | Ibstock                   |  5,849  | 14,999.47  |   176.5000  |   10,323.49  |     3.44% |  -4,675.98  |      0.00  |       807.14  |  -3,868.84  |        4.25% |      438.67 
BLND | British Land Company      |  1,273  |  7,494.24  |   533.2000  |    6,787.64  |     2.26% |    -706.60  |      0.00  |       624.69  |     -81.91  |        3.18% |      215.90 
LAND | Land Securities Group     |    818  |  7,499.19  |   785.6000  |    6,426.21  |     2.14% |  -1,072.98  |      0.00  |       702.23  |    -370.75  |        4.20% |      269.94 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,907.0000  |   24,360.66  |     8.11% |   9,368.15  |      0.00  |     3,509.70  |  12,877.85  |        6.80% |    1,655.67 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 6,070.0000  |   10,501.10  |     3.50% |     668.03  |    609.50  |       391.97  |   1,669.50  |        9.51% |      999.17 
SHEL | Shell                     |    457  |  9,626.22  | 2,135.0000  |    9,756.95  |     3.25% |     130.73  |      0.00  |       980.92  |   1,111.65  |        3.43% |      334.67 
BP   | BP                        |  1,347  |  7,496.10  |   386.6500  |    5,208.18  |     1.73% |  -2,287.92  |      0.00  |       921.20  |  -1,366.72  |        4.31% |      224.40 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |   130.8200  |   13,182.73  |     4.39% |  -1,815.75  |      0.00  |     2,335.44  |     519.69  |        5.80% |      764.11 
CCL  | Carnival Corporation      |    384  | 14,979.79  | 1,290.5000  |    4,955.52  |     1.65% | -10,024.27  |      0.00  |       610.18  |  -9,414.09  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  | 1,052.0000  |   13,844.32  |     4.61% |   3,173.73  |      0.00  |     1,447.69  |   4,621.42  |        3.25% |      449.54 
     |                           |         |            |             |              |           |             |            |               |             |              |             
     | Sub Total:                |         |            |             | £297,354.32  |    98.96% | -£2,208.30  | £3,121.71  |               |             |        5.23% |  £15,538.58 
     | Cash Balance:             |         |            |             |       £1.08  |     0.00% |             |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £3,121.71  |     1.04% |             |            |               |             |              |             
     |                           |         |            |             |              |           |             |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £300,477.11  |           |             |            |               |             |              |             
     | From:                     |         |            |             |              |           |             |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |             |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |             |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £37,951.65  |           |             |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £3,121.71  |           |             |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £6,707.28  |           |             |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             |  -£2,208.30  |           |             |            |               |             |              |             
     |                           |         |            |             |              |    XIRR   |             |            |               |             |              |             
     | Total:                    |         |            |             | £300,477.11  |     5.51% |             |            |               |             |              |

Current Portfolio: Business Sectors

Business             |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Mining               | 24,825.58  |  34,861.76  |      11.60% |  10,036.18  |      609.50  |       3,901.67  |    14,547.35  |        7.62% |      2,654.84 
Tobacco              | 34,480.55  |  31,495.88  |      10.48% |  -2,984.67  |      162.80  |       5,686.17  |     2,864.30  |        7.73% |      2,435.61 
Weapons              | 14,995.20  |  23,278.95  |       7.75% |   8,283.75  |        0.00  |       2,130.07  |    10,413.82  |        3.28% |        763.78 
Gambling             | 14,999.32  |  23,256.04  |       7.74% |   8,256.72  |        0.00  |       3,579.51  |    11,836.23  |        5.13% |      1,193.18 
Insurance - Life     | 19,703.37  |  20,657.99  |       6.88% |     954.62  |      708.68  |       2,809.68  |     4,472.98  |        5.15% |      1,063.03 
Fund Manager         | 24,586.92  |  20,600.81  |       6.86% |  -3,986.11  |      894.00  |       3,774.31  |       682.20  |        7.64% |      1,574.20 
Advertising          | 14,997.55  |  17,322.96  |       5.77% |   2,325.41  |        0.00  |       1,717.70  |     4,043.11  |        3.21% |        555.36 
Pharma               | 14,999.37  |  16,785.56  |       5.59% |   1,786.19  |        0.00  |       2,258.40  |     4,044.59  |        4.34% |        729.27 
Oil                  | 17,122.32  |  14,965.13  |       4.98% |  -2,157.19  |        0.00  |       1,902.12  |      -255.07  |        3.74% |        559.07 
Utility - Water      | 10,670.59  |  13,844.32  |       4.61% |   3,173.73  |        0.00  |       1,447.69  |     4,621.42  |        3.25% |        449.54 
Packaging            | 14,997.11  |  13,287.73  |       4.42% |  -1,709.38  |      413.76  |       1,219.73  |       -75.89  |        4.18% |        555.99 
Real Estate IT       | 14,993.43  |  13,213.85  |       4.40% |  -1,779.58  |        0.00  |       1,326.92  |      -452.66  |        3.68% |        485.84 
Telecom - Mobile     | 14,998.48  |  13,182.73  |       4.39% |  -1,815.75  |        0.00  |       2,335.44  |       519.69  |        5.80% |        764.11 
Banks                | 14,998.27  |  12,932.53  |       4.30% |  -2,065.74  |      332.97  |         959.86  |      -772.91  |        3.58% |        462.46 
Bricks               | 14,999.47  |  10,323.49  |       3.44% |  -4,675.98  |        0.00  |         807.14  |    -3,868.84  |        4.25% |        438.67 
Television           | 14,999.08  |   9,221.39  |       3.07% |  -5,777.69  |        0.00  |         932.15  |    -4,845.54  |        6.32% |        582.60 
Cruising             | 14,979.79  |   4,955.52  |       1.65% | -10,024.27  |        0.00  |         610.18  |    -9,414.09  |        0.00% |          0.00 
Insurance - Non-Life |  3,216.22  |   3,167.68  |       1.05% |     -48.54  |        0.00  |           0.00  |       -48.54  |        8.56% |        271.03

[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 clearly indicated otherwise.

[2] - Realised Profit and Loss – To Date

Date      | EPIC | Name         | Real P&L (£) | Comment                                
20-Sep-19 | IBST | Ibstock      |      292.45  | Return of Capital / Special Dividend   
09-Oct-19 | GNK  | Greene King  |    4,188.29  | Sale – Pending Takeover                
16-Jul-21 | PNN  | Pennon Group |    1,676.05  | Return of Capital / Share Consolidation
21-Sep-21 | BHP  | BHP Group    |      550.49  | Return of Capital / Special Dividend   
          |      |              |              |                                        
          |      | Total        |   £6,707.28  |

Next Actions Required

BHP Spinoff of Woodside Petroleum shares

31 May 2022 / 01 Jun 2022

At the moment, this will probably be dealt with by way of what is the HYP default action plan – do nothing!

As I understand it, although Woodside Petroleum (WDPL) is currently only listed in Australia, they will now be securing a secondary listing on the London Stock Exchange (LSE). From a purely administrative point of view therefore, it should be entirely possible to monitor the newly created holding with a price download from the LSE, as is done with all other constituents of this “virtual” HYP. I suspect that going forward, dividends will also be given a GBp alternative.

My understanding is that, from the current holding of 838 BHP shares, the portfolio will receive 151 shares of WDPL, worth approximately £2,800.00. The current yield on WDPL is around 5.50% which, assuming the dividend continues at about the same level after this deal with BHP is done, makes it an entirely appropriate HYP holding.

If I discover any more information, it will be reported.

Next Top-Up

Top-Ups for this Portfolio are 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 for the next 12 months is as follows:

Date      | Balance   | Re-Invest?
10-May-22 | 1,740.84  | N         
10-Jun-22 | 8,957.87  | Y         
11-Jul-22 |   869.84  | N         
10-Aug-22 | 1,410.03  | N         
12-Sep-22 | 1,868.40  | N         
10-Oct-22 | 5,018.20  | Y         
10-Nov-22 | 1,406.83  | N         
12-Dec-22 | 2,068.96  | Y         
10-Jan-23 |   962.65  | N         
10-Feb-23 | 1,686.29  | N         
10-Mar-23 | 2,044.24  | Y         
11-Apr-23 | 1,944.13  | N

The next top-up will therefore be on 10 Jun 2022, at which point, thanks to the Special Dividend due to be received from Aviva (AV) on 31 May 2022, the amount available will be a fairly chunky £8,957.87. At the moment, it looks as if this amount will be invested in increasing the just created holding of Direct Line Insurance Group (DLG). A final decision will be made a day or two before the Top Up is due to be made.

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?f=15&t=34042

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

Enjoy!

Ian

IanTHughes · #504414

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

This is an update on the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.

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

Year Four: Update - 01 June 2022

1 - Aviva PLC (AV): Return of Capital – 16 May 2022

Shares | Special Dividend (p) | Dividend Receipt (£) | Current (#) | New (#) | New Holding (#) | Fraction Leftover (#) | Price (p) | Fraction Receipt (£) | Total Receipt (£)
 4,821 |             101.6900 |             4,902.47 |         100 |      76 |           3,663 |                0.9600 |  428.7000 |                 4.12 |          4,906.59

So far, an amount of £4,902.47 has been added to the Portfolio Cash Balance. My own “real” portfolio has yet to receive any cash from the sale of the Fraction of a share left behind. This amount will be calculated and added to the Portfolio Cash Balance when and if it is received by myself, in my “real” portfolio.

2 - BHP Group (BHP): In-Specie Dividend - 01 June 2022

The portfolio has received shares of Woodside Petroleum, the number being calculated as follows:

WPL 1 share for BHP 5.534 shares

BHP Shares (#) | WPL Shares (#) | Fraction Left (#) | BHP Price (p) | Fraction Value (£)
           838 |            151 |            0.4275 |      2,550.00 |              10.90

Using the closing price of WPL from the 01 June 2022 – A$30.1900 - the value of this In-Specie dividend for BHP has so far been calculated as £2,619.94 which amount has been used as the cost of the new WPL holding. My own “real” portfolio has yet to receive these shares so, when they are received, I shall use the holding cost applied by my broker to recalculate the correct value for this In-Specie dividend.

Also, my own “real” portfolio has yet to receive any cash from the sale of the fraction of a BHP share left behind. This amount will be calculated and added to the Portfolio Cash Balance when and if it is received by myself, in my “real” portfolio.

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 1,791.5000  |   22,984.95  |     7.76% |   -3,136.56  |    272.89  |     4,585.41  |   1,721.74  |        7.79% |    1,789.78 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,536.5000  |   10,574.14  |     3.57% |    2,215.10  |      0.00  |     1,263.56  |   3,478.66  |        6.16% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   922.8000  |   16,425.84  |     5.54% |    1,428.29  |      0.00  |     1,717.70  |   3,145.99  |        3.38% |      555.36 
ITV  | ITV                       | 11,652  | 14,999.08  |    70.6000  |    8,226.31  |     2.78% |   -6,772.77  |      0.00  |     1,316.66  |  -5,456.11  |        7.08% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   529.6000  |   12,842.80  |     4.34% |   -2,155.47  |      0.00  |     1,294.96  |    -860.51  |        3.79% |      486.12 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   714.0000  |   19,720.68  |     6.66% |    4,721.36  |      0.00  |     3,579.51  |   8,300.87  |        6.05% |    1,193.18 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   192.7500  |   12,314.80  |     4.16% |   -5,082.28  |      0.00  |     3,967.81  |  -1,114.47  |        7.57% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   216.4000  |    7,584.82  |     2.56% |      394.98  |      0.00  |       700.50  |   1,095.48  |        8.46% |      641.41 
AV   | Aviva                     |  3,663  | 14,974.76  |   428.7000  |   15,703.28  |     5.30% |      732.64  |      0.00  |     3,518.36  |   4,251.00  |        5.14% |      807.69 
DLG  | Direct Line Insurance Grp |  1,194  |  3,216.22  |   254.8000  |    3,042.31  |     1.03% |     -173.91  |      0.00  |         0.00  |    -173.91  |        8.91% |      271.03 
GSK  | GSK Plc                   |    941  | 14,999.37  | 1,707.8000  |   16,070.40  |     5.42% |    1,071.03  |    131.74  |     2,258.40  |   3,461.17  |        4.57% |      733.98 
BA   | BAE Systems               |  3,043  | 14,995.20  |   778.2000  |   23,680.63  |     7.99% |    8,685.43  |      0.00  |     2,592.60  |  11,278.03  |        3.23% |      763.78 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   303.2000  |   13,067.92  |     4.41% |   -1,929.19  |      0.00  |     1,426.61  |    -502.58  |        4.25% |      555.99 
IBST | Ibstock                   |  5,849  | 14,999.47  |   186.3000  |   10,896.69  |     3.68% |   -4,102.78  |      0.00  |     1,099.59  |  -3,003.19  |        4.03% |      438.67 
BLND | British Land Company      |  1,273  |  7,494.24  |   521.2000  |    6,634.88  |     2.24% |     -859.36  |      0.00  |       624.69  |    -234.67  |        4.21% |      279.04 
LAND | Land Securities Group     |    818  |  7,499.19  |   766.4000  |    6,269.15  |     2.12% |   -1,230.04  |      0.00  |       702.23  |    -527.81  |        4.83% |      302.66 
BHP  | BHP Group                 |    838  | 15,003.41  | 2,550.0000  |   21,369.00  |     7.21% |    6,376.49  |      0.00  |     3,509.70  |   9,886.19  |        8.14% |    1,740.37 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 5,758.0000  |    9,961.34  |     3.36% |      128.27  |      0.00  |     1,001.47  |   1,129.74  |       10.03% |      999.17 
SHEL | Shell                     |    457  |  9,626.22  | 2,361.0000  |   10,789.77  |     3.64% |    1,163.55  |     91.61  |       980.92  |   2,236.08  |        3.40% |      366.45 
BP   | BP                        |  1,347  |  7,496.10  |   431.3000  |    5,809.61  |     1.96% |   -1,686.49  |     58.97  |       921.20  |    -706.32  |        4.06% |      235.88 
WPL  | Woodside Energy Group Ltd |    151  |  2,619.94  | 1,735.0575  |    2,619.94  |     0.88% |        0.00  |      0.00  |         0.00  |       0.00  |        6.24% |      163.45 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |   126.7000  |   12,767.56  |     4.31% |   -2,230.92  |    383.54  |     2,335.44  |     488.06  |        6.01% |      767.08 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   969.0000  |    3,720.96  |     1.26% |  -11,258.83  |      0.00  |       610.18  | -10,648.65  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  | 1,010.0000  |   13,291.60  |     4.49% |    2,621.01  |      0.00  |     1,447.69  |   4,068.70  |        3.81% |      507.05 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £286,369.38  |    96.66% | -£11,080.45  |   £938.75  |               |             |        5.51% |  £15,764.75 
     | Cash Balance:             |         |            |             |   £8,960.00  |     3.02% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |     £938.75  |     0.32% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £296,268.13  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £42,008.10  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |     £938.75  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £9,496.96  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£11,080.45  |           |              |            |               |             |              |             
     |                           |         |            |             |              | XIRR      |              |            |               |             |              |             
     | Total:                    |         |            |             | £296,268.13  |     4.80% |              |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  33,559.09  |      11.33% |    -921.46  |      272.89  |       5,848.97  |     5,200.40  |        7.27% |      2,441.00 
Mining              | 24,836.48  |  31,330.34  |      10.57% |   6,504.76  |        0.00  |       4,511.17  |    11,015.93  |        8.74% |      2,739.54 
Weapons             | 14,995.20  |  23,680.63  |       7.99% |   8,685.43  |        0.00  |       2,592.60  |    11,278.03  |        3.23% |        763.78 
Fund Manager        | 24,586.92  |  19,899.62  |       6.72% |  -4,687.30  |        0.00  |       4,668.31  |       -18.99  |        7.91% |      1,574.20 
Gambling            | 14,999.32  |  19,720.68  |       6.66% |   4,721.36  |        0.00  |       3,579.51  |     8,300.87  |        6.05% |      1,193.18 
Oil                 | 19,742.26  |  19,219.32  |       6.49% |    -522.94  |      150.58  |       1,902.12  |     1,529.76  |        3.98% |        765.78 
Advertising         | 14,997.55  |  16,425.84  |       5.54% |   1,428.29  |        0.00  |       1,717.70  |     3,145.99  |        3.38% |        555.36 
Pharma              | 14,999.37  |  16,070.40  |       5.42% |   1,071.03  |      131.74  |       2,258.40  |     3,461.17  |        4.57% |        733.98 
Insurance: Life     | 14,974.76  |  15,703.28  |       5.30% |     732.64  |        0.00  |       3,518.36  |     4,251.00  |        5.14% |        807.69 
Packaging           | 14,997.11  |  13,067.92  |       4.41% |  -1,929.19  |        0.00  |       1,426.61  |      -502.58  |        4.25% |        555.99 
Utility: Water      | 10,670.59  |  13,291.60  |       4.49% |   2,621.01  |        0.00  |       1,447.69  |     4,068.70  |        3.81% |        507.05 
Real Estate IT      | 14,993.43  |  12,904.03  |       4.36% |  -2,089.40  |        0.00  |       1,326.92  |      -762.48  |        4.51% |        581.70 
Banks               | 14,998.27  |  12,842.80  |       4.33% |  -2,155.47  |        0.00  |       1,294.96  |      -860.51  |        3.79% |        486.12 
Telecom: Mobile     | 14,998.48  |  12,767.56  |       4.31% |  -2,230.92  |      383.54  |       2,335.44  |       488.06  |        6.01% |        767.08 
Bricks              | 14,999.47  |  10,896.69  |       3.68% |  -4,102.78  |        0.00  |       1,099.59  |    -3,003.19  |        4.03% |        438.67 
Television          | 14,999.08  |   8,226.31  |       2.78% |  -6,772.77  |        0.00  |       1,316.66  |    -5,456.11  |        7.08% |        582.60 
Cruising            | 14,979.79  |   3,720.96  |       1.26% | -11,258.83  |        0.00  |         610.18  |   -10,648.65  |        0.00% |          0.00 
Insurance: Non-Life |  3,216.22  |   3,042.31  |       1.03% |    -173.91  |        0.00  |           0.00  |      -173.91  |        8.91% |        271.03

[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 clearly indicated otherwise. I do now believe that the recent dividend suspensions/cancellations, caused by the Covid Pandemic and Lockdowns, have been played out. Consequently, the above Year Div (£) columns can once again be treated as a reasonable estimate.

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name         | Real P&L (£) | Comment                                                   
16-May-22 | AV   | Aviva        |      169.74  | Return of Capital - Share Consolidation                   
06-Jun-22 | AV   | Aviva        |        0.00  | Share Consolidation - Fractional Share Sale               
21-Sep-21 | BHP  | BHP Group    |      550.49  | Return of Capital                                         
25-May-22 | BHP  | BHP Group    |    2,619.94  | Return of Capital - Woodside Energy Group (WPL) shares    
06-Jun-22 | BHP  | BHP Group    |        0.00  | Woodside Energy Group (WPL) shares - Fractional Share Sale
09-Oct-19 | GNK  | Greene King  |    4,188.29  | Sale – Pending Takeover                                   
20-Sep-19 | IBST | Ibstock      |      292.45  | Return of Capital                                         
16-Jul-21 | PNN  | Pennon Group |    1,667.84  | Return of Capital - Share Consolidation                   
16-Jul-21 | PNN  | Pennon Group |        8.21  | Share Consolidation - Fractional Share Sale               
          |      |              |              |                                                           
          |      | Total        |   £9,496.96  |

Top-Up: 10 Jun 2022

At the close of business on Thursday 9 June 2022, the amount available for re-investment will be £8,960.00. This amount will be used to top-up one or more holdings on Friday 10 June 2022.

Candidates

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

Top-Up              |      |                           |           |          |                                                       
Business            | EPIC | Company                   | Yield (%) | Decision | Comments                                              
House Builder       | PSN  | Persimmon                 |    10.76% | Selected | New Business Sector                                   
Mining              | RIO  | Rio Tinto                 |    10.03% | Rejected | Resultant Sector Value Concentration (13.58%) too high
Insurance: Non-Life | DLG  | Direct Line Insurance Grp |     8.91% | Selected | Resultant Sector Value Concentration (4.04%)          
Fund Manager        | MNG  | M & G PLC                 |     8.46% | Selected | Resultant Sector Value Concentration (9.73%)          
Mining              | BHP  | BHP Group                 |     8.14% | Rejected | Resultant Sector Value Concentration (13.58%) too high
Tobacco             | IMB  | Imperial Brands           |     7.79% | Rejected | Resultant Sector Value Concentration (14.34%) too high

Decision

While it is the case that PSN has the highest yield, some of that has been described as returning capital to the shareholders over the past few years. Indeed, the company has already stated that there will be a further 110p per share later this year. However, I have been unable to determine what the yield would be without such capital returns. As a result, PSN is rejected for now.

Moving down the list RIO remains disqualified, so as to avoid the resulting Business Sector Value Concentration from breaching my limit of 10%. DLG, which was first added to the portfolio only in April this year, has therefore been selected once again.

Insurance Non-Life – Direct Line Insurance Group PLC (DLG) – Yield 8.46% - is therefore the decision for this top-up.

The Value Concentration after purchase (4.04%) means the Insurance – Non-Life Business Sector holdings will be the 15th largest of the portfolio, around 30% to 35% of the largest Business Sector holdings – Mining and Tobacco.

As I am not intending to purchase DLG for any of the real portfolios under my control, the price to be applied for this virtual purchase will be the average price reported on the day. I shall post an update when the details of the purchase 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?f=15&t=34042

The intention is to keep this thread simply recording the events of the Portfolio during its fourth year.

Enjoy!

Ian

IanTHughes · #506435

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

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

Update 10 June 2022

Top Up Purchase: Transaction Details

The Top-Up indicated in the previous post https: viewtopic.php?f=15&t=34041&p=504414#p504414 has now been made as follows:

Business            | EPIC | Shares | Price (p) | Cost (£)   | Stamp (£) | Fee (£) | Total (£)  | Yield (%)
Insurance: Non-Life | DLG  | 3,497  | 254.8500  | -8,912.10  |   -44.56  |  -1.50  | -8,958.16  |   8.91%

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 1,792.0000  |   22,991.36  |     7.94% |   -3,130.15  |    272.89  |     4,585.41  |   1,728.15  |        7.78% |    1,789.78 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,493.0000  |   10,444.07  |     3.61% |    2,085.03  |      0.00  |     1,263.56  |   3,348.59  |        6.24% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   844.0000  |   15,023.20  |     5.19% |       25.65  |    332.86  |     1,717.70  |   2,076.21  |        3.70% |      555.36 
ITV  | ITV                       | 11,652  | 14,999.08  |    68.5200  |    7,983.95  |     2.76% |   -7,015.13  |      0.00  |     1,316.66  |  -5,698.47  |        7.30% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   499.1000  |   12,103.18  |     4.18% |   -2,895.09  |      0.00  |     1,294.96  |  -1,600.13  |        4.02% |      486.08 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   684.0000  |   18,892.08  |     6.52% |    3,892.76  |      0.00  |     3,579.51  |   7,472.27  |        6.32% |    1,193.18 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   174.6000  |   11,155.19  |     3.85% |   -6,241.89  |      0.00  |     3,967.81  |  -2,274.08  |        8.36% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   207.0000  |    7,255.35  |     2.50% |       65.51  |      0.00  |       700.50  |     766.01  |        8.84% |      641.41 
AV   | Aviva                     |  3,663  | 14,970.64  |   405.4000  |   14,849.80  |     5.13% |     -120.84  |      0.00  |     3,518.36  |   3,397.52  |        5.44% |      807.69 
DLG  | Direct Line Insurance Grp |  4,691  | 12,174.38  |   249.8000  |   11,718.12  |     4.05% |     -456.26  |      0.00  |         0.00  |    -456.26  |        9.09% |    1,064.85 
GSK  | GSK Plc                   |    941  | 14,999.37  | 1,736.6000  |   16,341.41  |     5.64% |    1,342.04  |    131.74  |     2,258.40  |   3,732.18  |        4.49% |      733.98 
BA   | BAE Systems               |  3,043  | 14,995.20  |   771.2000  |   23,467.62  |     8.10% |    8,472.42  |      0.00  |     2,592.60  |  11,065.02  |        3.25% |      763.78 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   289.7000  |   12,486.07  |     4.31% |   -2,511.04  |      0.00  |     1,426.61  |  -1,084.43  |        4.45% |      555.99 
IBST | Ibstock                   |  5,849  | 14,999.47  |   184.9000  |   10,814.80  |     3.73% |   -4,184.67  |      0.00  |     1,099.59  |  -3,085.08  |        4.06% |      438.67 
BLND | British Land Company      |  1,273  |  7,494.24  |   513.6000  |    6,538.13  |     2.26% |     -956.11  |      0.00  |       624.69  |    -331.42  |        4.27% |      279.04 
LAND | Land Securities Group     |    818  |  7,499.19  |   744.4000  |    6,089.19  |     2.10% |   -1,410.00  |      0.00  |       702.23  |    -707.77  |        4.97% |      302.66 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,558.0000  |   21,436.04  |     7.40% |    6,443.53  |      0.00  |     3,509.70  |   9,953.23  |        8.12% |    1,740.23 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 5,690.0000  |    9,843.70  |     3.40% |       10.63  |      0.00  |     1,001.47  |   1,012.10  |       10.15% |      999.17 
SHEL | Shell                     |    457  |  9,626.22  | 2,338.0000  |   10,684.66  |     3.69% |    1,058.44  |     91.60  |       980.92  |   2,130.96  |        3.43% |      366.42 
BP   | BP                        |  1,347  |  7,496.10  |   437.4500  |    5,892.45  |     2.03% |   -1,603.65  |     58.66  |       921.20  |    -623.79  |        4.00% |      235.54 
WDS  | Woodside Energy Group Ltd |    151  |  2,565.55  | 1,915.0000  |    2,891.65  |     1.00% |      326.10  |      0.00  |         0.00  |     326.10  |        5.65% |      163.44 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |   125.4600  |   12,642.60  |     4.36% |   -2,355.88  |    386.84  |     2,335.44  |     366.40  |        6.12% |      773.69 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   821.8000  |    3,155.71  |     1.09% |  -11,824.08  |      0.00  |       610.18  | -11,213.90  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  | 1,043.0000  |   13,725.88  |     4.74% |    3,055.29  |      0.00  |     1,447.69  |   4,502.98  |        3.69% |      507.05 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £288,426.21  |    99.56% | -£17,927.39  | £1,274.59  |               |             |        5.74% |  £16,564.62 
     | Cash Balance:             |         |            |             |       £1.84  |     0.00% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,274.59  |     0.44% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £289,702.64  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £42,008.10  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,274.59  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £9,442.57  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£17,927.39  |           |              |            |               |             |              |             
     |                           |         |            |             |              |    XIRR   |              |            |               |             |              |             
     | Total:                    |         |            |             | £289,702.64  |   4.04%   |              |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  33,435.43  |      11.54% |  -1,045.12  |      272.89  |       5,848.97  |     5,076.74  |        7.30% |      2,441.00 
Mining              | 24,825.58  |  31,279.74  |      10.80% |   6,454.16  |        0.00  |       4,511.17  |    10,965.33  |        8.76% |      2,739.40 
Weapons             | 14,995.20  |  23,467.62  |       8.10% |   8,472.42  |        0.00  |       2,592.60  |    11,065.02  |        3.25% |        763.78 
Oil                 | 19,687.87  |  19,468.76  |       6.72% |    -219.11  |      150.26  |       1,902.12  |     1,833.27  |        3.93% |        765.40 
Gambling            | 14,999.32  |  18,892.08  |       6.52% |   3,892.76  |        0.00  |       3,579.51  |     7,472.27  |        6.32% |      1,193.18 
Fund Manager        | 24,586.92  |  18,410.54  |       6.35% |  -6,176.38  |        0.00  |       4,668.31  |    -1,508.07  |        8.55% |      1,574.20 
Pharma              | 14,999.37  |  16,341.41  |       5.64% |   1,342.04  |      131.74  |       2,258.40  |     3,732.18  |        4.49% |        733.98 
Advertising         | 14,997.55  |  15,023.20  |       5.19% |      25.65  |      332.86  |       1,717.70  |     2,076.21  |        3.70% |        555.36 
Insurance: Life     | 14,970.64  |  14,849.80  |       5.13% |    -120.84  |        0.00  |       3,518.36  |     3,397.52  |        5.44% |        807.69 
Utility: Water      | 10,670.59  |  13,725.88  |       4.74% |   3,055.29  |        0.00  |       1,447.69  |     4,502.98  |        3.69% |        507.05 
Telecom: Mobile     | 14,998.48  |  12,642.60  |       4.36% |  -2,355.88  |      386.84  |       2,335.44  |       366.40  |        6.12% |        773.69 
Real Estate IT      | 14,993.43  |  12,627.32  |       4.36% |  -2,366.11  |        0.00  |       1,326.92  |    -1,039.19  |        4.61% |        581.70 
Packaging           | 14,997.11  |  12,486.07  |       4.31% |  -2,511.04  |        0.00  |       1,426.61  |    -1,084.43  |        4.45% |        555.99 
Banks               | 14,998.27  |  12,103.18  |       4.18% |  -2,895.09  |        0.00  |       1,294.96  |    -1,600.13  |        4.02% |        486.08 
Insurance: Non-Life | 12,174.38  |  11,718.12  |       4.04% |    -456.26  |        0.00  |           0.00  |      -456.26  |        9.09% |      1,064.85 
Bricks              | 14,999.47  |  10,814.80  |       3.73% |  -4,184.67  |        0.00  |       1,099.59  |    -3,085.08  |        4.06% |        438.67 
Television          | 14,999.08  |   7,983.95  |       2.76% |  -7,015.13  |        0.00  |       1,316.66  |    -5,698.47  |        7.30% |        582.60 
Cruising            | 14,979.79  |   3,155.71  |       1.09% | -11,824.08  |        0.00  |         610.18  |   -11,213.90  |        0.00% |          0.00

[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 clearly indicated otherwise.

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name         | Real P&L (£) | Comment                                                   
16-May-22 | AV   | Aviva        |      169.74  | Return of Capital - Share Consolidation                   
30-Jun-22 | AV   | Aviva        |        0.00  | Share Consolidation - Fractional Share Sale               
21-Sep-21 | BHP  | BHP Group    |      550.49  | Return of Capital                                         
01-Jun-22 | BHP  | BHP Group    |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares    
30-Jun-22 | BHP  | BHP Group    |        0.00  | Woodside Energy Group (WDS) shares - Fractional Share Sale
09-Oct-19 | GNK  | Greene King  |    4,188.29  | Sale – Pending Takeover                                   
20-Sep-19 | IBST | Ibstock      |      292.45  | Return of Capital                                         
16-Jul-21 | PNN  | Pennon Group |    1,667.84  | Return of Capital - Share Consolidation                   
16-Jul-21 | PNN  | Pennon Group |        8.21  | Share Consolidation - Fractional Share Sale               
          |      |              |              |                                                           
          |      | Total        |   £9,442.57  |

Next Actions Required

18 July 2022

GSK PLC (GSK): Spinoff of Haleon PLC shares

At the moment, this will probably be dealt with by way of what is the HYP default action plan – do nothing!

As I understand it, an as yet unspecified number of Haleon PLC shares will be issued to all shareholders, on or soon after the 18 July 2022. I have yet to discover whether a Share Consolidation of the current GSK holding will take place but assuming it does it will be reported at the same time.

If I discover any more information, it will be reported.

Next Top-Up

Top-Ups for this Portfolio are 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 for the next 12 months is as follows:

Date      | Balance   | Re-Invest?
11-Jul-22 |   889.59  | N         
10-Aug-22 | 1,530.43  | N         
12-Sep-22 | 2,402.82  | Y         
10-Oct-22 | 3,156.71  | Y         
10-Nov-22 | 1,406.83  | N         
12-Dec-22 | 2,068.96  | Y         
10-Jan-23 |   973.45  | N         
10-Feb-23 | 1,701.88  | N         
10-Mar-23 | 2,059.83  | Y         
11-Apr-23 | 2,131.02  | Y         
10-May-23 | 1,894.32  | N         
12-Jun-23 | 4,747.00  | Y

The next top-up will therefore be on 12 September 2022 when £2,402.82 will be available for re-investment. At the moment, it looks as if this amount will once again be invested in increasing the holding of Direct Line Insurance Group (DLG), but there are three months ahead, during which that might change. A final decision will be made a few days before the Top Up is due to be made.

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?f=15&t=34042

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

Enjoy!

Ian

IanTHughes · #515900

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

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

Year Four: Update – 19 July 2022

1 - GSK PLC (GSK): Haleon PLC Spinoff - 18 July 2022

The portfolio has received shares of Haleon PLC (HLN), the number being calculated as follows:

For each 1 GSK share, 1 HLN share will be issued

Therefore, 941 HLN shares have been added to the portfolio

2 - GSK PLC (GSK): Haleon PLC (HLN) Spinoff – Holding Cost

My thanks to tjh290633 for this one!

The holding cost for the new HLN holding was calculated as follows:

(GSK Holding Cost) * (Close Price HLN / (Close Price GSK + Close Price HLN)
Or
(14,999.37) * (308.35 / (1,389.80 + 308.35) = 2,723.59

This gives a price for the “purchase” of this holding of 289.4352. An Internal Purchase transaction has been recorded as follows:

Shares | Price (p) | Cost (£)   | Stamp (£) | Broker (£) | Net Cash (£)
  941  | 289.4352  | -2,723.59  |     0.00  |      0.00  |   -2,723.59

3 - GSK PLC (GSK): Share Consolidation – 19 July 2022

The GSK holding has been reduced in accordance with the reported share consolidation whereby:

For every 5 “Old” GSK Shares, 4 “New” GSK shares were issued as follows:

Old GSK Shares (#) | New GSK Shares (#) | Fraction Left (#)
               941 |                752 |            0.8000

An Internal Sale has been generated to reflect the fact that 189 shares have been disposed of, replaced by the new HLN shares. The amount calculated as the HLN holding cost has been used as the receipt for this internal sale, which gives a price for this transaction of 1,441.0529. The transaction has been recorded as follows:

Shares | Price (p)   | Receipt (£) | Stamp (£) | Broker (£) | Net Cash (£)
 -189  | 1,441.0529  |   2,723.59  |     0.00  |      0.00  |    2,723.59

My own “real” portfolio has yet to receive any cash from the sale of the fraction of a GSK share left behind. This amount will be calculated and added to the Portfolio Cash Balance when and if it is received by myself, in my “real” portfolio.

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%)[1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 1,900.5000  |   24,383.42  |     8.66% |   -1,738.09  |      0.00  |     4,858.30  |   3,120.21  |        7.34% |    1,789.78 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,528.5000  |   10,550.22  |     3.75% |    2,191.18  |    162.80  |     1,263.56  |   3,617.54  |        6.17% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   835.2000  |   14,866.56  |     5.28% |     -130.99  |      0.00  |     2,050.56  |   1,919.57  |        3.74% |      555.36 
ITV  | ITV                       | 11,652  | 14,999.08  |    67.6600  |    7,883.74  |     2.80% |   -7,115.34  |      0.00  |     1,316.66  |  -5,798.68  |        7.39% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   523.4000  |   12,692.45  |     4.51% |   -2,305.82  |      0.00  |     1,294.96  |  -1,010.86  |        4.03% |      511.64 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   724.5000  |   20,010.69  |     7.11% |    5,011.37  |      0.00  |     3,579.51  |   8,590.88  |        5.96% |    1,193.18 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   158.7000  |   10,139.34  |     3.60% |   -7,257.74  |      0.00  |     3,967.81  |  -3,289.93  |        9.20% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   210.2000  |    7,367.50  |     2.62% |      177.66  |      0.00  |       700.50  |     878.16  |        8.71% |      641.41 
AV   | Aviva                     |  3,663  | 14,970.64  |   395.2000  |   14,476.17  |     5.14% |     -494.47  |      0.00  |     3,518.36  |   3,023.89  |        5.58% |      807.69 
DLG  | Direct Line Insurance Grp |  4,691  | 12,174.38  |   201.0000  |    9,428.91  |     3.35% |   -2,745.47  |      0.00  |         0.00  |  -2,745.47  |       11.29% |    1,064.85 
HLN  | Haleon PLC                |    941  |  2,723.59  |   301.0000  |    2,832.41  |     1.01% |      108.82  |      0.00  |         0.00  |     108.82  |        6.64% |      188.20 
GSK  | GSK PLC                   |    752  | 11,986.74  | 1,783.4000  |   13,411.16  |     4.76% |    1,424.42  |      0.00  |     2,390.14  |   3,814.56  |        3.04% |      407.96 
BA   | BAE Systems               |  3,043  | 14,995.20  |   811.2000  |   24,684.82  |     8.77% |    9,689.62  |      0.00  |     2,592.60  |  12,282.22  |        3.09% |      763.78 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   294.9000  |   12,710.19  |     4.52% |   -2,286.92  |      0.00  |     1,426.61  |    -860.31  |        5.09% |      646.50 
IBST | Ibstock                   |  5,849  | 14,999.47  |   178.0000  |   10,411.22  |     3.70% |   -4,588.25  |      0.00  |     1,099.59  |  -3,488.66  |        4.21% |      438.67 
BLND | British Land Company      |  1,273  |  7,494.24  |   470.7000  |    5,992.01  |     2.13% |   -1,502.23  |    147.66  |       624.69  |    -729.88  |        4.66% |      279.04 
LAND | Land Securities Group     |    818  |  7,499.19  |   700.2000  |    5,727.64  |     2.04% |   -1,771.55  |    106.34  |       702.23  |    -962.98  |        5.51% |      315.74 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,115.0000  |   17,723.70  |     6.30% |    2,731.19  |      0.00  |     3,509.70  |   6,240.89  |       10.33% |    1,831.73 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 4,707.5000  |    8,143.98  |     2.89% |   -1,689.09  |      0.00  |     1,001.47  |    -687.62  |       12.27% |      999.17 
SHEL | Shell                     |    457  |  9,626.22  | 2,034.0000  |    9,295.38  |     3.30% |     -330.84  |      0.00  |     1,072.36  |     741.52  |        4.15% |      385.68 
BP   | BP                        |  1,347  |  7,496.10  |   385.6000  |    5,194.03  |     1.85% |   -2,302.07  |      0.00  |       979.86  |  -1,322.21  |        4.78% |      248.24 
WDS  | Woodside Energy Group Ltd |    151  |  2,565.55  | 1,855.0000  |    2,801.05  |     1.00% |      235.50  |      0.00  |         0.00  |     235.50  |        6.14% |      172.03 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |   131.0000  |   13,200.87  |     4.69% |   -1,797.61  |    385.66  |     2,335.44  |     923.49  |        5.84% |      771.33 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   743.2000  |    2,853.89  |     1.01% |  -12,125.90  |      0.00  |       610.18  | -11,515.72  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  |   988.5000  |   13,008.66  |     4.62% |    2,338.07  |      0.00  |     1,447.69  |   3,785.76  |        3.90% |      507.05 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £279,790.01  |    99.40% | -£26,274.55  |   £802.46  |               |             |        5.96% |  £16,685.64 
     | Cash Balance:             |         |            |             |     £889.43  |     0.32% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |     £802.46  |     0.29% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £281,481.90  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £42,895.69  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |     £802.46  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £9,153.53  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£26,274.55  |           |              |            |               |             |              |             
     |                           |         |            |             |              |   XIRR    |              |            |               |             |              |             
     | Total:                    |         |            |             | £281,481.90  |     3.01% |              |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  34,933.64  |      12.41% |     453.09  |      162.80  |       6,121.86  |     6,737.75  |        6.99% |      2,441.00 
Mining              | 24,825.58  |  25,867.68  |       9.19% |   1,042.10  |        0.00  |       4,511.17  |     5,553.27  |       10.94% |      2,830.90 
Weapons             | 14,995.20  |  24,684.82  |       8.77% |   9,689.62  |        0.00  |       2,592.60  |    12,282.22  |        3.09% |        763.78 
Gambling            | 14,999.32  |  20,010.69  |       7.11% |   5,011.37  |        0.00  |       3,579.51  |     8,590.88  |        5.96% |      1,193.18 
Oil                 | 19,687.87  |  17,290.46  |       6.14% |  -2,397.41  |        0.00  |       2,052.22  |      -345.19  |        4.66% |        805.95 
Fund Manager        | 24,586.92  |  17,506.84  |       6.22% |  -7,080.08  |        0.00  |       4,668.31  |    -2,411.77  |        8.99% |      1,574.20 
Advertising         | 14,997.55  |  14,866.56  |       5.28% |    -130.99  |        0.00  |       2,050.56  |     1,919.57  |        3.74% |        555.36 
Insurance: Life     | 14,970.64  |  14,476.17  |       5.14% |    -494.47  |        0.00  |       3,518.36  |     3,023.89  |        5.58% |        807.69 
Telecom: Mobile     | 14,998.48  |  13,200.87  |       4.69% |  -1,797.61  |      385.66  |       2,335.44  |       923.49  |        5.84% |        771.33 
Pharma              | 11,986.74  |  13,411.16  |       4.76% |   1,424.42  |        0.00  |       2,390.14  |     3,814.56  |        3.04% |        407.96 
Utility: Water      | 10,670.59  |  13,008.66  |       4.62% |   2,338.07  |        0.00  |       1,447.69  |     3,785.76  |        3.90% |        507.05 
Banks               | 14,998.27  |  12,692.45  |       4.51% |  -2,305.82  |        0.00  |       1,294.96  |    -1,010.86  |        4.03% |        511.64 
Packaging           | 14,997.11  |  12,710.19  |       4.52% |  -2,286.92  |        0.00  |       1,426.61  |      -860.31  |        5.09% |        646.50 
Real Estate IT      | 14,993.43  |  11,719.65  |       4.16% |  -3,273.78  |      254.00  |       1,326.92  |    -1,692.86  |        5.08% |        594.78 
Bricks              | 14,999.47  |  10,411.22  |       3.70% |  -4,588.25  |        0.00  |       1,099.59  |    -3,488.66  |        4.21% |        438.67 
Insurance: Non-Life | 12,174.38  |   9,428.91  |       3.35% |  -2,745.47  |        0.00  |           0.00  |    -2,745.47  |       11.29% |      1,064.85 
Television          | 14,999.08  |   7,883.74  |       2.80% |  -7,115.34  |        0.00  |       1,316.66  |    -5,798.68  |        7.39% |        582.60 
Medical Products    |  2,723.59  |   2,832.41  |       1.01% |     108.82  |        0.00  |           0.00  |       108.82  |        6.64% |        188.20 
Cruising            | 14,979.79  |   2,853.89  |       1.01% | -12,125.90  |        0.00  |         610.18  |   -11,515.72  |        0.00% |          0.00

[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 clearly indicated otherwise. I do now believe that the recent dividend suspensions/cancellations, caused by the Covid Pandemic and Lockdowns, have been played out. Consequently, the above Year Div (£) columns can once again be treated as a reasonable estimate.

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name         | Real P&L (£) | Comment                                               
20-Sep-19 | IBST | Ibstock      |      292.45  | Return of Capital                                     
09-Oct-19 | GNK  | Greene King  |    4,188.29  | Sale – Pending Takeover                               
16-Jul-21 | PNN  | Pennon Group |    1,676.05  | Return of Capital - Share Consolidation               
21-Sep-21 | BHP  | BHP Group    |      550.49  | Return of Capital                                     
16-May-22 | AV   | Aviva        |      169.74  | Return of Capital - Share Consolidation               
01-Jun-22 | BHP  | BHP Group    |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares
19-Jul-22 | GSK  | GSK PLC      |     -289.04  | Return of Capital - Haleon PLC (HLN) shares           
          |      |              |              |                                                       
          |      | Total        |   £9,153.53  |

Haleon PLC (HLN): Details

As can be seen in the Business Sector table above, I have categorised HLN as follows:

Industry – HealthCare
Sector – Medical Products

For now I have forecast an annual dividend of 20p per share, giving a yield of 6.64%. When added to the annual dividend for GSK PLC (GSK), which has been forecast by the GSK themselves as 44p, this will mean a total of 64p, a reduction from the pre-separation dividend of 80p.

With regard to the expected dates for Interim and Final Results, together with Dividend Payment Dates, for now I have copied those pertaining to GSK.

Next Top-Up

Top-Ups for this Portfolio are 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 for the next 12 months is as follows:

Date      | Balance   | Re-Invest?
10-Aug-22 | 1,529.09  | N         
12-Sep-22 | 2,401.48  | Y         
10-Oct-22 | 3,140.47  | Y         
10-Nov-22 | 1,497.34  | N         
12-Dec-22 | 2,159.47  | Y         
10-Jan-23 |   981.37  | N         
10-Feb-23 | 1,631.35  | N         
10-Mar-23 | 1,989.30  | N         
11-Apr-23 | 4,187.91  | Y         
10-May-23 | 1,797.81  | N         
12-Jun-23 | 4,650.49  | Y         
10-Jul-23 |   846.95  | N

The next top-up will therefore be on 12 September 2022 when £2,401.48 will be available for re-investment. At the moment there are a number of shares that might be topped up, plus a couple of new holdings that might be considered. However, there are two months ahead during which time all that might change. A final decision will be made a few days before the Top Up is due to be made.

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?f=15&t=34042

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

Enjoy!

Ian

IanTHughes · #524043

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

This is an update on the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.

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

Year Four: Update - 20 August 2022

1 - Aviva PLC (AV): Return of Capital – 16 May 2022 - Update

On 03 August 2022, the cash due from the sale of the Fractional Leftover from the Aviva PLC (AV) share consolidation was paid out. The price realised for these leftover shares was 412.50p, meaning that the details of the Share Consolidation for the portfolio’s AV shares was recalculated as follows:

Shares | Special Dividend (p) | Dividend Receipt (£) | Current (#) | New (#) | New Holding (#) | Fraction Leftover (#) | Sale Price (p) | Fraction Value (£) | Total Value (£)
 4,821 |             101.6900 |             4,902.47 |         100 |      76 |           3,663 |                0.9600 |       412.5000 |               3.96 |        4,906.43

An amount of £3.96 has therefore been credited to the portfolio’s Cash Balance.

2 - GSK PLC (GSK): Return of Capital – 18 July 2022 - Update

On 03 August 2022, the cash due from the sale of the Fractional Leftover from the GSK PLC (GSK) share consolidation was paid out. The price realised for these leftover shares was 1,662.50p, meaning that the details of the Share Consolidation for the portfolio’s GSK shares was recalculated as follows:

Old Holding (#) | Current (#) | New (#) | New Holding (#) | Fraction Leftover (#) | Sale Price (p) | Fraction Value (£)
            941 |           5 |       4 |             752 |                0.8000 |       1,662.50 |              13.30

An amount of £13.30 has therefore been credited to the portfolio’s Cash Balance.

Next Actions Required

Top-Up: 12 September 2022

A report on the share selected for the Top-Up due on 12 September 2022, will be made a couple of days before that date, with a report of the actual purchase being made on the purchase date or soon after.

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?f=15&t=34042

The intention is to keep this thread simply recording the events of the Portfolio during its fourth year.

Enjoy!

Ian

IanTHughes · #528912

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

Update – 10 September 2022

This is an update on the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.

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

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 1,952.5000  |   25,050.58  |     8.80% |   -1,070.93  |    272.89  |     4,858.30  |   4,060.26  |        7.14% |    1,789.78 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,489.0000  |   10,432.11  |     3.67% |    2,073.07  |      0.00  |     1,426.36  |   3,499.43  |        6.24% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   771.2000  |   13,727.36  |     4.82% |   -1,270.19  |      0.00  |     2,050.56  |     780.37  |        4.37% |      599.86 
ITV  | ITV                       | 11,652  | 14,999.08  |    64.6400  |    7,531.85  |     2.65% |   -7,467.23  |      0.00  |     1,316.66  |  -6,150.57  |        7.74% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   525.0000  |   12,731.25  |     4.47% |   -2,267.02  |    189.04  |     1,294.96  |    -783.02  |        4.45% |      567.12 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   793.5000  |   21,916.47  |     7.70% |    6,917.15  |      0.00  |     3,579.51  |  10,496.66  |        5.57% |    1,220.80 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   151.3500  |    9,669.75  |     3.40% |   -7,727.33  |    466.39  |     3,967.81  |  -3,293.13  |        9.65% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   204.1000  |    7,153.71  |     2.51% |      -36.13  |    217.31  |       700.50  |     881.68  |        9.02% |      644.92 
AV   | Aviva                     |  3,663  | 14,970.64  |   443.1000  |   16,230.75  |     5.70% |    1,260.11  |    377.28  |     3,518.36  |   5,155.75  |        5.64% |      915.75 
DLG  | Direct Line Insurance Grp |  4,691  | 12,174.38  |   212.6000  |    9,973.06  |     3.50% |   -2,201.32  |      0.00  |       356.51  |  -1,844.81  |       10.68% |    1,064.85 
GSK  | GSK PLC                   |    752  | 11,986.74  | 1,348.6000  |   10,141.48  |     3.56% |   -1,845.26  |    122.20  |     2,390.14  |     667.08  |        4.02% |      407.96 
HLN  | Haleon PLC                |    941  |  2,723.59  |   261.0000  |    2,456.01  |     0.86% |     -267.58  |      0.00  |         0.00  |    -267.58  |        7.66% |      188.20 
BA   | BAE Systems               |  3,043  | 14,995.20  |   784.4000  |   23,869.29  |     8.39% |    8,874.09  |      0.00  |     2,592.60  |  11,466.69  |        3.26% |      779.00 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   279.2000  |   12,033.52  |     4.23% |   -2,963.59  |      0.00  |     1,426.61  |  -1,536.98  |        5.37% |      646.50 
IBST | Ibstock                   |  5,849  | 14,999.47  |   197.1000  |   11,528.38  |     4.05% |   -3,471.09  |    193.01  |     1,099.59  |  -2,178.49  |        4.21% |      485.46 
BLND | British Land Company      |  1,273  |  7,494.24  |   414.1000  |    5,271.49  |     1.85% |   -2,222.75  |      0.00  |       772.35  |  -1,450.40  |        5.29% |      279.04 
LAND | Land Securities Group     |    818  |  7,499.19  |   635.0000  |    5,194.30  |     1.83% |   -2,304.89  |     70.34  |       808.57  |  -1,425.98  |        6.08% |      315.74 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,280.0000  |   19,106.40  |     6.71% |    4,113.89  |  1,269.25  |     3,509.70  |   8,892.84  |       12.34% |    2,358.04 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 4,862.0000  |    8,411.26  |     2.96% |   -1,421.81  |    383.41  |     1,001.47  |     -36.93  |       10.87% |      914.04 
SHEL | Shell                     |    457  |  9,626.22  | 2,300.0000  |   10,511.00  |     3.69% |      884.78  |     98.57  |     1,072.36  |   2,055.71  |        3.76% |      395.45 
BP   | BP                        |  1,347  |  7,496.10  |   450.8000  |    6,072.28  |     2.13% |   -1,423.82  |     69.61  |       979.86  |    -374.35  |        4.29% |      260.71 
WDS  | Woodside Energy Group Ltd |    151  |  2,565.55  | 1,949.0000  |    2,942.99  |     1.03% |      377.44  |    142.56  |         0.00  |     520.00  |        9.51% |      279.89 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |   108.4800  |   10,931.53  |     3.84% |   -4,066.95  |      0.00  |     2,716.86  |  -1,350.09  |        7.18% |      784.41 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   781.2000  |    2,999.81  |     1.05% |  -11,979.98  |      0.00  |       610.18  | -11,369.80  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  |   949.0000  |   12,488.84  |     4.39% |    1,818.25  |      0.00  |     1,800.77  |   3,619.02  |        4.06% |      507.05 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £278,375.47  |    97.79% | -£27,689.09  | £3,871.86  |               |             |        6.31% |  £17,571.18 
     | Cash Balance:             |         |            |             |   £2,414.50  |     0.85% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £3,871.86  |     1.36% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £284,661.83  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £44,403.50  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £3,871.86  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £9,170.79  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£27,689.09  |           |              |            |               |             |              |             
     |                           |         |            |             |              |   XIRR    |              |            |               |             |              |             
     | Total:                    |         |            |             | £284,661.83  |   3.22%   |              |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  35,482.69  |      12.46% |   1,002.14  |      272.89  |       6,284.66  |     7,559.69  |        6.88% |      2,441.00 
Mining              | 24,825.58  |  27,517.66  |       9.67% |   2,692.08  |    1,652.66  |       4,511.17  |     8,855.91  |       11.89% |      3,272.08 
Weapons             | 14,995.20  |  23,869.29  |       8.39% |   8,874.09  |        0.00  |       2,592.60  |    11,466.69  |        3.26% |        779.00 
Gambling            | 14,999.32  |  21,916.47  |       7.70% |   6,917.15  |        0.00  |       3,579.51  |    10,496.66  |        5.57% |      1,220.80 
Oil                 | 19,687.87  |  19,526.27  |       6.86% |    -161.60  |      310.74  |       2,052.22  |     2,201.36  |        4.79% |        936.05 
Fund Manager        | 24,586.92  |  16,823.46  |       5.91% |  -7,763.46  |      683.70  |       4,668.31  |    -2,411.45  |        9.38% |      1,577.71 
Insurance: Life     | 14,970.64  |  16,230.75  |       5.70% |   1,260.11  |      377.28  |       3,518.36  |     5,155.75  |        5.64% |        915.75 
Advertising         | 14,997.55  |  13,727.36  |       4.82% |  -1,270.19  |        0.00  |       2,050.56  |       780.37  |        4.37% |        599.86 
Banks               | 14,998.27  |  12,731.25  |       4.47% |  -2,267.02  |      189.04  |       1,294.96  |      -783.02  |        4.45% |        567.12 
Utility: Water      | 10,670.59  |  12,488.84  |       4.39% |   1,818.25  |        0.00  |       1,800.77  |     3,619.02  |        4.06% |        507.05 
Packaging           | 14,997.11  |  12,033.52  |       4.23% |  -2,963.59  |        0.00  |       1,426.61  |    -1,536.98  |        5.37% |        646.50 
Bricks              | 14,999.47  |  11,528.38  |       4.05% |  -3,471.09  |      193.01  |       1,099.59  |    -2,178.49  |        4.21% |        485.46 
Telecom: Mobile     | 14,998.48  |  10,931.53  |       3.84% |  -4,066.95  |        0.00  |       2,716.86  |    -1,350.09  |        7.18% |        784.41 
Real Estate IT      | 14,993.43  |  10,465.79  |       3.68% |  -4,527.64  |       70.34  |       1,580.92  |    -2,876.38  |        5.68% |        594.78 
Pharma              | 11,986.74  |  10,141.48  |       3.56% |  -1,845.26  |      122.20  |       2,390.14  |       667.08  |        4.02% |        407.96 
Insurance: Non-Life | 12,174.38  |   9,973.06  |       3.50% |  -2,201.32  |        0.00  |         356.51  |    -1,844.81  |       10.68% |      1,064.85 
Television          | 14,999.08  |   7,531.85  |       2.65% |  -7,467.23  |        0.00  |       1,316.66  |    -6,150.57  |        7.74% |        582.60 
Cruising            | 14,979.79  |   2,999.81  |       1.05% | -11,979.98  |        0.00  |         610.18  |   -11,369.80  |        0.00% |          0.00 
Medical Products    |  2,723.59  |   2,456.01  |       0.86% |    -267.58  |        0.00  |           0.00  |      -267.58  |        7.66% |        188.20

[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 clearly indicated otherwise. I do now believe that the recent dividend suspensions/cancellations, caused by the Covid Pandemic and Lockdowns, have been played out. Consequently, the above [b]Y'ld (%) and Year Div (£) columns can once again be treated as a reasonable estimate.[/b]

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name         | Real P&L (£) | Event                                                            
20-Sep-19 | IBST | Ibstock      |      292.45  | Return of Capital                                                
09-Oct-19 | GNK  | Greene King  |    4,188.29  | Sale – Pending Takeover                                          
16-Jul-21 | PNN  | Pennon Group |    1,676.05  | Return of Capital - Share Consolidation                          
21-Sep-21 | BHP  | BHP Group    |      550.49  | Return of Capital                                                
16-May-22 | AV   | Aviva        |      173.70  | Return of Capital - Share Consolidation                          
01-Jun-22 | BHP  | BHP Group    |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares           
19-Jul-22 | GSK  | GSK PLC      |     -275.74  | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation
          |      |              |              |                                                                  
          |      | Total        |   £9,170.79  |

Top-Up: 12 Sep 2022

As at the close of business on Friday 09 September 2022, the amount available for re-investment was £2,414.50. This amount will be used to top-up one holding on Monday 12 September 2022.

Candidates

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

Top-Up              |      |                           |            |              |                                                       
Business            | EPIC | Company                   | Reward (%) | Decision     | Comments                                              
House Builder       | PSN  | Persimmon                 |     15.65% | Possible     | New Business Sector                                   
Mining              | BHP  | BHP Group                 |     12.34% | Disqualified | Resultant Sector Value Concentration (10.51%) too high
Mining              | RIO  | Rio Tinto                 |     10.87% | Disqualified | Resultant Sector Value Concentration (10.51%) too high
Insurance: Non-Life | DLG  | Direct Line Insurance Grp |     10.68% | Possible     | Resultant Sector Value Concentration (4.35%)          
Fund Manager        | ABDN | Abrdn PLC                 |      9.65% | Possible     | Resultant Sector Value Concentration (6.75%)          
Oil                 | WDS  | Woodside Energy Group Ltd |      9.51% | Possible     | Resultant Sector Value Concentration (7.70%)          
Fund Manager        | MNG  | M & G PLC                 |      9.02% | Possible     | Resultant Sector Value Concentration (6.75%)

Decision

Persimmon PLC (PSN)

While it is the case that PSN has the highest yield (15.65%), that is based on what has been described as “Returning Capital to the shareholders” over the past few years. In their recent results the company has stated that that particular program is now at an end. There was no indication that another similar program would be started so I believe that the high yield maybe a false indicator. I still have little handle on what the dividend is likely to be without such capital returns, but I believe that the real yield should be much less. Once again, PSN is rejected for now.

Moving down the list BHP and RIO are both disqualified, so as to avoid the resulting Business Sector Value Concentration from further breaching the limit of 10%.

The next possible candidate is …….

Direct Line Insurance Group (DLG)

The recent Half Year Results, published last month, are not the most encouraging, due I believe to a downturn in the Motor Insurance sector of the business. As Penny James, CEO of Direct Line Group commented:

https://www.investegate.co.uk/direct-li ... 00095328U/

As we announced in our 18 July trading update, uniquely complex motor market conditions during the first half, due to significant regulatory changes, heightened claims inflation and macroeconomic uncertainty, have challenged our short-term profitability.

However, the longer-term fundamentals of the business remain strong. Through pricing action, steps taken in our garage repair network and through deployment of enhanced pricing capability, we have now returned to writing at our target margins based on latest claims assumptions.

With regard to going forward, and the sustainability of the dividend, she went on to say:

We are pleased that all of our other businesses have continued to perform in line with expectations. We remain ahead of our long-term return on tangible equity target despite the challenges, demonstrating the benefit of the Group's diversification. We are announcing an interim dividend in line with 2021 and are confident in the sustainability of our regular dividends as we look ahead to the full year and beyond.

The regular dividends for 2021 were an interim of 7.6p and a final of 15.1p, giving a total of 22.7p. Taking the CEO at her word, and indeed the non-Motor related results do look good, I believe that this year’s final will be maintained, as indeed the interim has been.

We shall see ……

Insurance Non-Life – Direct Line Insurance Group PLC (DLG) – Yield 10.98% - is therefore the decision for this top-up.

The Value Concentration after purchase (1.06%) will obviously leave the Insurance – Non-Life Business Sector holding as the smallest by that measure but who knows, there may be further purchases to come.

As I am not intending to purchase DLG for any of the real portfolios under my control, the price to be applied for this virtual purchase will be the mid-price reported on the day. I shall post an update when the details of the purchase 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?f=15&t=34042

The intention is to keep this thread simply recording the events of the Portfolio during its fourth year.

Enjoy!

Ian

IanTHughes · #529396

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

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

Update 12 September 2022

Dividend Re-Investment Purchase: Transaction Details

The Dividend Re-Investment indicated in the previous post https: viewtopic.php?p=528912#p528912 has now been made as follows:

Business            | EPIC | Shares | Price (p) | Cost (£)   | Stamp (£) | Fee (£) | Total (£)  |  Yield (%)
Insurance: Non-Life | DLG  | 1,117  | 214.9000  | -2,400.43  |   -12.00  |  -1.50  | -2,413.93  |   10.56%

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 1,952.0000  |   25,044.16  |     8.67% |   -1,077.35  |    272.89  |     4,858.30  |   4,053.84  |        7.15% |    1,789.78 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,509.0000  |   10,491.91  |     3.63% |    2,132.87  |      0.00  |     1,426.36  |   3,559.23  |        6.21% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   797.6000  |   14,197.28  |     4.92% |     -800.27  |      0.00  |     2,050.56  |   1,250.29  |        4.23% |      599.86 
ITV  | ITV                       | 11,652  | 14,999.08  |    66.7600  |    7,778.88  |     2.69% |   -7,220.20  |      0.00  |     1,316.66  |  -5,903.54  |        7.49% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   536.0000  |   12,998.00  |     4.50% |   -2,000.27  |    188.30  |     1,294.96  |    -517.01  |        4.35% |      564.92 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   799.0000  |   22,068.38  |     7.64% |    7,069.06  |      0.00  |     3,579.51  |  10,648.57  |        5.53% |    1,220.80 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   154.8000  |    9,890.17  |     3.42% |   -7,506.91  |    466.39  |     3,967.81  |  -3,072.71  |        9.43% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   201.7000  |    7,069.59  |     2.45% |     -120.25  |    217.31  |       700.50  |     797.56  |        9.12% |      644.92 
AV   | Aviva                     |  3,663  | 14,970.64  |   444.8000  |   16,293.03  |     5.64% |    1,322.39  |    377.28  |     3,518.36  |   5,218.03  |        5.62% |      915.75 
DLG  | Direct Line Insurance Grp |  5,808  | 14,588.31  |   216.6000  |   12,580.12  |     4.36% |   -2,008.19  |      0.00  |       356.51  |  -1,651.68  |       10.48% |    1,318.41 
GSK  | GSK PLC                   |    752  | 11,986.74  | 1,377.6000  |   10,359.56  |     3.59% |   -1,627.18  |    122.20  |     2,390.14  |     885.16  |        3.94% |      407.96 
HLN  | Haleon PLC                |    941  |  2,723.59  |   264.0000  |    2,484.24  |     0.86% |     -239.35  |      0.00  |         0.00  |    -239.35  |        7.58% |      188.20 
BA   | BAE Systems               |  3,043  | 14,995.20  |   790.6000  |   24,057.96  |     8.33% |    9,062.76  |      0.00  |     2,592.60  |  11,655.36  |        3.24% |      779.00 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   288.3000  |   12,425.73  |     4.30% |   -2,571.38  |      0.00  |     1,426.61  |  -1,144.77  |        5.20% |      646.50 
IBST | Ibstock                   |  5,849  | 14,999.47  |   201.2000  |   11,768.19  |     4.07% |   -3,231.28  |    193.01  |     1,099.59  |  -1,938.68  |        4.13% |      485.46 
BLND | British Land Company      |  1,273  |  7,494.24  |   422.9000  |    5,383.52  |     1.86% |   -2,110.72  |      0.00  |       772.35  |  -1,338.37  |        5.18% |      279.04 
LAND | Land Securities Group     |    818  |  7,499.19  |   645.2000  |    5,277.74  |     1.83% |   -2,221.45  |     70.34  |       808.57  |  -1,342.54  |        5.98% |      315.74 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,327.5000  |   19,504.45  |     6.75% |    4,511.94  |  1,269.25  |     3,509.70  |   9,290.89  |       12.07% |    2,353.81 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 4,944.5000  |    8,553.99  |     2.96% |   -1,279.08  |    383.41  |     1,001.47  |     105.80  |       10.69% |      914.04 
SHEL | Shell                     |    457  |  9,626.22  | 2,321.5000  |   10,609.26  |     3.67% |      983.04  |     98.57  |     1,072.36  |   2,153.97  |        3.72% |      394.30 
BP   | BP                        |  1,347  |  7,496.10  |   457.8500  |    6,167.24  |     2.14% |   -1,328.86  |     69.61  |       979.86  |    -279.39  |        4.22% |      259.96 
WDS  | Woodside Energy Group Ltd |    151  |  2,565.55  | 1,998.0000  |    3,016.98  |     1.04% |      451.43  |    142.01  |         0.00  |     593.44  |        9.24% |      278.80 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |   110.5600  |   11,141.13  |     3.86% |   -3,857.35  |      0.00  |     2,716.86  |  -1,140.49  |        7.05% |      785.62 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   789.8000  |    3,032.83  |     1.05% |  -11,946.96  |      0.00  |       610.18  | -11,336.78  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  |   972.5000  |   12,798.10  |     4.43% |    2,127.51  |      0.00  |     1,800.77  |   3,928.28  |        3.96% |      507.05 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £284,992.44  |    98.66% | -£23,486.05  | £3,870.57  |               |             |        6.25% |  £17,816.53 
     | Cash Balance:             |         |            |             |       £0.57  |     0.00% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £3,870.57  |     1.34% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £288,863.58  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £44,403.50  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £3,870.57  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £9,170.79  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£23,486.05  |           |              |            |               |             |              |             
     |                           |         |            |             |              |    XIRR   |              |            |               |             |              |             
     | Total:                    |         |            |             | £288,863.58  |     3.65% |              |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  35,536.07  |      12.30% |   1,055.52  |      272.89  |       6,284.66  |     7,613.07  |        6.87% |      2,441.00 
Mining              | 24,825.58  |  28,058.44  |       9.71% |   3,232.86  |    1,652.66  |       4,511.17  |     9,396.69  |       11.65% |      3,267.85 
Weapons             | 14,995.20  |  24,057.96  |       8.33% |   9,062.76  |        0.00  |       2,592.60  |    11,655.36  |        3.24% |        779.00 
Gambling            | 14,999.32  |  22,068.38  |       7.64% |   7,069.06  |        0.00  |       3,579.51  |    10,648.57  |        5.53% |      1,220.80 
Oil                 | 19,687.87  |  19,793.48  |       6.85% |     105.61  |      310.19  |       2,052.22  |     2,468.02  |        4.71% |        933.06 
Fund Manager        | 24,586.92  |  16,959.76  |       5.87% |  -7,627.16  |      683.70  |       4,668.31  |    -2,275.15  |        9.30% |      1,577.71 
Insurance: Life     | 14,970.64  |  16,293.03  |       5.64% |   1,322.39  |      377.28  |       3,518.36  |     5,218.03  |        5.62% |        915.75 
Advertising         | 14,997.55  |  14,197.28  |       4.91% |    -800.27  |        0.00  |       2,050.56  |     1,250.29  |        4.23% |        599.86 
Banks               | 14,998.27  |  12,998.00  |       4.50% |  -2,000.27  |      188.30  |       1,294.96  |      -517.01  |        4.35% |        564.92 
Utility: Water      | 10,670.59  |  12,798.10  |       4.43% |   2,127.51  |        0.00  |       1,800.77  |     3,928.28  |        3.96% |        507.05 
Packaging           | 14,997.11  |  12,425.73  |       4.30% |  -2,571.38  |        0.00  |       1,426.61  |    -1,144.77  |        5.20% |        646.50 
Bricks              | 14,999.47  |  11,768.19  |       4.07% |  -3,231.28  |      193.01  |       1,099.59  |    -1,938.68  |        4.13% |        485.46 
Telecom: Mobile     | 14,998.48  |  11,141.13  |       3.86% |  -3,857.35  |        0.00  |       2,716.86  |    -1,140.49  |        7.05% |        785.62 
Real Estate IT      | 14,993.43  |  10,661.26  |       3.69% |  -4,332.17  |       70.34  |       1,580.92  |    -2,680.91  |        5.58% |        594.78 
Pharma              | 11,986.74  |  10,359.56  |       3.59% |  -1,627.18  |      122.20  |       2,390.14  |       885.16  |        3.94% |        407.96 
Insurance: Non-Life | 14,588.31  |  12,580.12  |       4.36% |  -2,008.19  |        0.00  |         356.51  |    -1,651.68  |       10.48% |      1,318.41 
Television          | 14,999.08  |   7,778.88  |       2.69% |  -7,220.20  |        0.00  |       1,316.66  |    -5,903.54  |        7.49% |        582.60 
Cruising            | 14,979.79  |   3,032.83  |       1.05% | -11,946.96  |        0.00  |         610.18  |   -11,336.78  |        0.00% |          0.00 
Medical Products    |  2,723.59  |   2,484.24  |       0.86% |    -239.35  |        0.00  |           0.00  |      -239.35  |        7.58% |        188.20

[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 clearly indicated otherwise.

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name         | Real P&L (£) | Event                                                            
20-Sep-19 | IBST | Ibstock      |      292.45  | Return of Capital                                                
09-Oct-19 | GNK  | Greene King  |    4,188.29  | Sale – Pending Takeover                                          
16-Jul-21 | PNN  | Pennon Group |    1,676.05  | Return of Capital - Share Consolidation                          
21-Sep-21 | BHP  | BHP Group    |      550.49  | Return of Capital                                                
16-May-22 | AV   | Aviva        |      173.70  | Return of Capital - Share Consolidation                          
01-Jun-22 | BHP  | BHP Group    |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares           
19-Jul-22 | GSK  | GSK PLC      |     -275.74  | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation
          |      |              |              |                                                                  
          |      | Total        |   £9,170.79  |

Next Actions Required

Next Dividend Re-Investment

Dividends received by this Portfolio are re-invested 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 Dividend Re-Investment timetable for the next 12 months is as follows:

Date      | Balance   | Re-Invest?
10-Oct-22 | 3,871.14  |    Y         
10-Nov-22 | 1,663.56  |    N         
12-Dec-22 | 2,340.91  |    Y         
10-Jan-23 |   984.91  |    N         
10-Feb-23 | 1,642.04  |    N         
10-Mar-23 | 1,999.99  |    N         
11-Apr-23 | 4,228.84  |    Y         
10-May-23 | 1,806.04  |    N         
12-Jun-23 | 4,827.38  |    Y         
10-Jul-23 |   944.59  |    N         
10-Aug-23 | 1,591.40  |    N         
11-Sep-23 | 2,548.68  |    Y

The next Dividend Re-Investment will therefore be on 10 October 2022 when £3,871.14 is currently forecast to be available for re-investment. At the moment, it looks as if this amount will once again be invested in increasing the holding of Direct Line Insurance Group (DLG), but there are 4 weeks to wait, during which that might change. A final decision will be made, and reported here, a couple of days before the Re-Investment is due to be made.

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?f=15&t=34042

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

Enjoy!

Ian

IanTHughes · #535755

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

Update – 08 October 2022

This is an update on the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.

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

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1]  | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 1,991.0000  |   25,544.53  |     9.39% |     -576.98  |      0.00  |     5,131.19  |   4,554.21  |        7.01% |    1,789.78 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,313.5000  |    9,907.37  |     3.64% |    1,548.33  |    162.80  |     1,426.36  |   3,137.49  |        6.57% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   757.6000  |   13,485.28  |     4.96% |   -1,512.27  |      0.00  |     2,050.56  |     538.29  |        4.45% |      599.86 
ITV  | ITV                       | 11,652  | 14,999.08  |    58.6400  |    6,832.73  |     2.51% |   -8,166.35  |      0.00  |     1,316.66  |  -6,849.69  |        8.53% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   467.0000  |   11,324.75  |     4.16% |   -3,673.52  |      0.00  |     1,486.10  |  -2,187.42  |        5.20% |      588.43 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   778.5000  |   21,502.17  |     7.91% |    6,502.85  |    862.84  |     3,579.51  |  10,945.20  |        5.68% |    1,220.80 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   133.0000  |    8,497.37  |     3.13% |   -8,899.71  |      0.00  |     4,434.20  |  -4,465.51  |       10.98% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   165.8000  |    5,811.30  |     2.14% |   -1,378.54  |      0.00  |       917.81  |    -460.73  |       11.10% |      644.92 
AV   | Aviva                     |  3,663  | 14,970.64  |   400.7000  |   14,677.64  |     5.40% |     -293.00  |      0.00  |     3,895.64  |   3,602.64  |        6.24% |      915.75 
DLG  | Direct Line Insurance Grp |  5,808  | 14,588.31  |   194.3500  |   11,287.85  |     4.15% |   -3,300.46  |      0.00  |       356.51  |  -2,943.95  |       11.68% |    1,318.41 
GSK  | GSK PLC                   |    752  | 11,986.74  | 1,342.6000  |   10,096.36  |     3.71% |   -1,890.38  |      0.00  |     2,512.34  |     621.96  |        3.65% |      368.48 
HLN  | Haleon PLC                |    941  |  2,723.59  |   279.3000  |    2,628.21  |     0.97% |      -95.38  |      0.00  |         0.00  |     -95.38  |        3.58% |       94.10 
BA   | BAE Systems               |  3,043  | 14,995.20  |   846.2000  |   25,749.87  |     9.47% |   10,754.67  |      0.00  |     2,592.60  |  13,347.27  |        3.03% |      779.00 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   241.8000  |   10,421.58  |     3.83% |   -4,575.53  |    439.62  |     1,426.61  |  -2,709.30  |        6.20% |      646.50 
IBST | Ibstock                   |  5,849  | 14,999.47  |   166.4000  |    9,732.74  |     3.58% |   -5,266.73  |      0.00  |     1,292.60  |  -3,974.13  |        4.99% |      485.46 
BLND | British Land Company      |  1,273  |  7,494.24  |   340.1000  |    4,329.47  |     1.59% |   -3,164.77  |      0.00  |       772.35  |  -2,392.42  |        6.45% |      279.04 
LAND | Land Securities Group     |    818  |  7,499.19  |   508.8000  |    4,161.98  |     1.53% |   -3,337.21  |      0.00  |       878.91  |  -2,458.30  |        7.59% |      315.74 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,322.5000  |   19,462.55  |     7.16% |    4,470.04  |      0.00  |     4,778.95  |   9,248.99  |       12.58% |    2,447.64 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 5,066.0000  |    8,764.18  |     3.22% |   -1,068.89  |      0.00  |     1,384.88  |     315.99  |       10.43% |      914.04 
SHEL | Shell                     |    457  |  9,626.22  | 2,345.5000  |   10,718.94  |     3.94% |    1,092.72  |      0.00  |     1,170.93  |   2,263.65  |        3.83% |      410.71 
BP   | BP                        |  1,347  |  7,496.10  |   469.1000  |    6,318.78  |     2.32% |   -1,177.32  |      0.00  |     1,049.47  |    -127.85  |        4.29% |      271.02 
WDS  | Woodside Energy Group Ltd |    151  |  2,565.55  | 2,034.0000  |    3,071.34  |     1.13% |      505.79  |      0.00  |       142.00  |     647.79  |        9.46% |      290.41 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |   100.5200  |   10,129.40  |     3.73% |   -4,869.08  |      0.00  |     2,716.86  |  -2,152.22  |        7.88% |      798.07 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   526.0000  |    2,019.84  |     0.74% |  -12,959.95  |      0.00  |       610.18  | -12,349.77  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  |   770.5000  |   10,139.78  |     3.73% |     -530.81  |      0.00  |     1,800.77  |   1,269.96  |        5.00% |      507.05 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £266,616.01  |    98.04% | -£41,862.48  | £1,465.26  |               |             |        6.70% |  £17,851.82 
     | Cash Balance:             |         |            |             |   £3,873.97  |     1.42% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,465.26  |     0.54% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £271,955.24  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £48,276.90  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,465.26  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     |[2]      |            |             |   £9,170.79  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£41,862.48  |           |              |            |               |             |              |             
     |                           |         |            |             |              |    XIRR   |              |            |               |             |              |             
     | Total:                    |         |            |             | £271,955.24  |   1.84%   |              |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  35,451.90  |      13.04% |     971.35  |      162.80  |       6,557.55  |     7,691.70  |        6.89% |      2,441.00 
Mining              | 24,825.58  |  28,226.73  |      10.38% |   3,401.15  |        0.00  |       6,163.83  |     9,564.98  |       11.91% |      3,361.68 
Weapons             | 14,995.20  |  25,749.87  |       9.47% |  10,754.67  |        0.00  |       2,592.60  |    13,347.27  |        3.03% |        779.00 
Gambling            | 14,999.32  |  21,502.17  |       7.91% |   6,502.85  |      862.84  |       3,579.51  |    10,945.20  |        5.68% |      1,220.80 
Oil                 | 19,687.87  |  20,109.06  |       7.39% |     421.19  |        0.00  |       2,362.40  |     2,783.59  |        4.83% |        972.14 
Fund Manager        | 24,586.92  |  14,308.67  |       5.26% | -10,278.25  |        0.00  |       5,352.01  |    -4,926.24  |       11.03% |      1,577.71 
Insurance: Life     | 14,970.64  |  14,677.64  |       5.40% |    -293.00  |        0.00  |       3,895.64  |     3,602.64  |        6.24% |        915.75 
Advertising         | 14,997.55  |  13,485.28  |       4.96% |  -1,512.27  |        0.00  |       2,050.56  |       538.29  |        4.45% |        599.86 
Banks               | 14,998.27  |  11,324.75  |       4.16% |  -3,673.52  |        0.00  |       1,486.10  |    -2,187.42  |        5.20% |        588.43 
Packaging           | 14,997.11  |  10,421.58  |       3.83% |  -4,575.53  |      439.62  |       1,426.61  |    -2,709.30  |        6.20% |        646.50 
Insurance: Non-Life | 14,588.31  |  11,287.85  |       4.15% |  -3,300.46  |        0.00  |         356.51  |    -2,943.95  |       11.68% |      1,318.41 
Utility: Water      | 10,670.59  |  10,139.78  |       3.73% |    -530.81  |        0.00  |       1,800.77  |     1,269.96  |        5.00% |        507.05 
Telecom: Mobile     | 14,998.48  |  10,129.40  |       3.72% |  -4,869.08  |        0.00  |       2,716.86  |    -2,152.22  |        7.88% |        798.07 
Bricks              | 14,999.47  |   9,732.74  |       3.58% |  -5,266.73  |        0.00  |       1,292.60  |    -3,974.13  |        4.99% |        485.46 
Pharma              | 11,986.74  |  10,096.36  |       3.71% |  -1,890.38  |        0.00  |       2,512.34  |       621.96  |        3.65% |        368.48 
Real Estate IT      | 14,993.43  |   8,491.45  |       3.12% |  -6,501.98  |        0.00  |       1,651.26  |    -4,850.72  |        7.00% |        594.78 
Television          | 14,999.08  |   6,832.73  |       2.51% |  -8,166.35  |        0.00  |       1,316.66  |    -6,849.69  |        8.53% |        582.60 
Medical Products    |  2,723.59  |   2,628.21  |       0.97% |     -95.38  |        0.00  |           0.00  |       -95.38  |        3.58% |         94.10 
Cruising            | 14,979.79  |   2,019.84  |       0.74% | -12,959.95  |        0.00  |         610.18  |   -12,349.77  |        0.00% |          0.00

[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 clearly indicated otherwise. I do now believe that the recent dividend suspensions/cancellations, caused by the Covid Pandemic and Lockdowns, have been played out. Consequently, the above [b]Y'ld (%) and Year Div (£) columns can once again be treated as a reasonable estimate.[/b]

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name         | Real P&L (£) | Event                                                            
20-Sep-19 | IBST | Ibstock      |      292.45  | Return of Capital                                                
09-Oct-19 | GNK  | Greene King  |    4,188.29  | Sale – Pending Takeover                                          
16-Jul-21 | PNN  | Pennon Group |    1,676.05  | Return of Capital - Share Consolidation                          
21-Sep-21 | BHP  | BHP Group    |      550.49  | Return of Capital                                                
16-May-22 | AV   | Aviva        |      173.70  | Return of Capital - Share Consolidation                          
01-Jun-22 | BHP  | BHP Group    |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares           
19-Jul-22 | GSK  | GSK PLC      |     -275.74  | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation
          |      |              |              |                                                                  
          |      | Total        |   £9,170.79  |

Top-Up: 10 October 2022

As at the close of business on Friday 07 October 2022, the amount available for re-investment was £3,873.97. This amount will be used to top-up one holding on Monday 10 October 2022.

Candidates

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

EPIC | Company                   | Reward (%) | Decision     | Comments                                              
PSN  | Persimmon                 |     19.33% | Possible     | New Business Sector                                   
BHP  | BHP Group                 |     12.58% | Disqualified | Resultant Sector Value Concentration (11.80%) too high
DLG  | Direct Line Insurance Grp |     11.68% | Possible     | Resultant Sector Value Concentration (5.57%)          
MNG  | M & G PLC                 |     11.10% | Possible     | Resultant Sector Value Concentration (6.68%)          
ABDN | Abrdn PLC                 |     10.98% | Possible     | Resultant Sector Value Concentration (6.68%)          
RIO  | Rio Tinto                 |     10.43% | Disqualified | Resultant Sector Value Concentration (11.80%) too high
WDS  | Woodside Energy Group Ltd |      9.46% | Possible     | Resultant Sector Value Concentration (8.81%)

Decision

Persimmon PLC (PSN)

As I stated last month:

While it is the case that PSN has the highest yield (19.33%), that is based on what has been described as “Returning Capital to the shareholders” over the past few years. In their recent results the company has stated that that particular program is now at an end. There was no indication that another similar program would be started so I believe that the high yield maybe a false indicator. I still have little handle on what the dividend is likely to be without such capital returns, but I believe that the real yield could be much less. Once again, PSN is rejected for now.

Moving down the list BHP is once again disqualified, so as to avoid the resulting Business Sector Value Concentration from further breaching the limit of 10%.

The next possible candidate is …….

Direct Line Insurance Group (DLG)

As I stated last month:

The recent Half Year Results, published last month, are not the most encouraging, due I believe to a downturn in the Motor Insurance sector of the business. As Penny James, CEO of Direct Line Group commented:

https://www.investegate.co.uk/direct-li ... 00095328U/

As we announced in our 18 July trading update, uniquely complex motor market conditions during the first half, due to significant regulatory changes, heightened claims inflation and macroeconomic uncertainty, have challenged our short-term profitability.

However, the longer-term fundamentals of the business remain strong. Through pricing action, steps taken in our garage repair network and through deployment of enhanced pricing capability, we have now returned to writing at our target margins based on latest claims assumptions.

With regard to going forward, and the sustainability of the dividend, she went on to say:
We are pleased that all of our other businesses have continued to perform in line with expectations. We remain ahead of our long-term return on tangible equity target despite the challenges, demonstrating the benefit of the Group's diversification. We are announcing an interim dividend in line with 2021 and are confident in the sustainability of our regular dividends as we look ahead to the full year and beyond.

The regular dividends for 2021 were an interim of 7.6p and a final of 15.1p, giving a total of 22.7p. Taking the CEO at her word, and indeed the non-Motor related results do look good, I believe that this year’s final will be maintained, as indeed the interim has been.

We shall see ……

Insurance Non-Life – Direct Line Insurance Group PLC (DLG) – Yield 11.68% - is therefore the decision for this top-up.

The Value Concentration after purchase (5.57%) will leave the Insurance – Non-Life Business Sector holding halfway up the list by that measure, well below the maximum allowed – 10% - but who knows, there may be further purchases to come.

As I am not intending to purchase DLG for any of the real portfolios under my control, the price to be applied for this virtual purchase will be the mid-price reported on the day. I shall post an update when the details of the purchase 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?f=15&t=34042

The intention is to keep this thread simply recording the events of the Portfolio during its fourth year.

Enjoy!

Ian

IanTHughes · #536358

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

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

Update 10 October 2022

Dividend Re-Investment Purchase: Transaction Details

The Dividend Re-Investment indicated in the previous post https: viewtopic.php?f=15&t=34041&p=535755#p535755 has now been made as follows:

Business            | EPIC | Shares | Price (p) | Cost (£)   | Stamp (£) | Fee (£) | Total (£)  |  Yield (%)
Insurance: Non-Life | DLG  | 1,981  | 194.4310  | -3,851.68  |  -19.26   |  -1.50  | -3,872.44  |   11.68%

In the end, I did purchase some DLG for one of my “real” portfolios, so the price logged above is the same as I received from my broker.

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 2,006.0000  |   25,736.98  |     9.44% |     -384.53  |      0.00  |     5,131.19  |   4,746.66  |        6.95% |    1,789.78 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,319.0000  |    9,923.81  |     3.64% |    1,564.77  |    162.80  |     1,426.36  |   3,153.93  |        6.56% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   759.8000  |   13,524.44  |     4.96% |   -1,473.11  |      0.00  |     2,050.56  |     577.45  |        4.44% |      599.86 
ITV  | ITV                       | 11,652  | 14,999.08  |    59.8200  |    6,970.23  |     2.56% |   -8,028.85  |      0.00  |     1,316.66  |  -6,712.19  |        8.36% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   462.7500  |   11,221.69  |     4.12% |   -3,776.58  |      0.00  |     1,486.10  |  -2,290.48  |        5.24% |      588.32 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   774.5000  |   21,391.69  |     7.84% |    6,392.37  |    862.84  |     3,579.51  |  10,834.72  |        5.71% |    1,220.80 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   135.5000  |    8,657.10  |     3.18% |   -8,739.98  |      0.00  |     4,434.20  |  -4,305.78  |       10.77% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   170.5500  |    5,977.78  |     2.19% |   -1,212.06  |      0.00  |       917.81  |    -294.25  |       10.79% |      644.92 
AV   | Aviva                     |  3,663  | 14,970.64  |   400.4000  |   14,666.65  |     5.38% |     -303.99  |      0.00  |     3,895.64  |   3,591.65  |        6.24% |      915.75 
DLG  | Direct Line Insurance Grp |  7,789  | 18,460.75  |   193.1500  |   15,044.46  |     5.52% |   -3,416.29  |      0.00  |       356.51  |  -3,059.78  |       11.75% |    1,768.10 
GSK  | GSK PLC                   |    752  | 11,986.74  | 1,346.0000  |   10,121.92  |     3.71% |   -1,864.82  |      0.00  |     2,512.34  |     647.52  |        3.64% |      368.48 
HLN  | Haleon PLC                |    941  |  2,723.59  |   271.1500  |    2,551.52  |     0.94% |     -172.07  |      0.00  |         0.00  |    -172.07  |        3.69% |       94.10 
BA   | BAE Systems               |  3,043  | 14,995.20  |   837.6000  |   25,488.17  |     9.35% |   10,492.97  |      0.00  |     2,592.60  |  13,085.57  |        3.06% |      779.00 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   271.1000  |   11,684.41  |     4.29% |   -3,312.70  |    439.62  |     1,426.61  |  -1,446.47  |        5.53% |      646.50 
IBST | Ibstock                   |  5,849  | 14,999.47  |   164.5000  |    9,621.61  |     3.53% |   -5,377.86  |      0.00  |     1,292.60  |  -4,085.26  |        5.05% |      485.46 
BLND | British Land Company      |  1,273  |  7,494.24  |   335.5000  |    4,270.92  |     1.57% |   -3,223.32  |      0.00  |       772.35  |  -2,450.97  |        6.53% |      279.04 
LAND | Land Securities Group     |    818  |  7,499.19  |   504.8000  |    4,129.26  |     1.51% |   -3,369.93  |      0.00  |       878.91  |  -2,491.02  |        7.65% |      315.74 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,317.5000  |   19,420.65  |     7.12% |    4,428.14  |      0.00  |     4,778.95  |   9,207.09  |       12.60% |    2,447.20 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 5,120.0000  |    8,857.60  |     3.25% |     -975.47  |      0.00  |     1,384.88  |     409.41  |       10.32% |      914.04 
SHEL | Shell                     |    457  |  9,626.22  | 2,327.5000  |   10,636.68  |     3.90% |    1,010.46  |      0.00  |     1,170.93  |   2,181.39  |        3.86% |      410.63 
BP   | BP                        |  1,347  |  7,496.10  |   462.4500  |    6,229.20  |     2.28% |   -1,266.90  |      0.00  |     1,049.47  |    -217.43  |        4.35% |      270.98 
WDS  | Woodside Energy Group Ltd |    151  |  2,565.55  | 1,964.0000  |    2,965.64  |     1.09% |      400.09  |      0.00  |       142.00  |     542.09  |        9.79% |      290.35 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |   101.4800  |   10,226.14  |     3.75% |   -4,772.34  |      0.00  |     2,716.86  |  -2,055.48  |        7.80% |      797.15 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   501.4000  |    1,925.38  |     0.71% |  -13,054.41  |      0.00  |       610.18  | -12,444.23  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  |   759.0000  |    9,988.44  |     3.66% |     -682.15  |      0.00  |     1,800.77  |   1,118.62  |        5.08% |      507.05 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £271,232.37  |    99.46% | -£41,118.56  | £1,465.26  |               |             |        6.75% |  £18,299.86 
     | Cash Balance:             |         |            |             |       £1.53  |     0.00% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,465.26  |     0.54% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £272,699.16  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £48,276.90  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,465.26  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     |[2]      |            |             |   £9,170.79  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£41,118.56  |           |              |            |               |             |              |             
     |                           |         |            |             |              |   XIRR    |              |            |               |             |              |             
     | Total:                    |         |            |             | £272,699.16  |   1.91%   |              |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  35,660.79  |      13.08% |   1,180.24  |      162.80  |       6,557.55  |     7,900.59  |        6.85% |      2,441.00 
Mining              | 24,825.58  |  28,278.25  |      10.37% |   3,452.67  |        0.00  |       6,163.83  |     9,616.50  |       11.89% |      3,361.24 
Weapons             | 14,995.20  |  25,488.17  |       9.35% |  10,492.97  |        0.00  |       2,592.60  |    13,085.57  |        3.06% |        779.00 
Gambling            | 14,999.32  |  21,391.69  |       7.84% |   6,392.37  |      862.84  |       3,579.51  |    10,834.72  |        5.71% |      1,220.80 
Oil                 | 19,687.87  |  19,831.52  |       7.27% |     143.65  |        0.00  |       2,362.40  |     2,506.05  |        4.90% |        971.96 
Insurance: Non-Life | 18,460.75  |  15,044.46  |       5.52% |  -3,416.29  |        0.00  |         356.51  |    -3,059.78  |       11.75% |      1,768.10 
Insurance: Life     | 14,970.64  |  14,666.65  |       5.38% |    -303.99  |        0.00  |       3,895.64  |     3,591.65  |        6.24% |        915.75 
Fund Manager        | 24,586.92  |  14,634.88  |       5.37% |  -9,952.04  |        0.00  |       5,352.01  |    -4,600.03  |       10.78% |      1,577.71 
Advertising         | 14,997.55  |  13,524.44  |       4.96% |  -1,473.11  |        0.00  |       2,050.56  |       577.45  |        4.44% |        599.86 
Packaging           | 14,997.11  |  11,684.41  |       4.28% |  -3,312.70  |      439.62  |       1,426.61  |    -1,446.47  |        5.53% |        646.50 
Banks               | 14,998.27  |  11,221.69  |       4.12% |  -3,776.58  |        0.00  |       1,486.10  |    -2,290.48  |        5.24% |        588.32 
Telecom: Mobile     | 14,998.48  |  10,226.14  |       3.75% |  -4,772.34  |        0.00  |       2,716.86  |    -2,055.48  |        7.80% |        797.15 
Utility: Water      | 10,670.59  |   9,988.44  |       3.66% |    -682.15  |        0.00  |       1,800.77  |     1,118.62  |        5.08% |        507.05 
Pharma              | 11,986.74  |  10,121.92  |       3.71% |  -1,864.82  |        0.00  |       2,512.34  |       647.52  |        3.64% |        368.48 
Bricks              | 14,999.47  |   9,621.61  |       3.53% |  -5,377.86  |        0.00  |       1,292.60  |    -4,085.26  |        5.05% |        485.46 
Real Estate IT      | 14,993.43  |   8,400.18  |       3.08% |  -6,593.25  |        0.00  |       1,651.26  |    -4,941.99  |        7.08% |        594.78 
Television          | 14,999.08  |   6,970.23  |       2.56% |  -8,028.85  |        0.00  |       1,316.66  |    -6,712.19  |        8.36% |        582.60 
Medical Products    |  2,723.59  |   2,551.52  |       0.94% |    -172.07  |        0.00  |           0.00  |      -172.07  |        3.69% |         94.10 
Cruising            | 14,979.79  |   1,925.38  |       0.71% | -13,054.41  |        0.00  |         610.18  |   -12,444.23  |        0.00% |          0.00

[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 clearly indicated otherwise.

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name         | Real P&L (£) | Event                                                            
20-Sep-19 | IBST | Ibstock      |      292.45  | Return of Capital                                                
09-Oct-19 | GNK  | Greene King  |    4,188.29  | Sale – Pending Takeover                                          
16-Jul-21 | PNN  | Pennon Group |    1,676.05  | Return of Capital - Share Consolidation                          
21-Sep-21 | BHP  | BHP Group    |      550.49  | Return of Capital                                                
16-May-22 | AV   | Aviva        |      173.70  | Return of Capital - Share Consolidation                          
01-Jun-22 | BHP  | BHP Group    |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares           
19-Jul-22 | GSK  | GSK PLC      |     -275.74  | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation
          |      |              |              |                                                                  
          |      | Total        |   £9,170.79  |

Next Actions Required

Next Dividend Re-Investment

Dividends received by this Portfolio are re-invested 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 Dividend Re-Investment timetable for the next 12 months is as follows:

Date      | Balance   | Re-Invest?
10-Nov-22 | 1,570.99  |      N         
12-Dec-22 | 2,248.34  |      Y         
10-Jan-23 |   991.62  |      N         
10-Feb-23 | 1,654.51  |      N         
10-Mar-23 | 2,012.46  |      Y         
11-Apr-23 | 2,286.16  |      Y         
10-May-23 | 1,821.64  |      N         
12-Jun-23 | 5,142.11  |      Y         
10-Jul-23 |   857.20  |      N         
10-Aug-23 | 1,509.77  |      N         
11-Sep-23 | 2,617.61  |      Y         
10-Oct-23 | 3,900.45  |      Y

The next Dividend Re-Investment will therefore be on 12 December 2022 when £2,248.34 is currently forecast to be available for re-investment. At the moment, it looks as if this amount will once again be invested in increasing the holding of Direct Line Insurance Group (DLG), but there are nine weeks to wait, during which that might change.

As usual, a final decision will be made, and reported here, a couple of days before the Re-Investment is due to be made.

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?f=15&t=34042

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

Enjoy!

Ian

IanTHughes · #542229

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

This is an update on the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.

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

Year Four: Update - 30 October 2022

Woodside Energy Group Ltd (WDS): Return of Capital – 24 October 2022 - Update

On 24 October 2022, the cash due from the sale of the Fractional Leftover from the Woodside Energy Group Ltd (WDS) newly issued shares, as a result of the surrender of BHP Ltd (BHP) shares, was paid out. The price realised for these leftover shares, which I have calculated from the actual amounts received in my “real” portfolios, was 1,906.5226p, meaning that the details of the Fractional Share sale for this “virtual” portfolio, can be calculated as follows:

BHP Holding (#) | BHP Shares (#) | WDS Shares (#) | New WDS Holding (#) | Fraction Leftover (#) | Sale Price (p) | Fraction Value (£)
       838      |     5.5340     |        1       |          151        |         0.4275        |  1,906.5226    |       8.15

An amount of £8.15, logged as a Return of Capital, has therefore been credited to the portfolio’s Cash Balance.

Next Actions Required

Dividend Re-Investment:: 12 December 2022

A report on the share selected for the Top-Up due on 12 December 2022, will be made a couple of days before that date, with a report of the actual purchase being made on the purchase date, or soon after.

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?f=15&t=34042

The intention is to keep this thread simply recording the events of the Portfolio during its fourth year.

Enjoy!

Ian

IanTHughes · #553866

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

Top-Up Decision – 10 December 2022

This is an update on the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.

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

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 2,077.0000  |   26,647.91  |     8.98% |      526.40  |    632.64  |     5,131.19  |   6,290.23  |        6.80% |    1,811.21 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,316.0000  |    9,914.84  |     3.34% |    1,555.80  |      0.00  |     1,589.16  |   3,144.96  |        6.57% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   840.0000  |   14,952.00  |     5.04% |      -45.55  |      0.00  |     2,317.56  |   2,272.01  |        4.01% |      599.86 
ITV  | ITV                       | 11,652  | 14,999.08  |    75.5600  |    8,804.25  |     2.97% |   -6,194.83  |      0.00  |     1,514.74  |  -4,680.09  |        6.62% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   496.2000  |   12,032.85  |     4.05% |   -2,965.42  |      0.00  |     1,486.10  |  -1,479.32  |        4.43% |      532.96 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   805.0000  |   22,234.10  |     7.49% |    7,234.78  |      0.00  |     4,442.35  |  11,677.13  |        5.49% |    1,220.80 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   185.2000  |   11,832.43  |     3.99% |   -5,564.65  |      0.00  |     4,434.20  |  -1,130.45  |        7.88% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   183.9500  |    6,447.45  |     2.17% |     -742.39  |      0.00  |       917.81  |     175.42  |       10.00% |      644.92 
AV   | Aviva                     |  3,663  | 14,970.64  |   448.0000  |   16,410.24  |     5.53% |    1,439.60  |      0.00  |     3,895.64  |   5,335.24  |        6.92% |    1,135.53 
DLG  | Direct Line Insurance Grp |  7,789  | 18,460.75  |   205.0000  |   15,967.45  |     5.38% |   -2,493.30  |      0.00  |       356.51  |  -2,136.79  |       11.07% |    1,768.10 
GSK  | GSK PLC                   |    752  | 11,986.74  | 1,457.8000  |   10,962.66  |     3.69% |   -1,024.08  |    103.40  |     2,512.34  |   1,591.66  |        4.20% |      460.60 
HLN  | Haleon PLC                |    941  |  2,723.59  |   314.6000  |    2,960.39  |     1.00% |      236.80  |      0.00  |         0.00  |     236.80  |        3.18% |       94.10 
BA   | BAE Systems               |  3,043  | 14,995.20  |   825.6000  |   25,123.01  |     8.47% |   10,127.81  |      0.00  |     2,909.07  |  13,036.88  |        3.10% |      779.00 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   327.7000  |   14,123.87  |     4.76% |     -873.24  |      0.00  |     1,866.23  |     992.99  |        5.49% |      775.80 
IBST | Ibstock                   |  5,849  | 14,999.47  |   155.8000  |    9,112.74  |     3.07% |   -5,886.73  |      0.00  |     1,292.60  |  -4,594.13  |        5.33% |      485.46 
BLND | British Land Company      |  1,273  |  7,494.24  |   396.6000  |    5,048.72  |     1.70% |   -2,445.52  |    147.66  |       772.35  |  -1,525.51  |        5.85% |      295.33 
LAND | Land Securities Group     |    818  |  7,499.19  |   626.6000  |    5,125.59  |     1.73% |   -2,373.60  |     73.62  |       878.91  |  -1,421.07  |        6.24% |      319.83 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,634.0000  |   22,072.92  |     7.44% |    7,080.41  |      0.00  |     4,778.95  |  11,859.36  |       10.04% |    2,216.93 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 5,835.0000  |   10,094.55  |     3.40% |      261.48  |      0.00  |     1,384.88  |   1,646.36  |        9.05% |      914.04 
SHEL | Shell                     |    457  |  9,626.22  | 2,286.0000  |   10,447.02  |     3.52% |      820.80  |     94.18  |     1,170.93  |   2,085.91  |        3.97% |      415.03 
BP   | BP                        |  1,347  |  7,496.10  |   461.9500  |    6,222.47  |     2.10% |   -1,273.63  |     66.54  |     1,049.47  |    -157.62  |        4.24% |      264.09 
WDS  | Woodside Energy Group Ltd |    151  |  2,565.55  | 1,884.0000  |    2,844.84  |     0.96% |      279.29  |      0.00  |       142.00  |     421.29  |        9.25% |      263.03 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |    86.7500  |    8,741.80  |     2.95% |   -6,256.68  |    388.94  |     2,716.86  |  -3,150.88  |        8.90% |      777.88 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   655.0000  |    2,515.20  |     0.85% |  -12,464.59  |      0.00  |       610.18  | -11,854.41  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  |   941.5000  |   12,390.14  |     4.18% |    1,719.55  |      0.00  |     1,800.77  |   3,520.32  |        4.46% |      552.19 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £293,029.44  |    98.73% | -£19,321.49  | £1,506.98  |               |             |        6.31% |  £18,493.30 
     | Cash Balance:             |         |            |             |   £2,256.49  |     0.76% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,506.98  |     0.51% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £296,792.91  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £50,523.71  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,506.98  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £9,178.94  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£19,321.49  |           |              |            |               |             |              |             
     |                           |         |            |             |              | XIRR      |              |            |               |             |              |             
     | Total:                    |         |            |             | £296,792.91  |     4.16% |              |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  36,562.75  |      12.32% |   2,082.20  |      632.64  |       6,720.35  |     9,435.19  |        6.73% |      2,462.43 
Mining              | 24,825.58  |  32,167.47  |      10.84% |   7,341.89  |        0.00  |       6,163.83  |    13,505.72  |        9.73% |      3,130.97 
Weapons             | 14,995.20  |  25,123.01  |       8.46% |  10,127.81  |        0.00  |       2,909.07  |    13,036.88  |        3.10% |        779.00 
Gambling            | 14,999.32  |  22,234.10  |       7.49% |   7,234.78  |        0.00  |       4,442.35  |    11,677.13  |        5.49% |      1,220.80 
Oil                 | 19,687.87  |  19,514.33  |       6.58% |    -173.54  |      160.72  |       2,362.40  |     2,349.58  |        4.83% |        942.15 
Fund Manager        | 24,586.92  |  18,279.88  |       6.16% |  -6,307.04  |        0.00  |       5,352.01  |      -955.03  |        8.63% |      1,577.71 
Insurance: Life     | 14,970.64  |  16,410.24  |       5.53% |   1,439.60  |        0.00  |       3,895.64  |     5,335.24  |        6.92% |      1,135.53 
Insurance: Non-Life | 18,460.75  |  15,967.45  |       5.38% |  -2,493.30  |        0.00  |         356.51  |    -2,136.79  |       11.07% |      1,768.10 
Advertising         | 14,997.55  |  14,952.00  |       5.04% |     -45.55  |        0.00  |       2,317.56  |     2,272.01  |        4.01% |        599.86 
Packaging           | 14,997.11  |  14,123.87  |       4.76% |    -873.24  |        0.00  |       1,866.23  |       992.99  |        5.49% |        775.80 
Utility: Water      | 10,670.59  |  12,390.14  |       4.17% |   1,719.55  |        0.00  |       1,800.77  |     3,520.32  |        4.46% |        552.19 
Banks               | 14,998.27  |  12,032.85  |       4.05% |  -2,965.42  |        0.00  |       1,486.10  |    -1,479.32  |        4.43% |        532.96 
Pharma              | 11,986.74  |  10,962.66  |       3.69% |  -1,024.08  |      103.40  |       2,512.34  |     1,591.66  |        4.20% |        460.60 
Real Estate IT      | 14,993.43  |  10,174.31  |       3.43% |  -4,819.12  |      221.28  |       1,651.26  |    -2,946.58  |        6.05% |        615.16 
Bricks              | 14,999.47  |   9,112.74  |       3.07% |  -5,886.73  |        0.00  |       1,292.60  |    -4,594.13  |        5.33% |        485.46 
Television          | 14,999.08  |   8,804.25  |       2.97% |  -6,194.83  |        0.00  |       1,514.74  |    -4,680.09  |        6.62% |        582.60 
Telecom: Mobile     | 14,998.48  |   8,741.80  |       2.95% |  -6,256.68  |      388.94  |       2,716.86  |    -3,150.88  |        8.90% |        777.88 
Medical Products    |  2,723.59  |   2,960.39  |       1.00% |     236.80  |        0.00  |           0.00  |       236.80  |        3.18% |         94.10 
Cruising            | 14,979.79  |   2,515.20  |       0.85% | -12,464.59  |        0.00  |         610.18  |   -11,854.41  |        0.00% |          0.00

[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 clearly indicated otherwise. I do now believe that the recent dividend suspensions/cancellations, caused by the Covid Pandemic and Lockdowns, have been played out. Consequently, the above [b]Y'ld (%) and Year Div (£) columns can once again be treated as a reasonable estimate.[/b]

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name                      | Real P&L (£) | Comment                                                                     
20-Sep-19 | IBST | Ibstock                   |      292.45  | Return of Capital                                                           
09-Oct-19 | GNK  | Greene King               |    4,188.29  | Sale – Pending Takeover                                                     
16-Jul-21 | PNN  | Pennon Group              |    1,676.05  | Return of Capital - Share Consolidation                                     
21-Sep-21 | BHP  | BHP Group                 |      550.49  | Return of Capital                                                           
16-May-22 | AV   | Aviva                     |      173.70  | Return of Capital - Share Consolidation                                     
01-Jun-22 | BHP  | BHP Group                 |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares                      
19-Jul-22 | GSK  | GSK PLC                   |     -275.74  | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation           
19-Jul-22 | WDS  | Woodside Energy Group Ltd |        8.15  | Return of Capital - Woodside Energy Group (WDS) shares - Share Consolidation
          |      |                           |              |                                                                             
          |      | Total                     |   £9,178.94  |

Top-Up: 10 October 2022

As at the close of business on Friday 09 December 2022, the amount available for re-investment was £2,256.49. This amount will be used to top-up one holding on Monday 12 December 2022.

Candidates

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

EPIC | Company                   | Reward (%) | Decision     | Comments                                              
PSN  | Persimmon                 |     18.33% | Possible     | New Business Sector                                   
DLG  | Direct Line Insurance Grp |     11.07% | Possible     | Resultant Sector Value Concentration (6.14%)          
BHP  | BHP Group                 |     10.04% | Disqualified | Resultant Sector Value Concentration (11.59%) too high
MNG  | M & G PLC                 |     10.00% | Possible     | Resultant Sector Value Concentration (6.92%)          
WDS  | Woodside Energy Group Ltd |      9.25% | Possible     | Resultant Sector Value Concentration (7.33%)          
RIO  | Rio Tinto                 |      9.05% | Disqualified | Resultant Sector Value Concentration (11.59%) too high

Decision

Persimmon PLC (PSN)

As I stated last month:

While it is the case that PSN has the highest yield (19.33%), that is based on what has been described as “Returning Capital to the shareholders” over the past few years. In their recent results the company has stated that that particular program is now at an end. There was no indication that another similar program would be started so I believe that the high yield maybe a false indicator. I still have little handle on what the dividend is likely to be without such capital returns, but I believe that the real yield could be much less. Once again, PSN is rejected for now.

The next possible candidate is …….

Direct Line Insurance Group (DLG)

As I stated before the last two re-investment decisions:

The recent Half Year Results, published last month, are not the most encouraging, due I believe to a downturn in the Motor Insurance sector of the business. As Penny James, CEO of Direct Line Group commented:

https://www.investegate.co.uk/direct-li ... 00095328U/

As we announced in our 18 July trading update, uniquely complex motor market conditions during the first half, due to significant regulatory changes, heightened claims inflation and macroeconomic uncertainty, have challenged our short-term profitability.

However, the longer-term fundamentals of the business remain strong. Through pricing action, steps taken in our garage repair network and through deployment of enhanced pricing capability, we have now returned to writing at our target margins based on latest claims assumptions.

With regard to going forward, and the sustainability of the dividend, she went on to say:
We are pleased that all of our other businesses have continued to perform in line with expectations. We remain ahead of our long-term return on tangible equity target despite the challenges, demonstrating the benefit of the Group's diversification. We are announcing an interim dividend in line with 2021 and are confident in the sustainability of our regular dividends as we look ahead to the full year and beyond.

The regular dividends for 2021 were an interim of 7.6p and a final of 15.1p, giving a total of 22.7p. Taking the CEO at her word, and indeed the non-Motor related results do look good, I believe that this year’s final will be maintained, as indeed the interim has been.

We shall see ……

Insurance Non-Life – Direct Line Insurance Group PLC (DLG) – Yield 11.68% - is therefore the decision for this top-up.

The Value Concentration after purchase (6.14%) will leave the Insurance – Non-Life Business Sector holding as number seven by that measure, well below the maximum allowed – 10% - but who knows, there may be further purchases to come.

As I am not intending to purchase DLG for any of the “real” portfolios under my control, the price to be applied for this “virtual” purchase will be the mid-price reported on the day. I shall post an update when the details of the purchase 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?f=15&t=34042

The intention is to keep this thread simply recording the events of the Portfolio during its fourth year.

Enjoy!

Ian

IanTHughes · #554459

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

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

Update 12 December 2022

Dividend Re-Investment Purchase: Transaction Details

The Dividend Re-Investment indicated in the previous post https: viewtopic.php?f=15&t=34041&p=535755#p535755 has now been made as follows:

Business            | EPIC | Shares | Price (p)  | Cost (£)   | Stamp (£) | Fee (£) | Total (£)  |  Yield (%)
Insurance: Non-Life | DLG  | 1,093  | 205.22505  | -2,243.11  |  -11.22   |  -1.50  | -2,255.83  |   11.06%

The price achieved is the average of the High and Low Price for the day

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 2,062.0000  |   26,455.46  |     8.98% |      333.95  |    632.64  |     5,131.19  |   6,097.78  |        6.85% |    1,811.21 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,309.0000  |    9,893.91  |     3.36% |    1,534.87  |      0.00  |     1,589.16  |   3,124.03  |        6.58% |      651.22 
WPP  | WPP                       |  1,780  | 14,997.55  |   825.0000  |   14,685.00  |     4.99% |     -312.55  |      0.00  |     2,317.56  |   2,005.01  |        4.08% |      599.86 
ITV  | ITV                       | 11,652  | 14,999.08  |    74.0400  |    8,627.14  |     2.93% |   -6,371.94  |      0.00  |     1,514.74  |  -4,857.20  |        6.75% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   495.8500  |   12,024.36  |     4.08% |   -2,973.91  |      0.00  |     1,486.10  |  -1,487.81  |        4.43% |      532.96 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   803.5000  |   22,192.67  |     7.54% |    7,193.35  |      0.00  |     4,442.35  |  11,635.70  |        5.50% |    1,220.80 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   185.8000  |   11,870.76  |     4.03% |   -5,526.32  |      0.00  |     4,434.20  |  -1,092.12  |        7.86% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   182.6500  |    6,401.89  |     2.17% |     -787.95  |      0.00  |       917.81  |     129.86  |       10.07% |      644.92 
AV   | Aviva                     |  3,663  | 14,970.64  |   444.0000  |   16,263.72  |     5.52% |    1,293.08  |      0.00  |     3,895.64  |   5,188.72  |        6.98% |    1,135.53 
DLG  | Direct Line Insurance Grp |  8,882  | 20,716.58  |   204.2000  |   18,137.04  |     6.16% |   -2,579.54  |      0.00  |       356.51  |  -2,223.03  |       11.12% |    2,016.21 
GSK  | GSK PLC                   |    752  | 11,986.74  | 1,439.2000  |   10,822.78  |     3.67% |   -1,163.96  |    103.40  |     2,512.34  |   1,451.78  |        4.26% |      460.60 
HLN  | Haleon PLC                |    941  |  2,723.59  |   317.7000  |    2,989.56  |     1.02% |      265.97  |      0.00  |         0.00  |     265.97  |        3.15% |       94.10 
BA   | BAE Systems               |  3,043  | 14,995.20  |   837.6000  |   25,488.17  |     8.65% |   10,492.97  |      0.00  |     2,909.07  |  13,402.04  |        3.06% |      779.00 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   320.3000  |   13,804.93  |     4.69% |   -1,192.18  |      0.00  |     1,866.23  |     674.05  |        5.62% |      775.80 
IBST | Ibstock                   |  5,849  | 14,999.47  |   155.5000  |    9,095.20  |     3.09% |   -5,904.27  |      0.00  |     1,292.60  |  -4,611.67  |        5.34% |      485.46 
BLND | British Land Company      |  1,273  |  7,494.24  |   387.4000  |    4,931.60  |     1.67% |   -2,562.64  |    147.66  |       772.35  |  -1,642.63  |        5.99% |      295.33 
LAND | Land Securities Group     |    818  |  7,499.19  |   615.2000  |    5,032.34  |     1.71% |   -2,466.85  |     73.62  |       878.91  |  -1,514.32  |        6.36% |      319.83 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,569.0000  |   21,528.22  |     7.31% |    6,535.71  |      0.00  |     4,778.95  |  11,314.66  |       10.30% |    2,216.93 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 5,739.0000  |    9,928.47  |     3.37% |       95.40  |      0.00  |     1,384.88  |   1,480.28  |        9.21% |      914.04 
SHEL | Shell                     |    457  |  9,626.22  | 2,277.0000  |   10,405.89  |     3.53% |      779.67  |     94.18  |     1,170.93  |   2,044.78  |        3.99% |      415.03 
BP   | BP                        |  1,347  |  7,496.10  |   457.8000  |    6,166.57  |     2.09% |   -1,329.53  |     66.54  |     1,049.47  |    -213.52  |        4.28% |      264.09 
WDS  | Woodside Energy Group Ltd |    151  |  2,565.55  | 1,931.0000  |    2,915.81  |     0.99% |      350.26  |      0.00  |       142.00  |     492.26  |        9.02% |      263.03 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |    86.7460  |    8,741.39  |     2.97% |   -6,257.09  |    388.94  |     2,716.86  |  -3,151.29  |        8.90% |      777.88 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   638.1097  |    2,450.34  |     0.83% |  -12,529.45  |      0.00  |       610.18  | -11,919.27  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  |   925.5000  |   12,179.58  |     4.14% |    1,508.99  |      0.00  |     1,800.77  |   3,309.76  |        4.53% |      552.19 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £293,032.80  |    99.49% | -£21,573.96  | £1,506.98  |               |             |        6.40% |  £18,741.41 
     | Cash Balance:             |         |            |             |       £0.66  |     0.00% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,506.98  |     0.51% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £294,540.44  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £50,523.71  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,506.98  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £9,178.94  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£21,573.96  |           |              |            |               |             |              |             
     |                           |         |            |             |              | XIRR      |              |            |               |             |              |             
     | Total:                    |         |            |             | £294,540.44  |     3.94% |              |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  36,349.37  |      12.34% |   1,868.82  |      632.64  |       6,720.35  |     9,221.81  |        6.77% |      2,462.43 
Mining              | 24,825.58  |  31,456.69  |      10.68% |   6,631.11  |        0.00  |       6,163.83  |    12,794.94  |        9.95% |      3,130.97 
Weapons             | 14,995.20  |  25,488.17  |       8.65% |  10,492.97  |        0.00  |       2,909.07  |    13,402.04  |        3.06% |        779.00 
Gambling            | 14,999.32  |  22,192.67  |       7.53% |   7,193.35  |        0.00  |       4,442.35  |    11,635.70  |        5.50% |      1,220.80 
Oil                 | 19,687.87  |  19,488.27  |       6.62% |    -199.60  |      160.72  |       2,362.40  |     2,323.52  |        4.83% |        942.15 
Fund Manager        | 24,586.92  |  18,272.65  |       6.20% |  -6,314.27  |        0.00  |       5,352.01  |      -962.26  |        8.63% |      1,577.71 
Insurance: Non-Life | 20,716.58  |  18,137.04  |       6.16% |  -2,579.54  |        0.00  |         356.51  |    -2,223.03  |       11.12% |      2,016.21 
Insurance: Life     | 14,970.64  |  16,263.72  |       5.52% |   1,293.08  |        0.00  |       3,895.64  |     5,188.72  |        6.98% |      1,135.53 
Advertising         | 14,997.55  |  14,685.00  |       4.99% |    -312.55  |        0.00  |       2,317.56  |     2,005.01  |        4.08% |        599.86 
Packaging           | 14,997.11  |  13,804.93  |       4.69% |  -1,192.18  |        0.00  |       1,866.23  |       674.05  |        5.62% |        775.80 
Utility: Water      | 10,670.59  |  12,179.58  |       4.14% |   1,508.99  |        0.00  |       1,800.77  |     3,309.76  |        4.53% |        552.19 
Banks               | 14,998.27  |  12,024.36  |       4.08% |  -2,973.91  |        0.00  |       1,486.10  |    -1,487.81  |        4.43% |        532.96 
Pharma              | 11,986.74  |  10,822.78  |       3.67% |  -1,163.96  |      103.40  |       2,512.34  |     1,451.78  |        4.26% |        460.60 
Real Estate IT      | 14,993.43  |   9,963.94  |       3.38% |  -5,029.49  |      221.28  |       1,651.26  |    -3,156.95  |        6.17% |        615.16 
Bricks              | 14,999.47  |   9,095.20  |       3.09% |  -5,904.27  |        0.00  |       1,292.60  |    -4,611.67  |        5.34% |        485.46 
Telecom: Mobile     | 14,998.48  |   8,741.39  |       2.97% |  -6,257.09  |      388.94  |       2,716.86  |    -3,151.29  |        8.90% |        777.88 
Television          | 14,999.08  |   8,627.14  |       2.93% |  -6,371.94  |        0.00  |       1,514.74  |    -4,857.20  |        6.75% |        582.60 
Medical Products    |  2,723.59  |   2,989.56  |       1.01% |     265.97  |        0.00  |           0.00  |       265.97  |        3.15% |         94.10 
Cruising            | 14,979.79  |   2,450.34  |       0.83% | -12,529.45  |        0.00  |         610.18  |   -11,919.27  |        0.00% |          0.00

[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 clearly indicated otherwise.

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name                      | Real P&L (£) | Comment                                                                     
20-Sep-19 | IBST | Ibstock                   |      292.45  | Return of Capital                                                           
09-Oct-19 | GNK  | Greene King               |    4,188.29  | Sale – Pending Takeover                                                     
16-Jul-21 | PNN  | Pennon Group              |    1,676.05  | Return of Capital - Share Consolidation                                     
21-Sep-21 | BHP  | BHP Group                 |      550.49  | Return of Capital                                                           
16-May-22 | AV   | Aviva                     |      173.70  | Return of Capital - Share Consolidation                                     
01-Jun-22 | BHP  | BHP Group                 |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares                      
19-Jul-22 | GSK  | GSK PLC                   |     -275.74  | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation           
19-Jul-22 | WDS  | Woodside Energy Group Ltd |        8.15  | Return of Capital - Woodside Energy Group (WDS) shares - Share Consolidation
          |      |                           |              |                                                                             
          |      | Total                     |   £9,178.94  |

Next Actions Required

Next Dividend Re-Investment

Dividends received by this Portfolio are re-invested 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 Dividend Re-Investment timetable for the next 12 months is as follows:

Date      | Balance   | Re-Invest?
10-Jan-23 | 1,015.30  | N         
10-Feb-23 | 1,929.04  | N         
10-Mar-23 | 2,286.99  | Y         
11-Apr-23 | 2,197.88  | Y         
10-MaY-23 | 1,606.06  | N         
12-Jun-23 | 5,311.36  | Y         
10-Jul-23 |   778.54  | N         
10-Aug-23 | 1,526.76  | N         
11-Sep-23 | 2,746.23  | Y         
10-Oct-23 | 3,658.77  | Y         
10-Nov-23 | 1,769.24  | N         
11-Dec-23 | 2,446.59  | Y

The next Dividend Re-Investment will therefore be on 10 March 2023 when £2,286.99 is currently forecast to be available for re-investment. At the moment, it looks as if this amount will once again be invested in increasing the holding of Direct Line Insurance Group (DLG), but there are three months to wait, during which that might change.

As usual, a final decision will be made, and reported here, a couple of days before the Re-Investment is due to be made.

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?f=15&t=34042

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

Enjoy!

Ian

IanTHughes · #573121

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

Top-Up Decision – 10 March 2023

This is an update on the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.

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

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)     | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 2,004.0000  |   25,711.32  |     8.12% |    -410.19  |    632.77  |     5,763.83  |   5,986.41  |        7.04% |    1,811.21 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,144.0000  |    9,400.56  |     2.97% |   1,041.52  |      0.00  |     1,751.96  |   2,793.48  |        7.34% |      690.33 
WPP  | WPP                       |  1,780  | 14,997.55  | 1,031.5000  |   18,360.70  |     5.80% |   3,363.15  |      0.00  |     2,317.56  |   5,680.71  |        3.82% |      701.32 
ITV  | ITV                       | 11,652  | 14,999.08  |    87.3200  |   10,174.53  |     3.21% |  -4,824.55  |      0.00  |     1,514.74  |  -3,309.81  |        5.73% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   618.3000  |   14,993.78  |     4.73% |      -4.49  |    465.06  |     1,486.10  |   1,946.67  |        4.32% |      647.04 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   810.5000  |   22,386.01  |     7.07% |   7,386.69  |      0.00  |     4,808.59  |  12,195.28  |        5.49% |    1,229.09 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   232.1000  |   14,828.87  |     4.68% |  -2,568.21  |      0.00  |     4,434.20  |   1,865.99  |        6.29% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   218.0000  |    7,640.90  |     2.41% |     451.06  |      0.00  |       917.81  |   1,368.87  |        8.44% |      644.92 
AV   | Aviva                     |  3,663  | 14,970.64  |   447.2000  |   16,380.93  |     5.17% |   1,410.29  |      0.00  |     3,895.64  |   5,305.93  |        6.93% |    1,135.53 
DLG  | Direct Line Insurance Grp |  8,882  | 20,716.58  |   175.1500  |   15,556.83  |     4.91% |  -5,159.75  |      0.00  |       356.51  |  -4,803.24  |        4.34% |      675.03 
GSK  | GSK PLC                   |    752  | 11,986.74  | 1,442.2000  |   10,845.34  |     3.42% |  -1,141.40  |    103.40  |     2,615.74  |   1,577.74  |        3.89% |      422.06 
HLN  | Haleon PLC                |    941  |  2,723.59  |   315.8000  |    2,971.68  |     0.94% |     248.09  |      0.00  |         0.00  |     248.09  |        1.52% |       45.16 
BA   | BAE Systems               |  3,043  | 14,995.20  |   908.0000  |   27,630.44  |     8.72% |  12,635.24  |      0.00  |     2,909.07  |  15,544.31  |        2.97% |      821.60 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   341.9000  |   14,735.89  |     4.65% |    -261.22  |      0.00  |     2,124.83  |   1,863.61  |        5.26% |      775.80 
IBST | Ibstock                   |  5,849  | 14,999.47  |   162.7000  |    9,516.32  |     3.00% |  -5,483.15  |      0.00  |     1,292.60  |  -4,190.55  |        5.10% |      485.46 
BLND | British Land Company      |  1,273  |  7,494.24  |   444.1000  |    5,653.39  |     1.79% |  -1,840.85  |      0.00  |       920.01  |    -920.84  |        5.22% |      295.33 
LAND | Land Securities Group     |    818  |  7,499.19  |   661.4000  |    5,410.25  |     1.71% |  -2,088.94  |     73.62  |       952.53  |  -1,062.79  |        5.99% |      323.92 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,733.0000  |   22,902.54  |     7.23% |   7,910.03  |      0.00  |     4,778.95  |  12,688.98  |        8.08% |    1,851.66 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 6,144.0000  |   10,629.12  |     3.36% |     796.05  |      0.00  |     1,384.88  |   2,180.93  |        6.62% |      704.07 
SHEL | Shell                     |    457  |  9,626.22  | 2,580.0000  |   11,790.60  |     3.72% |   2,164.38  |    109.55  |     1,265.11  |   3,539.04  |        3.72% |      438.21 
BP   | BP                        |  1,347  |  7,496.10  |   555.3000  |    7,479.89  |     2.36% |     -16.21  |     74.23  |     1,116.01  |   1,174.03  |        3.70% |      276.58 
WDS  | Woodside Energy Group Ltd |    151  |  2,565.55  | 2,130.0000  |    3,216.30  |     1.02% |     650.75  |      0.00  |       142.00  |     792.75  |        9.90% |      318.54 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |   100.4800  |   10,125.37  |     3.20% |  -4,873.11  |      0.00  |     3,115.82  |  -1,757.29  |        7.93% |      803.01 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   821.2000  |    3,153.41  |     1.00% | -11,826.38  |      0.00  |       610.18  | -11,216.20  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  |   862.5000  |   11,350.50  |     3.58% |     679.91  |    170.55  |     1,800.77  |   2,651.23  |        4.86% |      552.19 
     |                           |         |            |             |              |           |             |            |               |             |              |             
     | Sub Total:                |         |            |             | £312,845.47  |    98.76% | -£1,761.29  | £1,629.18  |               |             |        5.49% |  £17,163.45 
     | Cash Balance:             |         |            |             |   £2,305.30  |     0.73% |             |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,629.18  |     0.51% |             |            |               |             |              |             
     |                           |         |            |             |              |           |             |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £316,779.95  |           |             |            |               |             |              |             
     | From:                     |         |            |             |              |           |             |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |             |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |             |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £52,828.35  |           |             |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £1,629.18  |           |             |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £9,178.94  |           |             |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             |  -£1,761.29  |           |             |            |               |             |              |             
     |                           |         |            |             |              |   XIRR    |             |            |               |             |              |             
     | Total:                    |         |            |             | £316,779.95  |   5.64%   |             |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  35,111.88  |      11.08% |     631.33  |      632.77  |       7,515.79  |     8,779.89  |        7.12% |      2,501.54 
Mining              | 24,825.58  |  33,531.66  |      10.59% |   8,706.08  |        0.00  |       6,163.83  |    14,869.91  |        7.62% |      2,555.73 
Weapons             | 14,995.20  |  27,630.44  |       8.72% |  12,635.24  |        0.00  |       2,909.07  |    15,544.31  |        2.97% |        821.60 
Gambling            | 14,999.32  |  22,386.01  |       7.07% |   7,386.69  |        0.00  |       4,808.59  |    12,195.28  |        5.49% |      1,229.09 
Oil                 | 19,687.87  |  22,486.79  |       7.10% |   2,798.92  |      183.78  |       2,523.12  |     5,505.82  |        4.60% |      1,033.33 
Fund Manager        | 24,586.92  |  22,469.77  |       7.09% |  -2,117.15  |        0.00  |       5,352.01  |     3,234.86  |        7.02% |      1,577.71 
Advertising         | 14,997.55  |  18,360.70  |       5.80% |   3,363.15  |        0.00  |       2,317.56  |     5,680.71  |        3.82% |        701.32 
Insurance: Life     | 14,970.64  |  16,380.93  |       5.17% |   1,410.29  |        0.00  |       3,895.64  |     5,305.93  |        6.93% |      1,135.53 
Insurance: Non-Life | 20,716.58  |  15,556.83  |       4.91% |  -5,159.75  |        0.00  |         356.51  |    -4,803.24  |        4.34% |        675.03 
Banks               | 14,998.27  |  14,993.78  |       4.73% |      -4.49  |      465.06  |       1,486.10  |     1,946.67  |        4.32% |        647.04 
Packaging           | 14,997.11  |  14,735.89  |       4.65% |    -261.22  |        0.00  |       2,124.83  |     1,863.61  |        5.26% |        775.80 
Real Estate IT      | 14,993.43  |  11,063.64  |       3.49% |  -3,929.79  |       73.62  |       1,872.54  |    -1,983.63  |        5.60% |        619.25 
Utility: Water      | 10,670.59  |  11,350.50  |       3.58% |     679.91  |      170.55  |       1,800.77  |     2,651.23  |        4.86% |        552.19 
Pharma              | 11,986.74  |  10,845.34  |       3.42% |  -1,141.40  |      103.40  |       2,615.74  |     1,577.74  |        3.89% |        422.06 
Television          | 14,999.08  |  10,174.53  |       3.21% |  -4,824.55  |        0.00  |       1,514.74  |    -3,309.81  |        5.73% |        582.60 
Telecom: Mobile     | 14,998.48  |  10,125.37  |       3.20% |  -4,873.11  |        0.00  |       3,115.82  |    -1,757.29  |        7.93% |        803.01 
Bricks              | 14,999.47  |   9,516.32  |       3.00% |  -5,483.15  |        0.00  |       1,292.60  |    -4,190.55  |        5.10% |        485.46 
Cruising            | 14,979.79  |   3,153.41  |       1.00% | -11,826.38  |        0.00  |         610.18  |   -11,216.20  |        0.00% |          0.00 
Medical Products    |  2,723.59  |   2,971.68  |       0.94% |     248.09  |        0.00  |           0.00  |       248.09  |        1.52% |         45.16

[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 clearly indicated otherwise. I do now believe that the recent dividend suspensions/cancellations, caused by the Covid Pandemic and Lockdowns, have been played out. Consequently, the above Y'ld (%) and Year Div (£) columns can once again be treated as a reasonable estimate.

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name                      | Real P&L (£) | Comment                                                                     
20-Sep-19 | IBST | Ibstock                   |      292.45  | Return of Capital                                                           
09-Oct-19 | GNK  | Greene King               |    4,188.29  | Sale – Pending Takeover                                                     
16-Jul-21 | PNN  | Pennon Group              |    1,676.05  | Return of Capital - Share Consolidation                                     
21-Sep-21 | BHP  | BHP Group                 |      550.49  | Return of Capital                                                           
16-May-22 | AV   | Aviva                     |      173.70  | Return of Capital - Share Consolidation                                     
01-Jun-22 | BHP  | BHP Group                 |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares                      
19-Jul-22 | GSK  | GSK PLC                   |     -275.74  | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation           
19-Jul-22 | WDS  | Woodside Energy Group Ltd |        8.15  | Return of Capital - Woodside Energy Group (WDS) shares - Share Consolidation
          |      |                           |              |                                                                             
          |      | Total                     |   £9,178.94  |

Top-Up: 10 March 2023

As at the close of business on Thursday 09 March 2023, the amount available for re-investment will be £2,305.30. This amount will be used to top-up one holding on Friday 10 March 2023.

Candidates

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

Business        | EPIC | Company                   | Reward (%) | Decision     | Comments                                     
Oil             | WDS  | Woodside Energy Group Ltd |      9.90% | Possible     | Resultant Sector Value Concentration (7.82%) 
Fund Manager    | MNG  | M & G PLC                 |      8.44% | Possible     | Resultant Sector Value Concentration (7.82%) 
Mining          | BHP  | BHP Group                 |      8.08% | Disqualified | Resultant Sector Value Concentration (11.31%)
Telecom: Mobile | VOD  | Vodafone Group            |      7.93% | Possible     | Resultant Sector Value Concentration (3.92%)

Decision

Ignoring those that are disqualified in order to avoid over-concentration by Business Sector, we end up with …..

Woodside Energy Group Ltd (WDS) – Yield 9.90%

The only potential downside that I can see with WDS is that, with profits being boosted by the current high price of oil, which may of course reduce again in short order, there may be pressure on the dividend next year. I am also somewhat bemused as to why the yield for WDS is so far ahead of that for BP PLC (BP) or Shell PLC (SHEL). Maybe some further investigation is required.

M & G PLC (MNG) – Yield 8.44%

MNG are due to release the end of year results for 31 December 2022 on the 9 March 2023, this coming Thursday. I will make a final check when these results are available.

Vodafone Group (VOD) – Yield 7.93%

The dividend has now been held for four years, and a continued hold for a fifth year looks likely to me.

As I said, I will be checking the forthcoming results for MNG, as well as having another look at WDS, but for now …..

Oil – Woodside Energy Group Ltd (WDS) – Yield 9.90% - is the decision for this top-up.

The Value Concentration after purchase (7.82%) will leave the Oil Business Sector holding as number four by that measure, well below the maximum allowed – 10% - but who knows, there may be further purchases to come.

As I am not intending to purchase WDS for any of the “real” portfolios under my control, the price to be applied for this “virtual” purchase will be the mid-price reported on the day. I shall post an update when the details of the purchase 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?f=15&t=34042

The intention is to keep this thread simply recording the events of the Portfolio during its fourth year.

Enjoy!

Ian

IanTHughes · #574680

For the activity during Year One of this portfolio please see this thread: viewtopic.php?f=15&t=17908
For the activity during Year Two of this portfolio please see this thread: viewtopic.php?f=15&t=22901
For the activity during Year Three of this portfolio please see this thread: viewtopic.php?f=15&t=33979

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

Update 10 March 2023

Dividend Re-Investment Purchase: Transaction Details

The Dividend Re-Investment indicated in the previous post https: viewtopic.php?f=15&t=34041&p=535755#p535755 has now been made as follows:

Date      | Business | EPIC | Shares | Price (p)   | Cash (£)   | Stamp (£) | Fee (£) | Total (£)  | Yield (%)
10-Mar-23 | Oil      | WDS  |   121  | 1,880.5000  | -2,275.41  |   -11.38  |  -1.50  | -2,288.29  |  11.39%

The price achieved is the average of the High and Low Price for the day.

Current Portfolio: Holdings

EPIC | Company                   | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) | P/L (£)      | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 1,979.0000  |   25,390.57  |     8.21% |     -730.94  |    632.77  |     5,763.83  |   5,665.66  |        7.13% |    1,811.21 
BATS | British American Tobacco  |    299  |  8,359.04  | 3,113.5000  |    9,309.37  |     3.01% |      950.33  |      0.00  |     1,751.96  |   2,702.29  |        7.42% |      690.33 
WPP  | WPP                       |  1,780  | 14,997.55  |   984.6000  |   17,525.88  |     5.67% |    2,528.33  |      0.00  |     2,317.56  |   4,845.89  |        4.00% |      701.32 
ITV  | ITV                       | 11,652  | 14,999.08  |    85.1600  |    9,922.84  |     3.21% |   -5,076.24  |      0.00  |     1,514.74  |  -3,561.50  |        5.87% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   592.6000  |   14,370.55  |     4.65% |     -627.72  |    465.06  |     1,486.10  |   1,323.44  |        4.50% |      647.04 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   797.0000  |   22,013.14  |     7.12% |    7,013.82  |      0.00  |     4,808.59  |  11,822.41  |        5.58% |    1,229.09 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   219.8000  |   14,043.02  |     4.54% |   -3,354.06  |      0.00  |     4,434.20  |   1,080.14  |        6.64% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   214.6000  |    7,521.73  |     2.43% |      331.89  |      0.00  |       917.81  |   1,249.70  |        9.13% |      686.98 
AV   | Aviva                     |  3,663  | 14,970.64  |   449.7000  |   16,472.51  |     5.32% |    1,501.87  |      0.00  |     3,895.64  |   5,397.51  |        6.89% |    1,135.53 
DLG  | Direct Line Insurance Grp |  8,882  | 20,716.58  |   167.6500  |   14,890.67  |     4.81% |   -5,825.91  |      0.00  |       356.51  |  -5,469.40  |        4.53% |      675.03 
GSK  | GSK PLC                   |    752  | 11,986.74  | 1,398.6000  |   10,517.48  |     3.40% |   -1,469.26  |    103.40  |     2,615.74  |   1,249.88  |        4.01% |      422.06 
HLN  | Haleon PLC                |    941  |  2,723.59  |   317.5500  |    2,988.15  |     0.97% |      264.56  |      0.00  |         0.00  |     264.56  |        1.51% |       45.16 
BA   | BAE Systems               |  3,043  | 14,995.20  |   929.8000  |   28,293.81  |     9.15% |   13,298.61  |      0.00  |     2,909.07  |  16,207.68  |        2.90% |      821.60 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   322.6000  |   13,904.06  |     4.49% |   -1,093.05  |      0.00  |     2,124.83  |   1,031.78  |        5.58% |      775.80 
IBST | Ibstock                   |  5,849  | 14,999.47  |   168.9000  |    9,878.96  |     3.19% |   -5,120.51  |      0.00  |     1,292.60  |  -3,827.91  |        5.21% |      514.71 
BLND | British Land Company      |  1,273  |  7,494.24  |   409.7000  |    5,215.48  |     1.69% |   -2,278.76  |      0.00  |       920.01  |  -1,358.75  |        5.66% |      295.33 
LAND | Land Securities Group     |    818  |  7,499.19  |   629.8000  |    5,151.76  |     1.67% |   -2,347.43  |     73.62  |       952.53  |  -1,321.28  |        6.29% |      323.92 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,531.5000  |   21,213.97  |     6.86% |    6,221.46  |    628.86  |     4,778.95  |  11,629.27  |        8.73% |    1,851.66 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 5,634.0000  |    9,746.82  |     3.15% |      -86.25  |    320.65  |     1,384.88  |   1,619.28  |        7.22% |      704.07 
SHEL | Shell                     |    457  |  9,626.22  | 2,544.5000  |   11,628.37  |     3.76% |    2,002.15  |    109.55  |     1,265.11  |   3,376.81  |        3.77% |      438.21 
BP   | BP                        |  1,347  |  7,496.10  |   549.2000  |    7,397.72  |     2.39% |      -98.38  |     74.23  |     1,116.01  |   1,091.86  |        3.74% |      276.58 
WDS  | Woodside Energy Group Ltd |    272  |  4,853.84  | 1,880.0000  |    5,113.60  |     1.65% |      259.76  |    181.30  |       142.00  |     583.06  |       11.22% |      573.80 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |    98.5600  |    9,931.89  |     3.21% |   -5,066.59  |      0.00  |     3,115.82  |  -1,950.77  |        8.09% |      803.01 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   744.4000  |    2,858.50  |     0.92% |  -12,121.29  |      0.00  |       610.18  | -11,511.11  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  |   860.0000  |   11,317.60  |     3.66% |      647.01  |    170.55  |     1,800.77  |   2,618.33  |        4.88% |      552.19 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £306,618.45  |    99.10% | -£10,276.60  | £2,759.99  |               |             |        5.70% |  £17,490.02 
     | Cash Balance:             |         |            |             |      £17.01  |     0.01% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £2,759.99  |     0.89% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £309,395.45  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £52,828.35  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £2,759.99  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £9,178.94  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£10,276.60  |           |              |            |               |             |              |             
     |                           |         |            |             |              |   XIRR    |              |            |               |             |              |             
     | Total:                    |         |            |             | £309,395.45  |   4.99%   |              |            |               |             |              |

Current Portfolio: Business Sectors

Business            |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%) [1] |  Year Div (£) 
Tobacco             | 34,480.55  |  34,699.94  |      11.22% |     219.39  |      632.77  |       7,515.79  |     8,367.95  |        7.21% |      2,501.54 
Mining              | 24,825.58  |  30,960.79  |      10.01% |   6,135.21  |      949.51  |       6,163.83  |    13,248.55  |        8.25% |      2,555.73 
Weapons             | 14,995.20  |  28,293.81  |       9.14% |  13,298.61  |        0.00  |       2,909.07  |    16,207.68  |        2.90% |        821.60 
Oil                 | 21,976.16  |  24,139.69  |       7.80% |   2,163.53  |      365.08  |       2,523.12  |     5,051.73  |        5.34% |      1,288.59 
Gambling            | 14,999.32  |  22,013.14  |       7.11% |   7,013.82  |        0.00  |       4,808.59  |    11,822.41  |        5.58% |      1,229.09 
Fund Manager        | 24,586.92  |  21,564.75  |       6.97% |  -3,022.17  |        0.00  |       5,352.01  |     2,329.84  |        7.51% |      1,619.77 
Advertising         | 14,997.55  |  17,525.88  |       5.66% |   2,528.33  |        0.00  |       2,317.56  |     4,845.89  |        4.00% |        701.32 
Insurance: Life     | 14,970.64  |  16,472.51  |       5.32% |   1,501.87  |        0.00  |       3,895.64  |     5,397.51  |        6.89% |      1,135.53 
Insurance: Non-Life | 20,716.58  |  14,890.67  |       4.81% |  -5,825.91  |        0.00  |         356.51  |    -5,469.40  |        4.53% |        675.03 
Banks               | 14,998.27  |  14,370.55  |       4.64% |    -627.72  |      465.06  |       1,486.10  |     1,323.44  |        4.50% |        647.04 
Packaging           | 14,997.11  |  13,904.06  |       4.49% |  -1,093.05  |        0.00  |       2,124.83  |     1,031.78  |        5.58% |        775.80 
Utility: Water      | 10,670.59  |  11,317.60  |       3.66% |     647.01  |      170.55  |       1,800.77  |     2,618.33  |        4.88% |        552.19 
Pharma              | 11,986.74  |  10,517.48  |       3.40% |  -1,469.26  |      103.40  |       2,615.74  |     1,249.88  |        4.01% |        422.06 
Real Estate IT      | 14,993.43  |  10,367.24  |       3.35% |  -4,626.19  |       73.62  |       1,872.54  |    -2,680.03  |        5.97% |        619.25 
Telecom: Mobile     | 14,998.48  |   9,931.89  |       3.21% |  -5,066.59  |        0.00  |       3,115.82  |    -1,950.77  |        8.09% |        803.01 
Television          | 14,999.08  |   9,922.84  |       3.21% |  -5,076.24  |        0.00  |       1,514.74  |    -3,561.50  |        5.87% |        582.60 
Bricks              | 14,999.47  |   9,878.96  |       3.19% |  -5,120.51  |        0.00  |       1,292.60  |    -3,827.91  |        5.21% |        514.71 
Medical Products    |  2,723.59  |   2,988.15  |       0.97% |     264.56  |        0.00  |           0.00  |       264.56  |        1.51% |         45.16 
Cruising            | 14,979.79  |   2,858.50  |       0.92% | -12,121.29  |        0.00  |         610.18  |   -11,511.11  |        0.00% |          0.00

[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 clearly indicated otherwise.

[2] - Realised Profit and Loss & Return of Capital – To Date

Date      | EPIC | Name                      | Real P&L (£) | Comment                                                                     
20-Sep-19 | IBST | Ibstock                   |      292.45  | Return of Capital                                                           
09-Oct-19 | GNK  | Greene King               |    4,188.29  | Sale – Pending Takeover                                                     
16-Jul-21 | PNN  | Pennon Group              |    1,676.05  | Return of Capital - Share Consolidation                                     
21-Sep-21 | BHP  | BHP Group                 |      550.49  | Return of Capital                                                           
16-May-22 | AV   | Aviva                     |      173.70  | Return of Capital - Share Consolidation                                     
01-Jun-22 | BHP  | BHP Group                 |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares                      
19-Jul-22 | GSK  | GSK PLC                   |     -275.74  | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation           
19-Jul-22 | WDS  | Woodside Energy Group Ltd |        8.15  | Return of Capital - Woodside Energy Group (WDS) shares - Share Consolidation
          |      |                           |              |                                                                             
          |      | Total                     |   £9,178.94  |

Next Actions Required

Next Dividend Re-Investment

Dividends received by this Portfolio are re-invested 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 Dividend Re-Investment timetable for the next 12 months is as follows:

Date      | Balance   | Re-Invest?
11-Apr-23 | 1,887.89  | N         
10-May-23 | 3,419.25  | Y         
12-Jun-23 | 2,435.96  | Y         
10-Jul-23 |   884.21  | N         
10-Aug-23 | 1,645.93  | N         
11-Sep-23 | 2,875.18  | Y         
10-Oct-23 | 3,809.61  | Y         
10-Nov-23 | 1,925.84  | N         
11-Dec-23 | 2,440.39  | Y         
10-Jan-24 | 1,030.92  | N         
12-Feb-24 | 1,969.82  | N         
11-Mar-24 | 2,336.06  | Y

The next Dividend Re-Investment will therefore be on 10 May 2023 when £3,419.25 is currently forecast to be available for re-investment. At the moment, it looks as if this amount will once again be invested in increasing the holding of Woodside Energy Group (WDS), but there are two months to wait, during which that might change.

As usual, a final decision will be made, and reported here, a few of days before the Re-Investment is due to be made.

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?f=15&t=34042

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

Enjoy!

Ian

IanTHughes · #581063

PYAD HYP 2019_04 REINVEST – Year Four

Year Four – End of Year - 05 April 2023

This is the fourth 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, by myself, as if an HYPer were still building an income pot by the re-investment of all dividends received.

A thread detailing the progress during the Year One can be found here: viewtopic.php?p=225860#p225860
A thread detailing the progress during the Year Two can be found here: viewtopic.php?f=15&t=22901
A thread detailing the progress during the Year Three can be found here: viewtopic.php?f=15&t=33979

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

Current Portfolio: Holdings

EPIC |      Company              | Shares  | Cost (£)   | Price (p)   | Value (£)    | Value (%) |   P/L (£)    | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%)[1]  | Year Div (£)
IMB  | Imperial Brands           |  1,283  | 26,121.51  | 1,869.5000  |   23,985.69  |     8.10% |   -2,135.82  |      0.00  |     6,396.60  |   4,260.78  |        7.55% |    1,811.21 
BATS | British American Tobacco  |    299  |  8,359.04  | 2,805.0000  |    8,386.95  |     2.83% |       27.91  |    172.58  |     1,751.96  |   1,952.45  |        8.23% |      690.33 
WPP  | WPP                       |  1,780  | 14,997.55  |   926.8000  |   16,497.04  |     5.57% |    1,499.49  |      0.00  |     2,317.56  |   3,817.05  |        4.25% |      701.32 
ITV  | ITV                       | 11,652  | 14,999.08  |    79.7800  |    9,295.97  |     3.14% |   -5,703.11  |      0.00  |     1,514.74  |  -4,188.37  |        6.27% |      582.60 
HSBA | HSBC Holdings             |  2,425  | 14,998.27  |   554.2000  |   13,439.35  |     4.54% |   -1,558.92  |    451.43  |     1,486.10  |     378.61  |        4.67% |      628.08 
IGG  | IG Group Holdings         |  2,762  | 14,999.32  |   688.5000  |   19,016.37  |     6.42% |    4,017.05  |      0.00  |     4,808.59  |   8,825.64  |        6.46% |    1,229.09 
ABDN | Abrdn PLC                 |  6,389  | 17,397.08  |   199.2500  |   12,730.09  |     4.30% |   -4,666.99  |    466.39  |     4,434.20  |     233.60  |        7.33% |      932.79 
MNG  | M & G PLC                 |  3,505  |  7,189.84  |   189.8500  |    6,654.24  |     2.25% |     -535.60  |    469.67  |       917.81  |     851.88  |       10.32% |      686.98 
AV   | Aviva                     |  3,663  | 14,970.64  |   409.0000  |   14,981.67  |     5.06% |       11.03  |    758.24  |     3,895.64  |   4,664.91  |        7.58% |    1,135.53 
DLG  | Direct Line Insurance Grp |  8,882  | 20,716.58  |   153.0500  |   13,593.91  |     4.59% |   -7,122.67  |      0.00  |       356.51  |  -6,766.16  |        4.97% |      675.03 
GSK  | GSK PLC                   |    752  | 11,986.74  | 1,487.2000  |   11,183.74  |     3.77% |     -803.00  |    103.40  |     2,615.74  |   1,916.14  |        3.77% |      422.06 
HLN  | Haleon PLC                |    941  |  2,723.59  |   340.6500  |    3,205.52  |     1.08% |      481.93  |     22.58  |         0.00  |     504.51  |        1.41% |       45.16 
BA   | BAE Systems               |  3,043  | 14,995.20  |   995.0000  |   30,277.85  |    10.22% |   15,282.65  |      0.00  |     2,909.07  |  18,191.72  |        2.71% |      821.60 
SMDS | DS Smith                  |  4,310  | 14,997.11  |   307.5000  |   13,253.25  |     4.47% |   -1,743.86  |      0.00  |     2,124.83  |     380.97  |        5.85% |      775.80 
IBST | Ibstock                   |  5,849  | 14,999.47  |   166.9000  |    9,761.98  |     3.30% |   -5,237.49  |      0.00  |     1,292.60  |  -3,944.89  |        5.27% |      514.71 
BLND | British Land Company      |  1,273  |  7,494.24  |   382.3000  |    4,866.68  |     1.64% |   -2,627.56  |      0.00  |       920.01  |  -1,707.55  |        6.07% |      295.33 
LAND | Land Securities Group     |    818  |  7,499.19  |   617.0000  |    5,047.06  |     1.70% |   -2,452.13  |     73.64  |       952.51  |  -1,425.98  |        6.42% |      323.92 
BHP  | BHP Group                 |    838  | 14,992.51  | 2,412.5000  |   20,216.75  |     6.82% |    5,224.24  |      0.00  |     5,402.17  |  10,626.41  |        8.89% |    1,797.41 
RIO  | Rio Tinto                 |    173  |  9,833.07  | 5,283.0000  |    9,139.59  |     3.09% |     -693.48  |    320.65  |     1,384.88  |   1,012.05  |        7.70% |      704.07 
SHEL | Shell                     |    457  |  9,626.22  | 2,363.0000  |   10,798.91  |     3.65% |    1,172.69  |      0.00  |     1,375.29  |   2,547.98  |        3.94% |      425.37 
BP   | BP                        |  1,347  |  7,496.10  |   533.7000  |    7,188.94  |     2.43% |     -307.16  |      0.00  |     1,190.77  |     883.61  |        3.74% |      268.50 
WDS  | Woodside Energy Group Ltd |    272  |  4,853.84  | 1,828.0000  |    4,972.16  |     1.68% |      118.32  |      0.00  |       325.49  |     443.81  |       11.20% |      556.98 
VOD  | Vodafone Group            | 10,077  | 14,998.48  |    89.4500  |    9,013.88  |     3.04% |   -5,984.60  |      0.00  |     3,115.82  |  -2,868.78  |        8.85% |      797.43 
CCL  | Carnival Corporation      |    384  | 14,979.79  |   696.4000  |    2,674.18  |     0.90% |  -12,305.61  |      0.00  |       610.18  | -11,695.43  |        0.00% |        0.00 
PNN  | Pennon Group              |  1,316  | 10,670.59  |   871.5000  |   11,468.94  |     3.87% |      798.35  |      0.00  |     1,971.32  |   2,769.67  |        4.81% |      552.19 
     |                           |         |            |             |              |           |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Sub Total:                |         |            |             | £291,650.71  |    98.43% | -£25,244.34  | £2,838.58  |               |             |        5.96% |  £17,373.49 
     | Cash Balance:             |         |            |             |   £1,811.96  |     0.64% |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £2,838.58  |     0.93% |              |            |               |             |              |             
     |                           |         |            |             |              |           |              |            |               |             |              |             
     | Current Portfolio Value:  |         |            |             | £296,301.25  |           |              |            |               |             |              |             
     | From:                     |         |            |             |              |           |              |            |               |             |              |             
     | Cash In:                  |         |            |             | £254,904.77  |           |              |            |               |             |              |             
     | LESS Cash Out:            |         |            |             |       £0.00  |           |              |            |               |             |              |             
     | Dividends Received:       |         |            |             |  £54,623.30  |           |              |            |               |             |              |             
     | Ex-Dividend:              |         |            |             |   £2,838.58  |           |              |            |               |             |              |             
     | Realised Profit/Loss:     | [2]     |            |             |   £9,178.94  |           |              |            |               |             |              |             
     | Un-Realised Profit/Loss:  |         |            |             | -£25,244.34  |           |              |            |               |             |              |             
     |                           |         |            |             |              |   XIRR    |              |            |               |             |              |             
     | Total:                    |         |            |             | £296,301.25  |   3.78%   |              |            |               |             |              |

Current Portfolio: Business Sectors

     Business       |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Overall (£)  | Y'ld (%)[1] |  Year Div (£) 
Tobacco             | 34,480.55  |  32,372.64  |      10.93% |  -2,107.91  |      172.58  |       8,148.56  |     6,213.23  |        7.73% |      2,501.54 
Weapons             | 14,995.20  |  30,277.85  |      10.22% |  15,282.65  |        0.00  |       2,909.07  |    18,191.72  |        2.71% |        821.60 
Mining              | 24,825.58  |  29,356.34  |       9.91% |   4,530.76  |      320.65  |       6,787.05  |    11,638.46  |        8.52% |      2,501.48 
Oil                 | 21,976.16  |  22,960.01  |       7.75% |     983.85  |        0.00  |       2,891.55  |     3,875.40  |        5.45% |      1,250.85 
Fund Manager        | 24,586.92  |  19,384.33  |       6.54% |  -5,202.59  |      936.06  |       5,352.01  |     1,085.48  |        8.36% |      1,619.77 
Gambling            | 14,999.32  |  19,016.37  |       6.42% |   4,017.05  |        0.00  |       4,808.59  |     8,825.64  |        6.46% |      1,229.09 
Advertising         | 14,997.55  |  16,497.04  |       5.57% |   1,499.49  |        0.00  |       2,317.56  |     3,817.05  |        4.25% |        701.32 
Insurance: Life     | 14,970.64  |  14,981.67  |       5.06% |      11.03  |      758.24  |       3,895.64  |     4,664.91  |        7.58% |      1,135.53 
Banks               | 14,998.27  |  13,439.35  |       4.54% |  -1,558.92  |      451.43  |       1,486.10  |       378.61  |        4.67% |        628.08 
Packaging           | 14,997.11  |  13,253.25  |       4.47% |  -1,743.86  |        0.00  |       2,124.83  |       380.97  |        5.85% |        775.80 
Insurance: Non-Life | 20,716.58  |  13,593.91  |       4.59% |  -7,122.67  |        0.00  |         356.51  |    -6,766.16  |        4.97% |        675.03 
Utility: Water      | 10,670.59  |  11,468.94  |       3.87% |     798.35  |        0.00  |       1,971.32  |     2,769.67  |        4.81% |        552.19 
Pharma              | 11,986.74  |  11,183.74  |       3.77% |    -803.00  |      103.40  |       2,615.74  |     1,916.14  |        3.77% |        422.06 
Bricks              | 14,999.47  |   9,761.98  |       3.29% |  -5,237.49  |        0.00  |       1,292.60  |    -3,944.89  |        5.27% |        514.71 
Real Estate IT      | 14,993.43  |   9,913.74  |       3.35% |  -5,079.69  |       73.64  |       1,872.52  |    -3,133.53  |        6.25% |        619.25 
Television          | 14,999.08  |   9,295.97  |       3.14% |  -5,703.11  |        0.00  |       1,514.74  |    -4,188.37  |        6.27% |        582.60 
Telecom: Mobile     | 14,998.48  |   9,013.88  |       3.04% |  -5,984.60  |        0.00  |       3,115.82  |    -2,868.78  |        8.85% |        797.43 
Medical Products    |  2,723.59  |   3,205.52  |       1.08% |     481.93  |       22.58  |           0.00  |       504.51  |        1.41% |         45.16 
Cruising            | 14,979.79  |   2,674.18  |       0.90% | -12,305.61  |        0.00  |         610.18  |   -11,695.43  |        0.00% |          0.00

[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 clearly indicated otherwise. I do now believe that the recent dividend suspensions/cancellations, caused by the Covid Pandemic and Lockdowns, have been played out. Consequently, the above Year Div (£) columns can once again be treated as a reasonable estimate.

[2] - Realised Profit and Loss & Return of Capital: To Date

 Date      | EPIC |         Name              | Real P&L (£) | Comment                                                                     
20-Sep-19 | IBST | Ibstock                   |      292.45  | Return of Capital                                                           
09-Oct-19 | GNK  | Greene King               |    4,188.29  | Sale – Pending Takeover                                                     
16-Jul-21 | PNN  | Pennon Group              |    1,676.05  | Return of Capital - Share Consolidation                                     
21-Sep-21 | BHP  | BHP Group                 |      550.49  | Return of Capital                                                           
16-May-22 | AV   | Aviva                     |      173.70  | Return of Capital - Share Consolidation                                     
01-Jun-22 | BHP  | BHP Group                 |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares                      
19-Jul-22 | GSK  | GSK PLC                   |     -275.74  | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation           
19-Jul-22 | WDS  | Woodside Energy Group Ltd |        8.15  | Return of Capital - Woodside Energy Group (WDS) shares - Share Consolidation
          |      |                           |              |                                                                             
          |      | Total                     |   £9,178.94  |

Portfolio Transactions: Year Four

   Date   |      Business       | EPIC | Shares  | Price (p)   | Cash (£)   | Stamp (£) | Fee (£) | Total (£)  | Yield (%) | Comment                                                 
11-Apr-22 | Insurance: Non-Life | DLG  |  1,194  |   267.9000  | -3,198.73  |   -15.99  |  -1.50  | -3,216.22  |   8.47%   | Routine Dividend Re-Investment                          
16-May-22 | Insurance: Life     | AV   | -1,158  |   423.3566  |  4,902.47  |     0.00  |   0.00  |  4,902.47  |           | Return of Capital from Aviva (AV) Share Consolidation   
01-Jun-22 | Oil                 | WDS  |    151  | 1,699.0397  | -2,565.55  |     0.00  |   0.00  | -2,565.55  |   5.90%   | In Specie Dividend from BHP                             
01-Jun-22 | Mining              | BHP  |         |             |  2,565.55  |     0.00  |   0.00  |  2,565.55  |           | Value of In Specie Dividend                             
10-Jun-22 | Insurance: Non-Life | DLG  |  3,497  |   254.8500  | -8,912.10  |   -44.56  |  -1.50  | -8,958.16  |   8.91%   | Replace Aviva (AV) Return of Capital                    
18-Jul-22 | Pharma              | GSK  |   -189  | 1,441.0529  |  2,723.59  |     0.00  |   0.00  |  2,723.59  |           | Return of Capital from GSK PLC (GSK) Share Consolidation
18-Jul-22 | Medical Products    | HLN  |    941  |   289.4352  | -2,723.59  |     0.00  |   0.00  | -2,723.59  |   6.91%   | In Specie Dividend from GSK                             
03-Aug-22 | Insurance: Life     | AV   |      0  |   412.5000  |      3.96  |     0.00  |   0.00  |      3.96  |           | Sale of Leftover from Share Consolidation               
03-Aug-22 | Pharma              | GSK  |      0  | 1,662.5000  |     13.30  |     0.00  |   0.00  |     13.30  |           | Sale of Leftover from Share Consolidation               
12-Sep-22 | Insurance: Non-Life | DLG  |  1,117  |   214.9000  | -2,400.43  |   -12.00  |  -1.50  | -2,413.93  |  10.56%   | Routine Dividend Re-Investment                          
10-Oct-22 | Insurance: Non-Life | DLG  |  1,981  |   194.4310  | -3,851.68  |   -19.26  |  -1.50  | -3,872.44  |  11.68%   | Routine Dividend Re-Investment                          
12-Dec-22 | Insurance: Non-Life | DLG  |  1,093  |   205.2251  | -2,243.11  |   -11.22  |  -1.50  | -2,255.83  |  11.06%   | Routine Dividend Re-Investment                          
10-Mar-23 | Oil                 | WDS  |    121  | 1,880.5000  | -2,275.41  |   -11.38  |  -1.50  | -2,288.29  |  11.46%   | Routine Dividend Re-Investment

Portfolio Income: Year Four

  Date    | EPIC |         Name              | Shares  | Div'd (p) | Amount (£)
07-Apr-22 | LAND | Land Securities Group     |    818  |   8.5000  |     69.53 
07-Apr-22 | GSK  | GlaxoSmithKline           |    941  |  23.0000  |    216.43 
21-Apr-22 | RIO  | Rio Tinto                 |    173  | 306.7200  |    530.62 
21-Apr-22 | RIO  | Rio Tinto                 |    173  |  45.6000  |     78.88 
28-Apr-22 | HSBA | HSBC Holdings             |  2,425  |  13.8188  |    335.10 
28-Apr-22 | MNG  | M & G PLC                 |  3,505  |  12.2000  |    427.61 
03-May-22 | SMDS | DS Smith                  |  4,310  |   4.8000  |    206.88 
04-May-22 | BATS | British American Tobacco  |    299  |  54.4500  |    162.80 
13-May-22 | IBST | Ibstock                   |  5,849  |   5.0000  |    292.45 
19-May-22 | AV   | Aviva                     |  4,821  |  14.7000  |    708.68 
24-May-22 | ABDN | Abrdn PLC                 |  6,389  |   7.3000  |    466.39 
26-May-22 | ITV  | ITV                       | 11,652  |   3.3000  |    384.51 
01-Jun-22 | BA   | BAE Systems               |  3,043  |  15.2000  |    462.53 
24-Jun-22 | BP   | BP                        |  1,347  |   4.3556  |     58.66 
27-Jun-22 | SHEL | Shell                     |    457  |  20.0100  |     91.44 
30-Jun-22 | IMB  | Imperial Brands           |  1,283  |  21.2700  |    272.89 
01-Jul-22 | GSK  | GSK Plc                   |    941  |  14.0000  |    131.74 
08-Jul-22 | WPP  | WPP                       |  1,780  |  18.7000  |    332.86 
22-Jul-22 | LAND | Land Securities Group     |    818  |  13.0000  |    106.34 
29-Jul-22 | BLND | British Land Company      |  1,273  |  11.6000  |    147.66 
05-Aug-22 | VOD  | Vodafone Group            | 10,077  |   3.7851  |    381.42 
17-Aug-22 | BATS | British American Tobacco  |    299  |  54.4500  |    162.80 
05-Sep-22 | PNN  | Pennon Group              |  1,316  |  26.8300  |    353.08 
09-Sep-22 | DLG  | Direct Line Insurance Grp |  4,691  |   7.6000  |    356.51 
13-Sep-22 | IBST | Ibstock                   |  5,849  |   3.3000  |    193.01 
20-Sep-22 | SHEL | Shell                     |    457  |  21.5700  |     98.57 
22-Sep-22 | BHP  | BHP Group                 |    838  | 151.4627  |  1,269.25 
22-Sep-22 | RIO  | Rio Tinto                 |    173  | 221.6300  |    383.41 
23-Sep-22 | BP   | BP                        |  1,347  |   5.1684  |     69.61 
27-Sep-22 | ABDN | Abrdn PLC                 |  6,389  |   7.3000  |    466.39 
28-Sep-22 | AV   | Aviva                     |  3,663  |  10.3000  |    377.28 
29-Sep-22 | MNG  | M & G PLC                 |  3,505  |   6.2000  |    217.31 
29-Sep-22 | HSBA | HSBC Holdings             |  2,425  |   7.8821  |    191.14 
30-Sep-22 | IMB  | Imperial Brands           |  1,283  |  21.2700  |    272.89 
06-Oct-22 | WDS  | Woodside Energy Group Ltd |    151  |  94.0450  |    142.00 
06-Oct-22 | GSK  | GSK PLC                   |    752  |  16.2500  |    122.20 
07-Oct-22 | LAND | Land Securities Group     |    818  |   8.6000  |     70.34 
20-Oct-22 | IGG  | IG Group Holdings         |  2,762  |  31.2400  |    862.84 
01-Nov-22 | WPP  | WPP                       |  1,780  |  15.0000  |    267.00 
01-Nov-22 | SMDS | DS Smith                  |  4,310  |  10.2000  |    439.62 
10-Nov-22 | BATS | British American Tobacco  |    299  |  54.4500  |    162.80 
28-Nov-22 | ITV  | ITV                       | 11,652  |   1.7000  |    198.08 
30-Nov-22 | BA   | BAE Systems               |  3,043  |  10.4000  |    316.47 
16-Dec-22 | BP   | BP                        |  1,347  |   4.9402  |     66.54 
19-Dec-22 | SHEL | Shell                     |    457  |  20.6100  |     94.18 
30-Dec-22 | IMB  | Imperial Brands           |  1,283  |  49.3100  |    632.64 
03-Jan-23 | LAND | Land Securities Group     |    818  |   9.0000  |     73.62 
06-Jan-23 | BLND | British Land Company      |  1,273  |  11.6000  |    147.66 
12-Jan-23 | GSK  | GSK PLC                   |    752  |  13.7500  |    103.40 
31-Jan-23 | SMDS | DS Smith                  |  4,310  |   6.0000  |    258.60 
02-Feb-23 | BATS | British American Tobacco  |    299  |  54.4500  |    162.80 
03-Feb-23 | VOD  | Vodafone Group            | 10,077  |   3.9592  |    398.96 
03-Mar-23 | IGG  | IG Group Holdings         |  2,762  |  13.2600  |    366.24 
27-Mar-23 | SHEL | Shell                     |    457  |  24.1100  |    110.18 
30-Mar-23 | BHP  | BHP Group                 |    838  |  74.3709  |    623.22 
31-Mar-23 | IMB  | Imperial Brands           |  1,283  |  49.3200  |    632.77 
31-Mar-23 | BP   | BP                        |  1,347  |   5.5507  |     74.76 
05-Apr-23 | WDS  | Woodside Energy Group Ltd |    151  | 121.5169  |    183.49 
05-Apr-23 | PNN  | Pennon Group              |  1,316  |  12.9600  |    170.55 
          |      |                           |         |           |           
          |      |                           |         | Total     | 16,957.63

Realised Profit & Loss: Year Four

Date      | EPIC |        Name               | Real P&L (£) |         Comment                                                             
16-May-22 | AV   | Aviva                     |      173.70  | Return of Capital - Share Consolidation                                     
01-Jun-22 | BHP  | BHP Group                 |    2,565.55  | Return of Capital - Woodside Energy Group (WDS) shares                      
19-Jul-22 | GSK  | GSK PLC                   |     -275.74  | Return of Capital - Haleon PLC (HLN) shares - Share Consolidation           
19-Jul-22 | WDS  | Woodside Energy Group Ltd |        8.15  | Return of Capital - Woodside Energy Group (WDS) shares - Share Consolidation
          |      |                           |              |                                                                             
          |      | Total                     |    2,471.66  |

Dividends Received: Year on Year - To Date and Forecast

Dividends per Unit: Year on Year - To Date and Forecast

Dividends Received: Quarterly To-Date

Year Start |  05 Jul   |  05 Oct   |  05 Jan   |  05 Apr   |   Total     | Year End 
06-Apr-19  | 3,919.13  | 4,385.07  | 3,748.91  | 2,704.03  | £14,757.14  | 05-Apr-20
06-Apr-20  | 1,561.24  | 3,083.61  | 2,343.70  | 2,939.93  |  £9,928.48  | 05-Apr-21
06-Apr-21  | 2,922.91  | 3,702.96  | 3,288.96  | 3,065.24  | £12,980.07  | 05-Apr-22
06-Apr-22  | 4,897.14  | 5,379.53  | 3,448.33  | 3,232.63  | £16,957.63  | 05-Apr-23

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

Capital Value: Quarterly To-Date

Year Start |   05 Jul    |   05 Oct    |   05 Jan    |   05 Apr    | Year End 
06-Apr-19  | 259,509.36  | 261,593.22  | 296,020.32  | 197,839.92  | 05-Apr-20
06-Apr-20  | 226,071.10  | 217,987.76  | 250,944.78  | 269,488.45  | 05-Apr-21
06-Apr-21  | 281,107.37  | 271,335.37  | 288,791.35  | 299,408.37  | 05-Apr-22
06-Apr-22  | 271,759.08  | 272,155.05  | 304,883.30  | 296,301.23  | 05-Apr-23

Everything was going quite well until the Covid-19 virus struck. Now two years on, there has been great improvement and hopefully we are now back on track.

Expected Top-Up Dates and Amounts: Year Five

Dividends and other cash 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?
11-Apr-23 | 1,885.60  | N         
10-May-23 | 3,403.33  | Y         
12-Jun-23 | 2,435.96  | Y         
10-Jul-23 |   879.03  | N         
10-Aug-23 | 1,637.96  | N         
11-Sep-23 | 2,867.21  | Y         
10-Oct-23 | 3,756.01  | Y         
10-Nov-23 | 1,925.84  | N         
11-Dec-23 | 2,440.39  | Y         
10-Jan-24 | 1,025.74  | N         
12-Feb-24 | 1,961.85  | N         
11-Mar-24 | 2,328.09  | Y

The next top-up will therefore be on 10 May 2023 which, because it is into Year Five of this virtual HYP, will be posted on a new Year Five thread.

Portfolio Capital Value: History

For those who are fascinated by the meanderings of the Capital Value, the following more detailed view of low and high values might be of interest:

Portfolio History | Date      | Cash Value  | P/L (£)     | P/L (%) | Cash Value   | XIRR  
Start Value       | 18-Mar-19 | 254,904.77  |             |         | -254,904.77  |       
Minimum Value     | 23-Mar-20 | 186,676.73  | -68,228.04  | -26.77% |              |       
Maximum Value     | 06-Mar-23 | 316,825.48  |  61,920.71  |  24.29% |              |       
Current Value     | 06-Apr-23 | 296,301.23  |  41,396.46  |  16.24% |  296,301.23  |  3.78%

Last 12 Months    | Date      | Cash Value  | P/L (£)     | P/L (%) | Cash Value   | XIRR  
Start Value       | 07-Apr-22 | 296,874.75  |             |         | -296,874.75  |       
Minimum Value     | 29-Sep-22 | 264,577.98  | -32,296.77  | -10.88% |              |       
Maximum Value     | 06-Mar-23 | 316,825.48  |  19,950.73  |   6.72% |              |       
Current Value     | 06-Apr-23 | 296,301.23  |    -573.52  |  -0.19% |  296,301.23  | -0.19%

Comparison to Other Income Investments

Over the history of this “Virtual” HYP, I have also kept records of what would have happened had the “Virtual” funds been invested elsewhere, with the same aim of drawing income. The following charts show a comparison with this “Virtual” HYP:

CTY = The City of London Investment Trust Plc
EDIN = Edinburgh Investment Trust Plc
HHI = Henderson High Income Trust Plc
JCH = JPMorgan Claverhouse Investment Trust Plc
MRCH = The Merchants Trust Plc
TMPL = Temple Bar Investment Trust Plc

Price details are taken from Yahoo. For example: https://finance.yahoo.com/quote/JCH.L?p=JCH.L
Dividend details are taken from Dividend Max. For example: https://www.dividendmax.com/united-king ... /dividends

Annual Income: Year Four - HYP Compared with Various Other Income Investments

        Dates          |    HYP    |    CTY    |    EDIN   |    HHI    |    JCH    |    MRCH   |    TMPL  
06-Apr-19 to 05-Apr-20 | 14,757.14 | 11,782.62 | 11,388.11 | 13,906.70 | 10,362.28 | 14,108.79 | 10,085.71
06-Apr-20 to 05-Apr-21 |  9,928.48 | 12,394.28 | 11,820.57 | 14,495.33 | 11,035.29 | 15,183.79 |  7,956.17
06-Apr-21 to 05-Apr-22 | 12,980.07 | 13,179.60 | 12,779.57 | 13,643.76 | 11,923.16 | 16,104.21 |  8,490.87
06-Apr-22 to 05-Apr-23 | 16,957.63 | 14,410.70 | 11,912.32 | 14,508.07 | 13,480.30 | 17,029.45 | 10,437.38

During this fourth year, the HYP’s Income has increased to be on a par with the average of the chosen alternatives!

Average Annual Income: To Date - HYP Compared with Various Other Income Investments

        Dates          | HYP Avg   | CTY Avg   | EDIN Avg  | HHI Avg   | JCH Avg   | MRCH Avg  | TMPL Avg 
06-Apr-19 to 05-Apr-20 | 14,757.14 | 11,782.62 | 11,388.11 | 13,906.70 | 10,362.28 | 14,108.79 | 10,085.71
06-Apr-19 to 05-Apr-21 | 12,342.81 | 12,088.45 | 11,604.34 | 14,201.02 | 10,698.79 | 14,646.29 |  9,020.94
06-Apr-19 to 05-Apr-22 | 12,555.23 | 12,452.17 | 11,996.08 | 14,015.26 | 11,106.91 | 15,132.26 |  8,844.25
06-Apr-19 to 05-Apr-23 | 13,655.83 | 12,941.80 | 11,975.14 | 14,138.47 | 11,700.26 | 15,606.56 |  9,242.53

Because of the income received during the first year, the HYP’s Average Annual Income for the these first three years is still on a par with the average of the chosen alternatives.

Annual Value: End of Year Four - HYP Compared with Various Other Income Investments

Year End  |    HYP     |    CTY     |    EDIN    |    HHI     |    JCH     |    MRCH    |    TMPL   
05-Apr-19 | 258,446.15 | 257,863.59 | 254,617.84 | 257,258.82 | 254,467.83 | 258,096.06 | 255,989.17
05-Apr-20 | 197,839.92 | 195,528.17 | 169,979.44 | 190,933.44 | 188,001.48 | 195,469.63 | 148,435.18
05-Apr-21 | 269,488.45 | 255,131.42 | 264,089.21 | 282,687.20 | 263,793.82 | 291,753.81 | 243,526.42
05-Apr-22 | 299,408.37 | 298,241.39 | 293,069.64 | 309,451.91 | 287,783.35 | 351,804.89 | 252,590.86
05-Apr-23 | 296,301.23 | 306,222.36 | 313,207.36 | 310,964.17 | 281,230.15 | 361,923.67 | 264,051.17

During this admittedly short period of four years, HYP’s capital values have basically aligned with those recorded for the chosen alternatives.

Please note that the above three datasets are for interest and information only. It is not my intention to further discuss the comparative effectiveness of HYP with any other Income Investment on this thread, or indeed on this board!

Next Action Required

The next report, which will be the start of the Year Five thread, will be next month – 9/10 May. I must decide what to purchase with the cash then available - £3,403.33. At the moment, my thinking in this regardis as follows:

Business        | EPIC | Company                   | Reward (%) | Decision     | Comments                                     
Oil             | WDS  | Woodside Energy Group Ltd |     11.20% | Possible     | Resultant Sector Value Concentration (8.38%) 
Fund Manager    | MNG  | M & G PLC                 |     10.32% | Possible     | Resultant Sector Value Concentration (7.17%) 
Insurance: Life | PHNX | Phoenix Group Holdings    |      9.34% | Possible     | Resultant Sector Value Concentration (5.69%) 
Telecom: Mobile | VOD  | Vodafone Group            |      8.85% | Possible     | Resultant Sector Value Concentration (3.67%) 
Tobacco         | BATS | British American Tobacco  |      8.23% | Disqualified | Resultant Sector Value Concentration (11.56%)
Mining          | RIO  | Rio Tinto                 |      7.70% | Disqualified | Resultant Sector Value Concentration (10.54%)
Insurance: Life | AV   | Aviva                     |      7.58% | Possible     | Resultant Sector Value Concentration (5.69%)

We shall see.

The re-investment will take place on 10 May.

Should anyone wish to comment on this report, as well as any actions taken in the management of this virtual HYP Portfolio, then please do so but only on this related thread: viewtopic.php?f=15&t=34042&p=575153

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

However please note, if you wish to discuss further the comparison of this “Virtual” HYP with other “Virtual” Investment Trust Investments, please do so, but on a more appropriate board.

Enjoy!

Ian

IanTHughes · #587955

For the activity during Year Five of this portfolio please see this thread: viewtopic.php?f=15&t=39071

The Lemon Fool

Donate to Remove ads

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

PYAD HYP 2019_04 REINVEST – Year Four

PYAD HYP 2019_04 REINVEST – Year Four

PYAD HYP 2019_04 REINVEST: Year Four - Top-Up

PYAD HYP 2019_04 REINVEST – Year Four: Top-Up - 10 June 2022

PYAD HYP 2019_04 REINVEST – Year Four: Top-Up - 10 June 2022 - Result

PYAD HYP 2019_04 REINVEST – Year Four: GSK PLC (GSK) – Haleon PLC (HLN) Demerger

PYAD HYP 2019_04 REINVEST – Year Four: Update - 20 August 2022

PYAD HYP 2019_04 REINVEST – Year Four: Top-Up – 12 September 2022 - Decision

PYAD HYP 2019_04 REINVEST – Year Four: Dividend Re-Investment - 12 September 2022 - Result

PYAD HYP 2019_04 REINVEST – Year Four: Top-Up – 10 October 2022 - Decision

PYAD HYP 2019_04 REINVEST – Year Four: Dividend Re-Investment - 10 October 2022 - Result

PYAD HYP 2019_04 REINVEST – Year Four: Update – 30 October 2022

PYAD HYP 2019_04 REINVEST – Year Four: Top-Up – 12 December 2022 - Decision

PYAD HYP 2019_04 REINVEST – Year Four: Dividend Re-Investment - 12 December 2022 - Result

PYAD HYP 2019_04 REINVEST – Year Four: Top-Up – 10 March 2023 - Decision

PYAD HYP 2019_04 REINVEST – Year Four: Dividend Re-Investment - 10 March 2023 - Result

PYAD HYP 2019_04 REINVEST – Year Four: End of Year

Re: PYAD HYP 2019_04 REINVEST – Year Four

Who is online