show excel procedure

45. You own a stock portfolio that is invested 25% in Stock A, 20% in Stock B, 45% in Stock C, and 10% in Stock D. The betas for these four stocks are 0.73, 0.86, 1.25 and 1.84 respectively. What is the portfolio beta? O a) 1.10 O b.) 2.20 .) 1.17 O d) 4.68