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
Eliteprofessionalwriters.com is an international company that helps freelancers find the work they need while giving our clients the best choice of people to finish their projects. Our goal is simple – to match skilled writers with people who need the best on the market.