Portfolio Analysis: Weighting and Expected Returns with Apple, Cisco, and Colgate-Palmolive Stocks”

QUESTION

You own three​ stocks: 600  shares of Apple​ Computer, 10,000  shares of Cisco​ Systems, and 5,000

shares of​ Colgate-Palmolive. The current share prices and expected returns of​ Apple, Cisco, and​ Colgate-Palmolive are,​ respectively,  $460​,  $25​,  $110  and  12%​,  10%​,  8%.

a. What are the portfolio weights of the three stocks in your​ portfolio?

b. What is the expected return of your​ portfolio?

c. Suppose the price of Apple stock goes up by $27​, Cisco rises by $3​, and​ Colgate-Palmolive falls by  $10.

What are the new portfolio​ weights?

d. Assuming the​ stocks’ expected returns remain the​ same, what is the expected return of the portfolio at the new​ prices?

ANSWER

Portfolio Analysis: Weighting and Expected Returns with Apple, Cisco, and Colgate-Palmolive Stocks”

To calculate the portfolio weights of the three stocks in your portfolio, you need to divide the value of each stock by the total value of your portfolio.

First, let’s calculate the value of each stock:
Value of Apple Computer = 600 shares * $460/share = $276,000
Value of Cisco Systems = 10,000 shares * $25/share = $250,000
– Value of Colgate-Palmolive = 5,000 shares * $110/share = $550,000

Next, calculate the total value of your portfolio:
Total Portfolio Value = $276,000 (Apple) + $250,000 (Cisco) + $550,000 (Colgate-Palmolive) = $1,076,000

Now, calculate the portfolio weights:
– Apple Weight = (Value of Apple / Total Portfolio Value) = ($276,000 / $1,076,000) ≈ 25.65%
– Cisco Weight = (Value of Cisco / Total Portfolio Value) = ($250,000 / $1,076,000) ≈ 23.22%
– Colgate-Palmolive Weight = (Value of Colgate-Palmolive / Total Portfolio Value) = ($550,000 / $1,076,000) ≈ 51.13%

So, the portfolio weights are approximately 25.65% for Apple, 23.22% for Cisco, and 51.13% for Colgate-Palmolive.

b. To calculate the expected return of your portfolio, you can use the weighted average of the expected returns of the individual stocks, where the weights are the portfolio weights calculated in part (a).

Expected Return of Portfolio = (Apple Weight * Expected Return of Apple) + (Cisco Weight * Expected Return of Cisco) + (Colgate-Palmolive Weight * Expected Return of Colgate-Palmolive)
Expected Return of Portfolio = (0.2565 * 12%) + (0.2322 * 10%) + (0.5113 * 8%)
Expected Return of Portfolio ≈ 9.27%

So, the expected return of your portfolio is approximately 9.27%.

c. Now, let’s calculate the new portfolio weights after the changes in stock prices:

After the changes:
– Apple’s new price = $460 + $27 = $487 per share
– Cisco’s new price = $25 + $3 = $28 per share
– Colgate-Palmolive’s new price = $110 – $10 = $100 per share

Now, calculate the new value of each stock:
– New Value of Apple = 600 shares * $487/share = $292,200
– New Value of Cisco = 10,000 shares * $28/share = $280,000
– New Value of Colgate-Palmolive = 5,000 shares * $100/share = $500,000

Calculate the new total portfolio value:
New Total Portfolio Value = $292,200 (Apple) + $280,000 (Cisco) + $500,000 (Colgate-Palmolive) = $1,072,200

Now, calculate the new portfolio weights:
– New Apple Weight = (New Value of Apple / New Total Portfolio Value) = ($292,200 / $1,072,200) ≈ 27.22%
– New Cisco Weight = (New Value of Cisco / New Total Portfolio Value) = ($280,000 / $1,072,200) ≈ 26.09%
– New Colgate-Palmolive Weight = (New Value of Colgate-Palmolive / New Total Portfolio Value) = ($500,000 / $1,072,200) ≈ 46.69%

So, the new portfolio weights are approximately 27.22% for Apple, 26.09% for Cisco, and 46.69% for Colgate-Palmolive.

d. Assuming the stocks’ expected returns remain the same, you can calculate the expected return of the portfolio at the new prices using the new portfolio weights:

New Expected Return of Portfolio = (New Apple Weight * Expected Return of Apple) + (New Cisco Weight * Expected Return of Cisco) + (New Colgate-Palmolive Weight * Expected Return of Colgate-Palmolive)
New Expected Return of Portfolio = (0.2722 * 12%) + (0.2609 * 10%) + (0.4669 * 8%)
New Expected Return of Portfolio ≈ 10.29%

So, assuming the expected returns of the stocks remain the same, the expected return of your portfolio at the new prices is approximately 10.29%.

In summary, the portfolio weights and expected returns of your portfolio have changed after the price fluctuations of the individual stocks. The new portfolio weights are approximately 27.22% for Apple, 26.09% for Cisco, and 46.69% for Colgate-Palmolive, with an expected return of approximately 10.29% at the new prices.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 Customer support
On-demand options
  • Tutor’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Attractive discounts
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Unique Features

As a renowned provider of the best writing services, we have selected unique features which we offer to our customers as their guarantees that will make your user experience stress-free.

Money-Back Guarantee

Unlike other companies, our money-back guarantee ensures the safety of our customers' money. For whatever reason, the customer may request a refund; our support team assesses the ground on which the refund is requested and processes it instantly. However, our customers are lucky as they have the least chances to experience this as we are always prepared to serve you with the best.

Zero-Plagiarism Guarantee

Plagiarism is the worst academic offense that is highly punishable by all educational institutions. It's for this reason that Peachy Tutors does not condone any plagiarism. We use advanced plagiarism detection software that ensures there are no chances of similarity on your papers.

Free-Revision Policy

Sometimes your professor may be a little bit stubborn and needs some changes made on your paper, or you might need some customization done. All at your service, we will work on your revision till you are satisfied with the quality of work. All for Free!

Privacy And Confidentiality

We take our client's confidentiality as our highest priority; thus, we never share our client's information with third parties. Our company uses the standard encryption technology to store data and only uses trusted payment gateways.

High Quality Papers

Anytime you order your paper with us, be assured of the paper quality. Our tutors are highly skilled in researching and writing quality content that is relevant to the paper instructions and presented professionally. This makes us the best in the industry as our tutors can handle any type of paper despite its complexity.