04-08-2014, 01:14 PM
(04-08-2014, 01:05 PM)hron Wrote: Hi guys, where can I find a friendly excel that can do the forward looking projection. Started to put something together but got myself too complex in the process.
Thanks in advance! Ron
I just have two columns at the end of my spreadsheet, one with the annual dividend and the final column the projected income, which is just the number of shares I own times the annual dividend rate.
Whenever I see that a company I own has increased the dividend, I just plug in the new annual rate in the cell.
Here is my most recent portfolio update, about halfway down is a image of my spreadsheet for a visual.