Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The table below shows the stock prices of 6 stocks at the end of each 30 holding periods (including at the end of period 0),

The table below shows the stock prices of 6 stocks at the end of each 30 holding periods (including at the end of period 0), and the dividends given during holding periods 13 and 24.

image text in transcribed

Your team of investment managers shall form portfolios of investments in 2 stocks according to the list below.

image text in transcribed

The 2 chosen stocks are Casper and Dresden

Required:

  • Calculate the returns for your 2 chosen stocks and any 2 others over each holding period.

  • Calculate the expected return and (population) standard deviation for the 4 stocks, as well as the

    correlation coefficients for each pair of stocks (correlation matrix).

  • Construct portfolios using your 2 chosen stocks only. Show the risk-return profile of your portfolios of

    investments in various weights in your 2 chosen stocks. Also, plot a chart (in Excel) showing the risk-return

    profile.

  • Using your 2 chosen stocks only, show how much (weights) in each stock would you invest in to construct

    the minimum variance portfolio, and portfolios X, Y and Z (Refer to the table above for the required standard deviations of Portfolios X, Y and Z). Calculate the expected returns of these portfolios. Show how you would spend $100,000 to construct the minimum variance portfolio and portfolios X, Y and Z respectively at the end of holding period 30.

  • If risk-free borrowing and lending rates are 4% and 2% respectively, show how you can improve on your portfolios of investments in your chosen stocks by allowing borrowing and/or lending. Explain briefly the basis of the improvements you are making. Show the risk-return profile of your portfolios of investments in various weights in your 2 chosen stocks and borrowing/lending.

  • Using your 2 chosen stocks and borrowing/lending, show how much (weights) in each stock would you invest in and how much borrowing/lending is needed to construct portfolios X*, Y* and Z* (if possible). Portfolios X*, Y* and Z* are the improved portfolios that have the same standard deviations as X, Y and Z respectively. Calculate the expected returns of these portfolios and compare with the expected returns of portfolios X, Y and Z respectively to justify your decisions. Show how you would spend $100,000 to construct these portfolios X*, Y* and Z* (if possible) respectively at the end of holding period 30.

