This assignment is to be completed using Microsoft Excel. It is due on April 17, 2021 at 11:59pm PROBLEM 1: Plotting Capital Allocation Line Exercise 1. Go to Yahoo Finance and download 5 years of monthly price data (March 2016 to March 2021) on the SPY (it is an ETF that tracks the S&P 500 stock market index). This will be our risky asset 2. Using only the historical adjusted closing price data, compute the monthly returns Price in ending month, price in beginning month Return= price in beginning month 3. Compute your average monthly return (using the AVERAGE FUNCTION in excel) 4. Compute the standard deviation of your monthly returns (using the STDEV.S FUNCTION in excel) This assignment is to be completed using Microsoft Excel. It is due on April 17, 2021 at 11:59pm PROBLEM 1: Plotting Capital Allocation Line Exercise 1. Go to Yahoo Finance and download 5 years of monthly price data (March 2016 to March 2021) on the SPY (it is an ETF that tracks the S&P 500 stock market index). This will be our risky asset 2. Using only the historical adjusted closing price data, compute the monthly returns Price in ending month, price in beginning month Return= price in beginning month 3. Compute your average monthly return (using the AVERAGE FUNCTION in excel) 4. Compute the standard deviation of your monthly returns (using the STDEV.S FUNCTION in excel)