1. Calculating Yields Download the historical monthly share prices for Alcatel-Lucent from Yahoo! Finance. Find the closing share price for yesterday and for exactly 2 years ago.
The dividends should also be listed in the monthly price series. What was the capital gains yield and dividend yield for Alcatel-Lucent equity for each of these years? Now calculate the capital gains yield and dividend yield for Alstom, the French design and infrastructure construction firm. How do the returns for these two companies compare?

2. Calculating Average Returns Download the Monthly Adjusted Prices for Deutsche Telekom AG. What is the return on the equity 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 Deutsche Telekom’s shares over the past year?