Calculate the expected return of the portfolio calculate


Stock A has an expected return of 12% and a standard deviation of 40%. Stock B has an expected return of 18% and a standard deviation of 60%. The correlation coefficient between Stocks A and B is 0.2. Stock A has a beta of .85 and Stock B has a beta of 1.20. Portfolio is invested 30% in Stock A and 70% in Stock B. PLEASE SHOW IN EXCEL-WITH STEPS.

a. Calculate the expected return of the portfolio.

b. Calculate the standard deviation of the portfolio.

c. Calculate the beta of the portfolio

d. Is your portfolio less risky or more risky than the market? Explain.

e. Will your portfolio likely outperform or underperform the market in a period when stocks are rapidly falling in value?

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Calculate the expected return of the portfolio calculate
Reference No:- TGS02862315

Expected delivery within 24 Hours