please describe any excel formulas used

Time: 4:48 PM 2. Assume that the CAPM is a good description of stock price returns. The market annected return is 7% with 99% volatility and the risk free rate is 3% New news arrives that does not change any of these numbers but it does change the expected return of the following stocks: 1 a. At current market prices, which stocks represent buying opportunities b. On which stocks should you put a sell order in? Complete the table with the alphas below: (Round to one decimal place) Alpha Green Leaf NatSam HanBel Rebecca Automobile Expected Return 10% 9% 9% Volatility 19% 41% 29% 35% Beta 1.62 1.84 0.65 1.24 7% 1: Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Green Leaf NatSam HanBel Rebecca Automobile Expected Return 10% 9% 9% 7% Volatility 19% 41% 29% 35% Beta 1.62 1.84 0.65 1.24