Concept explainers
Calculating Returns and Variability Using the following returns, calculate the average returns, the variances, and the Standard deviations for X and Y:
Returns
Year | X | Y |
1 | 9% | 12% |
2 | 21 | 27 |
3 | –27 | –32 |
4 | 15 | 14 |
5 | 23 | 36 |
To determine: The average return, variance, and standard deviation
Introduction:
The term return refers to a profit or gain made on an investment that is usually expressed in terms of percentage or dollars. The percentage total return shows the overall performance and efficiency of the amount invested.
The average return is the average amount of money made by a particular investment. The variance determines the variances among the yearly returns of the stock. The standard deviation is simply the square root of calculated variance that measures the volatility of an investment.
Answer to Problem 7QP
Solution: The average return for stock X is 8.20% and the average return for stock Y is 11.40%. The variance for X is 0.04172 and the variance for Y is 0.06848. The standard deviation for X is 20.43% and the standard deviation for Y is 26.17%
Explanation of Solution
Given information:
The returns for X are 9%, 21%, -27%, 15%, and 23%. The returns for Y are 12%, 27%, -32%, 14%, and 36%.
The formula to calculate the average return:
Compute the average return for X:
Hence, the average return of Stock X is 8.20%.
Compute the average return for Y:
Hence, the average return of Stock Y is 11.40%.
The formula to calculate the variance of each stock:
Where,
“T” refers to the total number of returns,
“R” refers to the return of each year,
“
Compute the variance of Stock X:
Hence, the variance for X is 0.04172.
Compute the variance of Stock Y:
Hence, the variance for Y is 0.06848.
The formula to calculate the standard deviation:
Compute the standard deviation of X:
Hence, the standard deviation for X is 20.43%.
Compute the standard deviation of Y:
Hence, the standard deviation for Y is 26.17%.
Want to see more full solutions like this?
Chapter 10 Solutions
CORPORATE FINANCE (LL)-W/ACCESS
- This variance is the difference involving spending more or using more than the standard amount. A. favorable variance B. unfavorable variance C. no variance D. variancearrow_forwardReturns Year X Y 1 16 % 20 % 2 19 31 3 10 15 4 – 8 – 17 5 10 21 Using the returns shown above, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. (Do not round intermediate calculations. Enter your average return and standard deviation as a percent rounded to 2 decimal places, e.g., 32.16, and round the variance to 5 decimal places, e.g., 32.16161.)arrow_forwardYear Returns X Y 1 11% 18% 2 25 26 3 11 10 4 −18 −23 5 10 17 Using the returns shown above, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. (Do not round intermediate calculations. Enter your average return and standard deviation answers as a percent rounded to 2 decimal places, e.g., 32.16, and round the variance answers to 5 decimal places, e.g., .16161.) X Y Average returns % % Variances Standard deviations % %arrow_forward
- Use the following returns for X and Y. Returns Year x y 1 21.8% 26.4% 2 -16.8 -3.8 3 9.8 28.4 4 19.6 -14.6 5 4.8 32.4 a. Calculate the average returns for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate the variances for X and Y. (Do not round intermediate calculations and round your answers to 6 decimal places, e.g., 32.161616.) c. Calculate the standard deviations for X and Y. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)arrow_forwardPlease include excel formula Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Input area: Year X Y 1 13% 27% 2 26% 36% 3 7% 11% 4 -5% -29% 5 11% 16% (Use cells A6 to C11 from the given information to complete this question. You must use the built-in Excel function to answers this question. Make sure to use the “sample” Excel formulas.) Output area: Asset X: Average return Variance Standard deviation Asset Y: Average return Variance Standard deviationarrow_forward10.7 Calculating Returns and Variability Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y: Returns Year X Y 1 12% 14% 2 24 29 3 -27 -33 4 14 17 5 19 37arrow_forward
- An investor experiences the following 5 annual returns. Calculate the sample variance of these returns. Write down the sample standard deviation, leaving your answer under the radical symbol. A)2% B)-3% C)-3% D)-2% E)1%arrow_forwardCalculate the range, the expected rate of return, the variance, and the standard deviation for the problem below: Economic Condition Probability Expected Return Better than expected 0.15 0.65 Good 0.25 0.3 Average 0.45 0.15 Poor 0.1 -0.15 Terrible 0.05 -0.35arrow_forwardPlease provide answers in excel with formulas. Calculate the following variances and indicate whether each variance is favorable or unfavorable: 1.5. Volume Variance1.6. Total Variancearrow_forward
- Consider two assets with expected return R1=0.22,R2=0.55and variance are s1=0.80, s2=0.88 and r12=0.55 respectively.A portifolio with weights W1=0.25 and W2= 0.65 is formed calculate the expected return and variance of the portifolioarrow_forwardWhat is the sample variance and standard deviation for x =23,17, 15, 30, 25.arrow_forwardWhat is the variance and standard deviation of 10%, (15%), 25%, 17%, 3% ?arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College