Explain the basis upon which you determined the weighted average yield. Explain the difference between a yield that is based on cost, as opposed to one that is based on current market value. What are the different uses of both? What non-quantitative observations can you make about the portfolio? Although you can transfer tables from Excel into Word, include the original Excel file in addition to the Word file with your submission.

Papers will be assessed using the following criteria:

The solved solutions for: The current market value of each security position of the portfolio. Individual yields (estimated current yield) based on current market pricing. The weighted average factor. The weighted average yields. An explanation of how the weighted average yield was determined. An explanation for the difference between a yield that is based on cost, as opposed to one that is based on current market value. The explanation discussed the different uses of both. Non-quantitative observations (narrative) about the portfolio.

One year

CCCCCCC CCCCCCCCCC Portfolio Current Current Estimated Estimated Weighted Weighted Type of Stock Position Company Name Market Market Dividend/ Current Average Average Investment Symbol (#of Price Value Interest Yield Factor Yield shares) Common stock Altria 119 50.04 $247.00 Common stock AT&T T 173 32.09 $325.00 Common stock Chevron CVX 26 125.82 $111.00 Common stock Coca Cola 59 54.33 $77.00 Common stock Duke Energy DUK 65 87.68 $206.00 Common stock Johnson & Johnson JNJ 31 128.84 $86.00 $176.00 $44.00 $280.00 Common stock McDonalds MCD 52 214.31 Common stock Pepsi Cola PEP 17 130.74 Common stock Philip Morris Intl PM 70 86.75 Common stock Proctor & Gamble PG 52 113.85 $133.00 0 Total Portfolio Market Value U Weighte Averatge Yield: CCCCCCC CCCCCCCCCC Portfolio Current Current Estimated Estimated Weighted Weighted Type of Stock Position Company Name Market Market Dividend/ Current Average Average Investment Symbol (#of Price Value Interest Yield Factor Yield shares) Common stock Altria 119 50.04 $247.00 Common stock AT&T T 173 32.09 $325.00 Common stock Chevron CVX 26 125.82 $111.00 Common stock Coca Cola 59 54.33 $77.00 Common stock Duke Energy DUK 65 87.68 $206.00 Common stock Johnson & Johnson JNJ 31 128.84 $86.00 $176.00 $44.00 $280.00 Common stock McDonalds MCD 52 214.31 Common stock Pepsi Cola PEP 17 130.74 Common stock Philip Morris Intl PM 70 86.75 Common stock Proctor & Gamble PG 52 113.85 $133.00 0 Total Portfolio Market Value U Weighte Averatge Yield