Donate to Remove ads

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

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

PYAD HYP 2019_04 DRAWDOWN – Year 2

For discussion of the practicalities of setting up and operating income-portfolios which follow the HYP Group Guidelines. READ Guidelines before posting
Forum rules
Tight HYP discussions only please - OT please discuss in strategies
IanTHughes
Lemon Quarter
Posts: 1789
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 730 times
Been thanked: 1117 times

PYAD HYP 2019_04 DRAWDOWN – Year 2

#323586

Postby IanTHughes » 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

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

MDW1954
Lemon Quarter
Posts: 2358
Joined: November 4th, 2016, 8:46 pm
Has thanked: 526 times
Been thanked: 1011 times

Re: PYAD HYP 2019_04 DRAWDOWN – Year 2

#323606

Postby MDW1954 » July 3rd, 2020, 8:15 pm

Moderator Message:
Posters are reminded of the OP's intent:

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

-- MDW1954

IanTHughes
Lemon Quarter
Posts: 1789
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 730 times
Been thanked: 1117 times

PYAD HYP 2019_04 DRAWDOWN – Year 2 - October Update

#345490

Postby IanTHughes » October 5th, 2020, 11:13 pm

Year 2 – Quarter Two - 05 October 2020

A thread detailing the progress during the Year One can be found here: viewtopic.php?p=225865#p225865

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 | 291.3000 | 12,042.34 | 6.02% | -4,845.05 | 0.00 | 1,348.22 | 1,348.22 | -3,496.83 | 9.41% | 1,132.71
BA | BAE Systems | 3,043 | 14,995.20 | 495.1000 | 15,065.89 | 7.54% | 70.69 | 0.00 | 1,107.64 | 1,107.64 | 1,178.33 | 4.69% | 705.97
BHP | BHP Group | 838 | 14,992.51 | 1,652.6000 | 13,848.79 | 6.93% | -1,143.72 | 0.00 | 1,296.94 | 1,296.94 | 153.22 | 5.61% | 777.06
BLND | British Land Company | 1,273 | 7,494.24 | 352.5000 | 4,487.33 | 2.25% | -3,006.91 | 0.00 | 301.87 | 301.87 | -2,705.04 | 2.26% | 101.61
BP | BP | 1,717 | 9,379.72 | 217.8000 | 3,739.63 | 1.87% | -5,640.09 | 0.00 | 708.11 | 708.11 | -4,931.98 | 7.45% | 278.62
CCL | Carnival Corporation | 384 | 14,979.79 | 969.8000 | 3,724.03 | 1.86% | -11,255.76 | 0.00 | 610.18 | 610.18 | -10,645.58 | 0.00% | 0.00
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,449.8000 | 13,642.62 | 6.82% | -1,356.75 | 178.79 | 931.59 | 1,110.38 | -246.37 | 5.52% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 309.3500 | 7,501.74 | 3.75% | -7,496.53 | 0.00 | 573.99 | 573.99 | -6,922.54 | 5.25% | 393.51
IBST | Ibstock | 5,849 | 14,999.47 | 160.2000 | 9,370.10 | 4.69% | -5,629.37 | 0.00 | 859.79 | 859.79 | -4,769.58 | 4.06% | 380.18
IGG | IG Group Holdings | 2,762 | 14,999.32 | 825.0000 | 22,786.50 | 11.40% | 7,787.18 | 835.22 | 1,193.17 | 2,028.39 | 9,815.57 | 5.24% | 1,193.18
IMB | Imperial Brands | 568 | 14,988.79 | 1,383.0000 | 7,855.44 | 3.93% | -7,133.35 | 0.00 | 1,410.15 | 1,410.15 | -5,723.20 | 9.96% | 782.13
ITV | ITV | 11,652 | 14,999.08 | 72.2400 | 8,417.40 | 4.21% | -6,581.68 | 0.00 | 932.15 | 932.15 | -5,649.53 | 0.00% | 0.00
LAND | Land Securities Group | 818 | 7,499.19 | 539.4000 | 4,412.29 | 2.21% | -3,086.90 | 0.00 | 285.05 | 285.05 | -2,801.85 | 4.30% | 189.77
PNN | Pennon Group | 1,900 | 15,406.25 | 1,060.0000 | 20,140.00 | 10.07% | 4,733.75 | 0.00 | 831.63 | 831.63 | 5,565.38 | 4.13% | 831.63
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 926.1000 | 2,861.65 | 1.43% | -4,620.01 | 0.00 | 530.83 | 530.83 | -4,089.18 | 5.34% | 152.81
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 240.9000 | 13,256.73 | 6.63% | -1,740.92 | 0.00 | 2,377.26 | 2,377.26 | 636.34 | 8.97% | 1,188.64
SMDS | DS Smith | 4,310 | 14,997.11 | 310.0000 | 13,361.00 | 6.68% | -1,636.11 | 0.00 | 698.22 | 698.22 | -937.89 | 1.74% | 232.74
VOD | Vodafone Group | 10,077 | 14,998.48 | 107.6800 | 10,850.91 | 5.43% | -4,147.57 | 0.00 | 1,169.18 | 1,169.18 | -2,978.39 | 7.57% | 821.41
WPP | WPP | 1,780 | 14,997.55 | 648.6000 | 11,545.08 | 5.78% | -3,452.47 | 0.00 | 1,068.00 | 1,068.00 | -2,384.47 | 1.54% | 178.00
| | | | | | | | | | | | |
| Sub Total: | | | | £198,909.47 | 99.49% | -£60,181.57 | £1,014.01 | | | | 5.07% | £10,092.77
| Cash Balance: | | | | £0.00 | 0.00% | | | | | | |
| Ex-Dividend: | | | | £1,014.01 | 0.51% | | | | | | |
| | | | | | | | | | | | |
| Current Portfolio Value: | | | | £199,923.48 | -21.57% | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | -£18,789.14 | | | | | | | |
| Dividends Received: | | | | £18,787.12 | | | | | | | |
| Ex-Dividend: | | | | £1,014.01 | | | | | | | |
| Realised P/L: | | | GNK | £4,188.29 | | | | | | | |
| Un-Realised P/L: | | | | -£60,181.57 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £199,923.48 | -9.99% | | | | | | |

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 | 22,786.50 | 11.40% | 7,787.18 | 835.22 | 1,193.17 | 2,028.39 | 9,815.57 | 5.24% | 1,193.18
Water | 15,406.25 | 20,140.00 | 10.07% | 4,733.75 | 0.00 | 831.63 | 831.63 | 5,565.38 | 4.13% | 831.63
Weapons | 14,995.20 | 15,065.89 | 7.54% | 70.69 | 0.00 | 1,107.64 | 1,107.64 | 1,178.33 | 4.69% | 705.97
Mining | 14,992.51 | 13,848.79 | 6.93% | -1,143.72 | 0.00 | 1,296.94 | 1,296.94 | 153.22 | 5.61% | 777.06
Pharma | 14,999.37 | 13,642.62 | 6.82% | -1,356.75 | 178.79 | 931.59 | 1,110.38 | -246.37 | 5.52% | 752.80
Packaging | 14,997.11 | 13,361.00 | 6.68% | -1,636.11 | 0.00 | 698.22 | 698.22 | -937.89 | 1.74% | 232.74
Fund Manager | 14,997.65 | 13,256.73 | 6.63% | -1,740.92 | 0.00 | 2,377.26 | 2,377.26 | 636.34 | 8.97% | 1,188.64
Insurance | 16,887.39 | 12,042.34 | 6.02% | -4,845.05 | 0.00 | 1,348.22 | 1,348.22 | -3,496.83 | 9.41% | 1,132.71
Advertising | 14,997.55 | 11,545.08 | 5.77% | -3,452.47 | 0.00 | 1,068.00 | 1,068.00 | -2,384.47 | 1.54% | 178.00
Telecom | 14,998.48 | 10,850.91 | 5.43% | -4,147.57 | 0.00 | 1,169.18 | 1,169.18 | -2,978.39 | 7.57% | 821.41
Bricks | 14,999.47 | 9,370.10 | 4.69% | -5,629.37 | 0.00 | 859.79 | 859.79 | -4,769.58 | 4.06% | 380.18
Property | 14,993.43 | 8,899.62 | 4.45% | -6,093.81 | 0.00 | 586.92 | 586.92 | -5,506.89 | 3.27% | 291.38
Television | 14,999.08 | 8,417.40 | 4.21% | -6,581.68 | 0.00 | 932.15 | 932.15 | -5,649.53 | 0.00% | 0.00
Tobacco | 14,988.79 | 7,855.44 | 3.93% | -7,133.35 | 0.00 | 1,410.15 | 1,410.15 | -5,723.20 | 9.96% | 782.13
Banks | 14,998.27 | 7,501.74 | 3.75% | -7,496.53 | 0.00 | 573.99 | 573.99 | -6,922.54 | 5.25% | 393.51
Oil | 16,861.38 | 6,601.28 | 3.30% | -10,260.10 | 0.00 | 1,238.94 | 1,238.94 | -9,021.16 | 6.54% | 431.43
Cruise Ships | 14,979.79 | 3,724.03 | 1.86% | -11,255.76 | 0.00 | 610.18 | 610.18 | -10,645.58 | 0.00% | 0.00

(*) - 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 2nd 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 | 2,809.72 | 0.00 | 0.00 | £4,113.90 | 05-Apr-21

Seven of the original holdings were already Ex-Dividend on purchase, meaning that the income received in Year One 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 several months, but I still do not believe it is currently possible to make a sensible estimate of the income to be received during the next 12 months, we shall have to wait and see. My best estimate is as follows:

Income: Monthly Forecast

Date      | Income (£)  |         
05-Nov-20 | 1,014.01 |
04-Dec-20 | 464.04 |
05-Jan-21 | 475.37 |
05-Feb-21 | 178.79 |
05-Mar-21 | 768.65 |
01-Apr-21 | 949.76 |
05-May-21 | 1,298.71 |
04-Jun-21 | 2,091.52 |
05-Jul-21 | 606.45 |
05-Aug-21 | 178.79 |
03-Sep-21 | 982.79 |
05-Oct-21 | 1,232.17 |
| | Average
12 Months | £10,241.05 | £853.42

If received as above, the total for Year Two will be £7,964.52, a drop from Year One of £6,708.70 or 45.72%.

Capital Value: Quarterly History

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,113.59 | | | 05-Apr-21

Everything was going quite well until the Covid-19 virus struck.

Over this second quarter, the value has reduced by £10,318.32. It is still ahead of the value for 5 April 2020 low point.

For those of you that are fascinated by the Capital Value, the following might be of interest:

Portfolio History | Date      | Value       | P/L (£)     | P/L (%)
Start Value | 11-Apr-19 | 254,904.77 | - | -
Minimum Value | 23-Mar-20 | 176,006.86 | -78,897.91 | -30.95%
Maximum Value | 27-Dec-19 | 284,068.42 | 29,163.65 | 11.44%
Current Value | 05-Oct-20 | 199,923.48 | -54,981.29 | -21.57%

Last 12 Months    | Date      | Value       | P/L (£)     | P/L (%)
Start Value | 06-Oct-19 | 253,439.06 | - | -
Minimum Value | 23-Mar-20 | 176,006.86 | -77,432.20 | -30.55%
Maximum Value | 27-Dec-19 | 284,068.42 | 30,629.36 | 12.09%
Current Value | 05-Oct-20 | 199,923.48 | -53,515.58 | -21.12%


The next report will be at the end of Quarter Three - 5 January 2021 - 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

IanTHughes
Lemon Quarter
Posts: 1789
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 730 times
Been thanked: 1117 times

PYAD HYP 2019_04 DRAWDOWN – Year 2 – January Update

#373600

Postby IanTHughes » January 5th, 2021, 8:48 pm

Year 2 – End of Quarter Three - 05 January 2021

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

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 | 328.2000 | 13,567.79 | 5.94% | -3,319.60 | 289.38 | 1,348.22 | 1,637.60 | -1,682.00 | 6.40% | 868.14
BA | BAE Systems | 3,043 | 14,995.20 | 500.8000 | 15,239.34 | 6.67% | 244.14 | 0.00 | 1,393.68 | 1,393.68 | 1,637.82 | 4.63% | 705.97
BHP | BHP Group | 838 | 14,992.51 | 2,063.5000 | 17,292.13 | 7.57% | 2,299.62 | 0.00 | 1,296.94 | 1,296.94 | 3,596.56 | 4.31% | 745.93
BLND | British Land Company | 1,273 | 7,494.24 | 468.7000 | 5,966.55 | 2.61% | -1,527.69 | 0.00 | 301.87 | 301.87 | -1,225.82 | 3.58% | 213.86
BP | BP | 1,717 | 9,379.72 | 272.5000 | 4,678.83 | 2.05% | -4,700.89 | 0.00 | 775.36 | 775.36 | -3,925.53 | 5.72% | 267.46
CCL | Carnival Corporation | 384 | 14,979.79 | 1,288.5000 | 4,947.84 | 2.17% | -10,031.95 | 0.00 | 610.18 | 610.18 | -9,421.77 | 0.00% | 0.00
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,375.4000 | 12,942.51 | 5.67% | -2,056.86 | 178.79 | 1,110.38 | 1,289.17 | -767.69 | 5.82% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 378.6000 | 9,181.05 | 4.02% | -5,817.22 | 0.00 | 573.99 | 573.99 | -5,243.23 | 5.15% | 473.08
IBST | Ibstock | 5,849 | 14,999.47 | 204.6000 | 11,967.05 | 5.24% | -3,032.42 | 0.00 | 859.79 | 859.79 | -2,172.63 | 3.18% | 380.18
IGG | IG Group Holdings | 2,762 | 14,999.32 | 880.0000 | 24,305.60 | 10.65% | 9,306.28 | 0.00 | 2,028.39 | 2,028.39 | 11,334.67 | 4.91% | 1,193.18
IMB | Imperial Brands | 568 | 14,988.79 | 1,564.5000 | 8,886.36 | 3.89% | -6,102.43 | 0.00 | 1,682.79 | 1,682.79 | -4,419.64 | 8.80% | 782.19
ITV | ITV | 11,652 | 14,999.08 | 105.6000 | 12,304.51 | 5.39% | -2,694.57 | 0.00 | 932.15 | 932.15 | -1,762.42 | 0.00% | 0.00
LAND | Land Securities Group | 818 | 7,499.19 | 666.8000 | 5,454.42 | 2.39% | -2,044.77 | 0.00 | 383.21 | 383.21 | -1,661.56 | 3.60% | 196.32
PNN | Pennon Group | 1,900 | 15,406.25 | 941.0000 | 17,879.00 | 7.83% | 2,472.75 | 0.00 | 831.63 | 831.63 | 3,304.38 | 2.32% | 414.67
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 1,337.6000 | 4,133.18 | 1.81% | -3,348.48 | 0.00 | 564.89 | 564.89 | -2,783.59 | 3.69% | 152.65
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 287.2000 | 15,804.62 | 6.92% | 806.97 | 0.00 | 2,377.26 | 2,377.26 | 3,184.23 | 7.52% | 1,188.64
SMDS | DS Smith | 4,310 | 14,997.11 | 383.7000 | 16,537.47 | 7.24% | 1,540.36 | 0.00 | 698.22 | 698.22 | 2,238.58 | 3.13% | 517.20
VOD | Vodafone Group | 10,077 | 14,998.48 | 124.4200 | 12,537.80 | 5.49% | -2,460.68 | 408.71 | 1,169.18 | 1,577.89 | -882.79 | 6.52% | 817.42
WPP | WPP | 1,780 | 14,997.55 | 777.0000 | 13,830.60 | 6.06% | -1,166.95 | 0.00 | 1,246.00 | 1,246.00 | 79.05 | 1.29% | 178.00
| | | | | | | | | | | | |
| Sub Total: | | | | £227,456.65 | 99.62% | -£31,634.39 | £876.88 | | | | 4.33% | £9,847.69
| Cash Balance: | | | | £0.00 | 0.00% | | | | | | |
| Ex-Dividend: | | | | £876.88 | 0.38% | | | | | | |
| | | | | | | | | | | | |
| Current Portfolio Value: | | | | £228,333.53 | -10.42% | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | -£20,743.80 | | | | | | | |
| Dividends Received: | | | | £20,741.78 | | | | | | | |
| Ex-Dividend: | | | | £876.88 | | | | | | | |
| Realised P/L: | | | GNK | £4,188.29 | | | | | | | |
| Un-Realised P/L: | | | | -£31,634.39 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £228,333.53 | -1.33% | | | | | | |

