03-14-2014, 12:50 PM
I maintain a spreadsheet listing each stock I own. Across the top, a column for each month. I record the dividend received each qtr when the company pays its div. If there is an increase I record the %. At year end I total the div for each company and record any increase and % of increase from the previous yr. Every year I add new columns for the next year.
I have a separate spreadsheet to record the annual div paid and the Div Growth % for each stock. This one provides me a quick review of the past 14 yrs (when I started it). At the end of the year I calculate the average div gth % for the number of yrs recorded. This report also shows me if the div gth % trend (steady, dropping or increasing).
I have a separate spreadsheet to record the annual div paid and the Div Growth % for each stock. This one provides me a quick review of the past 14 yrs (when I started it). At the end of the year I calculate the average div gth % for the number of yrs recorded. This report also shows me if the div gth % trend (steady, dropping or increasing).