Problem $10-14$ Spreadsheet Problem: Portfolio Beta and Return $($LG$10-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\mathrm{.}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.