06-04-2018, 10:22 AM
(This post was last modified: 06-04-2018, 10:29 AM by cannew.
Edit Reason: added some info
)
I've usually just picked a figure, say 6% or 7% and multiplied last years income to get my next years estimate. But I thought I'd try to be a bit more accurate, or at least more creative. So I've decided to:
1. Take the 5yr Ave DG% of each company
2. Multiply it by the % holding of each of my stocks, to get an Ave Gth %
3. Then add all the Ave Gth%, to get an estimated div gth for next year.
I only own 12 stocks so mine was fairly easy to compute, which came to 8.17%. As of today, I'm up 6.08%
I'll post my actual income increase% at year end.
ps: At the end of Dec I'm going to set up a new worksheet with the opening %Holdings as fixed amounts (actual as of Dec). Because I reinvest most of my dividends, the %Holdings will change slightly during the year so I'll have a different worksheet to reflect that change. Then at the end of the year the difference in the income amount will be due to the reinvestment.
1. Take the 5yr Ave DG% of each company
2. Multiply it by the % holding of each of my stocks, to get an Ave Gth %
3. Then add all the Ave Gth%, to get an estimated div gth for next year.
I only own 12 stocks so mine was fairly easy to compute, which came to 8.17%. As of today, I'm up 6.08%
I'll post my actual income increase% at year end.
ps: At the end of Dec I'm going to set up a new worksheet with the opening %Holdings as fixed amounts (actual as of Dec). Because I reinvest most of my dividends, the %Holdings will change slightly during the year so I'll have a different worksheet to reflect that change. Then at the end of the year the difference in the income amount will be due to the reinvestment.