Download the spreadsheet from My Finance Lab that contains historical monthly prices and dividends (paid at the end of the month) for Motor Company…

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadlines.


Order a Similar Paper Order a Different Paper

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

"Is this question part of your assignment? We can help"

ORDER NOW
Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper