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 ____.
Explain the assertion that the relationship between the standard deviation on a portfolio and standard deviations...
Explain the assertion that the relationship between the standard deviation on a portfolio and standard deviations of the assets in the portfolio is not a simple one.
The standard deviation of a portfolio: Multiple Choice is a weighted average of the standard deviations...
The standard deviation of a portfolio: Multiple Choice is a weighted average of the standard deviations of the individual securities held in the portfolio. is an arithmetic average of the standard deviations of the individual securities which comprise the portfolio. can never be less than the standard deviation of the most risky security in the portfolio. can be less than the standard deviation of the least risky security in the portfolio. must be equal to or greater than the lowest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT