Please carefully write up your answers to the following questions. Also send me your Excel sheet that shows your computations. Suppose there are only...

Consider five possible values for the correlation between the two stocks:

ρ ∈{−0.8,−0.4,0,0.4,0.8}

1. For each of the five possible values for the correlation ρ, use Excel to tabulate and draw the investment opportunity set of the two stocks. Use investment proportions for Stock A of −100% to 200% in increments of 1%. [You will have five graphs, one for each ρ]

2. For each of your five opportunity sets, compute the minimum variance portfolio (MVP) (find the expected return, standard deviation, and the weights on the two stocks that comprise each MVP).

3. What is the slope of the best feasible CAL for each ρ?

4. On each graph, draw a tangent from the risk-free rate to the investment opportunityset. What expected return and standard deviation does each of your graphs show for the optimal risky portfolio? What are the weights on the two stocks that comprise this portfolio?

5. Suppose your portfolio must provide an expected return of 8%. For each ρ, answer the following.

(a) If you use only the two stocks to form your portfolio, what is the lowest standarddeviation you can achieve?

(b) If you use the two stocks and the T-bill fund, what is the lowest standard deviationyou can achieve? Compare with your answer to part (a). What do you conclude?

(c) If you have $10,000 to invest, how much money do you invest in Stock A, StockB, and the T-bill fund to form the portfolio in part (b)?

6. Now suppose the two stocks are perfectly negatively correlated (ρ = −1). Construct a portfolio with zero variance, and show that the risk-free rate must be greater than 5%.

please send the excel  file to my email. thank you