I need help with the attached. Please show step-by-step process and include how calculations are computed in Excel. Thank you for your help!!

From the website www.finance.yahoo.com obtain the reports on Walmart and Target Corp. 1. What are the betas listed for these companies? 2. If you made an equal dollar investment in each stocks what would be the beta of your portfolio? 3. If you made 70% of dollar investment in stock A, and 30% of dollar investment in stock B, what would be the beta of your portfolio? Please show your work. 4. Apply the Capital Asset Pricing Model (CAPM) Security Market Line to estimate the required return on these two stocks. Assumptions and Data: Note that you will need the risk-free rate and the market risk premium. Assume a 5% market risk premium. To get the current yield on 10-year Treasury securities go to (www.finance.yahoo.com ) -click on Market Data - Bonds. You will use the current yield on 10-year Treasury securities as the risk-free rate to estimate the required rate of return on stocks. 5. Compare the required return on these stocks calculated using CAPM in question #3 against their historical return over the last 52 weeks, found in the Yahoo!Finance (www.finance.yahoo.com ) Key Statistics. Is there a difference between these returns? Is this a problem? Why is there a difference