Transcribed Image Text
The stocks are as follows: Macy's, Microsoft, Amazon, Facebookand Apple. Create a portfolio that invests 24% of $1 million incompany A, 22% in company B, 20% in company C, 18% in company D,and 16% in company E.What is the buy-and-hold return (HPR) for each of the 5 stocksand for the portfolio during the last calendar year (2018). Thismeans you are buying on Dec 31, after markets close, and selling onDec 31 of the following year, after markets close. Please make sureto show your work. You will need stock price/return data on the 5companies. To get the stock price/return data, go to Yahoo Finance,enter the ticker, click on “Historical Prices”, select the startand end date, and make sure “daily” is selected. Click on “GetPrices”, and use Adj. Close to calculate returns (Adj. Closeadjusts for dividends, stock splits, etc.).