Current Portfolio: Business Sectors

 Business      |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Total Inc (£)  |  Overall (£)  |  Yield (%) *  |  Year Div (£) 
Gambling | 14,999.32 | 24,305.60 | 10.64% | 9,306.28 | 0.00 | 2,028.39 | 2,028.39 | 11,334.67 | 4.91% | 1,193.18
Water | 15,406.25 | 17,879.00 | 7.83% | 2,472.75 | 0.00 | 831.63 | 831.63 | 3,304.38 | 2.32% | 414.67
Mining | 14,992.51 | 17,292.13 | 7.57% | 2,299.62 | 0.00 | 1,296.94 | 1,296.94 | 3,596.56 | 4.31% | 745.93
Packaging | 14,997.11 | 16,537.47 | 7.24% | 1,540.36 | 0.00 | 698.22 | 698.22 | 2,238.58 | 3.13% | 517.20
Fund Manager | 14,997.65 | 15,804.62 | 6.92% | 806.97 | 0.00 | 2,377.26 | 2,377.26 | 3,184.23 | 7.52% | 1,188.64
Weapons | 14,995.20 | 15,239.34 | 6.67% | 244.14 | 0.00 | 1,393.68 | 1,393.68 | 1,637.82 | 4.63% | 705.97
Advertising | 14,997.55 | 13,830.60 | 6.06% | -1,166.95 | 0.00 | 1,246.00 | 1,246.00 | 79.05 | 1.29% | 178.00
Insurance | 16,887.39 | 13,567.79 | 5.94% | -3,319.60 | 289.38 | 1,348.22 | 1,637.60 | -1,682.00 | 6.40% | 868.14
Pharma | 14,999.37 | 12,942.51 | 5.67% | -2,056.86 | 178.79 | 1,110.38 | 1,289.17 | -767.69 | 5.82% | 752.80
Telecom | 14,998.48 | 12,537.80 | 5.49% | -2,460.68 | 408.71 | 1,169.18 | 1,577.89 | -882.79 | 6.52% | 817.42
Television | 14,999.08 | 12,304.51 | 5.39% | -2,694.57 | 0.00 | 932.15 | 932.15 | -1,762.42 | 0.00% | 0.00
Bricks | 14,999.47 | 11,967.05 | 5.24% | -3,032.42 | 0.00 | 859.79 | 859.79 | -2,172.63 | 3.18% | 380.18
Property | 14,993.43 | 11,420.97 | 5.00% | -3,572.46 | 0.00 | 685.08 | 685.08 | -2,887.38 | 3.59% | 410.18
Banks | 14,998.27 | 9,181.05 | 4.02% | -5,817.22 | 0.00 | 573.99 | 573.99 | -5,243.23 | 5.15% | 473.08
Tobacco | 14,988.79 | 8,886.36 | 3.89% | -6,102.43 | 0.00 | 1,682.79 | 1,682.79 | -4,419.64 | 8.80% | 782.19
Oil | 16,861.38 | 8,812.01 | 3.86% | -8,049.37 | 0.00 | 1,340.25 | 1,340.25 | -6,709.12 | 4.77% | 420.11
Cruise Ships | 14,979.79 | 4,947.84 | 2.17% | -10,031.95 | 0.00 | 610.18 | 610.18 | -9,421.77 | 0.00% | 0.00

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

Portfolio Transactions: Year Two - Third Quarter

None

Portfolio Income: Year Two Third Quarter

Date      | Epic |         Name          | Shares | Dividend |   Amount 
08-Oct-20 | GSK | GlaxoSmithKline | 941 | 19.0000 | 178.79
22-Oct-20 | IGG | IG Group Holdings | 2,762 | 30.2400 | 835.22
06-Nov-20 | WPP | WPP | 1,780 | 10.0000 | 178.00
30-Nov-20 | BA | BAE Systems | 3,043 | 9.4000 | 286.04
16-Dec-20 | RDSB | Royal Dutch Shell | 309 | 12.4800 | 38.56
18-Dec-20 | BP | BP | 1,717 | 3.9169 | 67.25
31-Dec-20 | IMB | Imperial Brands | 568 | 48.0000 | 272.64
04-Jan-21 | LAND | Land Securities Group | 818 | 12.0000 | 98.16
| | | | |
| | | | Total | £1,954.66


Portfolio 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 | 2,809.72 | 1,954.66 | | £6,068.56 | 05-Apr-21

Seven of the original holdings were already Ex-Dividend on purchase, meaning that the income received in Year One 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 several months, but I still do not believe it is currently possible to make a sensible estimate of the income to be received during the next 12 months, we shall have to wait and see. My best estimate is as follows:

Portfolio Income: Monthly Forecast

Date      | Income (£) |         
05-Feb-21 | 876.88 |
05-Mar-21 | 464.88 |
01-Apr-21 | 910.39 |
05-May-21 | 668.15 |
04-Jun-21 | 1,785.61 |
05-Jul-21 | 684.56 |
05-Aug-21 | 334.80 |
03-Sep-21 | 694.75 |
05-Oct-21 | 1,097.05 |
05-Nov-21 | 1,358.81 |
03-Dec-21 | 544.98 |
05-Jan-22 | 426.74 |
| | Average
12 Months | £9,847.60 | £820.63

