Question

In: Finance

Portfolio analysis 4. Suppose you form a portfolio that invests 10% in T, 20% in JPM,...

Portfolio analysis

4. Suppose you form a portfolio that invests 10% in T, 20% in JPM, 30% in NEM and 40% in CVX. Calculate (a) portfolio monthly returns, (b) portfolio's average monthly return, and (c) standard deviation of portfolio monthly returns. Discuss. Highlight your final answers.

Average Return E (r) of each stock: The average return on each of these stocks were calculated in excel using today's price-yesterdays price/yesterday's price and then the average taken from 114 days of adj. closing cost.

Ave. Return E(T)=0.85% StDEV(T)=4.46%

Ave. Return(JPM)=1.36% StDEV(JPM)=6.94%

Ave.Return E(NEM)=0.60% StDEV(NEM)10.30%

Ave. Return E(CVX)=0.90% StDEV(CVX)5.74%

Weight

WW(T)=10%

W(JPM)20%

W(NEM)30%

W(CVX)40%

E (r)ptf = W(T)*E(T) + W(JPM)*E(JPM) + W(NEM)*E(NEM)+ W(CVX)*E(CVX)

******I calculated in excel and got these answers: Is the E(r)ptf the portfolio monthly returns or the average monthly return? How do you calculate the (a) portfolio montly returns and (b) the average monthly return?

E(r) ptf=0.90%

StDEV(r) ptf=2.51%

Solutions

Expert Solution

Expected return E(r) actually means the average return, Expectation is a measure of the averaging. Here in this equation, we are using expected return (average returns ) of the stocks. It is crystal clear that the return of the portfolio using average returns of the containing stocks will also be an average measure.

E (r)ptf = W(T)*E(T) + W(JPM)*E(JPM) + W(NEM)*E(NEM)+ W(CVX)*E(CVX)

=( 0.1*0.85%)+ (0.2*1.36% )+(0.3*0.60%)+(0.4*0.9%)= 0.897%=0.9%

For calculating monthly return of the portfolio, first of all, you have to calculate daily return of the portfolio and sum up them all to get the monthly return. For calculating daily return of the portfolio, you have to calculate each stocks daily returns and multiply them with the respective weight. Like wise you can have the return of the portfolio in daily frequency, all this daily return were added (for a particular month) together to arrive for the monthly return.

Daily (r)ptf = W(T)*R(T) + W(JPM)*R(JPM) + W(NEM)*R(NEM)+ W(CVX)*R(CVX)

here R is the daily return of the respective stocks

Do this for all the available trading days in a month and sum up all to arrive at the monthly return of the portfolio.

Let me know your response


Related Solutions

Suppose you own a 4-security portfolio composed of Apple, AT&T, Microsoft and Verizon. You expect a...
Suppose you own a 4-security portfolio composed of Apple, AT&T, Microsoft and Verizon. You expect a return of 19%, 12%, 18% and 22%, respectively, having invested $4,500, $2,500,$3,000, and $4,000, respectively. What is the expected return on the portfolio? 13.9% 15.7% 17.1% 18.4% 2. Consider a stock which earns 5%, 7% 18% when the economy is bad, normal, or good, respectively. Further, suppose that the probability that the economy is bad, normal, or good is 0.15, 0.60, or 0.25, respectively....
An investor holding a certain portfolio consisting of two stocks invests 20% in Stock A and...
An investor holding a certain portfolio consisting of two stocks invests 20% in Stock A and 80% in Stock B. The expected return from Stock A is 4% and that from Stock B is 12%. The standard deviations are 8% and 10% for Stocks A and B respectively. Compute the expected return of the portfolio. b) Compute the standard deviation of the portfolio assuming the correlation between the two stocks is 0.75. c) Compute the standard deviation of the portfolio...
Expected Return Standard Deviation Portfolio A 12% 20% Portfolio B 6% 12% T-bill 3% 0% You...
Expected Return Standard Deviation Portfolio A 12% 20% Portfolio B 6% 12% T-bill 3% 0% You are an investment adviser and you have the three investments above to recommend to your clients. The correlation between A and B is -0.5. Solve for the optimal risky portfolio and enter the weights as a %, 99% should be entered as 99.00%. Percent invested in Portfolio A Percent invested in Portfolio B What is the standard deviation of the optimal risky portfolio? What...
Expected Return Standard Deviation Portfolio A 12% 20% Portfolio B 6% 12% T-bill 3% 0% You...
Expected Return Standard Deviation Portfolio A 12% 20% Portfolio B 6% 12% T-bill 3% 0% You are an investment adviser and you have the three investments above to recommend to your clients. The correlation between A and B is -0.5. Solve for the optimal risky portfolio and enter the weights as a %, 99% should be entered as 99.00%. Percent invested in Portfolio A Percent invested in Portfolio B
QUESTION 4 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b,...
QUESTION 4 Regression Analysis Guide to marks: 20 marks – 5 for a, 10 for b, 3 for c, 2 for d Belinda, the accountant at Murray Manufacturing Company wants to identify cost drivers for support overhead costs. She has the impression that the staff spend a large part of their time ensuring that the equipment is correctly set up and checking the first units of production in each batch. Deborah has collected the following data for the past 12...
The expected return of market portfolio is 10%. The standard deviation of market portfolio is 20%....
The expected return of market portfolio is 10%. The standard deviation of market portfolio is 20%. Risk free interest rate is 2%. There is an investor with mean-variance utility function  Answer the following questions. 1) Calculate the optimal weight to be invested in the market portfolio for the investor with A=5 . Calculate the expected return and standard deviation of the optimal complete portfolio for the investor. 2) According to the CAPM, calculate the expected returns of two stocks (stock 1...
Suppose you held a diversified portfolio consisting of a $7,500 investment in each of 20 different...
Suppose you held a diversified portfolio consisting of a $7,500 investment in each of 20 different common stocks. The portfolio's beta is 1.84. Now suppose you decided to sell one of the stocks in your portfolio with a beta of 1.0 for $7,500 and use the proceeds to buy another stock with a beta of 0.93. What would your portfolio's new beta be? Do not round intermediate calculations. Round your answer to two decimal places.
Suppose you held a diversified portfolio consisting of a $7,500 investment in each of 20 different...
Suppose you held a diversified portfolio consisting of a $7,500 investment in each of 20 different common stocks. The portfolio's beta is 0.75. Now suppose you decided to sell one of the stocks in your portfolio with a beta of 1.0 for $7,500 and use the proceeds to buy another stock with a beta of 1.60. What would your portfolio's new beta be? Do not round intermediate calculations. Round your answer to two decimal places.
Suppose you held a diversified portfolio consisting of a $7,500 investment in each of 20 different...
Suppose you held a diversified portfolio consisting of a $7,500 investment in each of 20 different common stocks. The portfolio's beta is 1.31. Now suppose you decided to sell one of the stocks in your portfolio with a beta of 1.0 for $7,500 and use the proceeds to buy another stock with a beta of 1.35. What would your portfolio's new beta be? Do not round intermediate calculations. Round your answer to two decimal places.
Suppose you have a portfolio consisting of two stocks, Stock S and Stock T. $4,000 is...
Suppose you have a portfolio consisting of two stocks, Stock S and Stock T. $4,000 is invested in Stock S and $6,000 is invested in Stock T: State               Probability                 Stock S            Stock T Boom              0.10                             21%                 35% Normal            ?                                  6%                   11% Recession        0.60                             -17%               -40% What is the standard deviation of Stock S? 0.195194 0.186379 0.168237 0.142076 0.137335 What is the portfolio variance? 0.117452 0.093821 0.051505 0.043497 0.038826
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT