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,$$7,400,0\mathrm{.}92],[3,$Frozen Food Express,$$8,900,1\mathrm{.}36],[4,$Molecular Device,$$4,600,1\mathrm{.}24],[5,$Pandemic Busters,$$7,000,1\mathrm{.}29],[6,$Zoom Technologies,$$11,900,0\mathrm{.}59]]$

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.