Watching My Dividend Payments Grow Year After Year

Written by The Dividend Guy on December 2, 2007

Dividend Growth

The most rewarding aspect of being a dividend investor is watching your dividend payments grow year after year as the dividends are plowed into more shares of the company. I have set up an Excel spreadsheet that allows me to keep track of this dividend growth to give me both a visual representation of the dividends received as well as the yield I am currently earning on my shares.

What do I do with this spreadsheet? Do I use it to make investment decisions you might be asking yourself? The answer is no, not really. However, it does provide me with some justification that my dividend investing philosophy is strong and working. My hope is that the trends will continue out another 20 years and the visual representation of the yields my companies are providing will be nothing more than mind-blowing. Even if share prices stay flat for the next twenty years, I know that I will continue to receive this every increasing stream of dividend income.

Here is the spreadsheet and below it is a description of each section.

Royal Bank Dividend TrendClick to Enlarge

Section 1:

Section 1 simply represents the initial yield that I received upon my first purchase into the stock. For Royal Bank, when I made my first purchase, I was buying into the stock with a yield at 2.92%. It is the initial buy price divided by the current dividend per share at the time.

Section 2:

Section 2 is where it gets exciting. This is now the current yield I am earning on the initial investment and all other subsequent purchases and reinvestments of dividends into additional shares. It is calculated from simply recording each and every purchase that I make of the stock, including reinvested dividends. From this I end up with a number of shares and a total dollar amount invested. The dollar value invested divided by the number of shares gives me my average purchase price for the stock. In my Royal Bank example, my average price paid for the shares I own is $32.44. I do not take into account commissions in this calculation - I probably should to be more representative of my actual cost per share. I made the decision awhile back not to because I was not using this to make any decisions, just to show how my dividends are working for themselves.

Section 3:

Section 3 is the annual dividends I receive from a particular stock. In my Royal Bank example, I receive $401.26 per year in dividends from the company. It is calculated as the number of shares by the current dividend per year.

Section 4:

Section 4 is where all the purchases and reinvestment transactions are completed. I use Microsoft Money to manage my overall portfolio and all the pertinent transaction costs etc. This is just the number of shares, the price per share, and the total invested.

Section 5:

This section is a graphical representation of the dividends I have received each time a transaction is made. It is going up, which is cool because it shows that every time I reinvest those dividends into more shares, the next time I receive a dividend it is higher than last time. That is where the real power of reinvested dividends comes into play.

Making the effort of creating the spreadsheet to do this tracking has been very worthwhile. As I have stated, it does not help me make my investment decisions but it does provide me with some insight into the growth of my dividends which helps me stick to the plan and motivates me to keep going. This has been especially helpful in a market like the one we were just in.

(Photo Credit: Rodolfo Clix)


Recommended: ING DIRECT makes $aving money simple! Open your account online today and start earning 3.00% variable APY. No Fees and No Minimums!

del.icio.us| Digg| Furl| Reddit| Google| StumbleUpon| Technorati| Help|

11 Comments so far

  1. Economics Topics News » Blog Archive » Watching My Dividend Payments Grow Year After Year December 2, 2007 10:22 am

    […] Watching My Dividend Payments Grow Year After YearBy The Dividend GuyI use Microsoft Money to manage my overall portfolio and all the pertinent transaction costs etc. This is just the number of shares, the price per share, and the total invested. Section 5:. This section is a graphical representation of …The Dividend Guy Blog - http://www.thedividendguyblog.com […]

  2. Dividends4Life December 2, 2007 12:52 pm

    TDG: That is exciting! There is something about the 6% barrier that I enjoy watching my holdings break through (esp. when the initial yield was in the 2-3% range).

    Best Wishes,
    D4L

  3. Plan Your Escape December 2, 2007 4:23 pm

    Yes, very nice! The part that is really exciting is the original dividend at $46 and the recent ones at $100 … over %100 increase in dividend income! Wow. Great job!

    Peter

  4. Weekend Linkage - December 2, 2007 | The Sun’s Financial Diary | A Personal Finance Blog on Saving and Investing December 2, 2007 9:29 pm

    […] The Dividend Guy at The Dividend Guy Blog watched his dividend payment grow year after year. […]

  5. 10KPortfolio December 3, 2007 4:17 pm

    Very nice dividend growth. Dividends seem to give an added value of satisfaction to stockholders.

  6. B December 10, 2007 4:39 pm

    I am new to your blog. As a fairly new investor/saver I like what you are doing, but what about taxes? I am assuming you have everything in RothIRA ?

  7. The Dividend Guy December 10, 2007 9:33 pm

    Hi B - I have most of my investments in a RRSP - which is a Canadian version of a Roth IRA. It is a tax deferred account.

  8. Carnival of Money Stories #38 | Cash Money Life December 11, 2007 6:35 am

    […] Dividend Guy presents Watching My Dividend Payments Grow Year After Year posted at The Dividend Guy Blog, saying, “Dividends are a powerful tool. The real power comes […]

  9. Carnival of Money Stories #37 and #38 « Carnival of Money Stories - Read About Personal Finance December 14, 2007 2:11 pm

    […] The Divident Guy gives us Watching My Dividend Payment Grow Year After Year. […]

  10. Advidespose January 13, 2008 12:11 am

    on this subject ,. alloy employees credit union
    australian carbon credit purchasing
    , this the most good site

  11. Cellardoor April 2, 2008 8:39 am

    Screen shot looks cool. Any chance you will make the template available for download? :-)

POST A COMMENT

If you would like to make a comment, please fill out the form below.

Name - (Required)

Email - (Required but not published)

Website - (Optional)

ENTER YOUR COMMENTS BELOW






Student Loan

www.financialwebring.com