Question: ***PLEASE ANSWER IN EXCEL*** 4. Given the historical returns and variance/covariance matrix for three stocks: Find (1) the portfolio expected return and (2) the portfolio

***PLEASE ANSWER IN EXCEL*** 4. Given the historical returns and variance/covariance

***PLEASE ANSWER IN EXCEL***

4. Given the historical returns and variance/covariance matrix for three stocks: Find (1) the portfolio expected return and (2) the portfolio standard deviation of an equally weighted portfolio of the three stocks. Historical data (Returns) on three stocks Stock 1 Stock 2 Stock 3 Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 Period 7 Period 8 Period 9 Period 10 10.00% 12.00% 8.00% 7.00% 9.00% 7.00% 8.00% 6.00% 9.00% 11.00% 15.00% 17.00% 4.00% -8.00% 15.00% 22.00% 3.00% -14.00% 2.00% 15.00% 12.00% 13.00% 9.00% 7.00% 9.00% 11.00% 9.00% 6.00% 8.00% 10.00% Variance/Covariance Matrix Stock 1 Stock 2 Stock 3 Stock 1 0.032% Stock 2 0.124% 1.233% Stock 3 0.027% 0.200% 0.042% 5.The covariance of the returns on the two securities. A and B, is -0.0005. The standard deviation of A's returns is 4% and the standard deviation of B's returns is 6%. What is the correlation between the returns of A and B

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

As a finance teacher, illustrate how question c and e get to the answer please. The provided answers are correct, and I will just need the calculation process. WIll rate. 8. You have the following...

Q:

2. Use the 25 years of historical asset returns for 3 risky assets from the previous problem set [Mean-Variance Portfolio Choice 1] to estimate the vector of expected returns and the covariance...

Q:

help me to finish table d. Scenario Probability Rate of return of stock fund(") Rate of return of bond fund ) 0.10 Severe recession Mild recession Normal growth Boom 13 0.50 020 a. Calculate the...

Q:

The following table presents the performance of stock and bond funds under various scenarios. Scenario Severe recession Mild recession Normal growth Boom Probability Rate of return of stock fund (%)...

Q:

Question:E to J The following table presents the performance of stock and bond funds under various scenarios Scenario Probability Rate of return of stock fund (%) 0.1 -35 0.2 -10 0.5 15 0.2 40 Rate...

Q:

The following table presents the performance of stock and bond funds under various scenarios. Scenario Rate of return of bond fund (%) -6 Severe recession Mild recession Normal growth Boom...

Q:

Tabulate and draw the minimum variance frontier of INTC and COLM. Use the spreadsheet "Two Assets". Use the portfolio weight for INTC from 1.20 to -0.20 in increments of 0.10 (the corresponding...

Q:

Given the returns of two stocks J and K in the table below over the next 4 years. Find the expected return and standard deviation of holding a portfolio of 40% of stock J and 60% in stock K over the...

Q:

help me find the expected return and standard deviation of alpha co, beta co, portfolio 1, and portfolio 2. use excel please 19. You are considering two investment options, Alpha Co. and Beta Co. or...

Q:

**May use excel to answer. 1 (10 pts) Consider 3 securities with expected returns, standard deviations of returns and correlations between returns given below - - P21 = 0.1 Hi 12 0.2 0.11 0.05 01 0.2...

Q:

Define each of the following terms: a. Working capital; net working capital; net operating working capital b. Relaxed investment policy; restricted investment policy; moderate investment policy c....

Q:

The Greater Pittsburgh Area Chamber of Commerce wants to estimate the mean time workers who are employed in the downtown area spend getting to work. A sample of 15 workers reveals the following...

Q:

Which one of these formulas correctly computes the return required by an investor? ( P i | ) i = ( D , P ) 9 i = D 1 9 T = D 0 P 0 g

Q:

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Q:

3. Assess the quality or value of communication by examining its six characteristics

Q:

5. Describe the visual representations, or models, of communication

Q:

4. Define what communication scholars consider to be competent communication