Question

In: Finance

Pepsi’s mean return over the last 5 years is 19% while McDonald’s is 14%. Their respective...

  1. Pepsi’s mean return over the last 5 years is 19% while McDonald’s is 14%. Their respective standard deviations are 21% and 18%. The two stocks correlation coefficient is -.20.

  1. Calculate the portfolio mean return for the minimum variance portfolio.
  2. Calculate the portfolio risk for the minimum variance portfolio.
  3. Discuss the benefits of diversification for Pepsi and McDonald’s.

Solutions

Expert Solution

(a).The formula to calculate Mean/ expected return of minimum variance porfolio is

.................(1)

where,

E(rP)=Mean return of Pepsi, wp=weight of pepsi

E(rM)=Mean return of McDonald's, wM=weight of McDolanld

Here we have to calculate wP & wA

We know that for only two asset the weight wP+wM=1 or, wP=1-wM

Now from the variance formula,

.........................(2)

differentiating with respect to wP,,we get

Putting these values in 1

E(r)=16.31%

Therefore ,portfolio mean return =16.31% answer.

(b) here volatility is same as risk

so we calculate volatility

from euation (2)

Hence, portfolio risk =11.815% answer.

(c).Of these two portfolio pepsi has a higher return than Mcdonald.also these are negatively co related to each other.

Adding the riskier stock to the porfolio can actually lower the portfolio risk.

Here the portfolio risk is 11.815%,so adding Pepsi to the porfolio is the great idea because,it can increase the expected return to 14%to 16% and portfolio standard deviation from 18% to 12%.


Related Solutions

The SMH ETF has annual return of 14% over the last 10 years. The fund has...
The SMH ETF has annual return of 14% over the last 10 years. The fund has volatitlity of 19% during that same period. What is1 the 95% likely range of return for SMH over the next 5 years?
The stock market provided the following return over the last 3 years. Year Return 2016 +15...
The stock market provided the following return over the last 3 years. Year Return 2016 +15 2017 -30 2018 +35 What is the arithmetic average return? What is the geometric average return? Suppose you invested $1000 at the beginning of each of 2016,2017,2018 and withdrew all funds at the end of 2018, what is your average return (IRR)
Over the last 5 years a region has been hit by an average of 5 tornadoes...
Over the last 5 years a region has been hit by an average of 5 tornadoes per year. Assume this figure to be accurate and that the probability of a tornado occurring remains constant throughout a year. Calculate a) The probability that the same area will be hit by at least 4 tornadoes this year. b) The probability more than 4 months go by without a tornado. The answer below for a) and b) in order separated by a comma...
Assess the financial situations of commercial banks over the last 5 years.
Assess the financial situations of commercial banks over the last 5 years.
Over the last 20 years, the number of students who hold a job while attending university...
Over the last 20 years, the number of students who hold a job while attending university fulltime has increased. Work responsibilities may ‘compete’ for time and energy with course responsibilities, and consequently, may affect student academic success. An educational researcher is interested in determining whether student employment influences academic success. The research has obtained a relevant sample of university students, and has determined the following information for each student: their employment status (specifically, the typical number of hours worked per...
A portfolio generates the following returns over the past 10 years: Year Return (%) 1 14...
A portfolio generates the following returns over the past 10 years: Year Return (%) 1 14 2 2 3 -15 4 20 5 18 6 16 7 -17 8 24 9 -10 10 -4 Calculate the test statistic to test whether the standard deviation of this portfolio's return is different from the benchmark portfolio standard deviation of 23. The answer should be 4.075. Please use Excel and show formulas that are used. Thank you!
26. Suppose that over the last 30 years, company ABC has averaged a return of 10%....
26. Suppose that over the last 30 years, company ABC has averaged a return of 10%. Over the same period, the Treasury bond rate has averaged 3%. The current estimate of the Treasury bond rate is 5%. Using the historical approach, what is the estimate of ABC’s expected return. A. 13.0% B. 12.5% C. 12.0% D. 11.0% 27. Standard deviation measures: A. systematic risk. B. unsystematic risk. C. total risk. D. beta risk. 28. Investors can eliminate what type of...
1. Calculate the average return over the last 3 years. 2. Calculate the standard deviation of...
1. Calculate the average return over the last 3 years. 2. Calculate the standard deviation of your company’s returns over the last 3 years. [I will make sure to give thumbs up to those who answer] 8/1/2016 100.975754 9/1/2016 108.172951 10/1/2016 108.6418 11/1/2016 105.752083 12/1/2016 111.392426 1/1/2017 116.711029 2/1/2017 131.753159 3/1/2017 138.767197 4/1/2017 138.757538 5/1/2017 147.557281 6/1/2017 139.689148 7/1/2017 144.257507 8/1/2017 159.068329 9/1/2017 150.072464 10/1/2017 164.600632 11/1/2017 167.336838 12/1/2017 165.378021 1/1/2018 163.618988 2/1/2018 174.065674 3/1/2018 164.629501 4/1/2018 162.15683 5/1/2018 183.361038...
12. A mutual fund has earned an annual average return of 15% over the last 5...
12. A mutual fund has earned an annual average return of 15% over the last 5 years. During that time, the average risk-free rate was 2% and the average market return was 12% per year. The correlation coefficient between the mutual fund’s and market’s returns was 0.7. The standard deviation of returns was 30% for the mutual fund and 22% for the market. What was the fund’s CAPM alpha? Stuck on this. Any help would be greatly appreciated.
Solve it by R Over the past 5 years, the mean time for a warehouse to...
Solve it by R Over the past 5 years, the mean time for a warehouse to fill a buyer’s order has been 25 minutes. Officials of the company believe that the length of time has increased recently, either due to a change in the workforce or due to a change in customer purchasing policies. The processing time (in minutes) was recorded for a random sample of 15 orders processed over the past month. 28 25 27 31 10 26 30...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT