Constructing portfolios and efficient frontiers
Not what you're looking for?
Assume the expected returns, standard deviations, and correlations for well-diversified portfolios of US stocks, US bonds, US real estate and international stocks are given as follows. The risk-free rate is 4%.
Expected Annual Return
Annual Standard Deviation
US Stocks
9%
19%
US Bonds
5.5%
11%
US Real Estate
6%
12%
International Value Stocks
10%
21%
Emerging Markets Equities
10.5%
26%
Annual Correlations are as follows:
US Stocks
US Bonds
US Real Estate
International Value Stocks
Emerging Markets
US Stocks
1
US Bonds
55%
1
US Real Estate
35%
30%
1
Int'l Value Stocks
50%
20%
25%
1
Emerging Markets
45%
25%
10%
40%
1
1) Derive the efficient frontier using US stocks, bonds, real estate, international value stocks, and emerging markets equities. (Hint: Use Solver. In setting the objective function and the constraints, do not permit short-sales, and recall that the goal is to choose the portfolio weights that minimize the level of portfolio risk, given some level of expected return. Start with the level of portfolio expected return equal to that of 5.5%, and then lower this constraint in 0.5% increments until you reach 10%)
2) Find the minimum variance portfolio. What are the expected return and standard deviation of this portfolio?
3) Find the market portfolio. What are the expected return and standard deviation of the market portfolio?
4) Chart the capital market line on the efficient frontier.
Purchase this Solution
Solution Summary
Constructing portfolios and efficient frontiers, calculating the returns/risks for each portfolio and finding the minimum variance portfolio using excel.
Solution Preview
Refer to the excel sheet for calculations
Step 1 lists all of the information you've provided.
Step 2
First of all, we have a correlation matrix and we need a covariance matrix for calculating portfolio variances, so we need to convert that using
cov(x,y) = cor(x,y)*sd(x)*sd(y)
You will see that I've computed the covariance matrix in step 2.
Step ...
Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Operations Management
This quiz tests a student's knowledge about Operations Management
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.