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 Verizon VZ Xerox XRX AT&T T Capital One COF 1 Stock Name Stock Symbol Capital spent on that stock 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 $ 58.16 $ 27.50 $ 31.71 $ 90.47 $ 359.96 | $ $ $ $ $ 240.38 0.25 7. 44 7.82 2.41 4.00% 6.34 1.13 36.96 0.08 111.00 3.71% 3 $ $ 224.85 0.46 6 5.15 2.00 6.40% 40.12 1.34 11.84 7.16 1.60 1.78% 196.29 1.59 20.29 17.03 6.84 2.19% $ $ $ $ S $ $ $ Calculate the following: 1. Calculate the portfolio Beta weighting individual stock's Betas 2. 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% 3. Calculate the Forward Dividends you will receive from the portfolio 4. What is the portfolio Forward Dividend Yield? 5. Calculate the weighted average Market Capitalization of your portfolio 6. Calculate the weighted average price/Earnings Ratio of your portfolio In a paragraph what does this information tell you about your portfolio? 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 Verizon VZ Xerox XRX AT&T T Capital One COF 1 Stock Name Stock Symbol Capital spent on that stock 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 $ 58.16 $ 27.50 $ 31.71 $ 90.47 $ 359.96 | $ $ $ $ $ 240.38 0.25 7. 44 7.82 2.41 4.00% 6.34 1.13 36.96 0.08 111.00 3.71% 3 $ $ 224.85 0.46 6 5.15 2.00 6.40% 40.12 1.34 11.84 7.16 1.60 1.78% 196.29 1.59 20.29 17.03 6.84 2.19% $ $ $ $ S $ $ $ Calculate the following: 1. Calculate the portfolio Beta weighting individual stock's Betas 2. 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% 3. Calculate the Forward Dividends you will receive from the portfolio 4. What is the portfolio Forward Dividend Yield? 5. Calculate the weighted average Market Capitalization of your portfolio 6. Calculate the weighted average price/Earnings Ratio of your portfolio In a paragraph what does this information tell you about your portfolio