Hello please answer quick i will leave thumbs up! Also use Microsoft (MSFT) as the stock.

WRITE THE ANSWERS (TABLES/GRAPHS/FORMULAS) BELOW. SUBMIT EXCEL AS A SEPARATE DOCUMENT TO SUPPORT YOUR CALCULATIONS. BUT I NEED TO HAVE TABLES AND FIGURES BELOW. (a) (10 points) Use the traded stock that you have picked in your previous midterm. Namely, find a traded stock whose ticker symbols starts with the same letter as your LAST name. Make sure your selected company has more than 20 years of data coverage. 1 Download the historical data from Yahoo Finance. Use monthly frequency and maximum available time horizon. Calculate monthly returns data. Merge the data on Fama French factors into your returns dataset and make sure the timing is correct. Using merged Rf data and data in (a) calculate monthly excess returns. (b) (10 points) For the whole period of your selected stock data coverage run Fama French regression using LINEST command and report pricing error and factor loadings. (c) (10 points) Repeat (b) for the first 10 years of your stock historical data and for the latest 10 years. Report your answers below. Comment on the results - how do all these measures change