Date Price Dividend
Nov-06 76.81 0.32
Aug-06 67.67 0.32
May-06 60.91 0.32
Feb-06 59.37 0.32
Nov-05 58.03 0.29
Aug-05 59.9 0.29
May-05 56.2 0.29
Feb-05 63.31 0.27
a) Find the holding period return for each month.
b) Calculate the arithmetic mean return and standard deviation. Annualize the arithmetic mean and standard deviation (to annualize the monthly standard deviation multiply it by the square root of 12).
c) Calculate the geometric mean. Why is the geometric mean less than the arithmetic mean?
d) If you begin with the year with $10,000 invested in Exxon Mobil, how much would the investment be worth at the end of the two year period? Allow fractional shares and assume you reinvest your dividends in additional shares of XOM.
Please see attached file. Only qn 1 from the attachment is to be answered.
Calculates holding period return, arithmetic mean, standard deviation, geometric mean of returns etc.