Dec 5 2006

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 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.


TAGS:

5 Comments on this post

Trackbacks

  1. Latest Finance News » History » Tracking Dividend Payments and My Yield wrote:

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

    December 5th, 2006 at 9:47 pm
  2. kirkwalsh.com » Blog Archive » The Carnival of Personal Finance wrote:

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

    December 10th, 2006 at 2:11 pm
  3. The Dividend Guy Blog - One Guy’s Journey to Passive Income Through Dividend Investing » Yearly Dividend Income Update wrote:

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

    December 16th, 2006 at 10:35 am
  4. The Financial Flow » Putting Together an Estate Plan wrote:

    [...] 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) [...]

    January 12th, 2007 at 7:35 am
  1. Marshall Middle said:

    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.

    December 6th, 2006 at 10:33 am

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Recommended Book

Read Rob Carrick's 's Book - an author that has mentionned this blog in the past

My Broker

Questrade
Democratic Pricing - 1 cent per share, $4.95 min / $9.95 max

Keep Up-to-Date

twitter1gif
newspaper_feed_128x128

The Dividend Guy Sponsors

The Div-Net

Investment Links

Online Dividend Calendar

Friends of The Dividend Guy



Provident Loans

Invoice Discounting - Hitachi

credit cards

Need emergency cash and can't wait for your paycheck, get a payday loan and have the funds transferred overnight

Mortgage Brokers at Savills Private Finance

Debt Management

Personal Bad Credit Loans for every need and budget.

Get Out of Debt

Emergency Cash

Loan Insurance Claim from Keypoint

payday loans

Borrow payday loans UK online and receive up to £500 for your next payday loan

The Bettertrades stock reviews , online discussion forums and trading software can help trader earn rich dividends from stock market.

Bankruptcy is a serious measure - seek expert debt advice on various debt solutions available.

Networks

Seeking Alpha Certified


Money Hackers Network

Get Out of debt

If you're stuck in debt and trying to get caught up, don't resort to payday loans. They almost always have high interest rates, so if you don't pay them back immediately you will just end up in even more debt. In these tough times, it's better just to learn how to be more frugal with your money.

Twitter Posts

Powered by Twitter Tools

Disclaimer

Any information shared on The Dividend Guy does not constitute financial advice. The Dividend Guy is not a registered investment advisor or broker-dealer and does not purport to tell or suggest which securities readers or customers should buy or sell for themselves. The Website is intended to provide general information only and does not attempt to give you advice that relates to your specific circumstances. You are advised to discuss your specific requirements with an independent financial adviser. For more information, click here. All posts are © 2005-2009, The Dividend Guy.