Expected return and standard deviation

by | Aug 8, 2021 | Assignment

Can someone show me how to solve this in Excel? 25-3) 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?Weight of Stock A (WA) = 30% = 0.30Weight of Stock B (WB) = 70% = 0.70Expected return of Stock A (ERA) = 12% = 0.12Expected return of stock B (ERB) = 18% = 0.18Standard deviation of stock A…

Get your custom paper done at low prices

Y

275 words/page

Y

Double spacing

Y

Free formatting (APA, MLA, Chicago, Harvard and others)

Y

12 point Arial/Times New Roman font

Y

Free title page

Y

Free bibliography & reference

TESTIMONIALS

What Students Are Saying

Outstanding, thank you very much.

Undergraduate Student

English, Literature

Awesome. Will definitely use the service again.

Master's Student

Computer Science