Stock a has an expected return of 12 and a standard


Can someone show me how to solve this in Excel?

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 Stock A and B is 0.2. What are the expected return and standard deviation of a portfolio invested 30% in Stock A and 70% in Stock B?

Solution Preview :

Prepared by a verified Expert
Finance Basics: Stock a has an expected return of 12 and a standard
Reference No:- TGS02224541

Now Priced at $10 (50% Discount)

Recommended (99%)

Rated (4.3/5)