Please show all work, including step by step details & formulas in Excel. Also, please provide reference for stock market data.
**(Teacher is very strict and will want to see all work for proper credit.)
Portfolio: Alibaba, FitBit, Macyâ€™s
- Find the holding period return for each stock in your portfolio (Portfolio: Alibaba, FitBit, Macyâ€™s), assuming you purchased each stock at its unadjusted opening price on January 1, 2016 (or the first day the stock market was open in 2016), and sold it at its unadjusted closing price on December 31, 2016 (or the last day the stock market was open in 2016. Would you invest in the portfolio you have chosen? Why or why not?
- Assume that you bought 1,000 shares at each stockâ€™s opening price (from above), and sold them at each stockâ€™s closing price (from above). Use this information to find the return on your portfolio. Would you invest in the portfolio you have chosen? Why or why