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 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 Verizon AT&T Capital One COF Xerox VZ XRX BA $58.1627.50$ 31.71$90.47$ 359.96 $ 240.38$ 6.34 224.85$40.12 0.25 7.44 196.29 1.59 20.29 1.13 0.46 1.34 11.84 336.96 7.82 |$ 2.41 $ 0.08 $ 1.00 $ 5.15$ 2.00$ 7.16 $ 17.03 1.60 6.84 4.00% 3.71% 6.40% 1.78% 2.19% Calculate the following: 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 1. 2. 3. 4. 5. 6. In a paragraph what does this information tell you about your portfolio