Problem 10-14 Spreadsheet Problem: Portfolio Beta and Return (LG10-3)

You own the portfolio of five stocks shown below:

Problem 10-14 Spreadsheet Problem: Portfolio Beta and Return (LG10-3) You own the portfolio of five stocks shown below: Given the amount owned of each stock and their respective betas, what is the beta of your portfolio? If the market return is expected to be 9.5 percent and the risk-free rate is 2 percent, what is the required rate of return for the portfolio? Note: Do not round intermediate calculations and round your answers to 2 decimal places