Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please carefully write up your answers to the following questions and hand in a hard copy. Also send me your Excel sheet that shows your

image text in transcribed

Please carefully write up your answers to the following questions and hand in a hard copy.

Also send me your Excel sheet that shows your computations.

Suppose there are only two stocks and a T-bill money market fund that yields a sure rate of 5%. The characteristics of the two stocks are:

Stock

Expected Return

Standard Deviation

A

12%

40%

B

8%

20%

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 and word file to my email. thank you

image text in transcribed Please carefully write up your answers to the following questions and hand in a hard copy. Also send me your Excel sheet that shows your computations. Suppose there are only two stocks and a T-bill money market fund that yields a sure rate of 5%. The characteristics of the two stocks are: Stock Expected Return Standard Deviation A 12% 40% B 8% 20% 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? 1 (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 Tbill 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%. 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Healthcare Finance: An Introduction To Accounting And Financial Management

Authors: Louis Gapenski

6th Edition

1567937411, 978-1567937411

More Books

Students also viewed these Finance questions

Question

Whatisa target cost per unit? lop5

Answered: 1 week ago

Question

Howisactivity-based costing useful for pricing decisions? lop5

Answered: 1 week ago

Question

Describe three alternative cost-plus methods. lop5

Answered: 1 week ago