I will provide a spreadsheet that can be downloaded here.
The following notes apply:
- Estimated yearly dividends will be always higher then what is being paid. Why: I only track 1 yield number a year. Not only does price change yield (keeping payment the same), dividend increases do as well. If the dividend changes in June, the earlier estimated payments will be adjusted up as well. I don’t have the time to keep such detailed records. For me it is ok.
- Some stocks have funny payment schedules. They are on the quarter, but then they pay on the 30iest of the prevous quarter, rather than on the first of the scheduled quarter. My spreadsheet goes by the standard. In other words on quarterly payments one may see in real life 2 payments in a quarter and a missing (not really) payment in the next.
Disclaimer
All information on this blog is for entertainment, and education information purposes only. Nothing discussed constitutes as financial, investment, trading, tax or any other advice. No decisions should be made based on the information provided. Always do your own independent research and consult a professional broker or financial advisor.
No comments:
Post a Comment