If received as above then the total for Year Two, ending 05 April 2021, will be £8,320.71 (Year One: £14,673.22), which represents a drop of £6,352.51 or 43.29%, a slight improvement on the forecast made.at the end of the second quarter.

Portfolio Capital Value: Quarterly History

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 | | 05-Apr-21

Over this third quarter, the value has increased by £28,410.05 and is now well ahead of the lowest end-of-quarter value of 5 April 2020. However, it remains way behind the highest end-of-quarter value of £282,038.76, recorded on the 5 Jan 2020.

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   |    Value    |    P/L (£)   | P/L (%)
Start Value | 18-Mar-19 | 254,904.77 | - | -
Minimum Value | 23-Mar-20 | 176,006.86 | -78,897.91 | -30.95%
Maximum Value | 27-Dec-19 | 284,068.42 | 29,163.65 | 11.44%
Current Value | 05-Jan-21 | 228,333.53 | -26,571.24 | -10.42%

Last 12 Months | Date | Value | P/L (£) | P/L (%)
Start Value | 06-Jan-20 | 279,437.04 | - | -
Minimum Value | 23-Mar-20 | 176,006.86 | -103,430.18 | -37.01%
Maximum Value | 20-Jan-20 | 281,217.95 | 1,780.91 | 0.64%
Current Value | 05-Jan-21 | 228,333.53 | -51,103.51 | -18.29%


The next report will be the end of Year Two report at the end of Quarter Four - 5 April 2021 - 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

IanTHughes
Lemon Quarter
Posts: 1789
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 730 times
Been thanked: 1117 times

Re: PYAD HYP 2019_04 DRAWDOWN – Year 2

#379856

Postby IanTHughes » January 22nd, 2021, 10:56 pm

The first attempt at this post was removed at my request - thanks tjh29603 - as a result of a glaring error in one of the pie charts displayed. Hopefully, this second attempt is correct.

………

I was reviewing the current state of the portfolio and it struck me that portfolio diversification, which is so important to HYP, is best displayed by the use of charts.

So far during the history and management of this portfolio, I have not used any charts in my various posts. This is mainly because I detest using the Chart capability of Excel, which spreadsheets of course I use to monitor the portfolio! Anyway, I decided to put my Excel dislikes away, learn some new Excel skills and provide some pie charts which I do hope you will find interesting and hopefully informative.

Anyway, here goes nothing ……

As at the close of business on 22 Jan 2021 ….

Current Portfolio Diversification: Sector - Forecast Incomes

Image

Current Portfolio Diversification: Holding - Forecast Incomes

Image

Current Portfolio Diversification: Sector - Values

Image

Current Portfolio Diversification: Holding - Values

Image

So, what do you guys and gals think? Is the above a helpful and informative addition to the reporting of the portfolio? Are there any improvements or additions that you can think of?

Any comments please on this related thread: viewtopic.php?p=345491#p345491

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


Enjoy!


Ian
p.s. - I still detest Excel Charting functionality but at least I am beginning to get the hang of it :)

IanTHughes
Lemon Quarter
Posts: 1789
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 730 times
Been thanked: 1117 times

Re: PYAD HYP 2019_04 DRAWDOWN – Year 2

#383391

Postby IanTHughes » February 3rd, 2021, 3:30 pm

Following on from the valuation Pie Charts created last week, it is now time to introduce the Unit Valuation Graphs for the portfolio. Since the inception of the portfolio, a history of the values of the following has been created and stored:

- Accumulation Units
- Dividend Units
- FTSE 100 Units
- FTSE 100 Total Return Units

As of today, the graphs look like this:

Image

The daily values that make up the graphs are calculated as follows:

FTSE 100 & FTSE 100 Total Return: Unit Value

Daily closing values for the FTSE 100 & FTSE 100 Total Return are downloaded and stored.

For both Units, a Unit Value of £10.0000 was selected as the value pertaining when the portfolio was first set up on 18 Mar 2019. The closing value for the FTSE 100 index on that date was 7,299.19, The closing value for the FTSE 100 Total Return index on that date was 6,523.40.

For each day, the Unit Value = Closing Index Value DIVIDED BY Closing Index Value for 18 Mar 2019 MULTIPLIED BY ten

Portfolio Value

Daily prices for all shares within the portfolio are downloaded and stored.

For each day, each Holding Value = Number of Shares MULTIPLIED BY the price

I also maintain for each day a Portfolio Cash Balance as well as a Portfolio Ex-Dividend Amount – i.e. the total of all expected dividends where the Date is GREATER THAN OR EQUAL TO the Ex-Dividend Date AND LESS THAN the Payment Date.

For each day, the Portfolio Value = SUM all Holding Values PLUS the Portfolio Cash Balance PLUS the Ex-Dividend amount.

Accumulation and Dividend Units: Initial Number

A Unit Value of £10.0000 was selected as the value pertaining when the portfolio was first set up on 18 Mar 2019. The Total Amount paid In the portfolio on that date was £254,904.77

Initial Number of Units = Total Amount Paid In DIVIDED BY the Unit Value = 25,490.48

Unit Value

For each day, the Unit Value = the Portfolio Value DIVIDED BY the Number Units held.

Number of Units Held: Daily Purchase and Sales

Accumulation Units: Cash Movements

There are two types of Cash Movement event:

- Cash Transferred In - Purchasing Units
- Cash Transferred Out - Selling Units.

