Calculating Yields Download the historical stock prices for Duke Energy (DUK) under the "Mthly. Adj. Prices" link. Find the closing stock price for the beginning and end of the prior two years. Now use the annual financial statements to find the dividend for each of these years. What was the capital gains yield and dividend yield for Duke Energy stock for each of these years? Now calculate the capital gains yield and dividend yield for Abercrombie & Fitch (ANF). How do the returns for these two companies compare?
Calculating Average Returns Download the Monthly Adjusted Prices for Microsoft (MSFT). What is the return on the stock over the past 12 months? Now use the 1 Month Total Return and calculate the average monthly return. Is this one-twelfth of the annual return you calculated? Why or why not? What is the monthly standard deviation of Microsoft's stock over the past year?
