Donate to Remove ads

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

Thanks to Wasron,jfgw,Rhyd6,eyeball08,Wondergirly, for Donating to support the site

PYAD HYP 2019_04 DRAWDOWN – Year 1

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: 1790
Joined: May 2nd, 2018, 12:01 pm
Has thanked: 730 times
Been thanked: 1117 times

PYAD HYP 2019_04 DRAWDOWN – Year 1

#225865

Postby IanTHughes » May 31st, 2019, 8:08 pm

Update 31 May 2019

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


The portfolio currently looks like this:

EPIC  |  Company Name             |  Shares   |  Cost         |  Price        |  Value        |  Value %      |  Profit/Loss  |  Business        |  Annual Inc  |  Yield (1)  |  Inc To Date  |  Ex-Dividend  |  Total    
AV | Aviva | 3,637 | 14,996.21 | 404.6000 | 14,715.30 | 6.08% | -280.91 | Insurance | 1,091.10 | 7.41% | 754.67 | 0.00 | 754.67
BA | BAE Systems | 3,043 | 14,995.20 | 452.4000 | 13,766.53 | 5.69% | -1,228.67 | Weapons | 675.54 | 4.91% | 0.00 | 401.67 | 401.67
BHP | BHP Group | 838 | 14,992.51 | 1,784.6000 | 14,954.95 | 6.18% | -37.56 | Mining | 776.96 | 5.20% | 0.00 | 0.00 | 0.00
BLND | British Land Company | 1,280 | 7,497.95 | 534.0000 | 6,835.20 | 2.82% | -662.75 | Property | 396.80 | 5.81% | 0.00 | 0.00 | 0.00
BP | BP | 1,347 | 7,496.10 | 540.1000 | 7,275.15 | 3.01% | -220.95 | Oil | 433.92 | 5.96% | 0.00 | 108.48 | 108.48
CCL | Carnival Corporation | 384 | 14,979.79 | 3,910.0000 | 15,014.40 | 6.20% | 34.61 | Cruise Ships | 603.44 | 4.02% | 0.00 | 150.86 | 150.86
GNK | Greene King | 2,266 | 14,994.78 | 638.2000 | 14,461.61 | 5.98% | -533.17 | Brewing & Pubs | 752.31 | 5.20% | 0.00 | 0.00 | 0.00
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,527.0000 | 14,369.07 | 5.94% | -630.30 | Pharma | 752.80 | 5.24% | 0.00 | 178.79 | 178.79
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 645.1000 | 15,643.68 | 6.46% | 645.41 | Bank | 971.75 | 6.21% | 0.00 | 190.53 | 190.53
IBST | Ibstock | 5,849 | 14,999.47 | 238.0000 | 13,920.62 | 5.75% | -1,078.85 | Bricks | 555.65 | 3.99% | 0.00 | 380.18 | 380.18
IGG | IG Group Holdings | 2,762 | 14,999.32 | 547.2000 | 15,113.66 | 6.25% | 114.34 | Gambling | 1,193.18 | 7.89% | 0.00 | 0.00 | 0.00
IMB | Imperial Brands | 568 | 14,988.79 | 1,915.0000 | 10,877.20 | 4.49% | -4,111.59 | Tobacco | 1,173.26 | 10.79% | 0.00 | 177.67 | 177.67
ITV | ITV | 11,652 | 14,999.08 | 107.2500 | 12,496.77 | 5.16% | -2,502.31 | Television | 932.16 | 7.46% | 629.20 | 0.00 | 629.20
LAND | Land Securities Group | 818 | 7,499.19 | 828.6000 | 6,777.95 | 2.80% | -721.24 | Property | 397.13 | 5.86% | 0.00 | 0.00 | 0.00
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,473.5000 | 7,643.12 | 3.16% | 161.46 | Oil | 456.44 | 5.97% | 0.00 | 114.11 | 114.11
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 267.3000 | 14,709.52 | 6.08% | -288.13 | Fund Manager | 1,188.64 | 8.08% | 786.92 | 0.00 | 786.92
SMDS | DS Smith | 4,310 | 14,997.11 | 316.0000 | 13,619.60 | 5.63% | -1,377.51 | Packaging | 646.50 | 4.75% | 224.12 | 0.00 | 224.12
VOD | Vodafone Group | 10,077 | 14,998.48 | 129.4200 | 13,041.65 | 5.39% | -1,956.83 | Telecom | 795.83 | 6.10% | 0.00 | 0.00 | 0.00
WPP | WPP | 1,780 | 14,997.55 | 941.2000 | 16,753.36 | 6.92% | 1,755.81 | Advertising | 1,068.00 | 6.37% | 0.00 | 0.00 | 0.00
| | | | | | | | | | | | |
| Sub Total: | | 254,908.48 | | 241,989.34 | | -12,919.14 | | 14,861.41 | 6.14% | 2,394.91 | 1,702.29 | 4,097.20
| Cash: | | 0.00 | | 0.00 | | | | | | | |
| Ex-Dividend: | | 0.00 | | 1,702.29 | | | | | | | |
| | | | | | | | | | | | |
| Total: | | 254,908.48 | | 243,691.63 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | 254,908.48 | | 254,908.48 | | | | | | | |
| LESS Cash Out: | | 0.00 | | -2,394.91 | | | | | | | |
| Dividends: | | 0.00 | | 2,394.91 | | | | | | | |
| UnRealised Profit/Loss: | | 0.00 | | -12,919.14 | | | | | | | |
| Ex-Dividend: | | 0.00 | | 1,702.29 | Capital | Income | | | | | |
| | | | | | Profit/Loss | To-Date | Overall | | | | |
| Total: | | 254,908.48 | | 243,691.63 | -11,216.85 | 2,394.91 | -8,821.94 | | | | |

(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 indicated otherwise.

With the breakdown by Business as follows:

Business                 |  Cost         |  Value        |  Value %      |  Profit/Loss  |  Annual Inc  |  Yield   |  Inc To Date  |  Ex-Dividend  |  Total    
Advertising | 14,997.55 | 16,753.36 | 6.92% | 1,755.81 | 1,068.00 | 6.37% | 0.00 | 0.00 | 0.00
Bank | 14,998.27 | 15,643.68 | 6.46% | 645.41 | 971.75 | 6.21% | 0.00 | 190.53 | 190.53
Gambling | 14,999.32 | 15,113.66 | 6.25% | 114.34 | 1,193.18 | 7.89% | 0.00 | 0.00 | 0.00
Cruise Ships | 14,979.79 | 15,014.40 | 6.20% | 34.61 | 603.44 | 4.02% | 0.00 | 150.86 | 150.86
Mining | 14,992.51 | 14,954.95 | 6.18% | -37.56 | 776.96 | 5.20% | 0.00 | 0.00 | 0.00
Oil | 14,977.76 | 14,918.27 | 6.16% | -59.49 | 890.36 | 5.97% | 0.00 | 222.59 | 222.59
Insurance | 14,996.21 | 14,715.30 | 6.08% | -280.91 | 1,091.10 | 7.41% | 754.67 | 0.00 | 754.67
Fund Manager | 14,997.65 | 14,709.52 | 6.08% | -288.13 | 1,188.64 | 8.08% | 786.92 | 0.00 | 786.92
Brewing & Pubs | 14,994.78 | 14,461.61 | 5.98% | -533.17 | 752.31 | 5.20% | 0.00 | 0.00 | 0.00
Pharma | 14,999.37 | 14,369.07 | 5.94% | -630.30 | 752.80 | 5.24% | 0.00 | 178.79 | 178.79
Bricks | 14,999.47 | 13,920.62 | 5.75% | -1,078.85 | 555.65 | 3.99% | 0.00 | 380.18 | 380.18
Weapons | 14,995.20 | 13,766.53 | 5.69% | -1,228.67 | 675.54 | 4.91% | 0.00 | 401.67 | 401.67
Packaging | 14,997.11 | 13,619.60 | 5.63% | -1,377.51 | 646.50 | 4.75% | 224.12 | 0.00 | 224.12
Property | 14,997.14 | 13,613.15 | 5.63% | -1,383.99 | 793.93 | 5.83% | 0.00 | 0.00 | 0.00
Telecom | 14,998.48 | 13,041.65 | 5.39% | -1,956.83 | 795.83 | 6.10% | 0.00 | 0.00 | 0.00
Television | 14,999.08 | 12,496.77 | 5.16% | -2,502.31 | 932.16 | 7.46% | 629.20 | 0.00 | 629.20
Tobacco | 14,988.79 | 10,877.20 | 4.49% | -4,111.59 | 1,173.26 | 10.79% | 0.00 | 177.67 | 177.67
| | | | | | | | |
Sub Total: | 254,908.48 | 241,989.34 | | -12,919.14 | 14,861.41 | 6.14% | 2,394.91 | 1,702.29 | 4,097.20
Cash: | 0.00 | 0.00 | | | | | | |
Ex-Dividend: | 0.00 | 1,702.29 | | | | | | |
| | | | | | | | |
Total: | 254,908.48 | 243,691.63 | | | | | | |
From: | | | | | | | | |
Cash In: | 254,908.48 | 254,908.48 | | | | | | |
LESS Cash Out: | 0.00 | -2,394.91 | | | | | | |
Dividends: | 0.00 | 2,394.91 | | | | | | |
UnRealised Profit/Loss: | 0.00 | -12,919.14 | | | | | | |
Ex-Dividend: | 0.00 | 1,702.29 | | | | | | |
| | | Profit/Loss | Income | Net | | | |
Total: | 254,908.48 | 243,691.63 | -11,216.85 | 2,394.91 | -8,821.94 | | | |


Income To-Date

Year Start  |  Q1         |  Q2     |  Q3     |  Q4     |  Total      |  Year End 
06-Apr-19 | 2,394.91 | 0.00 | 0.00 | 0.00 | 2,394.91 | 05-Apr-20




Ian

SuperCally
Lemon Pip
Posts: 67
Joined: August 2nd, 2017, 7:31 am
Has thanked: 1009 times
Been thanked: 70 times

Re: PYAD HYP 2019_04 DRAWDOWN – Year 1

#226472

Postby SuperCally » June 3rd, 2019, 12:30 pm

‘Ditto’ (as per ‘REINVEST’)

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

Re: PYAD HYP 2019_04 DRAWDOWN – Year 1

#234372

Postby IanTHughes » July 6th, 2019, 10:35 am

PYAD HYP 2019_04 DRAWDOWN – Year 1

Update as at the Close of Business: 05 July 2019

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


The portfolio currently looks like this:

EPIC | Company                | Shares  | Cost (£)     | Price (p)   | Value (£)    | Value (%) | P/L (£)    | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
AV | Aviva | 3,637 | 14,996.21 | 431.7000 | 15,700.93 | 6.17% | 704.72 | 754.67 | 0.00 | 754.67 | 1,459.39 | 6.95% | 1,091.10
BA | BAE Systems | 3,043 | 14,995.20 | 494.6000 | 15,050.68 | 5.92% | 55.48 | 401.67 | 0.00 | 401.67 | 457.15 | 4.49% | 675.54
BHP | BHP Group | 838 | 14,992.51 | 1,955.6000 | 16,387.93 | 6.44% | 1,395.42 | 0.00 | 0.00 | 0.00 | 1,395.42 | 4.82% | 790.43
BLND | British Land Company | 1,273 | 7,494.24 | 557.4000 | 7,095.70 | 2.79% | -398.54 | 0.00 | 98.65 | 98.65 | -299.89 | 5.56% | 394.63
BP | BP | 1,347 | 7,496.10 | 542.5000 | 7,307.48 | 2.87% | -188.62 | 108.64 | 0.00 | 108.64 | -79.98 | 6.04% | 441.44
CCL | Carnival Corporation | 384 | 14,979.79 | 3,587.0000 | 13,774.08 | 5.41% | -1,205.71 | 150.63 | 0.00 | 150.63 | -1,055.08 | 4.46% | 613.88
GNK | Greene King | 2,266 | 14,994.78 | 620.2000 | 14,053.73 | 5.52% | -941.05 | 0.00 | 0.00 | 0.00 | -941.05 | 5.35% | 752.31
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,636.6000 | 15,400.41 | 6.05% | 401.04 | 0.00 | 178.79 | 178.79 | 579.83 | 4.89% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 672.5000 | 16,308.13 | 6.41% | 1,309.86 | 190.04 | 0.00 | 190.04 | 1,499.90 | 6.06% | 988.60
IBST | Ibstock | 5,849 | 14,999.47 | 239.8000 | 14,025.90 | 5.51% | -973.57 | 380.18 | 0.00 | 380.18 | -593.39 | 3.96% | 555.65
IGG | IG Group Holdings | 2,762 | 14,999.32 | 594.4000 | 16,417.33 | 6.45% | 1,418.01 | 0.00 | 0.00 | 0.00 | 1,418.01 | 7.27% | 1,193.18
IMB | Imperial Brands | 568 | 14,988.79 | 1,960.8000 | 11,137.34 | 4.38% | -3,851.45 | 177.67 | 0.00 | 177.67 | -3,673.78 | 10.53% | 1,173.26
ITV | ITV | 11,652 | 14,999.08 | 111.0500 | 12,939.55 | 5.09% | -2,059.53 | 629.20 | 0.00 | 629.20 | -1,430.33 | 7.20% | 932.16
LAND | Land Securities Group | 818 | 7,499.19 | 854.2000 | 6,987.36 | 2.75% | -511.83 | 0.00 | 119.83 | 119.83 | -392.00 | 5.68% | 397.13
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,586.5000 | 7,992.29 | 3.14% | 510.63 | 114.23 | 0.00 | 114.23 | 624.86 | 5.81% | 464.36
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 306.3000 | 16,855.69 | 6.63% | 1,858.04 | 786.92 | 0.00 | 786.92 | 2,644.96 | 7.05% | 1,188.64
SMDS | DS Smith | 4,310 | 14,997.11 | 364.4000 | 15,705.64 | 6.17% | 708.53 | 224.12 | 0.00 | 224.12 | 932.65 | 4.45% | 698.22
VOD | Vodafone Group | 10,077 | 14,998.48 | 134.6400 | 13,567.67 | 5.33% | -1,430.81 | 0.00 | 376.10 | 376.10 | -1,054.71 | 6.00% | 813.68
WPP | WPP | 1,780 | 14,997.55 | 992.6000 | 17,668.28 | 6.95% | 2,670.73 | 0.00 | 663.94 | 663.94 | 3,334.67 | 6.04% | 1,068.00
| | | | | | | | | | | | |
| Sub Total: | | £254,904.77 | | £254,376.12 | | -£528.65 | £3,917.97 | £1,437.31 | £5,355.28 | £4,826.63 | 5.89% | £14,985.01
| Cash Bal: | | £0.00 | | £0.00 | | | | | | | |
| Ex-Dividend: | | | | £1,437.31 | | | | | | | |
| Cash Out: | | | | £3,917.97 | | | | | | | |
| | | | | | | | | | | | |
| Total: | | £254,904.77 | | £259,731.40 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | £254,904.77 | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | -£3,917.97 | | | | | | | | | |
| Dividends: | | £3,917.97 | | | XIRR | | | | | | |
| Overall P/L: | | £0.00 | | £4,826.63 | 5.74% | | | | | | |
| | | | | | | | | | | | |
| Total: | | £254,904.77 | | £259,731.40 | | | | | | | |


(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 indicated otherwise.

With the breakdown by Business as follows:

Business       | Cost (£)     | Value (£)    | Value (%) | P/L (£)    | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Advertising | 14,997.55 | 17,668.28 | 6.95% | 2,670.73 | 0.00 | 663.94 | 663.94 | 3,334.67 | 6.04% | 1,068.00
Fund Manager | 14,997.65 | 16,855.69 | 6.63% | 1,858.04 | 786.92 | 0.00 | 786.92 | 2,644.96 | 7.05% | 1,188.64
Mining | 14,992.51 | 16,387.93 | 6.44% | 1,395.42 | 0.00 | 0.00 | 0.00 | 1,395.42 | 4.82% | 790.43
Gambling | 14,999.32 | 16,417.33 | 6.45% | 1,418.01 | 0.00 | 0.00 | 0.00 | 1,418.01 | 7.27% | 1,193.18
Banks | 14,998.27 | 16,308.13 | 6.41% | 1,309.86 | 190.04 | 0.00 | 190.04 | 1,499.90 | 6.06% | 988.60
Insurance | 14,996.21 | 15,700.93 | 6.17% | 704.72 | 754.67 | 0.00 | 754.67 | 1,459.39 | 6.95% | 1,091.10
Packaging | 14,997.11 | 15,705.64 | 6.17% | 708.53 | 224.12 | 0.00 | 224.12 | 932.65 | 4.45% | 698.22
Pharma | 14,999.37 | 15,400.41 | 6.05% | 401.04 | 0.00 | 178.79 | 178.79 | 579.83 | 4.89% | 752.80
Oil | 14,977.76 | 15,299.77 | 6.01% | 322.01 | 222.87 | 0.00 | 222.87 | 544.88 | 5.92% | 905.80
Weapons | 14,995.20 | 15,050.68 | 5.92% | 55.48 | 401.67 | 0.00 | 401.67 | 457.15 | 4.49% | 675.54
Property | 14,993.43 | 14,083.06 | 5.54% | -910.37 | 0.00 | 218.48 | 218.48 | -691.89 | 5.62% | 791.76
Brewing & Pubs | 14,994.78 | 14,053.73 | 5.52% | -941.05 | 0.00 | 0.00 | 0.00 | -941.05 | 5.35% | 752.31
Bricks | 14,999.47 | 14,025.90 | 5.51% | -973.57 | 380.18 | 0.00 | 380.18 | -593.39 | 3.96% | 555.65
Cruise Ships | 14,979.79 | 13,774.08 | 5.41% | -1,205.71 | 150.63 | 0.00 | 150.63 | -1,055.08 | 4.46% | 613.88
Telecom | 14,998.48 | 13,567.67 | 5.33% | -1,430.81 | 0.00 | 376.10 | 376.10 | -1,054.71 | 6.00% | 813.68
Television | 14,999.08 | 12,939.55 | 5.09% | -2,059.53 | 629.20 | 0.00 | 629.20 | -1,430.33 | 7.20% | 932.16
Tobacco | 14,988.79 | 11,137.34 | 4.38% | -3,851.45 | 177.67 | 0.00 | 177.67 | -3,673.78 | 10.53% | 1,173.26
| | | | | | | | | |
Sub Total: | £254,904.77 | £254,376.12 | | -£528.65 | £3,917.97 | £1,437.31 | £5,355.28 | £4,826.63 | 5.89% | £14,985.01
Cash Bal: | £0.00 | £0.00 | | | | | | | |
Ex-Dividend: | | £1,437.31 | | | | | | | |
Cash Out: | | £3,917.97 | | | | | | | |
| | | | | | | | | |
Total: | £254,904.77 | £259,731.40 | | | | | | | |
From: | | | | | | | | | |
Cash In: | £254,904.77 | £254,904.77 | | | | | | | |
LESS Cash Out: | -£3,917.97 | | | | | | | | |
Dividends: | £3,917.97 | | XIRR | | | | | | |
Overall P/L: | £0.00 | £4,826.63 | 5.74% | | | | | | |
| | | | | | | | | |
Total: | £254,904.77 | £259,731.40 | | | | | | | |


Income To-Date

Year Start | Q1        | Q2    | Q3    | Q4    | Total      | Year End
06-Apr-19 | 3,917.97 | 0.00 | 0.00 | 0.00 | £3,917.97 | 05-Apr-20


Some eagle-eyed will notice a few changes have been made to the above tables which I have done to ensure that the flow of information – Capital on the left and Income on the right – is made easier to the eye

The monthly dividend drawdown event has been adjusted to the 5th of each month. This means that the Portfolio’s year-end date will now be 5 April, which of course is the end of the tax year and almost exactly the date when the Portfolio turns a year older.

Enjoy


Ian

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

PYAD HYP 2019_04 DRAWDOWN – Year 1 - October Update

#256093

Postby IanTHughes » October 5th, 2019, 6:05 pm

PYAD HYP 2019_04 DRAWDOWN – Year 1

Update 05 October 2019

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


The portfolio currently looks like this:

EPIC  |  Company                 |  Shares   |  Cost (£)      |  Price (p)    |  Value (£)     |  Value (%)       |  P/L (£)      |  Div Rec'd (£)  |  Ex-Div (£)  |  Total Inc (£)  |  Overall (£)  |  Yield (%) *  |  Year Inc (£)
AV | Aviva | 3,637 | 14,996.21 | 380.0000 | 13,820.60 | 5.28% | -1,175.61 | 1,100.18 | 0.00 | 1,100.18 | -75.43 | 7.96% | 1,100.19
BA | BAE Systems | 3,043 | 14,995.20 | 544.0000 | 16,553.92 | 6.32% | 1,558.72 | 401.67 | 0.00 | 401.67 | 1,960.39 | 4.15% | 687.71
BHP | BHP Group | 838 | 14,992.51 | 1,683.2000 | 14,105.22 | 5.39% | -887.29 | 528.19 | 0.00 | 528.19 | -359.10 | 6.42% | 905.61
BLND | British Land Company | 1,273 | 7,494.24 | 555.6000 | 7,072.79 | 2.70% | -421.45 | 98.65 | 101.61 | 200.26 | -221.19 | 5.75% | 406.46
BP | BP | 1,347 | 7,496.10 | 494.9000 | 6,666.30 | 2.55% | -829.80 | 221.08 | 0.00 | 221.08 | -608.72 | 6.73% | 448.72
CCL | Carnival Corporation | 384 | 14,979.79 | 3,167.0000 | 12,161.28 | 4.64% | -2,818.51 | 312.16 | 0.00 | 312.16 | -2,506.35 | 5.13% | 624.00
GNK | Greene King | 2,266 | 14,994.78 | 846.0000 | 19,170.36 | 7.32% | 4,175.58 | 552.90 | 0.00 | 552.90 | 4,728.48 | 3.92% | 752.31
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,699.0000 | 15,987.59 | 6.10% | 988.22 | 178.79 | 178.79 | 357.58 | 1,345.80 | 4.71% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 601.9000 | 14,596.08 | 5.57% | -402.19 | 384.85 | 0.00 | 384.85 | -17.34 | 6.88% | 1,004.92
IBST | Ibstock | 5,849 | 14,999.47 | 232.2000 | 13,581.38 | 5.19% | -1,418.09 | 859.79 | 0.00 | 859.79 | -558.30 | 4.18% | 567.35
IGG | IG Group Holdings | 2,762 | 14,999.32 | 596.4000 | 16,472.57 | 6.29% | 1,473.25 | 0.00 | 835.22 | 835.22 | 2,308.47 | 7.24% | 1,193.18
IMB | Imperial Brands | 568 | 14,988.79 | 1,820.6000 | 10,341.01 | 3.95% | -4,647.78 | 355.34 | 0.00 | 355.34 | -4,292.44 | 11.35% | 1,173.26
ITV | ITV | 11,652 | 14,999.08 | 123.1000 | 14,343.61 | 5.48% | -655.47 | 629.20 | 0.00 | 629.20 | -26.27 | 6.50% | 932.16
LAND | Land Securities Group | 818 | 7,499.19 | 836.6000 | 6,843.39 | 2.61% | -655.80 | 190.17 | 0.00 | 190.17 | -465.63 | 5.55% | 379.96
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,309.5000 | 7,136.36 | 2.72% | -345.30 | 231.68 | 0.00 | 231.68 | -113.62 | 6.61% | 472.02
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 271.0000 | 14,913.13 | 5.69% | -84.52 | 1,188.63 | 0.00 | 1,188.63 | 1,104.11 | 7.97% | 1,188.64
SMDS | DS Smith | 4,310 | 14,997.11 | 335.0000 | 14,438.50 | 5.51% | -558.61 | 224.12 | 474.10 | 698.22 | 139.61 | 4.84% | 698.22
VOD | Vodafone Group | 10,077 | 14,998.48 | 157.8600 | 15,907.55 | 6.07% | 909.07 | 375.37 | 0.00 | 375.37 | 1,284.44 | 5.07% | 806.59
WPP | WPP | 1,780 | 14,997.55 | 973.8000 | 17,333.64 | 6.62% | 2,336.09 | 663.94 | 404.06 | 1,068.00 | 3,404.09 | 6.16% | 1,068.00
| | | | | | | | | | | | |
| Sub Total: | | £254,904.77 | | £251,445.28 | 96.00% | -£3,459.49 | £8,496.71 | £1,993.78 | £10,490.49 | £7,031.00 | 6.03% | £15,162.10
| Cash Bal: | | | | £0.00 | 0.00% | | | | | | |
| Ex-Dividend: | | | | £1,993.78 | 0.76% | | | | | | |
| Cash Out: | | | | £8,496.71 | 3.24% | | | | | | |
| | | | | | | | | | | | |
| Total: | | £254,904.77 | | £261,935.77 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | -£8,496.71 | | | | | | | |
| Dividends: | | | | £8,496.71 | | | | | | | |
| Realised P/L: | | | | £0.00 | P/L from Sales | | | | | | |
| Un-Realised P/L: | | | | £7,031.00 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £261,935.77 | 5.48% | | | | | | |


With the breakdown by Business as follows:

Business        |  Cost (£)    |  Value (£)   |  Value (%)  |  P/L (£)     |  Div Rec'd (£)  |  Ex-Div (£)  |  Total Inc (£)  |  Overall (£)  |  Yield (%) *  |  Year Inc (£)
Brewing & Pubs | 14,994.78 | 19,170.36 | 7.56% | 4,175.58 | 552.90 | 0.00 | 552.90 | 4,728.48 | 3.92% | 752.31
Advertising | 14,997.55 | 17,333.64 | 6.84% | 2,336.09 | 663.94 | 404.06 | 1,068.00 | 3,404.09 | 6.16% | 1,068.00
Gambling | 14,999.32 | 16,472.57 | 6.50% | 1,473.25 | 0.00 | 835.22 | 835.22 | 2,308.47 | 7.24% | 1,193.18
Weapons | 14,995.20 | 16,553.92 | 6.53% | 1,558.72 | 401.67 | 0.00 | 401.67 | 1,960.39 | 4.15% | 687.71
Pharma | 14,999.37 | 15,987.59 | 6.31% | 988.22 | 178.79 | 178.79 | 357.58 | 1,345.80 | 4.71% | 752.80
Telecom | 14,998.48 | 15,907.55 | 6.28% | 909.07 | 375.37 | 0.00 | 375.37 | 1,284.44 | 5.07% | 806.59
Fund Manager | 14,997.65 | 14,913.13 | 5.88% | -84.52 | 1,188.63 | 0.00 | 1,188.63 | 1,104.11 | 7.97% | 1,188.64
Banks | 14,998.27 | 14,596.08 | 5.76% | -402.19 | 384.85 | 0.00 | 384.85 | -17.34 | 6.88% | 1,004.92
Television | 14,999.08 | 14,343.61 | 5.66% | -655.47 | 629.20 | 0.00 | 629.20 | -26.27 | 6.50% | 932.16
Packaging | 14,997.11 | 14,438.50 | 5.70% | -558.61 | 224.12 | 474.10 | 698.22 | 139.61 | 4.84% | 698.22
Property | 14,993.43 | 13,916.18 | 5.49% | -1,077.25 | 288.82 | 101.61 | 390.43 | -686.82 | 5.65% | 786.42
Mining | 14,992.51 | 14,105.22 | 5.57% | -887.29 | 528.19 | 0.00 | 528.19 | -359.10 | 6.42% | 905.61
Insurance | 14,996.21 | 13,820.60 | 5.45% | -1,175.61 | 1,100.18 | 0.00 | 1,100.18 | -75.43 | 7.96% | 1,100.19
Oil | 14,977.76 | 13,802.66 | 5.45% | -1,175.10 | 452.76 | 0.00 | 452.76 | -722.34 | 6.67% | 920.74
Bricks | 14,999.47 | 13,581.38 | 5.36% | -1,418.09 | 859.79 | 0.00 | 859.79 | -558.30 | 4.18% | 567.35
Cruise Ships | 14,979.79 | 12,161.28 | 4.80% | -2,818.51 | 312.16 | 0.00 | 312.16 | -2,506.35 | 5.13% | 624.00
Tobacco | 14,988.79 | 10,341.01 | 4.08% | -4,647.78 | 355.34 | 0.00 | 355.34 | -4,292.44 | 11.35% | 1,173.26

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

Income: To-Date

Year Start  |  Q1          |  Q2          |  Q3      |  Q4      |  Total     
06-Apr-19 | £3,919.91 | £4,576.80 | £0.00 | £0.00 | £8,496.71

Income: Monthly Forecast

Date       |  Amount (£)   |
05-Nov-19 | 1,892.17 |
05-Dec-19 | 887.64 |
03-Jan-20 | 795.14 |
05-Feb-20 | 906.83 |
05-Mar-20 | 459.56 |
03-Apr-20 | 1,169.64 |
05-May-20 | 1,050.82 |
05-Jun-20 | 2,572.46 |
03-Jul-20 | 944.03 |
05-Aug-20 | 1,609.49 |
04-Sep-20 | 0.00 |
05-Oct-20 | 2,874.16 |
| | Average
12 Months | £15,161.94 | £1,263.50

Note: the above forecast includes amounts predicted for Greene King PLC (GNK) which will of course not now be received. However, there will be a replacement holding which will most likely yield more than the 3.93% forecast for GNK.

Sale of Greene King PLC (GNK)

The upcoming takeover of GNK means that a decision will be needed on a replacement holding. After initially waiting to see if the Hong Kong company’s offer of £8.50 per share would smoke out another higher offer, which of course has not happened, I have now decided to sell GNK to the market rather than wait until the end of the year to receive the funds. This will result in a slightly smaller amount being received but on the other hand it will allow the investment into a dividend producing share at an earlier date. HYP is about the Income after all.

So, the holding of GNK will be sold on 9 October 2019 with the proceeds being used to purchase a replacement the same day as well as a top-up on 10 October 2019. The sale should provide approximately £19,150.00 which I have decided to re-invest as follows:

Purchase on 9 October 2019

The sale of GNK will reduce the sector diversification from 17 to 16 which I have decided to rectify by investing £15,400, being the current average sector value, into a new sector. The choice was between:

Sector       |  EPIC  |  Company Name                 |  Yield
Water | PNN | Pennon Group | 4.96%
Engineering | BAB | Babcock International Group | 5.38%

Pennon Group PLC (PNN)

The owners of South West Water and Viridor Limited

The dividend history over more than a decade is unblemished in my view. Other figures include:

Dividend Cover: 1.32 – reasonably high for what is a regulated sector
P/E Ratio: 15.7 – low, or maybe lowish, when compared with other Utilities

The recent Trading update has already been reported on these boards here:

viewtopic.php?p=254244#p254244 – thanks to idpickering

I do appreciate the much-discussed political risk of nationalisation but, in my opinion, the chances of a future Corbyn led Labour Government with a working majority large enough to push through such a policy are slim. At least slim enough to leave it to Strategic Ignorance.

Babcock International PLC (BAB)

From their website: https://www.babcockinternational.com/
Babcock is a leading provider of critical, complex engineering services which support national defence, save lives and protect communities.
We focus on three highly regulated markets – defence, emergency services and civil nuclear – delivering vital services and managing complex assets in the UK and internationally. We are a trusted partner who understands the key roles that our technology, our expertise, our infrastructure and our assets play in ensuring our customers can deliver. We share risk with them in delivering innovation, and we share the benefits.

The dividend history over the past 5 years shows continuous growth although now slowing. Other figures include:

Dividend Cover: 1.61 – reasonable although reduced from the prior year
P/E Ratio: 12.7 – low, in my view

Year End 31 March 2019 revenue and profits were reduced from the previous year, but the Cash Flow is reported as good.

I was about to go for BAB but, upon reading the latest Annual Report here:

https://www.babcockinternational.com/wp ... tement.pdf

I noticed at the very beginning that the current outlook for the Year End 31 March 2020, as reported by the Company, mentions a reduction in Operating Profit to £515m - £535m (2019: £568m)
Outlook for the year ending 31 March 2020
- As previously highlighted, the year ending 31 March 2020 will be affected by a number of step downs (detailed on page 6). In total,
these step downs will reduce revenue by £410 million and reduce operating profit by £63 million
- The Group’s guidance reflects these step downs and the current market conditions, including the weakness in short cycle contracts
experienced this financial year
- We expect underlying revenue to be around £4.9 billion
- We expect to maintain our underlying margin (incl. JVs) at between 10.7% and 11.0%
- Underlying operating profit is expected to be in the range of £515 million to £535 million
- Free cash flow (post pension payments) is expected to be over £250 million and we expect to continue to reduce net debt
- As with previous years, performance for the group will be weighted to the second half, especially for cash generation

It does not sound too bad but the dividend does not look quite as sustainable as I would like. Rather a shame in my view, as BAB was otherwise looking like an interesting candidate not normally considered for HYP. Personally, I have put it on my watchlist.

Decision

The decision as to where to invest the bulk of the proceeds from the sale of GNK is therefore PNN

Top-Up on 10 Oct 2019

So as not to create an overweight holding, the remaining funds – approximately £3,750 – will be split between:

Sector     |  EPIC  |  Company Name  |  Yield
Insurance | AV | Aviva | 7.61%
Oil | BP | BP | 6.73%

The Value Concentration after purchase for both Oil and Insurance sectors will be around 6.00%, not the largest.


The price of the GNK sale will be determined by the mid-price on the 9 October 2019, as will the price of the PNN purchase. Once the remaining funds from the sale of GNK are known, the details of the two planned top-ups will be determined by the mid-prices on 10 October 2019. I will post an update when the details of all deals are known.

Enjoy!


Ian

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

Re: PYAD HYP 2019_04 DRAWDOWN – Year 1

#256994

Postby IanTHughes » October 10th, 2019, 6:35 pm

Update 10 October 2019

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=256093#p256093

The sale of Greene King PLC (GNK) and the purchase of Pennon PLC (PNN), together with the two top-ups indicated in the previous post viewtopic.php?p=256090#p256090 have now been made as follows:

EPIC | Shares  | Price (p) | Cost (£)    | Stamp (£) | Fee (£) | Total (£)  
BP | 370 | 506.1500 | -1,872.76 | -9.36 | -1.50 | -1,883.62
AV | 496 | 378.3265 | -1,876.50 | -9.38 | -1.50 | -1,887.38
PNN | 1,900 | 806.3000 | -15,319.70 | -76.60 | -9.95 | -15,406.25
GNK | -2,266 | 847.0000 | 19,193.02 | 0.00 | -9.95 | 19,183.07

The portfolio currently looks like this:

EPIC | Company                | Shares  | Cost (£)     | Price (p)   | Value (£)    | Value (%) | P/L (£)     | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
IMB | Imperial Brands | 568 | 14,988.79 | 1,872.6000 | 10,636.37 | 4.05% | -4,352.42 | 355.34 | 0.00 | 355.34 | -3,997.08 | 11.03% | 1,173.26
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 272.3000 | 14,984.67 | 5.70% | -12.98 | 1,188.63 | 0.00 | 1,188.63 | 1,175.65 | 7.93% | 1,188.64
AV | Aviva | 4,133 | 16,883.59 | 381.2000 | 15,755.00 | 5.99% | -1,128.59 | 1,100.18 | 0.00 | 1,100.18 | -28.41 | 7.94% | 1,250.23
IGG | IG Group Holdings | 2,762 | 14,999.32 | 576.6000 | 15,925.69 | 6.06% | 926.37 | 0.00 | 835.22 | 835.22 | 1,761.59 | 7.49% | 1,193.18
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 598.0000 | 14,501.50 | 5.52% | -496.77 | 384.85 | 197.00 | 581.85 | 85.08 | 6.93% | 1,004.75
ITV | ITV | 11,652 | 14,999.08 | 121.7500 | 14,186.31 | 5.40% | -812.77 | 629.20 | 0.00 | 629.20 | -183.57 | 6.57% | 932.16
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,304.0000 | 7,119.36 | 2.71% | -362.30 | 231.68 | 0.00 | 231.68 | -130.62 | 6.63% | 471.94
BP | BP | 1,717 | 9,379.72 | 502.0000 | 8,619.34 | 3.28% | -760.38 | 221.08 | 0.00 | 221.08 | -539.30 | 6.64% | 571.88
BHP | BHP Group | 838 | 14,992.51 | 1,696.6000 | 14,217.51 | 5.41% | -775.00 | 528.19 | 0.00 | 528.19 | -246.81 | 6.37% | 905.46
WPP | WPP | 1,780 | 14,997.55 | 963.8000 | 17,155.64 | 6.53% | 2,158.09 | 663.94 | 404.06 | 1,068.00 | 3,226.09 | 6.23% | 1,068.00
BLND | British Land Company | 1,273 | 7,494.24 | 548.0000 | 6,976.04 | 2.65% | -518.20 | 98.65 | 101.61 | 200.26 | -317.94 | 5.83% | 406.46
LAND | Land Securities Group | 818 | 7,499.19 | 839.2000 | 6,864.66 | 2.61% | -634.53 | 190.17 | 0.00 | 190.17 | -444.36 | 5.54% | 379.96
CCL | Carnival Corporation | 384 | 14,979.79 | 3,146.0000 | 12,080.64 | 4.60% | -2,899.15 | 312.16 | 0.00 | 312.16 | -2,586.99 | 5.16% | 623.92
PNN | Pennon Group | 1,900 | 15,406.25 | 821.4000 | 15,606.60 | 5.94% | 200.35 | 0.00 | 0.00 | 0.00 | 200.35 | 5.00% | 780.14
VOD | Vodafone Group | 10,077 | 14,998.48 | 162.8200 | 16,407.37 | 6.24% | 1,408.89 | 375.37 | 0.00 | 375.37 | 1,784.26 | 4.93% | 808.66
SMDS | DS Smith | 4,310 | 14,997.11 | 341.2000 | 14,705.72 | 5.59% | -291.39 | 224.12 | 474.10 | 698.22 | 406.83 | 4.75% | 698.22
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,712.0000 | 16,109.92 | 6.13% | 1,110.55 | 357.58 | 0.00 | 357.58 | 1,468.13 | 4.67% | 752.80
IBST | Ibstock | 5,849 | 14,999.47 | 231.6000 | 13,546.28 | 5.15% | -1,453.19 | 859.79 | 0.00 | 859.79 | -593.40 | 4.19% | 567.35
BA | BAE Systems | 3,043 | 14,995.20 | 553.2000 | 16,833.88 | 6.40% | 1,838.68 | 401.67 | 0.00 | 401.67 | 2,240.35 | 4.09% | 687.71
| | | | | | | | | | | | |
| Sub Total: | | £259,087.24 | | £252,232.50 | 95.93% | -£6,854.74 | £8,122.60 | £2,011.99 | £10,134.59 | £3,279.85 | 6.13% | £15,464.72
| Cash Bal: | | | | £182.81 | 0.07% | | | | | | |
| Ex-Dividend: | | | | £2,011.99 | 0.77% | | | | | | |
| Cash Out: | | | | £8,496.71 | 3.23% | | | | | | |
| | | | | | | | | | | | |
| Total: | | £259,087.24 | | £262,924.01 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | -£8,496.71 | | | | | | | |
| Dividends: | | | | £8,675.50 | | | | | | | |
| Realised P/L: | | | | £4,188.29 | GNK | | | | | | |
| Un-Realised P/L: | | | | £3,652.16 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £262,924.01 | 6.07% | | | | | | |

With the breakdown by Business as follows:

Business     | Cost (£)   | Value (£)  | Value (%) | P/L (£)    | Div Rec'd (£) | Ex-Div (£) | Total Inc (£) | Overall (£) | Yield (%) * | Year Inc (£)
Advertising | 14,997.55 | 17,155.64 | 6.74% | 2,158.09 | 663.94 | 404.06 | 1,068.00 | 3,226.09 | 6.23% | 1,068.00
Weapons | 14,995.20 | 16,833.88 | 6.62% | 1,838.68 | 401.67 | 0.00 | 401.67 | 2,240.35 | 4.09% | 687.71
Telecom | 14,998.48 | 16,407.37 | 6.45% | 1,408.89 | 375.37 | 0.00 | 375.37 | 1,784.26 | 4.93% | 808.66
Pharma | 14,999.37 | 16,109.92 | 6.33% | 1,110.55 | 357.58 | 0.00 | 357.58 | 1,468.13 | 4.67% | 752.80
Oil | 16,861.38 | 15,738.70 | 6.19% | -1,122.68 | 452.76 | 0.00 | 452.76 | -669.92 | 6.63% | 1,043.82
Gambling | 14,999.32 | 15,925.69 | 6.26% | 926.37 | 0.00 | 835.22 | 835.22 | 1,761.59 | 7.49% | 1,193.18
Insurance | 16,883.59 | 15,755.00 | 6.19% | -1,128.59 | 1,100.18 | 0.00 | 1,100.18 | -28.41 | 7.94% | 1,250.23
Water | 15,406.25 | 15,606.60 | 6.13% | 200.35 | 0.00 | 0.00 | 0.00 | 200.35 | 5.00% | 780.14
Fund Manager | 14,997.65 | 14,984.67 | 5.89% | -12.98 | 1,188.63 | 0.00 | 1,188.63 | 1,175.65 | 7.93% | 1,188.64
Packaging | 14,997.11 | 14,705.72 | 5.78% | -291.39 | 224.12 | 474.10 | 698.22 | 406.83 | 4.75% | 698.22
Banks | 14,998.27 | 14,501.50 | 5.70% | -496.77 | 384.85 | 197.00 | 581.85 | 85.08 | 6.93% | 1,004.75
Mining | 14,992.51 | 14,217.51 | 5.59% | -775.00 | 528.19 | 0.00 | 528.19 | -246.81 | 6.37% | 905.46
Television | 14,999.08 | 14,186.31 | 5.58% | -812.77 | 629.20 | 0.00 | 629.20 | -183.57 | 6.57% | 932.16
Property | 14,993.43 | 13,840.70 | 5.44% | -1,152.73 | 288.82 | 101.61 | 390.43 | -762.30 | 5.68% | 786.42
Bricks | 14,999.47 | 13,546.28 | 5.32% | -1,453.19 | 859.79 | 0.00 | 859.79 | -593.40 | 4.19% | 567.35
Cruise Ships | 14,979.79 | 12,080.64 | 4.75% | -2,899.15 | 312.16 | 0.00 | 312.16 | -2,586.99 | 5.16% | 623.92
Tobacco | 14,988.79 | 10,636.37 | 4.18% | -4,352.42 | 355.34 | 0.00 | 355.34 | -3,997.08 | 11.03% | 1,173.26

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

Income: To-Date

Year Start |     Q1     |     Q2     |    Q3    |   Q4   |   Total     
06-Apr-19 | £3,919.91 | £4,576.80 | £178.79 | £0.00 | £8,675.50

Income: Monthly Forecast

Date      | Amount (£)  |           
05-Nov-19 | 1,892.17 |
05-Dec-19 | 887.60 |
03-Jan-20 | 825.89 |
05-Feb-20 | 708.55 |
05-Mar-20 | 459.56 |
03-Apr-20 | 1,200.33 |
05-May-20 | 1,538.68 |
05-Jun-20 | 2,675.38 |
03-Jul-20 | 974.78 |
05-Aug-20 | 1,610.41 |
04-Sep-20 | 1,072.36 |
05-Oct-20 | 2,399.00 |
| | Average
12 Months | £16,244.71 | £1,353.73


The next update will be posted on or soon after the 5 January 2020

Enjoy!


Ian

Davidsb
2 Lemon pips
Posts: 197
Joined: November 17th, 2016, 5:51 pm
Has thanked: 318 times
Been thanked: 31 times

Re: PYAD HYP 2019_04 DRAWDOWN – Year 1

#258084

Postby Davidsb » October 15th, 2019, 5:08 pm

Thanks, Ian.

I'm currently waiting for the proceeds from Greene King and also Cobham, which will be added to the last quarter's dividend receipts, resulting in a roughly 12% uplift in the portfolio's valuation and overall dividend yield.

Deliberations will take place over the next six weeks or so - but a crude trawl last week didn't throw up any new shares screaming "BUY ME!"

I might take a closer look at PRU for part of the cash, as it seemed to be veering towards good value - I know it's only on 3.7% yield, but with cover of 2.9x and a single-figure P/E ratio it looks pretty solid to me. The M&G split is happening at the moment, so maybe I'll wait for that to settle down first.

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

PYAD HYP 2019_04 DRAWDOWN – Year 1 - Q3

#274972

Postby IanTHughes » January 3rd, 2020, 6:13 pm

Update 05 January 2020

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

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 | 419.4000 | 17,338.00 | 6.15% | 450.61 | 0.00 | 1,100.18 | 1,100.18 | 1,550.79 | 7.21% | 1,250.53
BA | BAE Systems | 3,043 | 14,995.20 | 580.8000 | 17,673.74 | 6.27% | 2,678.54 | 0.00 | 687.71 | 687.71 | 3,366.25 | 3.89% | 687.71
BHP | BHP Group | 838 | 14,992.51 | 1,796.4000 | 15,053.83 | 5.34% | 61.32 | 0.00 | 528.19 | 528.19 | 589.51 | 5.66% | 851.50
BLND | British Land Company | 1,273 | 7,494.24 | 629.8000 | 8,017.35 | 2.84% | 523.11 | 101.61 | 200.26 | 301.87 | 824.98 | 5.07% | 406.46
BP | BP | 1,717 | 9,379.72 | 494.0500 | 8,482.84 | 3.01% | -896.88 | 0.00 | 355.43 | 355.43 | -541.45 | 6.34% | 537.83
CCL | Carnival Corporation | 384 | 14,979.79 | 3,587.0000 | 13,774.08 | 4.88% | -1,205.71 | 0.00 | 460.02 | 460.02 | -745.69 | 4.26% | 586.75
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,784.4000 | 16,791.20 | 5.95% | 1,791.83 | 178.79 | 357.58 | 536.37 | 2,328.20 | 4.48% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 594.4000 | 14,414.20 | 5.11% | -584.07 | 0.00 | 573.99 | 573.99 | -10.08 | 6.56% | 944.87
IBST | Ibstock | 5,849 | 14,999.47 | 320.8000 | 18,763.59 | 6.65% | 3,764.12 | 0.00 | 859.79 | 859.79 | 4,623.91 | 3.02% | 567.35
IGG | IG Group Holdings | 2,762 | 14,999.32 | 699.8000 | 19,328.48 | 6.85% | 4,329.16 | 0.00 | 835.22 | 835.22 | 5,164.38 | 6.17% | 1,193.18
IMB | Imperial Brands | 568 | 14,988.79 | 1,922.2000 | 10,918.10 | 3.87% | -4,070.69 | 0.00 | 764.30 | 764.30 | -3,306.39 | 10.75% | 1,173.26
ITV | ITV | 11,652 | 14,999.08 | 149.8000 | 17,454.70 | 6.19% | 2,455.62 | 0.00 | 932.15 | 932.15 | 3,387.77 | 5.34% | 932.16
LAND | Land Securities Group | 818 | 7,499.19 | 989.4000 | 8,093.29 | 2.87% | 594.10 | 0.00 | 285.05 | 285.05 | 879.15 | 4.69% | 379.96
PNN | Pennon Group | 1,900 | 15,406.25 | 1,017.0000 | 19,323.00 | 6.85% | 3,916.75 | 0.00 | 0.00 | 0.00 | 3,916.75 | 4.12% | 795.72
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 2,306.5000 | 7,127.09 | 2.53% | -354.57 | 0.00 | 342.08 | 342.08 | -12.49 | 6.23% | 443.82
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 330.2000 | 18,170.91 | 6.44% | 3,173.26 | 0.00 | 1,188.63 | 1,188.63 | 4,361.89 | 6.54% | 1,188.64
SMDS | DS Smith | 4,310 | 14,997.11 | 387.1000 | 16,684.01 | 5.92% | 1,686.90 | 0.00 | 698.22 | 698.22 | 2,385.12 | 4.24% | 706.84
VOD | Vodafone Group | 10,077 | 14,998.48 | 147.9400 | 14,907.91 | 5.29% | -90.57 | 387.14 | 375.37 | 762.51 | 671.94 | 5.00% | 745.04
WPP | WPP | 1,780 | 14,997.55 | 1,070.5000 | 19,054.90 | 6.76% | 4,057.35 | 0.00 | 1,068.00 | 1,068.00 | 5,125.35 | 5.60% | 1,068.00
| | | | | | | | | | | | |
| Sub Total: | | | | £281,371.22 | 99.76% | £22,280.18 | £667.54 | | | | 5.41% | £15,212.42
| Cash Bal: | | | | £0.00 | 0.00% | | | | | | |
| Ex-Dividend: | | | | £667.54 | 0.24% | | | | | | |
| | | | | | | | | | | | |
| Total Value: | | | | £282,038.76 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | -£12,167.09 | | | | | | | |
| Dividends Received: | | | | £12,165.07 | | | | | | | |
| Ex-Dividend: | | | | £667.54 | | | | | | | |
| Realised P/L: | | | GNK | £4,188.29 | | | | | | | |
| Un-Realised P/L: | | | | £22,280.18 | | | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £282,038.76 | 21.05% | | | | | | |

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 | 19,328.48 | 6.85% | 4,329.16 | 0.00 | 835.22 | 835.22 | 5,164.38 | 6.17% | 1,193.18
Water | 15,406.25 | 19,323.00 | 6.85% | 3,916.75 | 0.00 | 0.00 | 0.00 | 3,916.75 | 4.12% | 795.72
Advertising | 14,997.55 | 19,054.90 | 6.76% | 4,057.35 | 0.00 | 1,068.00 | 1,068.00 | 5,125.35 | 5.60% | 1,068.00
Bricks | 14,999.47 | 18,763.59 | 6.65% | 3,764.12 | 0.00 | 859.79 | 859.79 | 4,623.91 | 3.02% | 567.35
Fund Manager | 14,997.65 | 18,170.91 | 6.44% | 3,173.26 | 0.00 | 1,188.63 | 1,188.63 | 4,361.89 | 6.54% | 1,188.64
Weapons | 14,995.20 | 17,673.74 | 6.27% | 2,678.54 | 0.00 | 687.71 | 687.71 | 3,366.25 | 3.89% | 687.71
Television | 14,999.08 | 17,454.70 | 6.19% | 2,455.62 | 0.00 | 932.15 | 932.15 | 3,387.77 | 5.34% | 932.16
Insurance | 16,887.39 | 17,338.00 | 6.15% | 450.61 | 0.00 | 1,100.18 | 1,100.18 | 1,550.79 | 7.21% | 1,250.53
Pharma | 14,999.37 | 16,791.20 | 5.95% | 1,791.83 | 178.79 | 357.58 | 536.37 | 2,328.20 | 4.48% | 752.80
Packaging | 14,997.11 | 16,684.01 | 5.92% | 1,686.90 | 0.00 | 698.22 | 698.22 | 2,385.12 | 4.24% | 706.84
Property | 14,993.43 | 16,110.64 | 5.71% | 1,117.21 | 101.61 | 485.31 | 586.92 | 1,704.13 | 4.88% | 786.42
Oil | 16,861.38 | 15,609.93 | 5.53% | -1,251.45 | 0.00 | 697.51 | 697.51 | -553.94 | 6.29% | 981.65
Mining | 14,992.51 | 15,053.83 | 5.34% | 61.32 | 0.00 | 528.19 | 528.19 | 589.51 | 5.66% | 851.50
Telecom | 14,998.48 | 14,907.91 | 5.29% | -90.57 | 387.14 | 375.37 | 762.51 | 671.94 | 5.00% | 745.04
Banks | 14,998.27 | 14,414.20 | 5.11% | -584.07 | 0.00 | 573.99 | 573.99 | -10.08 | 6.56% | 944.87
Cruise Ships | 14,979.79 | 13,774.08 | 4.88% | -1,205.71 | 0.00 | 460.02 | 460.02 | -745.69 | 4.26% | 586.75
Tobacco | 14,988.79 | 10,918.10 | 3.87% | -4,070.69 | 0.00 | 764.30 | 764.30 | -3,306.39 | 10.75% | 1,173.26


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

Income: To-Date

Year Start  |     Q1      |     Q2      |     Q3      |    Q4    |   Total   
06-Apr-19 | £3,919.13 | £4,576.80 | £3,669.14 | - | £12,165.07


Income: Monthly Forecast

   Date   |  Amount (£) |
05-Feb-20 | 178.79 |
05-Mar-20 | 837.86 |
03-Apr-20 | 1,398.59 |
05-May-20 | 1,027.32 |
05-Jun-20 | 2,675.59 |
03-Jul-20 | 942.47 |
05-Aug-20 | 1,571.08 |
04-Sep-20 | 536.18 |
05-Oct-20 | 2,310.38 |
05-Nov-20 | 1,892.17 |
04-Dec-20 | 872.34 |
05-Jan-21 | 895.92 |
| | Average
12 Months | £15,212.24 | £1,267.69


Enjoy!


Ian

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

PYAD HYP 2019_04 DRAWDOWN – Year 1

#297566

Postby IanTHughes » April 3rd, 2020, 10:54 pm

Annual Report 05 April 2020

This is the first annual 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 | 233.6000 | 9,657.02 | 5.24% | -7,230.37 | 0.00 | 1,100.18 | 1,100.18 | -6,130.19 | 13.23% | 1,277.40
BA | BAE Systems | 3,043 | 14,995.20 | 500.0000 | 15,215.00 | 8.26% | 219.80 | 0.00 | 687.71 | 687.71 | 907.51 | 1.88% | 286.04
BHP | BHP Group | 838 | 14,992.51 | 1,241.2000 | 10,401.26 | 5.65% | -4,591.25 | 0.00 | 944.08 | 944.08 | -3,647.17 | 9.29% | 966.71
BLND | British Land Company | 1,273 | 7,494.24 | 314.5000 | 4,003.59 | 2.17% | -3,490.65 | 0.00 | 301.87 | 301.87 | -3,188.78 | 7.61% | 304.85
BP | BP | 1,717 | 9,379.72 | 337.3000 | 5,791.44 | 3.14% | -3,588.28 | 0.00 | 495.46 | 495.46 | -3,092.82 | 10.05% | 581.75
CCL | Carnival Corporation | 384 | 14,979.79 | 614.8000 | 2,360.83 | 1.28% | -12,618.96 | 0.00 | 610.18 | 610.18 | -12,008.78 | 19.68% | 464.66
GSK | GlaxoSmithKline | 941 | 14,999.37 | 1,489.4000 | 14,015.25 | 7.61% | -984.12 | 216.43 | 536.37 | 752.80 | -231.32 | 5.37% | 752.80
HSBA | HSBC Holdings | 2,425 | 14,998.27 | 397.2000 | 9,632.10 | 5.23% | -5,366.17 | 0.00 | 573.99 | 573.99 | -4,792.18 | 0.00% | 0.00
IBST | Ibstock | 5,849 | 14,999.47 | 148.4000 | 8,679.92 | 4.71% | -6,319.55 | 0.00 | 859.79 | 859.79 | -5,459.76 | 2.16% | 187.16
IGG | IG Group Holdings | 2,762 | 14,999.32 | 667.5000 | 18,436.35 | 10.01% | 3,437.03 | 0.00 | 1,193.17 | 1,193.17 | 4,630.20 | 6.47% | 1,193.18
IMB | Imperial Brands | 568 | 14,988.79 | 1,563.5000 | 8,880.68 | 4.82% | -6,108.11 | 0.00 | 1,173.31 | 1,173.31 | -4,934.80 | 13.21% | 1,173.26
ITV | ITV | 11,652 | 14,999.08 | 54.4200 | 6,341.02 | 3.44% | -8,658.06 | 0.00 | 932.15 | 932.15 | -7,725.91 | 4.78% | 302.95
LAND | Land Securities Group | 818 | 7,499.19 | 514.6000 | 4,209.43 | 2.29% | -3,289.76 | 0.00 | 285.05 | 285.05 | -3,004.71 | 6.77% | 285.07
PNN | Pennon Group | 1,900 | 15,406.25 | 1,045.0000 | 19,855.00 | 10.78% | 4,448.75 | 0.00 | 259.54 | 259.54 | 4,708.29 | 4.01% | 795.72
RDSB | Royal Dutch Shell | 309 | 7,481.66 | 1,418.4000 | 4,382.86 | 2.38% | -3,098.80 | 0.00 | 454.55 | 454.55 | -2,644.25 | 10.69% | 468.63
SLA | Standard Life Aberdeen | 5,503 | 14,997.65 | 192.9000 | 10,615.29 | 5.76% | -4,382.36 | 786.92 | 1,188.63 | 1,975.55 | -2,406.81 | 11.20% | 1,188.64
SMDS | DS Smith | 4,310 | 14,997.11 | 254.7000 | 10,977.57 | 5.96% | -4,019.54 | 0.00 | 698.22 | 698.22 | -3,321.32 | 6.44% | 706.84
VOD | Vodafone Group | 10,077 | 14,998.48 | 111.0200 | 11,187.49 | 6.07% | -3,810.99 | 0.00 | 758.07 | 758.07 | -3,052.92 | 6.97% | 779.37
WPP | WPP | 1,780 | 14,997.55 | 483.7000 | 8,609.86 | 4.67% | -6,387.69 | 0.00 | 1,068.00 | 1,068.00 | -5,319.69 | 4.69% | 404.06
| | | | | | | | | | | | |
| Sub Total: | | | | £183,251.96 | 99.46% | -£75,839.08 | £1,003.35 | | | | 6.61% | £12,119.09
| Cash Balance: | | | | £0.00 | 0.00% | | | | | | |
| Ex-Dividend: | | | | £1,003.35 | 0.55% | | | | | | |
| | | | | | | | | | | | |
| Total Value: | | | | £184,255.31 | | | | | | | |
| From: | | | | | | | | | | | |
| Cash In: | | | | £254,904.77 | | | | | | | |
| LESS Cash Out: | | | | -£14,675.24 | | | | | | | |
| Dividends Received: | | | | £14,673.22 | | | | | | | |
| Ex-Dividend: | | | | £1,003.35 | | | | | | | |
| Realised P/L: | | | GNK | £4,188.29 | | | | | | | |
| Un-Realised P/L: | | | | -£75,839.08 | | 0.00 | | | | | |
| | | | | | XIRR | | | | | | |
| Total: | | | | £184,255.31 | -22.34% | | | | | | |


Current Portfolio: Business Sectors

 Business      |  Cost (£)  |  Value (£)  |  Value (%)  |  P/L (£)    |  Ex-Div (£)  |  Div Rec'd (£)  |  Total Inc (£)  |  Overall (£)  |  Yield (%) *  |  Year Inc (£) 
Water | 15,406.25 | 19,855.00 | 10.78% | 4,448.75 | 0.00 | 259.54 | 259.54 | 4,708.29 | 4.01% | 795.72
Gambling | 14,999.32 | 18,436.35 | 10.01% | 3,437.03 | 0.00 | 1,193.17 | 1,193.17 | 4,630.20 | 6.47% | 1,193.18
Weapons | 14,995.20 | 15,215.00 | 8.26% | 219.80 | 0.00 | 687.71 | 687.71 | 907.51 | 1.88% | 286.04
Pharma | 14,999.37 | 14,015.25 | 7.61% | -984.12 | 216.43 | 536.37 | 752.80 | -231.32 | 5.37% | 752.80
Packaging | 14,997.11 | 10,977.57 | 5.96% | -4,019.54 | 0.00 | 698.22 | 698.22 | -3,321.32 | 6.44% | 706.84
Telecom | 14,998.48 | 11,187.49 | 6.07% | -3,810.99 | 0.00 | 758.07 | 758.07 | -3,052.92 | 6.97% | 779.37
Oil | 16,861.38 | 10,174.30 | 5.52% | -6,687.08 | 0.00 | 950.01 | 950.01 | -5,737.07 | 10.32% | 1,050.38
Fund Manager | 14,997.65 | 10,615.29 | 5.76% | -4,382.36 | 786.92 | 1,188.63 | 1,975.55 | -2,406.81 | 11.20% | 1,188.64
Mining | 14,992.51 | 10,401.26 | 5.65% | -4,591.25 | 0.00 | 944.08 | 944.08 | -3,647.17 | 9.29% | 966.71
Insurance | 16,887.39 | 9,657.02 | 5.24% | -7,230.37 | 0.00 | 1,100.18 | 1,100.18 | -6,130.19 | 13.23% | 1,277.40
Banks | 14,998.27 | 9,632.10 | 5.23% | -5,366.17 | 0.00 | 573.99 | 573.99 | -4,792.18 | 0.00% | 0.00
Advertising | 14,997.55 | 8,609.86 | 4.67% | -6,387.69 | 0.00 | 1,068.00 | 1,068.00 | -5,319.69 | 4.69% | 404.06
Bricks | 14,999.47 | 8,679.92 | 4.71% | -6,319.55 | 0.00 | 859.79 | 859.79 | -5,459.76 | 2.16% | 187.16
Tobacco | 14,988.79 | 8,880.68 | 4.82% | -6,108.11 | 0.00 | 1,173.31 | 1,173.31 | -4,934.80 | 13.21% | 1,173.26
Property | 14,993.43 | 8,213.02 | 4.46% | -6,780.41 | 0.00 | 586.92 | 586.92 | -6,193.49 | 7.18% | 589.92
Television | 14,999.08 | 6,341.02 | 3.44% | -8,658.06 | 0.00 | 932.15 | 932.15 | -7,725.91 | 4.78% | 302.95
Cruise Ships | 14,979.79 | 2,360.83 | 1.28% | -12,618.96 | 0.00 | 610.18 | 610.18 | -12,008.78 | 19.68% | 464.66

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

This is a "Buy and Hold" portfolio with all dividends withdrawn. However, the takeover of Greene King PLC (GNK) during the year made it necessary to re-invest the proceeds received into new holdings as follows:

Transactions |              |         |           |             |           |         |             |                |                               
Date | EPIC | Shares | Price (p) | Cost (£) | Stamp (£) | Fee (£) | Total (£) | Business | Comment

10-Oct-19 | BP | 370 | 506.1500 | -1,872.76 | -9.36 | -1.50 | -1,883.62 | Oil | Replace GNK
10-Oct-19 | AV | 497 | 378.3265 | -1,880.28 | -9.40 | -1.50 | -1,891.18 | Insurance | Replace GNK
09-Oct-19 | PNN | 1,900 | 806.3000 | -15,319.70 | -76.60 | -9.95 | -15,406.25 | Water | Replace GNK
09-Oct-19 | GNK | -2,266 | 847.0000 | 19,193.02 | 0.00 | -9.95 | 19,183.07 | Brewing & Pubs | Sale Pending Imminent Takeover

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

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 few weeks 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-May-20 | 449.17 |
05-Jun-20 | 1,671.59 |
03-Jul-20 | 440.25 |
05-Aug-20 | 750.08 |
04-Sep-20 | 536.18 |
05-Oct-20 | 2,198.90 |
05-Nov-20 | 1,892.17 |
04-Dec-20 | 690.60 |
05-Jan-21 | 921.30 |
05-Feb-21 | 178.79 |
05-Mar-21 | 864.54 |
01-Apr-21 | 1,265.83 |
| | Average
12 Months | £11,859.40 | £988.28

Capital Value

Everything was going quite well until the Covid-19 virus struck. Now of course the value is well down and who knows when it will recover



The next report will be at the end of Quarter One - 5 July 2020 - when hopefully the dividend situation will be clearer. Because it is into Year 2 of this virtual HYP, it will be posted on a new Year 2 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=275149#p275149

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



Enjoy!


Ian


Return to “HYP Practical (See Group Guidelines)”

Who is online

Users browsing this forum: No registered users and 41 guests