Tracking Dividend Payments and My Yield

Written by The Dividend Guy on December 5, 2006

I like to keep track of the reinvested dividends that I receive from my dividend paying stocks. It is a good reminder to me of the power of compounding and the effect that has on my portfolio. Although I use Microsoft Money to track my overall portfolio, I use Excel to keep a better tab on what happens with the dividend reinvestment.

Here is how I have it set up:

Home Depot Dividend Reinvestment

I basically record the number of shares purchased and the price it was purchased at to get at the total transaction cost. Add up the number of shares and the total transaction costs and divide and you get the average share price you have purchased your shares at. With this number I can then see the effect my purchases have had on the dividend yield my shares are throwing off:

Home Depot Dividend Yield

As you can see, when I originally bought Home Depot in 2004 I was receiving a yield of 0.78%. Now, after all my dividend reinvestments and with the dividend increases that Home Depot has provided, the yield I am receiving from Home Depot is 2.49%. This continues to go up as I by more shares and the company increases its dividend.

Now I am not saying this is all mathematically correct from a true yield on investment perspective. It is just a way that I like to gauge how my portfolio is doing based on my goal: to receive as much dividend income as possible from my portfolio.


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|

5 Comments so far

  1. Latest Finance News » History » Tracking Dividend Payments and My Yield December 5, 2006 9:47 pm

    […] Original post by The Dividend Guy […]

  2. Marshall Middle December 6, 2006 10:33 am

    I know an older gentleman that brings in about $1400 dollars a month, all from dividends. He is the one who first got me interested in the stock market and investing. It seems like you have a good plan and are well on your way to becoming passively wealthy.

  3. kirkwalsh.com » Blog Archive » The Carnival of Personal Finance December 10, 2006 2:11 pm

    […] The Dividend Guy presents Tracking Dividend Payments and My Yield posted at The Dividend Guy Blog. […]

  4. The Dividend Guy Blog - One Guy’s Journey to Passive Income Through Dividend Investing » Yearly Dividend Income Update December 16, 2006 10:35 am

    […] Tracking Dividend Payments and My Yield […]

  5. The Financial Flow » Putting Together an Estate Plan January 12, 2007 7:35 am

    […] Tracking Dividend Payments and My Yield I like to keep track of the reinvested dividends that I receive from my dividend paying stocks. It is a good reminder to me of the power of compounding and the effect that has on my portfolio. Although I use Microsoft Money to track my overall portfolio, I use Excel to keep a [.] (more) […]

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