The following is market data as of the close of each year for the shares of...

Transcribed Image Text:

The following is market data as of the close of each year for the shares of General Motors (GM) and Microsoft (MSFT). Date Dec 29, 1989 Dec 31 1990 Dec 31 1991 Dec 31 1992 Dec 31 1993 Dec 30 1994 Dec 29 1995 Dec 31 1996 Dec 31 1997 Dec 31 1998 Dec 31 1999 GM Closing Price US$ 42.3 37.4 30.5 33.7 55.7 42.9 54.0 57.4 66.3 73.6 86.8 Métrics Average return Variance of returns Standar Deviation of returns Returns Covariance Returns Correlation Dividend US$ 3.0 1.6 1.4 0.8 0.8 1.1 1.6 5.6 2.0 14.2 According to the data shown, the following is requested: a) Complete following table: GM Closing Price 1.2 2.1 4.6 5.3 5.0 7.6 11.0 20.7 32.3 69.3 116.8 MSFT MSFT Dividend US$ Help: If you notice, there are no scenario probabilities here. Therefore, conventional statistical formulas should be used to use historical data to fill in the blanks. The following is market data as of the close of each year for the shares of General Motors (GM) and Microsoft (MSFT). Date Dec 29, 1989 Dec 31 1990 Dec 31 1991 Dec 31 1992 Dec 31 1993 Dec 30 1994 Dec 29 1995 Dec 31 1996 Dec 31 1997 Dec 31 1998 Dec 31 1999 GM Closing Price US$ 42.3 37.4 30.5 33.7 55.7 42.9 54.0 57.4 66.3 73.6 86.8 Métrics Average return Variance of returns Standar Deviation of returns Returns Covariance Returns Correlation Dividend US$ 3.0 1.6 1.4 0.8 0.8 1.1 1.6 5.6 2.0 14.2 According to the data shown, the following is requested: a) Complete following table: GM Closing Price 1.2 2.1 4.6 5.3 5.0 7.6 11.0 20.7 32.3 69.3 116.8 MSFT MSFT Dividend US$ Help: If you notice, there are no scenario probabilities here. Therefore, conventional statistical formulas should be used to use historical data to fill in the blanks.

Answer rating: 100% (QA)

To calculate the requested metrics using the provided data well need to perform some calculations based on historical prices and dividends Step 1 Calculate Annual Returns To calculate the annual retur... View the full answer