1) The following table provides month end prices and cash dividends from Exxon Mobil (XOM) for a recent two year period. Use these data to complete the following analyses.
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.© BrainMass Inc. brainmass.com July 17, 2018, 12:26 am ad1c9bdddf
Calculates holding period return, arithmetic mean, standard deviation, geometric mean of returns etc.