In: Finance
Suppose that the index model for stocks A and B is estimated from excess returns with the following results:
RA = 3.4% + 1.15RM + eA
RB = –1.5% + 1.30RM + eB
σM = 15%; R-squareA = 0.26; R-squareB = 0.16
Assume you create a portfolio Q, with investment proportions of 0.50 in a risky portfolio P, 0.30 in the market index, and 0.20 in T-bill. Portfolio P is composed of 60% Stock A and 40% Stock B.
a. What is the standard deviation of portfolio Q? (Calculate using numbers in decimal form, not percentages. Do not round intermediate calculations. Round your answer to 2 decimal places.)
b. What is the beta of portfolio Q? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
c. What is the "firm-specific" risk of portfolio Q? (Calculate using numbers in decimal form, not percentages. Do not round intermediate calculations. Round your answer to 4 decimal places.)
d. What is the covariance between the portfolio and the market index? (Calculate using numbers in decimal form, not percentages. Do not round intermediate calculations. Round your answer to 2 decimal places.)
I have answered the question below using excel and have attached the image below.
Please up vote for the same and thanks!!!
Do reach out in the comments for any queries
Answer: