This is a report on the Drawdown version of the “virtual” HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140 and subsequently managed by myself.
A thread detailing the progress during the Year One can be found here: viewtopic.php?p=225865#p225865
A thread detailing the progress during the Year Two can be found here: viewtopic.php?p=323586#p323586
A thread detailing the progress during the Year Three can be found here: viewtopic.php?f=15&t=33976
A thread detailing the progress during the Year Four can be found here: viewtopic.php?f=15&t=34668
Further details of how updates are to be made to this portfolio can be found on this thread: viewtopic.php?p=218513#p218513
Progress Update: 05 July 2023
Current Portfolio: Holdings
EPIC | Company | Shares | Cost (£) | Price (p) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£) | Year Div (%)
IMB | Imperial Brands | 988 | 21,739.68 | 1,772.0000 | 17,507.36 | 7.61% | -4,232.32 | 0.00 | 4,849.17 | 616.85 | 8.00% | 1,401.08 | 10.16%
WPP | WPP | 1,780 | 14,997.55 | 830.6000 | 14,784.68 | 6.43% | -212.87 | 434.32 | 2,317.56 | 2,539.01 | 4.74% | 701.32 | 5.09%
ITV | ITV | 11,652 | 14,999.08 | 68.0000 | 7,923.36 | 3.45% | -7,075.72 | 0.00 | 1,899.25 | -5,176.47 | 7.35% | 582.60 | 4.22%
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 621.9000 | 15,081.08 | 6.56% | 82.81 | 0.00 | 2,128.16 | 2,210.97 | 5.06% | 762.51 | 5.53%
ABDN | Abrdn PLC | 5,503 | 14,997.65 | 219.7000 | 12,090.09 | 5.26% | -2,907.56 | 0.00 | 4,385.81 | 1,478.25 | 6.65% | 803.43 | 5.83%
IGG | IG Grp Holdings | 2,762 | 14,999.32 | 652.5000 | 18,022.05 | 7.84% | 3,022.73 | 0.00 | 4,808.59 | 7,831.32 | 6.82% | 1,229.09 | 8.91%
AV | Aviva | 3,141 | 12,830.98 | 389.9000 | 12,246.75 | 5.33% | -584.23 | 0.00 | 4,101.59 | 3,517.36 | 7.95% | 973.71 | 7.06%
DLG | Direct Line Ins. Grp | 1,640 | 4,201.94 | 135.6000 | 2,223.84 | 0.97% | -1,978.10 | 0.00 | 124.64 | -1,853.46 | 5.60% | 124.64 | 0.90%
HLN | Haleon PLC | 941 | 2,723.59 | 317.8500 | 2,990.97 | 1.30% | 267.38 | 0.00 | 22.58 | 289.96 | 1.51% | 45.16 | 0.33%
GSK | GSK PLC | 752 | 11,986.74 | 1,366.6000 | 10,276.84 | 4.47% | -1,709.90 | 105.28 | 2,719.14 | 1,114.52 | 4.13% | 424.88 | 3.08%
IBST | Ibstock | 5,849 | 14,999.47 | 139.7000 | 8,171.05 | 3.55% | -6,828.42 | 0.00 | 1,614.29 | -5,214.13 | 6.30% | 514.71 | 3.73%
SMDS | DS Smith | 4,310 | 14,997.11 | 278.9000 | 12,020.59 | 5.23% | -2,976.52 | 0.00 | 2,124.83 | -851.69 | 6.45% | 775.80 | 5.63%
BA | BAE Systems | 3,043 | 14,995.20 | 910.8000 | 27,715.64 | 12.05% | 12,720.44 | 0.00 | 3,414.20 | 16,134.64 | 2.96% | 821.61 | 5.96%
LAND | Land Securities Grp | 818 | 7,499.19 | 597.6000 | 4,888.37 | 2.13% | -2,610.82 | 98.16 | 1,026.15 | -1,486.51 | 6.46% | 315.74 | 2.29%
BLND | British Land Company | 1,273 | 7,494.24 | 318.3000 | 4,051.96 | 1.76% | -3,442.28 | 140.53 | 920.01 | -2,381.74 | 7.11% | 288.20 | 2.09%
BHP | BHP Grp | 838 | 14,992.51 | 2,350.0000 | 19,693.00 | 8.56% | 4,700.49 | 0.00 | 5,402.17 | 10,102.66 | 8.86% | 1,745.69 | 12.66%
BP | BP | 1,717 | 9,379.72 | 459.8000 | 7,894.77 | 3.43% | -1,484.95 | 0.00 | 1,548.33 | 63.38 | 4.52% | 356.86 | 2.59%
SHEL | Shell | 309 | 7,481.66 | 2,329.0000 | 7,196.61 | 3.13% | -285.05 | 0.00 | 1,148.13 | 863.08 | 4.22% | 303.63 | 2.20%
WDS | Woodside Energy Grp | 151 | 2,565.55 | 1,830.0000 | 2,763.30 | 1.20% | 197.75 | 0.00 | 325.49 | 523.24 | 10.87% | 300.31 | 2.18%
VOD | Vodafone Grp | 10,077 | 14,998.48 | 72.6700 | 7,322.96 | 3.19% | -7,675.52 | 389.37 | 3,115.82 | -4,170.33 | 10.63% | 778.75 | 5.65%
CCL | Carnival Corp. | 384 | 14,979.79 | 1,351.5000 | 5,189.76 | 2.26% | -9,790.03 | 0.00 | 610.18 | -9,179.85 | 0.00% | 0.00 | 0.00%
PNN | Pennon Grp | 1,266 | 10,265.43 | 689.0000 | 8,722.74 | 3.79% | -1,542.69 | 0.00 | 1,896.45 | 353.76 | 6.20% | 540.96 | 3.92%
| | | | | | | | | | | | |
| Sub Total: | | | | £228,777.77 | 99.49% | -£34,345.38 | £1,167.66 | | | 6.03% | £13,790.68 |
| Cash Balance: | | | | £0.00 | 0.00% | | | | | | |
| Ex Dividend: | | | | £1,167.66 | 0.51% | | | | | | |
| | | | | | | | | | | | |
| Current Value: | | | | £229,945.43 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | -£51,929.57 | | | | | | | |
| Dividends Rec'd: | | | | £51,055.45 | | | | | | | |
| Ex Dividend: | | | | £1,167.66 | | | | | | | |
| Realised P/L: | [2] | | | £9,092.50 | | | | | | | |
| UnRealised P/L: | | | | -£34,345.38 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £229,945.43 | 2.61% | | | | | | |
Current Portfolio: Business Sectors
Business | Cost (£) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | Overall (£) | Y'ld (%) [1] | Year Div (£) | Year Div (%)
Weapons | 14,995.20 | 27,715.64 | 12.05% | 12,720.44 | 0.00 | 3,414.20 | 16,134.64 | 2.96% | 821.61 | 5.96%
Mining | 14,992.51 | 19,693.00 | 8.56% | 4,700.49 | 0.00 | 5,402.17 | 10,102.66 | 8.86% | 1,745.69 | 12.66%
Gambling | 14,999.32 | 18,022.05 | 7.84% | 3,022.73 | 0.00 | 4,808.59 | 7,831.32 | 6.82% | 1,229.09 | 8.91%
Oil | 19,426.93 | 17,854.68 | 7.76% | -1,572.25 | 0.00 | 3,021.95 | 1,449.70 | 5.38% | 960.80 | 6.97%
Tobacco | 21,739.68 | 17,507.36 | 7.61% | -4,232.32 | 0.00 | 4,849.17 | 616.85 | 8.00% | 1,401.08 | 10.16%
Banks | 14,998.27 | 15,081.08 | 6.56% | 82.81 | 0.00 | 2,128.16 | 2,210.97 | 5.06% | 762.51 | 5.53%
Advertising | 14,997.55 | 14,784.68 | 6.43% | -212.87 | 434.32 | 2,317.56 | 2,539.01 | 4.74% | 701.32 | 5.09%
Insurance: Life | 12,830.98 | 12,246.75 | 5.33% | -584.23 | 0.00 | 4,101.59 | 3,517.36 | 7.95% | 973.71 | 7.06%
Fund Manager | 14,997.65 | 12,090.09 | 5.26% | -2,907.56 | 0.00 | 4,385.81 | 1,478.25 | 6.65% | 803.43 | 5.83%
Packaging | 14,997.11 | 12,020.59 | 5.23% | -2,976.52 | 0.00 | 2,124.83 | -851.69 | 6.45% | 775.80 | 5.63%
Pharma | 11,986.74 | 10,276.84 | 4.47% | -1,709.90 | 105.28 | 2,719.14 | 1,114.52 | 4.13% | 424.88 | 3.08%
Utility: Water | 10,265.43 | 8,722.74 | 3.79% | -1,542.69 | 0.00 | 1,896.45 | 353.76 | 6.20% | 540.96 | 3.92%
Real Estate IT | 14,993.43 | 8,940.33 | 3.89% | -6,053.10 | 238.69 | 1,946.16 | -3,868.25 | 6.76% | 603.94 | 4.38%
Bricks | 14,999.47 | 8,171.05 | 3.55% | -6,828.42 | 0.00 | 1,614.29 | -5,214.13 | 6.30% | 514.71 | 3.73%
Television | 14,999.08 | 7,923.36 | 3.45% | -7,075.72 | 0.00 | 1,899.25 | -5,176.47 | 7.35% | 582.60 | 4.22%
Telecom: Mobile | 14,998.48 | 7,322.96 | 3.18% | -7,675.52 | 389.37 | 3,115.82 | -4,170.33 | 10.63% | 778.75 | 5.65%
Cruising | 14,979.79 | 5,189.76 | 2.26% | -9,790.03 | 0.00 | 610.18 | -9,179.85 | 0.00% | 0.00 | 0.00%
Medical Products | 2,723.59 | 2,990.97 | 1.30% | 267.38 | 0.00 | 22.58 | 289.96 | 1.51% | 45.16 | 0.33%
Insurance: NonLife | 4,201.94 | 2,223.84 | 0.97% | -1,978.10 | 0.00 | 124.64 | -1,853.46 | 5.60% | 124.64 | 0.90%
[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 | Amount | Comment
20-Sep-19 | BHP | BHP Group | 550.49 | Return of Capital
20-Sep-19 | IBST | Ibstock | 292.45 | Return of Capital
09-Oct-19 | GNK | Greene King | 4,188.29 | Profit from Sale – Pending Takeover
16-Jul-21 | PNN | Pennon Group | 1,612.39 | Return of Capital - Share Consolidation
16-May-22 | AV | Aviva | 150.92 | Return of Capital - Share Consolidation
25-May-22 | BHP | BHP Group | 2,565.55 | Return of Capital - Woodside Energy Group (WDS)
18-Jul-22 | GSK | GSK PLC | -275.74 | Return of Capital - Haleon PLC (HLN) - Share Consolidation
24-Oct-22 | WDS | Woodside Energy Grp Ltd | 8.15 | Return of Capital - Woodside Energy Group (WDS) - Share Consolidation
| | | |
| | Total | £9,092.50 |
Portfolio Transactions: Year Five – First Quarter
None
Portfolio Value: To Date
The value of the portfolio has been recorded at the end of each quarter as follows:
Year Start | 05 Jul | 05 Oct | 05 Jan | 05 Apr | Year End
06-Apr-19 | 255,788.16 | 253,439.06 | 282,038.76 | 184,255.31 | 05-Apr-20
06-Apr-20 | 210,241.80 | 199,923.48 | 228,333.53 | 243,598.51 | 05-Apr-21
06-Apr-21 | 251,495.87 | 239,861.05 | 252,613.80 | 255,457.52 | 05-Apr-22
06-Apr-22 | 228,631.50 | 224,572.00 | 247,653.54 | 244,503.41 | 05-Apr-23
06-Apr-23 | 232,726.45 | | | | 05-Apr-24
Portfolio Value: Comments
Capital Value has decreased close to 9% since inception, a value which represents approximately 60% of the dividends received during the same period. There was a recovery after the mauling to the portfolio value received during the Economy Lockdowns during 2020 and 2021, but the recent downturn in the market has now reversed that recovery somewhat.
Of course, as a High Yield Portfolio (HYP) the Capital Value is very much of secondary interest.
Portfolio Dividends Received: Year Five
Dividends received this current financial year – 06 April 2023 to 05 April 2024:
Date | Epic | Name | Shares (#) | Dividend (p) | Amount (£)
06-Apr-23 | LAND | Land Securities Group | 818 | 9.0000 | 73.62
13-Apr-23 | GSK | GSK PLC | 752 | 13.7500 | 103.40
27-Apr-23 | HSBA | HSBC Holdings | 2,425 | 18.5392 | 449.57
27-Apr-23 | HLN | Haleon PLC | 941 | 2.4000 | 22.58
12-May-23 | IBST | Ibstock | 5,849 | 5.5000 | 321.69
16-May-23 | ABDN | Abrdn PLC | 5,503 | 7.3000 | 401.71
18-May-23 | AV | Aviva | 3,141 | 20.7000 | 650.18
25-May-23 | ITV | ITV | 11,652 | 3.3000 | 384.51
01-Jun-23 | BA | BAE Systems | 3,043 | 16.6000 | 505.13
23-Jun-23 | BP | BP | 1,717 | 5.3089 | 91.15
23-Jun-23 | HSBA | HSBC Holdings | 2,425 | 7.9378 | 192.49
26-Jun-23 | SHEL | Shell | 309 | 22.9900 | 71.03
30-Jun-23 | IMB | Imperial Brands | 988 | 21.5900 | 213.30
| | | | |
| | | | Total | £3,480.36
Portfolio Income: Withdrawn To-Date
Amounts withdrawn from the portfolio during each quarter since inception:
Year Start | 05 Jul | 05 Oct | 05 Jan | 05 Apr | Total | Year End
06-Apr-19 | 3,919.13 | 4,576.80 | 3,671.16 | 2,508.15 | £14,675.24 | 05-Apr-20
06-Apr-20 | 1,304.18 | 2,809.72 | 1,954.66 | 2,497.89 | £8,566.45 | 05-Apr-21
06-Apr-21 | 2,380.96 | 3,470.79 | 2,922.75 | 2,743.56 | £11,518.06 | 05-Apr-22
06-Apr-22 | 3,457.24 | 4,193.51 | 3,136.00 | 2,902.71 | £13,689.46 | 05-Apr-23
06-Apr-23 | 3,480.36 | | | | £3,480.36 | 05-Apr-24
Portfolio Income: 12 Month Forecast
Amounts forecast to be withdrawn over the next 12 Months:
Date | Income (£)
04-Aug-23 | 1,167.66
05-Sep-23 | 376.88
05-Oct-23 | 3,281.92
03-Nov-23 | 1,434.84
05-Dec-23 | 705.17
05-Jan-24 | 725.91
05-Feb-24 | 902.79
05-Mar-24 | 366.24
05-Apr-24 | 1,580.25
03-May-24 | 393.98
05-Jun-24 | 2,263.22
05-Jul-24 | 569.03
|
12 Months | £13,767.89
Average | £1,147.32
Portfolio Income: Comments
A further £10,541.66 is currently forecast to be withdrawn during this current financial year – to 05 April 2024 – giving a forecast for the year of £14,022.02. This amount is somewhat ahead of the previous year - £13,689.46 – demonstrating I believe, the now complete recovery from the downturn wrought by the Covid Pandemic. However, it is recognised that such a total amount to be withdrawn during Year Five, welcome as it will be, is still short of the amount that was received in Year One.
Next Actions Required
Currently there are no actions that must be undertaken in the management of this portfolio, other than the occasional Progress Review
Next Progress Review: Year Ending 05 April 2024 - End of Quarter Two
A report on the continuing progress of the portfolio will be produced on, or soon after, the 05 October 2023
Should anyone wish to comment on this review, or 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=35045
The intention is to keep this thread simply recording the events and progress of the Portfolio during its fourth year.
Enjoy!
Ian