For this portfolio there is only one recorded Cash Transferred In event – the initial investment on 18 Mar 2019. Every month, one workday before the 6th of that month, there will be a Cash Transferred Out event the value of which is the Cash Balance recorded for that day.

Dividend Units: Cash Movements

There are three types of Cash Movement event:

- Cash Transferred In - Purchasing Units
- Dividends Received - Purchasing Units
- Cash Transferred Out - Selling Units.

For this portfolio there is only one recorded Cash Transferred In event – the initial investment on 18 Mar 2019. Every month, one workday before the 6th of that month, there will be a Cash Transferred Out event the value of which is the Cash Balance recorded for that day. A Dividend Received is recorded as a Cash Movement event on the Payment Date for the Dividend

Accumulation Units & Dividend Units

For each day, the Number of Units (Bought or Sold) = SUM all Cash Movements DIVIDED BY the Unit Value pertaining to the day before the Cash Movement Date


Simples!

Enjoy!


Ian

IanTHughes
Lemon Quarter
Posts: 1789
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 730 times
Been thanked: 1117 times

PYAD HYP 2019_04 DRAWDOWN – Year 2 – April Update – End of Year

#401343

Postby IanTHughes » April 3rd, 2021, 11:07 am

Year 2 – End of Year - 05 April 2021

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

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 (£)
BHP | BHP Group | 838 | 14,992.51 | 2,068.0000 | 17,329.84 | 7.11% | 2,337.33 | 0.00 | 1,908.57 | 1,908.57 | 4,245.90 | 5.47% | 947.85
BP | BP | 1,717 | 9,379.72 | 289.8000 | 4,975.87 | 2.04% | -4,403.85 | 0.00 | 840.06 | 840.06 | -3,563.79 | 5.25% | 261.43
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 1,335.4000 | 4,126.39 | 1.69% | -3,355.27 | 0.00 | 599.42 | 599.42 | -2,755.85 | 3.77% | 155.48
IMB | Imperial Brands | 568 | 14,988.79 | 1,488.5000 | 8,454.68 | 3.47% | -6,534.11 | 0.00 | 1,955.48 | 1,955.48 | -4,578.63 | 9.25% | 782.19
ITV | ITV | 11,652 | 14,999.08 | 121.8000 | 14,192.14 | 5.83% | -806.94 | 0.00 | 932.15 | 932.15 | 125.21 | 0.00% | 0.00
WPP | WPP | 1,780 | 14,997.55 | 934.0000 | 16,625.20 | 6.83% | 1,627.65 | 0.00 | 1,246.00 | 1,246.00 | 2,873.65 | 2.57% | 427.20
AV | Aviva | 4,134 | 16,887.39 | 409.1000 | 16,912.19 | 6.94% | 24.80 | 0.00 | 1,637.60 | 1,637.60 | 1,662.40 | 5.13% | 868.14
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 423.2000 | 10,262.60 | 4.21% | -4,735.67 | 263.74 | 573.99 | 837.73 | -3,897.94 | 4.88% | 501.10
IGG | IG Group Holdings | 2,762 | 14,999.32 | 909.5000 | 25,120.39 | 10.31% | 10,121.07 | 0.00 | 2,386.34 | 2,386.34 | 12,507.41 | 4.75% | 1,193.18
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 293.9000 | 16,173.32 | 6.64% | 1,175.67 | 0.00 | 2,377.26 | 2,377.26 | 3,552.93 | 4.97% | 803.43
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,277.6000 | 12,022.22 | 4.94% | -2,977.15 | 216.43 | 1,289.17 | 1,505.60 | -1,471.55 | 6.26% | 752.80
BA | BAE Systems | 3,043 | 14,995.20 | 510.4000 | 15,531.47 | 6.38% | 536.27 | 0.00 | 1,393.68 | 1,393.68 | 1,929.95 | 4.64% | 721.19
CCL | Carnival Corporation | 384 | 14,979.79 | 1,625.8000 | 6,243.07 | 2.56% | -8,736.72 | 0.00 | 610.18 | 610.18 | -8,126.54 | 0.00% | 0.00
IBST | Ibstock | 5,849 | 14,999.47 | 222.0000 | 12,984.78 | 5.33% | -2,014.69 | 0.00 | 859.79 | 859.79 | -1,154.90 | 0.72% | 93.58
SMDS | DS Smith | 4,310 | 14,997.11 | 413.6000 | 17,826.16 | 7.32% | 2,829.05 | 0.00 | 698.22 | 698.22 | 3,527.27 | 2.90% | 517.20
BLND | British Land Company | 1,273 | 7,494.24 | 509.6000 | 6,487.21 | 2.66% | -1,007.03 | 0.00 | 408.80 | 408.80 | -598.23 | 3.30% | 213.86
LAND | Land Securities Group | 818 | 7,499.19 | 701.6000 | 5,739.09 | 2.36% | -1,760.10 | 0.00 | 432.29 | 432.29 | -1,327.81 | 3.42% | 196.32
VOD | Vodafone Group | 10,077 | 14,998.48 | 133.6600 | 13,468.92 | 5.53% | -1,529.56 | 0.00 | 1,570.34 | 1,570.34 | 40.78 | 5.76% | 775.34
PNN | Pennon Group | 1,900 | 15,406.25 | 981.2000 | 18,642.80 | 7.65% | 3,236.55 | 0.00 | 960.26 | 960.26 | 4,196.81 | 2.22% | 414.67
| | | | | | | | | | | | |
| Sub Total: | | | | £243,118.34 | 99.80% | -£15,972.70 | £480.17 | | | | 3.96% | £9,624.96
| Cash Balance: | | | | £0.00 | 0.00% | | | | | | |
| Ex-Dividend: | | | | £480.17 | 0.20% | | | | | | |
| | | | | | | | | | | | |
| Current Portfolio Value: | | | | £243,598.51 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | -£23,241.69 | | | | | | | |
| Dividends Received: | | | | £23,239.67 | | | | | | | |
| Ex-Dividend: | | | | £480.17 | | | | | | | |
| Realised Profit/Loss: | | | GNK | £4,188.29 | | | | | | | |
| Un-Realised Profit/Loss: | | | | -£15,972.70 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £243,598.51 | 2.38% | | | | | | |

Current Portfolio: Business Sectors

 Business        |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)   |  Ex-Div (£)  |  Div Rec'd (£)  |  Total Inc (£)  |  Overall (£)  |  Yield (%) *  |  Year Div (£)  |  Income (%) 
Gambling | 14,999.32 | 25,120.39 | 10.31% | 10,121.07 | 0.00 | 2,386.34 | 2,386.34 | 12,507.41 | 4.75% | 1,193.18 | 12.40%
Water | 15,406.25 | 18,642.80 | 7.65% | 3,236.55 | 0.00 | 960.26 | 960.26 | 4,196.81 | 2.22% | 414.67 | 4.31%
Packaging | 14,997.11 | 17,826.16 | 7.32% | 2,829.05 | 0.00 | 698.22 | 698.22 | 3,527.27 | 2.90% | 517.20 | 5.37%
Mining | 14,992.51 | 17,329.84 | 7.11% | 2,337.33 | 0.00 | 1,908.57 | 1,908.57 | 4,245.90 | 5.47% | 947.85 | 9.85%
Insurance | 16,887.39 | 16,912.19 | 6.94% | 24.80 | 0.00 | 1,637.60 | 1,637.60 | 1,662.40 | 5.13% | 868.14 | 9.02%
Advertising | 14,997.55 | 16,625.20 | 6.82% | 1,627.65 | 0.00 | 1,246.00 | 1,246.00 | 2,873.65 | 2.57% | 427.20 | 4.44%
Fund Manager | 14,997.65 | 16,173.32 | 6.64% | 1,175.67 | 0.00 | 2,377.26 | 2,377.26 | 3,552.93 | 4.97% | 803.43 | 8.35%
Weapons | 14,995.20 | 15,531.47 | 6.38% | 536.27 | 0.00 | 1,393.68 | 1,393.68 | 1,929.95 | 4.64% | 721.19 | 7.49%
Television | 14,999.08 | 14,192.14 | 5.83% | -806.94 | 0.00 | 932.15 | 932.15 | 125.21 | 0.00% | 0.00 | 0.00%
Mobile Tel | 14,998.48 | 13,468.92 | 5.53% | -1,529.56 | 0.00 | 1,570.34 | 1,570.34 | 40.78 | 5.76% | 775.34 | 8.06%
Bricks | 14,999.47 | 12,984.78 | 5.33% | -2,014.69 | 0.00 | 859.79 | 859.79 | -1,154.90 | 0.72% | 93.58 | 0.97%
Pharma | 14,999.37 | 12,022.22 | 4.94% | -2,977.15 | 216.43 | 1,289.17 | 1,505.60 | -1,471.55 | 6.26% | 752.80 | 7.82%
Real Estate IT | 14,993.43 | 12,226.30 | 5.02% | -2,767.13 | 0.00 | 841.09 | 841.09 | -1,926.04 | 3.35% | 410.18 | 4.26%
Banks | 14,998.27 | 10,262.60 | 4.21% | -4,735.67 | 263.74 | 573.99 | 837.73 | -3,897.94 | 4.88% | 501.10 | 5.21%
Oil | 16,861.38 | 9,102.26 | 3.74% | -7,759.12 | 0.00 | 1,439.48 | 1,439.48 | -6,319.64 | 4.58% | 416.91 | 4.33%
Tobacco | 14,988.79 | 8,454.68 | 3.47% | -6,534.11 | 0.00 | 1,955.48 | 1,955.48 | -4,578.63 | 9.25% | 782.19 | 8.13%
Cruise Ships | 14,979.79 | 6,243.07 | 2.56% | -8,736.72 | 0.00 | 610.18 | 610.18 | -8,126.54 | 0.00% | 0.00 | 0.00%

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

Portfolio Transactions: Year Two

None

Portfolio Income: Year Two

