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

You own the portfolio of five stocks shown below:

$\backslash$table$[[,$A$,$B$,$C$],[1,,$Value,Beta$],[2,$Human Genome,$$10,400,0\mathrm{.}93],[3,$Frozen Food Expres,$$11,900,1\mathrm{.}39],[4,$Molecular Device,$$7,600,1\mathrm{.}23],[5,$Pandemic Busters,$$10,000,1\mathrm{.}29],[6,$Zoom Technologies,$$14,900,0\mathrm{.}58]]$

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.

$\backslash$table$[[$Portfolio Beta,,$],[$Required Return,,$\%$