12 The table below shows the stock prices of 6 stocks at the end of each 30 holding periods (including at the end of period o), and the dividends given during holding periods 13 and 24. Holding-Period Auburn Boulder Casper Dresden Erskine Frederik 0 1.23 1.72 2.13 2.06 3.05 4.87 1 1.20 2.14 2.23 2.55 4.17 5.09 2 1.43 2.35 2.41 2.51 3.79 3.97 3 1.68 2.83 2.17 4.20 3.79 5.87 4 1.80 2.51 1.86 3.73 5.09 6.82 5 1.76 2.44 1.92 3.50 6.11 5.23 6 2.10 2.40 2.20 4.23 7.24 8.52 7 1.96 3.03 2.81 5.35 6.68 10.17 8 1.89 2.78 2.98 5.88 9.20 12.50 9 1.68 3.51 2.72 6.02 7.89 14.83 10 1.55 4.33 2.52 6.47 6.88 18.97 11 1.46 5.33 2.37 7.27 6.06 20.12 1.37 6.19 2.25 7.45 5.38 21.30 13-Dividends 0.09 0.15 0.18 0.22 0.24 0.35 13 1.22 5.99 2.05 7.31 5.09 21.02 14 1.20 5.73 1.87 8.44 6.08 25.35 15 1.18 6.38 1.79 8.71 6.53 29.47 16 1.17 6.99 1.93 8.95 9.08 32.47 17 1.24 6.87 2.25 10.85 9.78 34.94 18 1.36 6.66 2.77 10.91 8.63 31.93 19 1.60 6.39 3.51 11.22 9.13 33.34 20 1.90 7.59 4.46 10.83 11.67 32.57 21 2.27 7.66 4.70 9.79 12.94 39.15 22 2.72 6.44 5.39 9.68 14.12 34.31 23 3.03 6.21 5.78 9.97 16.59 43.73 24 3.34 6.21 6.01 9.58 17.50 44.41 25-Dividends 0.07 0.16 0.20 0.21 0.27 0.35 25 3.25 6.03 5.85 9.39 17.37 44.15 26 3.52 6.26 6.26 10.04 18.64 47.87 27 4.16 6.74 7.18 10.93 20.62 50.55 28 4.51 6.61 7.36 10.93 23.76 57.81 29 4.51 6.81 7.36 12.54 25.18 59.34 30 4.07 6.97 9.87 13.71 26.37 62.81 2 chosen stocks are Boulder and Erskine. your calculation would be greatly helpful to recheck whether Ive got the right answers here. thank you Your team of investment managers shall form portfolios of investments in 2 stocks according to the list below. Teams Stocks Portfolio X Portfolio Y Portfolio Z 1 Auburn-Casper 0.09 0.095 0.11 2 Auburn-Boulder 0.0615 0.062 0.07 3 Auburn-Erskine 0.095 0.12 0.14 4 Casper-Frederik 0.09 0.094 0.11 5 Casper-Erskine 0.10 0.102 0.13 6 Boulder-Erskine 0.075 0.078 0.09 7 Auburn-Frederik 0.09 0.12 0.15 8 Boulder-Casper 0.0791 0.0798 0.09 9 Dresden-Frederik 0.14 0.15 0.16 10 Erskine-Frederik 0.1218 0.1225 0.14 11 Casper-Dresden 0.0915 0,0925 0.11 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 2). 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 Zif possible) respectively at the end of holding period 30. 12 The table below shows the stock prices of 6 stocks at the end of each 30 holding periods (including at the end of period o), and the dividends given during holding periods 13 and 24. Holding-Period Auburn Boulder Casper Dresden Erskine Frederik 0 1.23 1.72 2.13 2.06 3.05 4.87 1 1.20 2.14 2.23 2.55 4.17 5.09 2 1.43 2.35 2.41 2.51 3.79 3.97 3 1.68 2.83 2.17 4.20 3.79 5.87 4 1.80 2.51 1.86 3.73 5.09 6.82 5 1.76 2.44 1.92 3.50 6.11 5.23 6 2.10 2.40 2.20 4.23 7.24 8.52 7 1.96 3.03 2.81 5.35 6.68 10.17 8 1.89 2.78 2.98 5.88 9.20 12.50 9 1.68 3.51 2.72 6.02 7.89 14.83 10 1.55 4.33 2.52 6.47 6.88 18.97 11 1.46 5.33 2.37 7.27 6.06 20.12 1.37 6.19 2.25 7.45 5.38 21.30 13-Dividends 0.09 0.15 0.18 0.22 0.24 0.35 13 1.22 5.99 2.05 7.31 5.09 21.02 14 1.20 5.73 1.87 8.44 6.08 25.35 15 1.18 6.38 1.79 8.71 6.53 29.47 16 1.17 6.99 1.93 8.95 9.08 32.47 17 1.24 6.87 2.25 10.85 9.78 34.94 18 1.36 6.66 2.77 10.91 8.63 31.93 19 1.60 6.39 3.51 11.22 9.13 33.34 20 1.90 7.59 4.46 10.83 11.67 32.57 21 2.27 7.66 4.70 9.79 12.94 39.15 22 2.72 6.44 5.39 9.68 14.12 34.31 23 3.03 6.21 5.78 9.97 16.59 43.73 24 3.34 6.21 6.01 9.58 17.50 44.41 25-Dividends 0.07 0.16 0.20 0.21 0.27 0.35 25 3.25 6.03 5.85 9.39 17.37 44.15 26 3.52 6.26 6.26 10.04 18.64 47.87 27 4.16 6.74 7.18 10.93 20.62 50.55 28 4.51 6.61 7.36 10.93 23.76 57.81 29 4.51 6.81 7.36 12.54 25.18 59.34 30 4.07 6.97 9.87 13.71 26.37 62.81 2 chosen stocks are Boulder and Erskine. your calculation would be greatly helpful to recheck whether Ive got the right answers here. thank you Your team of investment managers shall form portfolios of investments in 2 stocks according to the list below. Teams Stocks Portfolio X Portfolio Y Portfolio Z 1 Auburn-Casper 0.09 0.095 0.11 2 Auburn-Boulder 0.0615 0.062 0.07 3 Auburn-Erskine 0.095 0.12 0.14 4 Casper-Frederik 0.09 0.094 0.11 5 Casper-Erskine 0.10 0.102 0.13 6 Boulder-Erskine 0.075 0.078 0.09 7 Auburn-Frederik 0.09 0.12 0.15 8 Boulder-Casper 0.0791 0.0798 0.09 9 Dresden-Frederik 0.14 0.15 0.16 10 Erskine-Frederik 0.1218 0.1225 0.14 11 Casper-Dresden 0.0915 0,0925 0.11 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 2). 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 Zif possible) respectively at the end of holding period 30