PYAD HYP 2019_04 DRAWDOWN – Year 2
Posted: July 3rd, 2020, 6:54 pm
A thread detailing the progress during the Year One can be found here: viewtopic.php?p=225865#p225865
Year 2 – Quarter One - 05 July 2020
This is a report on the Drawdown version of the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140
Further details of how updates are to be made to this portfolio can be found on this thread: viewtopic.php?p=218513#p218513
Current Portfolio: Holdings
Current Portfolio: Business Sectors
(*) - Yield and Forecast Income are based on my own Share Database Spreadsheet and are essentially calculated from the dividends that would have been earned over the previous 12 months, unless the company itself has clearly indicated otherwise. However, in view of all the recent dividend suspensions/cancellations, the above Year Div (£) columns should be treated very much as speculative.
Transactions concluded during this 1st Quarter
None
Income: To-Date
Seven of the original holdings were already Ex-Dividend on purchase, meaning that the income received did not represent a full year.
With regard to the future, I have attempted to keep up with all the suspensions/cancellations over the past couple of months, but I do not believe it is currently possible to make a sensible estimate of the income to be received during the next year. We shall have to wait and see.
Income: Monthly Forecast
Capital Value
Everything was going quite well until the Covid-19 virus struck. Now of course the value is well down, but it has recovered quite significantly since 05 April 2020.
The next report will be at the end of Quarter Two - 5 November 2020 - when hopefully the dividend situation will be clearer.
Should anyone wish to comment on this report, or any actions taken in the management of this virtual HYP Portfolio, then please do so but only on this related thread: viewtopic.php?p=323588#p323588
The intention is to keep this thread simply recording the history of the Portfolio
Enjoy!
Ian
Year 2 – Quarter One - 05 July 2020
This is a report on the Drawdown version of the HYP constructed by pyad, as recorded on this thread: viewtopic.php?f=15&t=16868&start=140
Further details of how updates are to be made to this portfolio can be found on this thread: viewtopic.php?p=218513#p218513
Current Portfolio: Holdings
EPIC | Company | Shares | Cost (£) | Price (p) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | To-Date(£) | Overall (£) | Yield (%) * | Year Div (£)
AV | Aviva | 4,134 | 16,887.39 | 273.5000 | 11,306.49 | 5.38% | -5,580.90 | 0.00 | 1,100.18 | 1,100.18 | -4,480.72 | 11.30% | 1,277.40
BA | BAE Systems | 3,043 | 14,995.20 | 482.2000 | 14,673.35 | 6.98% | -321.85 | 0.00 | 687.71 | 687.71 | 365.86 | 4.81% | 705.97
BHP | BHP Group | 838 | 14,992.51 | 1,636.4000 | 13,713.03 | 6.52% | -1,279.48 | 0.00 | 944.08 | 944.08 | -335.40 | 7.09% | 972.36
BLND | British Land Company | 1,273 | 7,494.24 | 389.0000 | 4,951.97 | 2.36% | -2,542.27 | 0.00 | 301.87 | 301.87 | -2,240.40 | 6.16% | 304.85
BP | BP | 1,717 | 9,379.72 | 307.5500 | 5,280.63 | 2.51% | -4,099.09 | 0.00 | 638.69 | 638.69 | -3,460.40 | 11.08% | 585.15
CCL | Carnival Corporation | 384 | 14,979.79 | 1,002.0000 | 3,847.68 | 1.83% | -11,132.11 | 0.00 | 610.18 | 610.18 | -10,521.93 | 12.15% | 467.38
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,625.8000 | 15,298.78 | 7.28% | 299.41 | 178.79 | 752.80 | 931.59 | 1,231.00 | 4.92% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 383.5000 | 9,299.88 | 4.42% | -5,698.39 | 0.00 | 573.99 | 573.99 | -5,124.40 | 4.44% | 413.21
IBST | Ibstock | 5,849 | 14,999.47 | 173.5000 | 10,148.02 | 4.83% | -4,851.45 | 0.00 | 859.79 | 859.79 | -3,991.66 | 5.59% | 567.35
IGG | IG Group Holdings | 2,762 | 14,999.32 | 844.0000 | 23,311.28 | 11.09% | 8,311.96 | 0.00 | 1,193.17 | 1,193.17 | 9,505.13 | 5.12% | 1,193.18
IMB | Imperial Brands | 568 | 14,988.79 | 1,486.5000 | 8,443.32 | 4.02% | -6,545.47 | 0.00 | 1,291.73 | 1,291.73 | -5,253.74 | 9.26% | 782.13
ITV | ITV | 11,652 | 14,999.08 | 71.9200 | 8,380.12 | 3.99% | -6,618.96 | 0.00 | 932.15 | 932.15 | -5,686.81 | 3.62% | 302.95
LAND | Land Securities Group | 818 | 7,499.19 | 578.0000 | 4,728.04 | 2.25% | -2,771.15 | 0.00 | 285.05 | 285.05 | -2,486.10 | 4.01% | 189.77
PNN | Pennon Group | 1,900 | 15,406.25 | 1,102.0000 | 20,938.00 | 9.96% | 5,531.75 | 0.00 | 259.54 | 259.54 | 5,791.29 | 3.97% | 831.63
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 1,234.4000 | 3,814.30 | 1.81% | -3,667.36 | 0.00 | 499.10 | 499.10 | -3,168.26 | 4.21% | 160.46
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 269.0000 | 14,803.07 | 7.04% | -194.58 | 0.00 | 1,975.55 | 1,975.55 | 1,780.97 | 8.03% | 1,188.64
SMDS | DS Smith | 4,310 | 14,997.11 | 291.4000 | 12,559.34 | 5.97% | -2,437.77 | 0.00 | 698.22 | 698.22 | -1,739.55 | 1.85% | 232.74
VOD | Vodafone Group | 10,077 | 14,998.48 | 129.6400 | 13,063.82 | 6.21% | -1,934.66 | 412.61 | 758.07 | 1,170.68 | -763.98 | 6.32% | 825.22
WPP | WPP | 1,780 | 14,997.55 | 623.2000 | 11,092.96 | 5.28% | -3,904.59 | 0.00 | 1,068.00 | 1,068.00 | -2,836.59 | 3.64% | 404.06
| | | | | | | | | | | | |
| Sub Total: | | | | £209,654.08 | 99.72% | -£49,436.96 | £591.40 | | | | 5.80% | £12,157.25
| Cash Balance: | | | | £0.00 | 0.00% | | | | | | |
| Ex-Dividend: | | | | £591.40 | 0.28% | | | | | | |
| | | | | | | | | | | | |
| Current Portfolio Value: | | | | £210,245.48 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | -£15,979.42 | | | | | | | |
| Dividends Received: | | | | £15,977.40 | | | | | | | |
| Ex-Dividend: | | | | £591.40 | | | | | | | |
| Realised P/L: | | | GNK | £4,188.29 | | | | | | | |
| Un-Realised P/L: | | | | -£49,436.96 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £210,245.48 | -9.34% | | | | | | |
Current Portfolio: Business Sectors
Business | Cost (£) | Value (£) | Value (%) | P/L (£) | Ex-Div (£) | Div Rec'd (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Gambling | 14,999.32 | 23,311.28 | 11.09% | 8,311.96 | 0.00 | 1,193.17 | 1,193.17 | 9,505.13 | 5.12% | 1,193.18
Water | 15,406.25 | 20,938.00 | 9.96% | 5,531.75 | 0.00 | 259.54 | 259.54 | 5,791.29 | 3.97% | 831.63
Pharma | 14,999.37 | 15,298.78 | 7.28% | 299.41 | 178.79 | 752.80 | 931.59 | 1,231.00 | 4.92% | 752.80
Fund Manager | 14,997.65 | 14,803.07 | 7.04% | -194.58 | 0.00 | 1,975.55 | 1,975.55 | 1,780.97 | 8.03% | 1,188.64
Weapons | 14,995.20 | 14,673.35 | 6.98% | -321.85 | 0.00 | 687.71 | 687.71 | 365.86 | 4.81% | 705.97
Mining | 14,992.51 | 13,713.03 | 6.52% | -1,279.48 | 0.00 | 944.08 | 944.08 | -335.40 | 7.09% | 972.36
Telecom | 14,998.48 | 13,063.82 | 6.21% | -1,934.66 | 412.61 | 758.07 | 1,170.68 | -763.98 | 6.32% | 825.22
Packaging | 14,997.11 | 12,559.34 | 5.97% | -2,437.77 | 0.00 | 698.22 | 698.22 | -1,739.55 | 1.85% | 232.74
Insurance | 16,887.39 | 11,306.49 | 5.38% | -5,580.90 | 0.00 | 1,100.18 | 1,100.18 | -4,480.72 | 11.30% | 1,277.40
Advertising | 14,997.55 | 11,092.96 | 5.28% | -3,904.59 | 0.00 | 1,068.00 | 1,068.00 | -2,836.59 | 3.64% | 404.06
Bricks | 14,999.47 | 10,148.02 | 4.83% | -4,851.45 | 0.00 | 859.79 | 859.79 | -3,991.66 | 5.59% | 567.35
Property | 14,993.43 | 9,680.01 | 4.60% | -5,313.42 | 0.00 | 586.92 | 586.92 | -4,726.50 | 5.11% | 494.62
Banks | 14,998.27 | 9,299.88 | 4.42% | -5,698.39 | 0.00 | 573.99 | 573.99 | -5,124.40 | 4.44% | 413.21
Oil | 16,861.38 | 9,094.93 | 4.33% | -7,766.45 | 0.00 | 1,137.79 | 1,137.79 | -6,628.66 | 8.20% | 745.61
Tobacco | 14,988.79 | 8,443.32 | 4.02% | -6,545.47 | 0.00 | 1,291.73 | 1,291.73 | -5,253.74 | 9.26% | 782.13
Television | 14,999.08 | 8,380.12 | 3.99% | -6,618.96 | 0.00 | 932.15 | 932.15 | -5,686.81 | 3.62% | 302.95
Cruise Ships | 14,979.79 | 3,847.68 | 1.83% | -11,132.11 | 0.00 | 610.18 | 610.18 | -10,521.93 | 12.15% | 467.38
(*) - Yield and Forecast Income are based on my own Share Database Spreadsheet and are essentially calculated from the dividends that would have been earned over the previous 12 months, unless the company itself has clearly indicated otherwise. However, in view of all the recent dividend suspensions/cancellations, the above Year Div (£) columns should be treated very much as speculative.
Transactions concluded during this 1st Quarter
None
Income: To-Date
Year Start | Q1 | Q2 | Q3 | Q4 | Total | Year End
06-Apr-19 | £3,919.13 | £4,576.80 | £3,669.14 | £2,508.15 | £14,673.22 | 05-Apr-20
06-Apr-20 | £1,304.18 | £0.00 | £0.00 | £0.00 | 1,304.18 | 05-Apr-21
Seven of the original holdings were already Ex-Dividend on purchase, meaning that the income received did not represent a full year.
With regard to the future, I have attempted to keep up with all the suspensions/cancellations over the past couple of months, but I do not believe it is currently possible to make a sensible estimate of the income to be received during the next year. We shall have to wait and see.
Income: Monthly Forecast
Date | Amount (£) |
05-Aug-20 | 178.79 |
04-Sep-20 | 984.70 |
05-Oct-20 | 1,972.57 |
05-Nov-20 | 1,418.07 |
04-Dec-20 | 690.60 |
05-Jan-21 | 709.70 |
05-Feb-21 | 178.79 |
05-Mar-21 | 872.17 |
01-Apr-21 | 1,056.80 |
05-May-21 | 1,318.41 |
04-Jun-21 | 2,091.52 |
05-Jul-21 | 684.99 |
| | Average
12 Months | £12,157.11 | £1,013.09
Capital Value
Everything was going quite well until the Covid-19 virus struck. Now of course the value is well down, but it has recovered quite significantly since 05 April 2020.
The next report will be at the end of Quarter Two - 5 November 2020 - when hopefully the dividend situation will be clearer.
Should anyone wish to comment on this report, or any actions taken in the management of this virtual HYP Portfolio, then please do so but only on this related thread: viewtopic.php?p=323588#p323588
The intention is to keep this thread simply recording the history of the Portfolio
Enjoy!
Ian