May 13 2009

Tracking Your Dividend Income


dividend-income

For those of you long-standing dividend investors you probably have a method to track the growth in your dividend income. However, for those of you who may be new to dividend investing or perhaps have a number of dividend stocks but have never set up a method to track this income then this post may help you. I have personally been tracking my dividend income for years and find that it is a powerful way to see my investment strategy at work.[ad#tdg-embedded]

The method I use is super simple. An investor can get as complicated as they really want to get, however I have found simply tracking the income my entire portfolio throws off to be enough. One thing to mention, is that I personally track the income I receive from all my portfolio assets, not just the dividend stocks. This gives me a true picture of the income from all assets including bonds which can be substantial.

In the Google Doc below, the sheet has only a few inputs that are required. The first is a listing of the assets you hold. The second is the average cost of that asset. How you get this depends on how you track your portfolio. If you use Microsoft Money then it is provided for you – simply enter that number in this row. If you don’t have an average cost then just use your original buy price, but remember your current yield will not be as accurate. Now enter the number of shares of that asset you hold. The next piece of data is the dividend per year for that asset. I just go to a financial site such as Morningstar.com and get the dividend/year for each asset from there and enter it into the sheet. With that data, the spreadsheet does the rest and calculates the income from that asset as well as the income from your entire account.

To download the spreadsheet, use this LINK. Feel free to play around with this spreadsheet to improve it – just be sure to let us all know what things you have done to improve it so we can all learn.

(Photo Credit)


TAGS:

8 Comments on this post

Trackbacks

  1. Weekly Blog Review - End of Rally Edition | Financial Highway wrote:

    [...] 3.The Dividend Blog Guy provides us with a simple way of tracking our dividend income [...]

    May 14th, 2009 at 11:15 pm
  2. Kvartalsutdelningar – JA TACK! « FuckPeace.Net wrote:

    [...] enkelt diagram i Excel och på det sättet följer jag den totala utdelningen. Fick tipset från, Tracking Your Dividend Income, av The Dividend Guy. Den enda diagramet som inte går ner, utan det enda riktningen den följer [...]

    August 28th, 2009 at 7:22 pm
  1. raionz said:

    Hey, when I try to click on the LINK for the spreadsheet it tells me I need permission?

    Thanks

    May 13th, 2009 at 8:09 am
  2. Joel said:

    Great article.

    I’m still confused as to how we get the “Avg Price”… Can you just calculate it by taking the number of total shares divided by the total cost? If this indeed the Avg Price, then how does Microsoft Money provide this data, since everyone’s Avg Price would be different.

    May 13th, 2009 at 6:19 pm
  3. Dividend Growth Investor said:

    That’s a nice and inspirin chart TDG. However, is the growth due to contributions or solely due to dividend growth and dividend re-investment?

    May 14th, 2009 at 11:36 am
  4. Larry Mong said:

    Dividend Guy,
    I’m a retired 75-1/2 yr old public, corporate accountant.I’ll drop all the titles. I viewed your video in its entirety. I can see numerous applications with Google Doc’s and in my previous profession but that’s
    in my rear-view mirror / history!
    My problem: I have ONLY One interest / Objective!
    Book / Record my stock purchases, shares, share purchase price, and the Mo, Qtly , Annual Dividends and Monitor / track throughout the year. Your video didn’t demonstrate any of this scenario.
    I’m questioning whether your website is the right fit for me and what I’m trying to accomplish.
    Your initial information and description got my attention but now I’m having second thoughts. Your initial spreadsheet dividend explaination was right on target for what I wanted to accomplish but Now I’m not sure. From your perspective I have a very Narrow
    Interest and Usage…That’s it!
    Any further clarification ?
    Larry Mong

    March 30th, 2010 at 12:53 am
  5. The Dividend Guy said:

    Hi Larry – which video are you referring to. I have never done a video?

    March 30th, 2010 at 11:44 am
  6. Matthew said:

    this is exactly what i need, but cannot save it, or the link.
    do i open it and then save it, or am i supposed to save the link?

    August 2nd, 2010 at 7: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.