how do you calculate "dividend yield using Excel?

C

cvolkert

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top