Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer A & B- % round two decimal places. Using the data shown in the table here, , that contains historical monthly prices and

image text in transcribed

Please answer A & B- % round two decimal places.

image text in transcribedimage text in transcribedimage text in transcribed Using the data shown in the table here, , 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 August 1998, compute the: a. Average monthly return over this period. b. Monthly volatility (or standard deviation) over this period. Data table (Click on the following icon in order to copy its contents into a spreadsheet.) May-96Jun-96Jul-96Aug-96Sep-96Oct-96Nov-96Dec-96Jan-97Feb-97Mar-97Apr-97May-97Jun-97Jul-97Aug-97Sep-97Oct-97Nov-97Dec-97Jan-98Feb-98Mar-98Apr-98May-98$36.500$32.375$32.375$33.500$31.250$31.250$32.750$32.250$32.125$32.875$31.375$34.750$37.500$38.000$40.875$43.000$45.125$43.688$43.000$48.563$51.000$56.563$64.813$45.813$51.875$0.000$0.000$0.385$0.000$0.000$0.385$0.000$0.000$0.385$0.000$0.000$0.420$0.000$0.000$0.420$0.000$0.000$0.420$0.000$0.000$0.420$0.000$0.000$23.680$0.0001.74%11.30%1.19%3.47%6.72%1.23%4.80%1.53%0.81%2.33%4.56%12.10%7.91%1.33%8.67%5.20%4.94%2.25%1.57%12.94%5.88%10.91%14.59%7.22%13.23%1.0170.8871.0121.0350.9331.0121.0480.9851.0081.0230.9541.1211.0791.0131.0871.0521.0490.9770.9841.1291.0591.1091.1461.0721.132 \begin{tabular}{cccrc} May-98 & $51.875 & $0.000 & 13.23% & 1.132 \\ Jun-98 & $59.000 & $0.000 & 13.73% & 1.137 \\ Jul-98 & $57.000 & $0.420 & 2.68% & 0.973 \\ Aug-98 & $44.625 & $0.000 & 21.71% & 0.783 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions