MNQ-required rate of return of portfolio

Based on the data on the fourth tab of SU_MBA6010_Final_Project_Information.xls, provided in the Doc Sharing area, create an equally weighted portfolio of all ten stocks (including MNQ Company and the other nine stocks) and estimate the beta of the portfolio.
Using the CAPM, determine the required rate of return for the portfolio.
Submit your answers in a 3- to 5-page Microsoft Word document and your calculations in a Microsoft Excel sheet.