Walmart Share Profit Calculation - Where am I going wrong?

Awol

I was trying to calculate the total return on shares in supermarkets, i put together a spreadsheet to calculate profit and loss.

Everything seemed to be fine until i calculated the returns from investing $1,000 in Walmart in 2006 until the present day. i have checked my calculations but they claim an almost $20,000 return?

Can this be correct? Have they really performed that well?

Tallying up the dividends alone they have paid out nearly $9 a share since 2006 (at the time $1000 bought 2.2k shares) :shocked:

Hazzanet

Looking at the share price on 01/09/2006, it was at $42.28; and at 03/09/2013 it was $72.59.

$42.28 should have bought 23.65 shares, selling at $72.59 would have gained $716.89, less broker fees etc.

Source: http://uk.finance.yahoo.com/q/hp?s=WMT&a=08&b=8&c=2005&d=08&e=7&f=2013&g=m&z=66&y=0

Not sure about the dividends etc.

Hazzanet

Awol wrote: »

share since 2006 (at the time $1000 bought 2.2k shares) :shocked:

The price is quoted in Dollars, not Cents; is that where you've gone wrong?

Hazzanet

Awol wrote: »

they have paid out nearly $9 a share since 2006

Not what I was getting on $250 of shares in 2006:

Awol

Hazzanet wrote: »

The price is quoted in Dollars, not Cents; is that where you've gone wrong?

Indeed, thanks for that. :embarasse