Question: The following table contains annual returns for the stocks of Home Depot (HD) and Lowe's (LOW). The returns are calculated using end-of-year prices (adjusted for dividends and stock splits) retrieved from https://www.finance.yahoo.com/. Use Excel to create a spreadsheet that calculates annual portfolio returns for an equally weighted portfolio of HD and LOW. Also, calculate the average annual return for both stocks and the portfolio.
![1472_10.png](https://secure.tutorsglobe.com/CMSImages/1472_10.png)