Question

In: Finance

Here are returns and standard deviations for four investments. Return (%) Standard Deviation (%) Treasury bills...

Here are returns and standard deviations for four investments.

Return (%) Standard Deviation (%)
Treasury bills 5.0 0
Stock P 11.5 16
Stock Q 14.5 28
Stock R 24.0 27

Calculate the standard deviations of the following portfolios.

a. 50% in Treasury bills, 50% in stock P. (Enter your answer as a percent rounded to 2 decimal places.)

a.Standart Deviation:?%

b. 50% each in Q and R, assuming the shares have: (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.)

b.

Perfect positive correlation standart deviation:?%

Perfect negative correlation standart deviation:?%

No correlation standart deviation:?%

Solutions

Expert Solution

ANswer 1 Portfolio SD = 8

Portfolio Standard Deviation=

where Wa = Weight of stock a ; Wb = Weight of STock B; SDa = Standard deviation of stock A; SDb = Standard deviation of stock B; r = Correlation COefficient between a & b

The caclulation is shown in excel and formuals are given below:

Answer 2

a. when perfect positive correlation (1) SD == 27.5

b..when perfect negative correlation (-1) SD = 0.5

c. When no COrrelation (0) SD    = 19.45   


Related Solutions

RISK AND RETURN – (A) Consider the expected return and standard deviation of these four stocks...
RISK AND RETURN – (A) Consider the expected return and standard deviation of these four stocks (chart below). If investors are buying only one stock, which one of these stocks would no investor buy? Why? (PLEASE INCLUDE FORMULAS USED TO SOLVE PROBLEM FOR EXCEL). STOCK EXPECTED RETURN STANDARD DEVIATION A 6% 1% B 7% 1.5% C 7% 2% D 8% 2% ADDING AN ASSET TO A PORTFOLIO - (B) Your current portfolio's cash returns over the past three years look...
The (annual) expected return and standard deviation of returns for 2 assets are as follows:
  1. The (annual) expected return and standard deviation of returns for 2 assets are as follows: Asset A Asset B E[r] 10% 20% SD[r] 30% 50% The correlation between the returns is 0.15. a. Calculate the expected returns and standard deviations of the following portfolios: (i) 80% in A, 20% in B (ii) 50% in A, 50% in B (iii) 20% in A, 80% in B b. Find the weights for a portfolio with an expected return of 25%?...
Stock A has an expected return of 5%, and a standard deviation of returns of 10%....
Stock A has an expected return of 5%, and a standard deviation of returns of 10%. Stock B has an expected return of 15% and a standard deviation of returns of 20%. The correlation between the two stocks returns in 0.90. The standard deviation of an equally-weighted portfolio comprised of the two stocks will be: more than 15% None of the answers listed here. 15% less than 15%
Based on the following data; (a) calculate the expected return and the standard deviation of returns...
Based on the following data; (a) calculate the expected return and the standard deviation of returns for each stock. State of the Economy         Probability      Stock A Rate of Return   Stock B Rate of Return Recession                                  0.25                                 6%                                 -20% Normal Growth 0.45                                7%                                  13% Boom                                         0.3                                 11%                                   33%       (b) Calculate the expected return and the standard deviation on the portfolio, where the portfolio is formed by investing 65% of the funds in Stock A and the rest in Stock B
P13-7 Calculating Returns and Standard Deviations [LO1] Consider the following information Rate of Return if State...
P13-7 Calculating Returns and Standard Deviations [LO1] Consider the following information Rate of Return if State Occurs   State of Economy Probability of State of Economy Stock A Stock B   Recession 0.20 0.04 -0.19   Normal 0.70 0.08 0.14   Boom 0.10 0.13 0.33    Required: (a) Calculate the expected return for Stock A. (Do not round your intermediate calculations.) (Click to select)7.70% 7.85% 9.34% 10.03% 6.76%    (b) Calculate the expected return for Stock B. (Do not round your intermediate calculations.) (Click...
There is a security to invest. One-year Treasury bills are currently paying 2.9%. Calculate the following investment’s expected return and its standard deviation. Should you invest in it?
There is a security to invest. One-year Treasury bills are currently paying 2.9%. Calculate the following investment’s expected return and its standard deviation. Should you invest in it?Probability 0.15, 0.30 , 0.40 , 0.15Return -3% , 2% , 4%, 6%Your submission must include two parts:Showing clearly which EQUATIONS from the textbook could be used to solve the problem mathematicallyIndicating the detailed steps on how to use FINANCIAL CALCULATOR to solve the problems. You also need to let me know which...
Given the following historical returns, calculate the average return and the standard deviation Year Return 1...
Given the following historical returns, calculate the average return and the standard deviation Year Return 1 12% 2 7% 3 10% 4 9%
A portfolio with a 19% standard deviation generated a return of 17% last year when T-bills...
A portfolio with a 19% standard deviation generated a return of 17% last year when T-bills were paying 4.4%. This portfolio had a Sharpe measure of ____.
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT