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 Newest Book - and see a mention of The Dividend Guy

My Broker

Keep Up-to-Date

twitter1gif
newspaper_feed_128x128

Quality Stock Advice

Top 20 Recommended Books

book_banner

The Dividend Guy Sponsors

The Div-Net

Investment Links

Online Dividend Calendar

Friends of The Dividend Guy

Emergency Cash

Loan Insurance

cheap auto insurance

payday loans

Apply online anytime from your own home for payday loans with us

Payday Loans

gold coins

Direct Buy Visitors Pass

debt

A solid Debt Consolidation Resource

Free Credit Report on the web

Get the top savings rates and latest finance news at GoBankingRates.

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

Stress free UK payday loan, solution to pay unexpected monthly bills.

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

No credit check, instant UK Payday Loans with cash paid into your account the same day.

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

Check out a FHA Refinancing for you current home loan or look into a FHA Loan for your next purchase

Thrifty Mortgages provides expert advice and help on all types of mortgages and remortgages. Choose from over 8000 home loan products.

Receive instant approval for a cash advance up to £750. Get a UK payday loan to pay unexpected monthly expenses.

Mortgage Insurance

Click here for information on available Credit Cards

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

Featured Link

Virtual Offices

Looking for a virtual office? Choose from 150 prime business addresses across the UK and 1000 across the world. Use Regus Virtual Offices to project a great business image, access facilities and support, and keep overheads down.

Serviced Offices

Looking for office space? Choose from 150 business centres across the UK and 1000 across the world. Low cost, fully furnished and equipped serviced offices, designed to suit individuals to larger groups with flexible terms.

Meeting Rooms

Planning a meeting? Choose from 4,000 meeting rooms in 75 countries. Fully equipped quality facilities in great venues. Get immediate availability, pricing and instant booking confirmation via our real-time online booking system.

Best Office Rates Guaranteed

Additional Sponsors

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.