Answered You can hire a professional tutor to get the answer.
Download the spreadsheet from My Finance Lab that contains historical monthly prices and dividends (paid at the end of the month) for Motor Company...
10. Download the spreadsheet from My Finance Lab that contains historical monthly prices and dividends (paid at the end of the month) for Motor Company Stock (Ticker: F) from August 1994 to August 1998. Calculate the realized return over this period, expressing your answer in percent per month.This is the Spreadsheet from My Finance LabAug-9429.25 Sep-9427.75 Oct-9429.500.260Nov-9427.13 Dec-9427.88 Jan-9525.250.260Feb-9526.13 Mar-9526.88 Apr-9527.130.310May-9529.25 Jun-9529.75 Jul-9529.000.310Aug-9530.75 Sep-9531.13 Oct-9528.750.350Nov-9528.25 Dec-9528.88 Jan-9629.500.350Feb-9631.25 Mar-9634.38 Apr-9635.880.350May-9636.50 Jun-9632.38 Jul-9632.380.385Aug-9633.50 Sep-9631.25 Oct-9631.250.385Nov-9632.75 Dec-9632.25 Jan-9732.130.385Feb-9732.88 Mar-9731.38 Apr-9734.750.420May-9737.50 Jun-9738.00 Jul-9740.880.420Aug-9743.00 Sep-9745.13 Oct-9743.690.420Nov-9743.00 Dec-9748.56 Jan-9851.000.420Feb-9856.56 Mar-9864.81 Apr-9845.8121.515May-9851.88 Jun-9859.00 Jul-9857.000.420Aug-9844.63 11. Using the same data in problem 10 compute the (A) average monthly return over this period (b) Monthly volatility (or standard deviation) over this period.12: Explain the difference between the average return you calculated in Problem 11(a) and the real-ized return you calculated in Problem 10. Are both numbers useful? If so explain why. Note: we are only solving Problem 12, but we need to solve 10 and 11 in order to solve 12
