Finance Stock Project

Instructions

  • This term project is due on December 11th 2017 at the beginning of the final exam.
  • It is worth 15% of your grade.
  • You are allowed to have at most 2 group members but you could choose to do a solo project.
  • There will be a 10% penalty per day for late assignments.
  • Answer each question in a chronological order.
  • I will not accept any hand written projects.
  • You can email me the project at yunus@gmail.com
  • I will reply with a “RCVD” if I receive your project project.

 

 

Pick 3 REIT stocks and 3 Equity stocks preferably from yahoo finance or google finance and answer the following questions:

  1. Briefly discuss each of the REIT stocks and equity stocks that you picked for your project.

 

  1. Using a twelve year holding period (2005 – 2017), calculate the average annual return for each equity stock, and for each REIT stock for the entire period. Use the formula:
  2. Compare the standard deviation of each individual security over the entire period. Which is the riskiest security and which is the least risky based on the Standard Deviation?

 

  1. Paying special attention to the most recent U.S. housing crisis, break down your data set and compare the risk and return attributes of your individual securities over the pre-crisis period, crisis period and the post-crisis period. Which security was most affected by the crisis and which security was least affected?  Comment on your findings.

 

Pre-crisis: Oct2003-June2007; post-crisis April 2009-present; crisis July 2007-march 2009

  1. Calculate all possible cross-correlations (REIT1 vs REIT2, Stock1 vs Stock2, REIT1 vs Stock1, REIT1 vs Stock2, REIT2 vs Stock1 and REIT2 vs Stock2). How has the correlation among these securities changed over time? Plot each of the price series and comment paying special attention to the most recent US housing crisis.

 

  1. Build three separate portfolios and allocate weights as you wish for each portfolio. Portfolio 1 is the real estate only portfolio, Portfolio 2 is the equity only portfolio and Portfolio 3 is the combined real estate and equity portfolio. Calculate portfolio returns (based on average annual return that you calculated in question 2). Use the following formula :

Where Ws are the weights and Rs are the annual returns.

 

  1. Compare the returns of the real estate only portfolio (Portfolio 1), the equity only portfolio (Portfolio 2), and the combined portfolios (comprised of both real estate and equity) (Portfolio 3). Which portfolio was most affected by the crisis and which portfolio was least affected?   Please discuss the performance of the three portfolios in depth paying special attention to the concept of diversification.

 

  1. Calculate, betas of the individual stocks and each portfolio (1,2 and 3) over the entire period. Use the standard deviations that you calculated in question number 3. Remember, you need to use the following formula to calculate the standard deviation of portfolios:

 

  1. Paying special attention to the most recent U.S. housing crisis, break down your data set and compare the risk and return attributes of each of your three portfolios for the all sub-periods (pre-crisis and post-crisis).

 

  1. Use one of the investment performance measures that we have learnt in  class (such as Treynor ratio) and compare the performance of  the individual securities to those of  each of the three portfolios (Portfolio1, 2 and 3) on a risk-adjusted basis for the entire period and for each of the sub-period. Discuss your results as it relates to portfolio diversification benefits.

 

 

 

Who is the winner in your portfolio?

Order from us and get better grades. We are the service you have been looking for.