A-D drop down is month and year; use MSFT and data from Yahoo finance. This is one question; if it is not answered fully, it will be downvoted.

a. What is the most recent month in which the company return moves in the opposite direction of the S&P 500 (SPY) return? (0.5 points) (ic. Firm monthly return is positive & market return negative, or vice-versa.) Choose from the drop down boxes below b. In what month was the largest positive monthly return for the company in the past 5 years? (0.5 points) Choose from the drop down boxes below c. What was the largest positive monthly return? Enter answer in highlighted cell below. NOTE: Enter 15.1% as 15.1 NOT 0.151 (0.5 points % d. In what month was the largest negative monthly return for the company in the past five years? (0.5 points) e. What was the largest negative monthly return? Enter answer in highlighted cell below NOTE: Enter -15.1% as 15.1 NOT -0.151 (0.5 point % f. Based on the line Graph 1 would you say that your company returns and S&P 500 (SPY) returns. (0.5 points) one is positive the other will be negative). 11) s move in opposite directions 2) often move in the opposite directions. 3) seldom move in the same direction. u 4) sometimes move in the same direction. 5) often move in the same direction. 6) always move in the same direction. escribe the calculations for the following cells: a. What is the most recent month in which the company return moves in the opposite direction of the S&P 500 (SPY) return? (0.5 points) (ic. Firm monthly return is positive & market return negative, or vice-versa.) Choose from the drop down boxes below b. In what month was the largest positive monthly return for the company in the past 5 years? (0.5 points) Choose from the drop down boxes below c. What was the largest positive monthly return? Enter answer in highlighted cell below. NOTE: Enter 15.1% as 15.1 NOT 0.151 (0.5 points % d. In what month was the largest negative monthly return for the company in the past five years? (0.5 points) e. What was the largest negative monthly return? Enter answer in highlighted cell below NOTE: Enter -15.1% as 15.1 NOT -0.151 (0.5 point % f. Based on the line Graph 1 would you say that your company returns and S&P 500 (SPY) returns. (0.5 points) one is positive the other will be negative). 11) s move in opposite directions 2) often move in the opposite directions. 3) seldom move in the same direction. u 4) sometimes move in the same direction. 5) often move in the same direction. 6) always move in the same direction. escribe the calculations for the following cells