Date      | Epic | Name                   | Shares | Dividend | Amount   
09-Apr-20 | GSK | GlaxoSmithKline | 941 | 23.0000 | 216.43
19-May-20 | SLA | Standard Life Aberdeen | 5,503 | 14.3000 | 786.92
19-Jun-20 | BP | BP | 1,717 | 8.3421 | 143.23
22-Jun-20 | RDSB | Royal Dutch Shell | 309 | 12.6800 | 39.18
30-Jun-20 | IMB | Imperial Brands | 568 | 20.8500 | 118.42
09-Jul-20 | GSK | GlaxoSmithKline | 941 | 19.0000 | 178.79
07-Aug-20 | VOD | Vodafone | 10,077 | 4.0797 | 411.11
02-Sep-20 | PNN | Pennon Group | 1,900 | 30.1100 | 572.09
14-Sep-20 | BA | BA | 3,043 | 13.8000 | 419.93
21-Sep-20 | RDSB | Royal Dutch Shell | 309 | 12.0900 | 37.35
22-Sep-20 | BHP | BHP Group | 838 | 42.1085 | 352.86
24-Sep-20 | AV | Aviva | 4,134 | 6.0000 | 248.04
25-Sep-20 | BP | BP | 1,717 | 4.0433 | 69.42
29-Sep-20 | SLA | Standard Life Aberdeen | 5,503 | 7.3000 | 401.71
30-Sep-20 | IMB | Imperial Brands | 568 | 20.8500 | 118.42
08-Oct-20 | GSK | GlaxoSmithKline | 941 | 19.0000 | 178.79
22-Oct-20 | IGG | IG Group Holdings | 2,762 | 30.2400 | 835.22
06-Nov-20 | WPP | WPP | 1,780 | 10.0000 | 178.00
30-Nov-20 | BA | BA | 3,043 | 9.4000 | 286.04
16-Dec-20 | RDSB | Royal Dutch Shell | 309 | 12.4800 | 38.56
18-Dec-20 | BP | BP | 1,717 | 3.9169 | 67.25
31-Dec-20 | IMB | Imperial Brands | 568 | 48.0000 | 272.64
04-Jan-21 | LAND | Land Securities Group | 818 | 12.0000 | 98.16
14-Jan-21 | GSK | GlaxoSmithKline | 941 | 19.0000 | 178.79
21-Jan-21 | AV | Aviva | 4,134 | 7.0000 | 289.38
05-Feb-21 | VOD | Vodafone | 10,077 | 3.9810 | 401.16
19-Feb-21 | BLND | British Land | 1,273 | 8.4000 | 106.93
25-Feb-21 | IGG | IG Group Holdings | 2,762 | 12.9600 | 357.95
23-Mar-21 | BHP | BHP Group | 838 | 73.1089 | 611.63
26-Mar-21 | BP | BP | 1,717 | 3.7684 | 64.70
29-Mar-21 | RDSB | Royal Dutch Shell | 309 | 11.9600 | 36.95
30-Mar-21 | LAND | Land Securities Group | 818 | 6.0000 | 49.08
31-Mar-21 | IMB | Imperial Brands | 568 | 48.0100 | 272.69
01-Apr-21 | PNN | Pennon Group | 1,900 | 6.7700 | 128.63
| | | | |
| | | | Total | £8,566.45

Portfolio Income: Quarterly 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 | 2,809.72 | 1,954.66 | 2,497.89 | £8,566.45 | 05-Apr-21

Seven of the original holdings were already Ex-Dividend on purchase, meaning that the income received in Year One 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 several months, but I still do not believe it is currently possible to make a sensible estimate of the income to be received during the next 12 months, we shall have to wait and see. My best estimate is as follows:

Portfolio Income: Year Three - Monthly Forecast

Date      | Income (£) |         
05-May-21 | 652.57 |
04-Jun-21 | 1,509.19 |
05-Jul-21 | 301.76 |
05-Aug-21 | 584.00 |
03-Sep-21 | 673.71 |
05-Oct-21 | 1,376.10 |
05-Nov-21 | 1,358.81 |
03-Dec-21 | 543.16 |
05-Jan-22 | 425.94 |
04-Feb-22 | 178.79 |
04-Mar-22 | 852.55 |
05-Apr-22 | 1,168.29 |
| | Average
12 Months | £9,624.87 | £802.07

Portfolio Income: Diversification by Industry, Business and Holding

Image

Portfolio Income: Year Two - Comments

What a disaster! Income has decreased by 36.86%!

Going forward, the current forecast total for the next year – shaky as it no doubt is - is for an amount of £9,624.87. Although this represents an increase year-on-year of 12.36%, it will still be significantly down from Year One’s total of £14,673.22.

Portfolio Capital Value: Quarterly To-Date

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

Over this second year, the Capital Value has increased by £59,343.20 and is now well ahead of the lowest end-of-quarter value of 5 April 2020. However, it remains way behind the highest end-of-quarter value of £282,038.76, recorded on the 5 Jan 2020.

Portfolio Capital: Diversification by Industry, Business and Holding

Image

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      | Value       | P/L (£)     | P/L (%)
Start Value | 18-Mar-19 | 254,904.77 | |
Minimum Value | 23-Mar-20 | 176,006.86 | -78,897.91 | -30.95%
Maximum Value | 27-Dec-19 | 284,068.42 | 29,163.65 | 11.44%
Current Value | 05-Apr-21 | 243,598.51 | -11,306.26 | -4.44%

Last 12 Months | Date | Value | P/L (£) | P/L (%)
Start Value | 02-Apr-20 | 187,816.57 | |
Minimum Value | 03-Apr-20 | 184,255.31 | -3,561.26 | -1.90%
Maximum Value | 30-Mar-21 | 245,243.78 | 57,427.21 | 30.58%
Current Value | 05-Apr-21 | 243,598.51 | 55,781.94 | 29.70%

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
JCH = JPMorgan Claverhouse 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: HYP Compared with Various Other Income Investments

During this second year, the HYP’s Income is lower than the chosen alternatives!

Image

Average Annual Income: HYP Compared with Various Other Income Investments

Because of the income received during the first year, the HYP’s Average Annual Income for the two years is still ahead of the chosen alternatives, with of course one notable exception.

Image

Annual Value: HYP Compared with Various Other Income Investments

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

Image

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


The next report will be at the end of Quarter One – 5 July 2021 – which will of course be on a new Year Three thread.

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 these annual threads 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


Return to “HYP Practical (See Group Guidelines)”

Who is online

Users browsing this forum: No registered users and 16 guests