Question

Find the percentage standard deviation of security A’s returns based on the following information: Not using...

Find the percentage standard deviation of security A’s returns based on the following information: Not using Excel

Year

Return

1

16%

2

38%

3

21%

4

(18)%

5

8%

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans 18.35%

YEAR RETURN (X -Average Return of X)^2
1 16 9.000000
2 38 625.000000
3 21 64.000000
4 -18 961.000000
5 8 25.000000
Total 65 1684.000000
Average Return = Total Return / NO of years
65 / 5
13.00
Variance = sum of (X -Average Return of X)^2 / no of years
1684 / 5
336.80
Standard Deviation = Square root of Variance
Square root of 336.80
18.35
Add a comment
Know the answer?
Add Answer to:
Find the percentage standard deviation of security A’s returns based on the following information: Not using...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • What is the expected standard deviation of stock A’s returns based on the information presented in...

    What is the expected standard deviation of stock A’s returns based on the information presented in the table? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098. Note that figures in the table are presented in decimal format, not as percentages. What is the expected standard deviation of stock A's returns based on the information presented in the table? Answer as a rate in decimal format so...

  • What is the expected standard deviation of stock A’s returns based on the information presented in...

    What is the expected standard deviation of stock A’s returns based on the information presented in the table? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098. Note that figures in the table are presented in decimal format, not as percentages. Outcome Probability of outcome Stock A return in outcome Good 0.3 0.7 Medium 0.5 0.1 Bad ? -0.1

  • What is the expected standard deviation of stock A’s returns based on the information presented in...

    What is the expected standard deviation of stock A’s returns based on the information presented in the table? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098. Note that figures in the table are presented in decimal format, not as percentages. Outcome Probability of outcome Stock A return in outcome Good 0.3 0.4 Medium 0.4 0.1 Bad ? -0.4 Rogelio’s portfolio is worth 73,600 dollars and has...

  • The higher the standard deviation of returns on a security, the _____ the expected rate of...

    The higher the standard deviation of returns on a security, the _____ the expected rate of return and the _____ the risk. 1) higher; lower 2) lower; lower 3) lower; higher 4) You cannot determine anything about the expected rate of return from the standard deviation. 5) higher; higher

  • Use the following information to answer the question below Analysts Estimated Return Standard Deviation 8% Security...

    Use the following information to answer the question below Analysts Estimated Return Standard Deviation 8% Security Beta 9.0% 1.1 10.0% 14% 16% 0.8 1.3 16.4% Risk Free Rate 2%; and Expected Return of Market 12% Based on CAPM, which security has the highest expected return? Security A Security B Security C They all have the same expected return Not enough information to answer the question. |CAC Use the following information to answer the question below Analysts' Estimated Return Standard Security...

  • a. Calculate the expected return for each security. b. Calculate the standard deviation of returns for...

    a. Calculate the expected return for each security. b. Calculate the standard deviation of returns for each security. c. Compare Stock A with Stocks B and C. Is Stock A preferred over the others? d. Using your result in parts a and b, compute the following probabilities:  Stock A makes a return more than 18.9%  Stock B makes a return less than 1.3%  Stock C makes a return between 6.1% and 16.1% 2) You are considering the...

  • NEED EXCEL SOLUTION PLEASE: (EXCEL FORMULA) Suppose we have the following returns for the market and...

    NEED EXCEL SOLUTION PLEASE: (EXCEL FORMULA) Suppose we have the following returns for the market and a stock: Year Market return Stock return 1 18% 7% 2 27% 25% 3 5% 21% 4 13% 4% 5 -17% -16% 6 6% 19% 7 -21% -38% 8 34% 29% 9 19% 15% 10 11% 16% What is the covariance and correlation of the returns between this stock and the market? Covariance: Use Covar Function Correlation: Use Correl Function Beta: Use Slope Function...

  • 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 %     25 %     2 31         46         3 20         -13         4 -21         -27         5 22         54             Calculate the arithmetic average return for X.     Calculate the arithmetic average return for Y.    Calculate the variance for X.     Calculate the variance for Y.   ...

  • Stock A’s expected return and standard deviation are E[rA] = 8% and σA= 15%, while stock...

    Stock A’s expected return and standard deviation are E[rA] = 8% and σA= 15%, while stock B’s expected return and standard deviation are E[rB] = 12% and σB= 21%.  a. Determine the expected return and standard deviation of the return on a portfolio with weights wA=.35 and wB=.65 for the following alternative values of correlation between A and B: pAB=0.6 and pAB= -0.4. b. Assume now that pAB=-1.0 and find the portfolio p of stocks A and B that...

  • 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 10 % 21 % 2 28 42 3 17 -9 4 -18 -23 5 19 50 Requirement 1: (a) Calculate the arithmetic average return for X 14%, 9.07%, 13.66%, 11.20%, 12.66% b) Calculate the arithmetic average return for Y. 19.76%, 16.20%, 18.31%, 20.25%, 13.12% Requirement 2: (a) Calculate the variance for X. (Do not round intermediate...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT