Question 1: (25 points)
Write a maximum one-page response with your excel documentation as support (appendices).
o As an individual, use the 5 years’ worth of data on multiple stocks (NASDAQ, NYSE, and TSE) provided in the excel files to choose either 3 or 4 different stocks for investment.
§ How did you choose your stocks?
§ What is the weight of each stock?
§ Why did you choose that weight?
§ What is your expected return on your portfolio and your standard deviation?
o Share your results with your group.
o With your group, use the 5 years’ worth of data on multiple stocks (NASDAQ, NYSE, and TSE) provided in the excel files to choose either 3 or 4 different stocks in which to invest and determine/develop a group porfolio.
§ Why your group chose those particular stocks.
§ How did your group take into account Risk? Return? Correlation between stocks?
o As an individual decide which portfolio you prefer as an investment: your initial portfolio or the group portfolio and why.