Question

In: Finance

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.

Solutions

Expert Solution

ANSWERS ARE GIVEN IN DECIMALS AND % (BOTH FORMAT). ROUNDED TO 4 DECIMALS. THANK YOU.

EXCEL FORMULAS ARE ALSO SPECIFIED. NEED ANY OTHER HELP. HAPPY TO HELP YOU


Related Solutions

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.
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