Question

In: Finance

If I were to provide you with 50 years of monthly returns on the S&P500 and...

  1. If I were to provide you with 50 years of monthly returns on the S&P500 and on the Barclays Aggregate Bond Index, how would you go about calculating the efficient frontier of investment opportunities?  By that I mean, determine
    1. What variables you need to calculate from the return data?
    2. What optimization problem would you need to solve, i.e., what are you going to maximize or minimize?
    3. What restrictions would you need to place on the optimization problem?
    4. How would you determine the starting point of the efficient frontier?

If I asked you to determine the optimal portfolio for a client, what information would you need?  Once that information is provided, what optimization problem would you solve to identify the optimal portfolio (what are you going to maximize or minimize)?  What constraints would you place on this problem?

Solutions

Expert Solution

a) The main variables needed for an efficient frontier are Risk (standard deviation of returns) and return of the portfolio. The efficient frontier is a set of optimal portfolios which have highest returns for a given level of risk, or lowest risk for a given level of returns. With Returns on Y axis and Risk on X axis.

b) You will Maximize returns for a given level of risk. Or minimize Risk for a given level of return. So if you take the graph, along the x-axis - Standard Deviation (Risk) you will plot all portfolios, the ones with the highest returns will form the efficient frontier. Another way to go about this is, you can plot the various portfolios which provide the lowest risk for a given level of returns. Combining these two, you should get your efficient frontier.

c) Constrains or restrictions would be -
1) Transactions costs are tricky to account for.
2) Optimization is hard.
3) Returns have to be normally distributed for mean-variance optimization.
4) May not be able to account for short sales as retail investor, thus, there should be a restriction of portfolio weights should be positive.

d) The starting point of the efficient frontier (left side of the graph) will be the portfolio with the lowest variance (risk). This is called the minimum variance portfolio.


Related Solutions

