Using excel formula
| X | Y | ||
| Year | Project X | Project Y | |
| 1 | 20X0 | 13% | 17% |
| 2 | 20X1 | 24% | 18% |
| 3 | 20X2 | 18% | 14% |
| 4 | 20X3 | 14% | 21% |
| 5 | 20X4 | 12% | 22% |
| Average annual rate of return on | 17.25% | 17.50% | |
| Using excel formula | Average(A1:A5) | Average(B1:B5) | |
| Standard Deviation | 4.92% | 3.21% | |
| Using excel formula | STDEV(A1:A5) | STDEV(B1:B5) |
c. Project X is more riskier
Problem 8-05 Two investments generated the following annual returns: Investment X Investment Y 20x0 13% 17...
Problem 8-05 Two investments generated the following annual returns: Investment x 13% Investment Y 24% 22 19 20x0 20X1 20x2 20x3 20X4 16 a. What is the average annual return on each investment? Round your answers to one decimal place. The average annual rate of return on X: The average annual rate of return on Y: b. What is the standard deviation of the return on investments X and Y? Round your answers to two decimal places. Standard deviation of...
Problem 1 (14 marks): Consider the following historical returns on two investments A and B. The average risk-free rate during the 2011-2015 period was equal to 3%. Annual return (%) Year Investment A Investment B 2015 5% -5% -2% 2014 -20% 15% 2013 30% 20% 2012 40% 2011 5% 10% a) Calculate the average return and the risk premium for each investment. Which investment is likely to be is riskier? Explain. (6 marks) b) Calculate the standard deviation for each...
1.
2.
A stock you are looking at has generated the following annual returns: 10.0%, -5.0% and 4.0%. What was the standard deviation of its returns? Answer in percent, rounded to two decimal places (e.g., 4.32% = 4.32). Numeric Answer: 11.66 You are incorrect 11.66 A stock has generated an annual average return of 8.0% with a standard deviation of 45.0% during the last 10 years. If the average risk-free rate was 1.6%, what was this stock's Sharpe Ratio? Round...
Consider the following returns for two investments, A and B, over the past four years: Investment 1: 4% 9% –8% 13% Investment 2: 15% 12% –14% 10% a-1. Calculate the mean for each investment. (Round your answers to 2 decimal places.) Mean Investment 1 % Investment 2 % a-2. Which investment provides the higher return? Investment 1 Investment 2 b-1. Calculate the standard deviation for each investment. (Round your answers to 2 decimal places.) Standard Deviation Investment 1 Investment...
a.
What is the average annual return on each investment?
b.
What is the standard deviation of the return on investments X and
Y?
c.
Based on the standard deviation, which investment was
riskier?
Investment X 10% 20 30 20 10 Investment Y 19X0 19X1 19X2 19X3 19X4 1696 18 15 20 21
1) A stock has generated an annual average return of 9.5% with a standard deviation of 40.7% during the last 10 years. If the average risk-free rate was 1.7%, what was this stock's Sharpe Ratio? Round to two decimal places. 2) The standard deviation of a stock's annual returns is 40.4%. The standard deviation of market returns is 24.3%. If the correlation between the returns of the stock and the market is 0.3, what is this stock's beta? Round to...
Use the following returns for X and Y. Returns Year X 21.4% -16.4 9.4 18.8 4.4 Y 25.2% - 3.4 27.2 – 13.8 31.2 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...
Consider the following returns for two investments, A and B, over the past four years: 9 10 78 98-16% 14% 158 Investment 1: Investment 2s a. Calculate the mean for each investment. (Round your answers to 2 decimal places.) Inve b. Calculate the standard deviation for each investment. (Round your answers to 2 decimal places.) Standard Deviation 2
Possible Returns Probability Investment Investment Y .05 -10% 0% 5% 5% 20% 16% 25 30% 24% .05 40% 32% Calculate the expected return and standard deviation for each investment. Find the standard deviation manually Upload your work to receive credit. Probability Returns .40 7% 4% 18% 10%
Use the following returns for X and Y. Returns 10 points Year vmtLO 22.2% - 17.2 10.2 20.4 5.2 27.6% - 4.2 29.6 - 15.4 33.6 eBook Print References 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.)...