Question: Using the data shown in the table here, LOADING... , that contains historical monthly prices and dividends ( paid at the end of the month

Using the data shown in the table here, LOADING..., that contains historical monthly prices and dividends(paid at the end of the month) for Ford Motor Company stock(Ticker: F) from August 1994 to August1998, compute the:
a. Average monthly return over this period.
b. Monthly volatility(or standard deviation) over this period. THIS IS THE DATA "Date Stock Price Dividend Return 1+Rt
Aug-94 $29.250 $0.000
Sep-94 $27.750 $0.000-5.13%0.949
Oct-94 $29.500 $0.2607.24%1.072
Nov-94 $27.125 $0.000-8.05%0.919
Dec-94 $27.875 $0.0002.76%1.028
Jan-95 $25.250 $0.260-8.48%0.915
Feb-95 $26.125 $0.0003.47%1.035
Mar-95 $26.875 $0.0002.87%1.029
Apr-95 $27.125 $0.3102.08%1.021
May-95 $29.250 $0.0007.83%1.078
Jun-95 $29.750 $0.0001.71%1.017
Jul-95 $29.000 $0.310-1.48%0.985
Aug-95 $30.750 $0.0006.03%1.060
Sep-95 $31.125 $0.0001.22%1.012
Oct-95 $28.750 $0.350-6.51%0.935
Nov-95 $28.250 $0.000-1.74%0.983
Dec-95 $28.875 $0.0002.21%1.022
Jan-96 $29.500 $0.3503.38%1.034
Feb-96 $31.250 $0.0005.93%1.059
Mar-96 $34.375 $0.00010.00%1.100
Apr-96 $35.875 $0.3505.38%1.054
May-96 $36.500 $0.0001.74%1.017
Jun-96 $32.375 $0.000-11.30%0.887
Jul-96 $32.375 $0.3851.19%1.012
Aug-96 $33.500 $0.0003.47%1.035
Sep-96 $31.250 $0.000-6.72%0.933
Oct-96 $31.250 $0.3851.23%1.012
Nov-96 $32.750 $0.0004.80%1.048
Dec-96 $32.250 $0.000-1.53%0.985
Jan-97 $32.125 $0.3850.81%1.008
Feb-97 $32.875 $0.0002.33%1.023
Mar-97 $31.375 $0.000-4.56%0.954
Apr-97 $34.750 $0.42012.10%1.121
May-97 $37.500 $0.0007.91%1.079
Jun-97 $38.000 $0.0001.33%1.013
Jul-97 $40.875 $0.4208.67%1.087
Aug-97 $43.000 $0.0005.20%1.052
Sep-97 $45.125 $0.0004.94%1.049
Oct-97 $43.688 $0.420-2.25%0.977
Nov-97 $43.000 $0.000-1.57%0.984
Dec-97 $48.563 $0.00012.94%1.129
Jan-98 $51.000 $0.4205.88%1.059
Feb-98 $56.563 $0.00010.91%1.109
Mar-98 $64.813 $0.00014.59%1.146
Apr-98 $45.813 $23.6807.22%1.072
May-98 $51.875 $0.00013.23%1.132
Jun-98 $59.000 $0.00013.73%1.137
Jul-98 $57.000 $0.420-2.68%0.973
Aug-98 $44.625 $0.000-21.71%0.783"

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!