Portfolio Help

Stock (A) closing 53.54yesterday close 53.39Beta = 1.34percent change 0.15
Stock (B) close 39.57yesterday close 40.72Beta 1.69Percent change 1.38
stock (C) close 78.65yesterday close 78.91Beta- 0.40percent change -0.26
Stock (D) close 96.54yesterday close 96.41Beta- 0.38percent change 0.13
Using excel*calculate return on holding stock for a day.* calculate a portfolio return with weights of 0.25 for each stock* calculate a weighted beta with weights of 0.25 for each stock.* Summarize implications of portfolios risk and return with respect to what you know about beta and CAPM