You are putting together a portfolio made up of four different stocks. However, you are considering two posible weightings Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a speelfle Excel function is to be used, the directions will speelfy the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the green cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. Given Data: Portfolio Weightings Asset Beta First Portfolio Second Portfolio 2.5 10% 40% B 1.0 10% 40% c 0.5 40% 10% D -1.5 40% 10% a. What is the beta on each portfolio? 9 10 11 12 14 15 16 17 19 20 2: First Portfolio Second Portfolio Portfolio beta . Which portfolio is riskier? According to the portfolios' betus, c. If the risk-free rate of interest were 4 percent and the market risk premium were 5 percent, what rate of return would you expect to earn from each of the portfolios? Risk-free rate Risk premium 5% is riskier 22 24 25 26 23 First Portfolio Second Portfolio Expected rate of return of the portfolio 28 20 30 31 12 Requirements 1 Start Excel 2 In cell E16, by using cell references and the Excel SUMPRODUCT function, calculate the beta of the first portfolio (1 pt.) 3 In cell F16, by using cell references and the Excel SUMPRODUCT function, calculate the beta of the second portfolio (1 pt.) 4 In cell 20, choose from the drop-down menu and interpret the bets of the two portfolios (1 p.) 5 In cell Els, by using cell references, calculate the expected rate of return of the first portfolio (1 pr.) 6 In cell128, by using cell references calculate the expected rate of return of the second portfolio (1 p.) 7 Save the workbook. Close the workbook and then exit Excel Submit the workbook as directed 34 36 8-23