JMN2 wrote:I've stopped using forecasts, instead I keep a record of actual announced/paid dividends for each stock and update the spreadsheet as divis are announced or paid, or when I update the divi payments for the next month. For instance, I just updated VOD dividend this morning. All this is showing 4.7% for the portfolio where as digital look is showing 4.93%.
I don't trust DL even for 'actual' data, so their estimates are effectively worthless for me. Their forecast divs are perhaps consensus broker estimates but broker-views are little more than rolling best guesses together with an element of vested interests.
So I do something similar to JMN. I base the HYPTUSS 'Forecast Yield' column on data in a separate spread-sheet page. Essentially this uses the actual dividends paid over the prior year divided by what is in the 'Current price' cell. Note further that DL appear to have no capacity for incorporating any non-standard dividends, so they exclude Specials and '''guaranteed''' future dividend plans. Here are two examples from last night's close:
Berkeley Group Holdings/BKG. Currently has such a 'guaranteed' div plan of paying 200p/pa through to Sep-2021. Close px last night = 3364p
200/3364 = 5.95%
DLs FTSE-250 constituent listing shows the 'Div Yield' figure as 5.65%. No idea why
http://www.digitallook.com/index/FTSE_250Interestingly when I go to the BKG page the 'Forecast Yield' shows at 5.9%
http://www.digitallook.com/equity/Berke ... ldings_TheBut IME that's more coincidence than due to reliability.
Lancashire Holdings/LRE. Infra-structure insurance; airports, oil-rigs etc. Due to the nature of the risks, it pays out divs as a very low basic div, plus a highly variable Special in addition.
This is a tricky one, as might be other insurers with variable specials. If you base your FY% calculation solely on the current US$0.15 basic div then you'd have no reason to buy them. On the other hand basing it on prior pay-outs would not be conservative - hmmm. I tend to pencil in the prior-year pay-out [rolling data on back-ground sheet] over the 'Current Price' cell. Note though: In no way do I mentally bank the higher figure nor expect to receive it until the day the results are announced.
For last night, the PY pay-out was 72.2p. Closing price was 677.5p = 10.66%
DL shows the Yield on the above FTSE-250 index page as 1.7%, perhaps derived off the US$0.15 basic div (but it's DL so who knows, is my cynical view)
Drill down into the stock and the 'Forecast Div%' is 7.6%
http://www.digitallook.com/equity/Lanca ... gs_Limited - and again, who knows where that figure comes from.
I watch corporate guidance on expected earnings/results; I ignore broker forecasts. Close to results if LRE start guiding expectations then I too will start guiding the PY actual div figures to come closer to what is currently expected.
So for me doing this recalculation is worth the small amount of work as the DL div data - esp. on stocks like these - is more than useless to me.