Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
$21.65 – Portfolio Milestone!
#11
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
Reply
#12
(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.
My website: DGI For The DIY
Also on: Facebook - Twitter - Seeking Alpha
Reply




Users browsing this thread: 1 Guest(s)