Question

In: Finance

Consider the following five monthly​ returns: 5​%   −2​% 4​% 8​% −1​% a. Calculate the arithmetic average...

Consider the following five monthly​ returns:

5​%  

−2​%

4​%

8​%

−1​%

a. Calculate the arithmetic average monthly return over this period and express your answer as a percentage per month.

b. Calculate the geometric average monthly return over this period.

c. Calculate the monthly variance over this period.

d. Calculate the monthly standard deviation over this period.

Solutions

Expert Solution

a.

Arithmetic average monthly return over this period is calculated in excel and screen shot provided below:

arithmetic average monthly return over this period is 2.50%.

b.

Geometric average monthly return over this period is calculated in excel and screen shot provided below:

Geometric average monthly return over this period is 2.42%.

c.

Monthly variance over this period is calculated in excel and screen shot provided below:

monthly variance over this period is 0.23%.

d.

Monthly standard deviation over this period is calculated in excel and screen shot provided below:

monthly standard deviation over this period is 4.80%.


Related Solutions

Consider the following five monthly​ returns: 0.07 0.00 0.06 0.1 0.01 a. Calculate the arithmetic average...
Consider the following five monthly​ returns: 0.07 0.00 0.06 0.1 0.01 a. Calculate the arithmetic average monthly return over this period. b. Calculate the geometric average monthly return over this period. c. Calculate the monthly variance over this period. d. Calculate the monthly standard deviation over this period.
Consider the following five monthly returns. The arithmetic average monthly return over this period is 3.40​%...
Consider the following five monthly returns. The arithmetic average monthly return over this period is 3.40​% and the geometric average monthly return over this period is 3.30​%. Explain the difference between the arithmetic average return and the geometric average return. Are both numbers​ useful? If​ so, explain​ why? 6​% negative 3​% 7​% 8​% negative 1​% Choose the correct answer below. A. The arithmetic average return is the best estimate of what you would earn in the​ future, so this is...
Using the following returns, calculate the arithmetic average returns, the standard deviations, and the geometric average...
Using the following returns, calculate the arithmetic average returns, the standard deviations, and the geometric average returns for the stock A, B, and C. Assume the returns of stocks are normally distributed. If Mr. Wong owns a stock C, based on the historical return data, there is only a 2.5 percent chance that the stock C will produce a return less than _____ percent in any one year.   If Mr. Wong owns a stock B, which range of returns would...
Using the following returns, calculate the arithmetic average returns, the standard deviations, and the geometric average...
Using the following returns, calculate the arithmetic average returns, the standard deviations, and the geometric average returns for the stock A, B, and C. Assume the returns of stocks are normally distributed. If Mr. WENG owns a stock C, based on the historical return data, there is only a 2.5 percent chance that the stock C will produce a return less than _____ percent in any one year.   If Mr. WENG owns a stock B, which range of returns would...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year X Y 1 11 % 23 % 2 29 44 3 18 -11 4 -19 -25 5 20 52 Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.    Returns Year X Y 1 11 %     23 %     2 29         44         3 18         -11...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year X Y 1 11 % 23 % 2 29 44 3 18 -11 4 -19 -25 5 20 52 Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.    Returns Year X Y 1 11 %     23 %     2 29         44         3 18         -11...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.    Returns Year X Y 1 15 %     22 %     2 33         43         3 22         -9         4 -23         -23         5 24         51    Calculate the arithmetic average return for X.     Calculate the arithmetic average return for Y.    Calculate the variance for X.     Calculate the variance for Y.    Calculate...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year X Y 1 11 % 20 % 2 29 41 3 18 -12 4 -19 -26 5 20 49 Requirement 1: (a) Calculate the arithmetic average return for X. (b) Calculate the arithmetic average return for Y. Requirement 2: (a) Calculate the variance for X. (Do not round intermediate calculations.) (b) Calculate the variance for Y. (Do not round...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.    Returns Year X Y 1 11 %     20 %     2 29         41         3 18         -12         4 -19         -26         5 20         49             Requirement 1: (a) Calculate the arithmetic average return for X.     (b) Calculate the arithmetic average return for Y.    Requirement 2: (a) Calculate the variance for X....
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year X Y 1   13% 23% 2   31      44   3   20     -10 4 - 21   - 24 5   22      52
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT