how do you calculate "dividend yield using Excel?
 

Can you calculate "dividend yield using Excel? If so, how?

There are a couple different approaches to dividend yields. The most
straight forward and simple is just dividing the annual dividend for a
company by the current stock price. This would be a simple division
issue. It can also be calculated over some period by using the
dividends over that period divided by either the beginning (typical) or
average during that period and then annualizing. Don't think you need
any special function here, but if you are doing the second method
above, you can actually use the Yield function assuming a constant
dividend rate. Hope this helps - Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=380448