Question
Refer to the investment schedule. For your quantitative analysis compute the current market value of each security position of the portfolio, calculate individual yields based
Refer to the investment schedule. For your quantitative analysis compute the current market value of each security position of the portfolio, calculate individual yields based on current market pricing, and determine the weighted average factor and the weighted average yields.
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 would be the different uses of both?
What non-quantitative observations can you make about the portfolio?
Type of Investment | Company Name | Stock Symbol | Portfolio Position (# of shares) | Current Market Price | Current Market Value | Estimated Dividend/Interest | Estimated Current Yield | Weighted Average Factor | Weighted Average Yield |
Common stock | Altria | MO | 119 | 50.20 | [___] | $247.00 | [___] | [___] | [___] |
Common stock | AT&T | T | 173 | 32.65 | [___] | $325.00 | [___] | [___] | [___] |
Common stock | Chevron | CVX | 26 | 104.98 | [___] | $111.00 | [___] | [___] | [___] |
Common stock | Coca Cola | KO | 59 | 40.55 | [___] | $77.00 | [___] | [___] | [___] |
Common stock | Duke Energy | DUK | 65 | 76.78 | [___] | $206.00 | [___] | [___] | [___] |
Common stock | Johnson & Johnson | JNJ | 31 | 100.60 | [___] | $86.00 | [___] | [___] | [___] |
Common stock | McDonalds | MCD | 52 | 97.44 | [___] | $176.00 | [___] | [___] | [___] |
Common stock | Pepsi Cola | PEP | 17 | 95.62 | [___] | $44.00 | [___] | [___] | [___] |
Common stock | Philip Morris Intl | PM | 70 | 75.33 | [___] | $280.00 | [___] | [___] | [___] |
Common stock | Proctor & Gamble | PG | 52 | 81.94 | [___] | $133.00 | [___] | [___] | [___] |
0 | |||||||||
Total Portfolio Market Value | [___] | ||||||||
Weighte Averatge Yield: | [___] |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started