Need help with number 2 and 3. For number 2 I need Weighted Average Return, Portfolio Monthly Return and Portfolio Annual Return. Please show EXCEL FORMULAS that are used. All information is provided below.

Risk \& Return Spreadsheet Example Average monthly return = Standard Deviation= Stock A's Beta SUMMARY OUTPUT NM/ Stock B's Beta SUMMARY OUTPUT SUMMARY OUTPUT 2. Calculation of Portfolio Beta and Portfolio Return 3. If the annual risk-free rate, Rrf, will be 2 percent in 2019 and the expected return on the market index, E(Rm), will be 8 percent, what is your portfolio's required rate of return according to the CAPM? E(Rp)=Rrf+(E(Rm)Rrf)p=formula Risk \& Return Spreadsheet Example Average monthly return = Standard Deviation= Stock A's Beta SUMMARY OUTPUT NM/ Stock B's Beta SUMMARY OUTPUT SUMMARY OUTPUT 2. Calculation of Portfolio Beta and Portfolio Return 3. If the annual risk-free rate, Rrf, will be 2 percent in 2019 and the expected return on the market index, E(Rm), will be 8 percent, what is your portfolio's required rate of return according to the CAPM? E(Rp)=Rrf+(E(Rm)Rrf)p=formula