Please use excel to solve. Data provided must be clearly laid out in the spreadsheet and cell referencing must be used

5. What is the beta of a portfolio consisting of one share of each of the following stocks, given their respective prices and beta coefficients? Stock Price Beta $10 24 0.8 1.3 1.8 How would the portfolio beta differ if (a) the investor purchased 200 shares of stocks B and C for every 100 shares of A and D and (b) equal dollar amounts were invested in each stock