Month Monthly Returns (%) Month Monthly Returns (%) Month Monthly Returns (%) Ended Yahoo Google S&P500...
Month Monthly Returns (%) Month Monthly Returns (%) Month Monthly Returns (%) Ended Yahoo Google S&P500 Ended Yahoo Google S&P500 Ended Yahoo Google S&P500 Dec-07 -13.241 -0.219 -0.692 Dec-06 -5.442 -5.018 1.403 Dec-05 -2.610 2.457 0.036 Nov-07 -13.794 -1.980 -4.182 Nov-06 2.544 1.767 1.899 Nov-05 8.818 8.806 3.778 Oct-07 15.861 24.632 1.590 Oct-06 4.193 18.534 3.257 Oct-05 9.249 17.595 -1.668 Sep-07 18.093 10.096 3.736 Sep-06 -12.314 6.174 2.575 Sep-05 1.561 10.650 0.810 Aug-07 -2.237 1.029 1.497 Aug-06 6.227 -2.087 2.376...
Here are the total returns for the S&P500 for the first ten years of this century....
Here are the total returns for the S&P500 for the first ten years of this century. Assume you invested $1 in the S&P500 on January 1, 2001. Your first year's return was -11.85%. Year Return 2001 -11.85% 2002 -21.97% 2003 28.36% 2004 10.74% 2005 4.83% 2006 15.61% 2007 5.48% 2008 -36.55% 2009 26.94% 2010 18.00% 4 points. Q1. If you invested $1 at the beginning of the time frame [1/1/2001], how much would it be worth five years later? Show...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222 is equivalent to -2.22%). A S_P500 -0.0222 0.0032 -0.0048 -0.0058 0.1333 0.0434 0.0765 0.1081 -0.0161 -0.0121 0.1250 0.1400 0.0145 0.0368 -0.0475 -0.0454 0.0430 0.0577 -0.0260 -0.1374 0.0071 0.0064 0.0249 0.0186 0.0850 0.0215 -0.0624 -0.0752 0.0933 0.0365 0.0456 0.0528 -0.0632 -0.0131 0.0450 0.0009 0.0200 0.0017 0.0280 0.0985 Suppose that the next S&P500 return will be 7%. Use the CAPM model to calculate the expected return...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222 is equivalent to -2.22%). A S_P500 -0.0222 0.0032 -0.0048 -0.0058 0.1333 0.0434 0.0765 0.1081 -0.0161 -0.0121 0.1250 0.1400 0.0145 0.0368 -0.0475 -0.0454 0.0430 0.0577 -0.0260 -0.1374 0.0071 0.0064 0.0249 0.0186 0.0850 0.0215 -0.0624 -0.0752 0.0933 0.0365 0.0456 0.0528 -0.0632 -0.0131 0.0450 0.0009 0.0200 0.0017 0.0280 0.0985 Assuming normal distribution, what is the probability that the next S&P500 return will be greater than 0? Please...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222 is equivalent to -2.22%). A S_P500 -0.0222 0.0032 -0.0048 -0.0058 0.1333 0.0434 0.0765 0.1081 -0.0161 -0.0121 0.1250 0.1400 0.0145 0.0368 -0.0475 -0.0454 0.0430 0.0577 -0.0260 -0.1374 0.0071 0.0064 0.0249 0.0186 0.0850 0.0215 -0.0624 -0.0752 0.0933 0.0365 0.0456 0.0528 -0.0632 -0.0131 0.0450 0.0009 0.0200 0.0017 0.0280 0.0985 What is the sample standard deviation of the stock A returns? Please write an answer in decimals. For...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222...
Below are returns on the stock A and S&P500 index. All numbers are in decimals (-0.0222 is equivalent to -2.22%). A S_P500 -0.0222 0.0032 -0.0048 -0.0058 0.1333 0.0434 0.0765 0.1081 -0.0161 -0.0121 0.1250 0.1400 0.0145 0.0368 -0.0475 -0.0454 0.0430 0.0577 -0.0260 -0.1374 0.0071 0.0064 0.0249 0.0186 0.0850 0.0215 -0.0624 -0.0752 0.0933 0.0365 0.0456 0.0528 -0.0632 -0.0131 0.0450 0.0009 0.0200 0.0017 0.0280 0.0985 Assuming normal distribution, what is the probability that the next stock A return will be less than 0?...
What is the average monthly return and standard deviation of returns for (i) S&P 500: Date...
What is the average monthly return and standard deviation of returns for (i) S&P 500: Date Adj Close 8/1/2015 1972.18 9/1/2015 1920.03 ######## 2079.36 ######## 2080.41 ######## 2043.94 1/1/2016 1940.24 2/1/2016 1932.23 3/1/2016 2059.74 4/1/2016 2065.3 5/1/2016 2096.95 6/1/2016 2098.86 7/1/2016 2173.6 8/1/2016 2170.95 9/1/2016 2168.27 ######## 2126.15 ######## 2198.81 ######## 2238.83 1/1/2017 2278.87 2/1/2017 2363.64 3/1/2017 2362.72 4/1/2017 2384.2 5/1/2017 2411.8 6/1/2017 2423.41 7/1/2017 2470.3 8/1/2017 2471.65 9/1/2017 2519.36 ######## 2575.26 ######## 2584.84 ######## 2673.61 1/1/2018 2823.81 2/1/2018 2713.83...
Use the following 5-year sample on annual returns on S&P500 index and XYZ to calculate XYZ's...
Use the following 5-year sample on annual returns on S&P500 index and XYZ to calculate XYZ's Coecient of Variation, Sharpe ratio, and Beta. The yield-to-maturity on one-year T-Bills is 2%. Year S&P500 XYZ 2014 0.01 0.02 2015 0.06 0.11 2016 0.02 0.05 2017 0.005 -0.01 2018 0.01 0.02
You have run a regression of monthly returns on a stock against monthly returns on the...
You have run a regression of monthly returns on a stock against monthly returns on the S&P 500 index, and come up with the following output: Rstock = 0.25% + 1.25 RMarket R2 = 0.60 The current one-year treasury bill rate is 4.8%, the current ten-year bond rate is 7.25% and the current thirty-year bond rate is 8%. The firm has 10 million shares outstanding, selling for $10 per share. i. What is the expected return on this stock over...
You have run a regression of monthly returns on a stock against monthly returns on the...
You have run a regression of monthly returns on a stock against monthly returns on the S&P 500 index, and come up with the following output: Rstock = 0.25% + 1.25 RMarket R2 = 0.60 The current one-year treasury bill rate is 4.8%, the current ten-year bond rate is 7.25% and the current thirty-year bond rate is 8%. The firm has 10 million shares outstanding, selling for $10 per share. The mean market return is 8.5% and the ERP is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT