Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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 Xerox AT&T Capital One COF VZ XRX BA $58.1627.5031.71 90.47$ 359.96 $ 240.38$ 6.34 224.85 40.12196.29 0.25 1.13 0.46 1.34 1.59 7.44 336.96 6 11.84 20.29 7.82 $ 2.41$ 0.08 $ 1.00$ 5.15 $ 2.00 s 7.16$ 17.03 1.60$ 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? 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 Xerox AT&T Capital One COF VZ XRX BA $58.1627.5031.71 90.47$ 359.96 $ 240.38$ 6.34 224.85 40.12196.29 0.25 1.13 0.46 1.34 1.59 7.44 336.96 6 11.84 20.29 7.82 $ 2.41$ 0.08 $ 1.00$ 5.15 $ 2.00 s 7.16$ 17.03 1.60$ 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Jeff Madura

9th Edition

1439038848, 978-1439038840

More Books

Students also viewed these Finance questions