Question

Question 8 (0.2 points) Stock Expected Return $ Invested $200 $300 $400 6% 10% 179 Given the above exhibit, what is the expected return on the portfolio? (Enter your answers as a decimal rounded to 2 decimal places, not a percentage. For example, enter 8.43% instead of 0.0843) Your Answer: Answer units

Answer 1

A Stock Expected Return Weights Weighted return N COVOU AWN- $ Invested 0.06 0.1 0.17 200 300 400 =SUM(C3:C5) =C3/$C$6 =C4/$C$6 =C5/$C$6 =D3*E3 =D4*E4 =D5*E5 =SUM(F3:F5) w

A B C DE F Stock $ Invested Expected Return 200 6.0% 300 10.0% 400 17.0% 900 Weights Weighted return 22.2% 1.33% 33.3% 3.33% 44.4% 7.56% 12.22%