WhatsApp +1 (332) 244-5747

Expected return and standard deviation

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

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…

TESTIMONIALS

What Students Are Saying

Outstanding service, thank you very much.

Undergraduate Student

English, Literature

Awesome. Will definitely use the service again.

Master's Student

Computer Science