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