Provided below is the data for 5 large capitalization stocks. Invest $100,000 in a portfolio of those 5 stocks and determine each stock's weighting. Use the data provided to do the calculations requested below: Boeing Stock Name Stock Symbol Capital spent on that Verizon Xerox AT&T Capital One COF XRX Percentage of overall portfolio (Stock Weight) Number of shares purchased Current Price Current Market Cap (Billion) Beta (3Y, Monthly) Price/Earnings Ratio Earnings Per Share Forward Dividend Forward Dividend Yield 558.16 27.5031.71 90.47359.96 5240.38 0.25 7.44 6.34$224.85 40.12$ 196.29 1.13 0.46 1.34 1.59 20.29 336.96 11.84 7.82$ 0.08 1.00 $ 5.15S 2.00 $ 7.16$ 17.03 1.60 2.41$ 6.84 4 .00% 3.71% 6.40% 1.78% 2.19% Calculate the following: 1. 2. 3. 4. 5. 6. Calculate the portfolio Beta weighting individual stock's Betas Using the Beta calculated to calculate the expected return of the portfolio using the Risk Free rate of 2% and the Market Risk Premium of 7% Calculate the Forward Dividends you will receive from the portfolio What is the portfolio Forward Dividend Yield? Calculate the weighted average Market Capitalization of your portfolio Calculate the weighted average price/Earnings Ratio of your portfolio In a paragraph what does this information tell you about your portfolio