Holding-Period 0 0 Auburn 1.23 1.20 Casper 2.13 2.23 Dresden 2.06 2.55 Frederik 4.87 5.09 1 2 1.43 3.97 Boulder 1.72 2.14 2.35 2.83 2.51 2.44 2.40 Erskine 3.05 4.17 3.79 3.79 5.09 6.11 7.24 3 4 5 1.68 1.80 1.76 2.10 1.96 5.87 6.82 5.23 8.52 10.17 12.50 6 7 3.03 6.68 8 1.89 9.20 7.89 14.83 9 10 11 12 2.78 3.51 4.33 5.33 6.19 0.15 5.99 5.73 6.38 18.97 20.12 21.30 2.41 2.17 1.86 1.92 2.20 2.81 2.98 2.72 2.52 2.37 2.25 0.18 2.05 1.87 1.79 1.93 2.25 2.77 3.51 4.46 4.70 1.68 1.55 1.46 1.37 0.09 1.22 1.20 1.18 1.17 1.24 1.36 1.60 1.90 2.27 13-Dividends 13 14 15 16 17 2.51 4.20 3.73 3.50 4.23 5.35 5.88 6.02 6.47 7.27 7.45 0.22 7.31 8.44 8.71 8.95 10.85 10.91 11.22 10.83 9.79 9.68 9.97 9.58 0.21 9.39 10.04 10.93 10.93 12.54 13.71 6.99 6.87 6.66 6.39 7.59 7.66 18 19 20 6.88 6.06 5.38 0.24 5.09 6.08 6.53 9.08 9.78 8.63 9.13 11.67 12.94 14.12 16.59 17.50 0.27 17.37 18.64 20.62 23.76 25.18 26.37 21 0.35 21.02 25.35 29.47 32.47 34.94 31.93 33.34 32.57 39.15 34.31 43.73 44.41 0.35 44.15 47.87 50.55 57.81 59.34 62.81 22 6.44 6.21 23 24 25-Dividends 25 2.72 3.03 3.34 0.07 3.25 3.52 4.16 4.51 6.21 0.16 6.03 6.26 6.74 6.61 5.39 5.78 6.01 0.20 5.85 6.26 7.18 7.36 7.36 9.87 26 27 28 29 4.51 6.81 30 4.07 6.97 Teams 1 2 Portfolio X 0.09 0.0615 0.095 0.09 0.10 Portfolio Y 0.095 0.062 0.12 0.094 0.102 Portfolio Z 0.11 0.07 0.14 0.11 0.13 3 4 5 Stocks Auburn-Casper Auburn-Boulder Auburn-Erskine Casper-Frederik Casper-Erskine Boulder-Erskine Auburn-Frederik Boulder-Casper Dresden-Frederik Erskine-Frederik Casper-Dresden 6 0.09 7 8 0.075 0.09 0.0791 0.14 0.1218 0.078 0.12 0.0798 0.15 0.1225 9 0.15 0.09 0.16 0.14 0.11 10 11 0.0915 0.0925 Holding-Period 0 0 Auburn 1.23 1.20 Casper 2.13 2.23 Dresden 2.06 2.55 Frederik 4.87 5.09 1 2 1.43 3.97 Boulder 1.72 2.14 2.35 2.83 2.51 2.44 2.40 Erskine 3.05 4.17 3.79 3.79 5.09 6.11 7.24 3 4 5 1.68 1.80 1.76 2.10 1.96 5.87 6.82 5.23 8.52 10.17 12.50 6 7 3.03 6.68 8 1.89 9.20 7.89 14.83 9 10 11 12 2.78 3.51 4.33 5.33 6.19 0.15 5.99 5.73 6.38 18.97 20.12 21.30 2.41 2.17 1.86 1.92 2.20 2.81 2.98 2.72 2.52 2.37 2.25 0.18 2.05 1.87 1.79 1.93 2.25 2.77 3.51 4.46 4.70 1.68 1.55 1.46 1.37 0.09 1.22 1.20 1.18 1.17 1.24 1.36 1.60 1.90 2.27 13-Dividends 13 14 15 16 17 2.51 4.20 3.73 3.50 4.23 5.35 5.88 6.02 6.47 7.27 7.45 0.22 7.31 8.44 8.71 8.95 10.85 10.91 11.22 10.83 9.79 9.68 9.97 9.58 0.21 9.39 10.04 10.93 10.93 12.54 13.71 6.99 6.87 6.66 6.39 7.59 7.66 18 19 20 6.88 6.06 5.38 0.24 5.09 6.08 6.53 9.08 9.78 8.63 9.13 11.67 12.94 14.12 16.59 17.50 0.27 17.37 18.64 20.62 23.76 25.18 26.37 21 0.35 21.02 25.35 29.47 32.47 34.94 31.93 33.34 32.57 39.15 34.31 43.73 44.41 0.35 44.15 47.87 50.55 57.81 59.34 62.81 22 6.44 6.21 23 24 25-Dividends 25 2.72 3.03 3.34 0.07 3.25 3.52 4.16 4.51 6.21 0.16 6.03 6.26 6.74 6.61 5.39 5.78 6.01 0.20 5.85 6.26 7.18 7.36 7.36 9.87 26 27 28 29 4.51 6.81 30 4.07 6.97 Teams 1 2 Portfolio X 0.09 0.0615 0.095 0.09 0.10 Portfolio Y 0.095 0.062 0.12 0.094 0.102 Portfolio Z 0.11 0.07 0.14 0.11 0.13 3 4 5 Stocks Auburn-Casper Auburn-Boulder Auburn-Erskine Casper-Frederik Casper-Erskine Boulder-Erskine Auburn-Frederik Boulder-Casper Dresden-Frederik Erskine-Frederik Casper-Dresden 6 0.09 7 8 0.075 0.09 0.0791 0.14 0.1218 0.078 0.12 0.0798 0.15 0.1225 9 0.15 0.09 0.16 0.14 0.11 10 11 0.0915 0.0925

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

Step: 3

blur-text-image

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

Handbook Of The Fundamentals Of Financial Decision Making

Authors: Leonard C MacLean, William T Ziemba

1st Edition

9814417343, 978-9814417341

More Books

Students also viewed these Finance questions

Question

Calculate the value for each of Exercises. C(25, 24)

Answered: 1 week ago