please describe any excel formulas used

2. Assume that the CAPM is a good description of stock price returns. The market aspected return is with 9 volaity and the risk-free rate is 4%. 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 soll order in? Complete the table with the alphas below: (Round to one decimal place.) Beta Alpha Expected Return 11% x 11% Green Leaf Nat Sam HanBel Rebecca Automobile Volatility 20% 37% 32% 40% 1.58 2.16 0.78 8% 6% 1.23 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.) Expected Return Volatility Beta Green Leaf 11% 20% 1.58 NatSam 11% 37% 2.16 HanBel 8% 32% 0.78 Rebecca Automobile 6% 40% 1.23