how do you calculate "dividend yield using Excel?

[Dennis]

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

[cvolkert]

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