Donate to Remove ads

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

Thanks to MrFahrenheit,SalvorHardin,Anonymous,johnhemming,Anonymous, 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: 1206
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 593 times
Been thanked: 557 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: 1089
Joined: November 4th, 2016, 8:46 pm
Has thanked: 194 times
Been thanked: 267 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


Return to “HYP Practical (See Group Guidelines)”

Who is online

Users browsing this forum: BhotiPila and 4 guests