Microsoft Excel

Q1) What is the beta of the following portfolio?

Stock Amount invested beta ---- --------------- ----- x $6,000 1.58 y $5,000 2.10 z $8,500 0.80

Q2) If the expected risk-free rate is 2.3% and the expected market risk premium is 4.5%, what is the expected portfolio return?

01) What is the beta of the following portfolio? Stock Amount invested beta XXN z $6,000 $5,000 $8,500 1.58 2.10 0.80 02) If the expected risk-free rate is 2.3% and the expected market risk premium is 4.5%, what is the expected portfolio return