On January 3, 2019, Bristol-Myers Squibb Company (NYSE: BMY) announced that BMY would acquire Celgene Corporation (NASDAQ: CELG) in a cash and stock transaction (see Appendix for details). You are hired as a financial analyst to analyze the financial aspects of this merger. Using/Analyzing historical daily data on stock prices of BMY and CELG as well as index prices of S&P 500 provided in the sheets named: BMY, CELG, and S&P500, respectively, answer the following questions: For QS 1-8, you must show your work on the sheet named "Part I Worksheet" to receive any credit. Q1. What is the beta of BMY? Use returns on S&P500 as market returns. Use the January 3, 2018 - December 31, 2018 period to estimate the beta (5 pts) On January 3, 2019, Bristol-Myers Squibb Company (NYSE: BMY) announced that BMY would acquire Celgene Corporation (NASDAQ: CELG) in a cash and stock transaction (see Appendix for details). You are hired as a financial analyst to analyze the financial aspects of this merger. Using/Analyzing historical daily data on stock prices of BMY and CELG as well as index prices of S&P 500 provided in the sheets named: BMY, CELG, and S&P500, respectively, answer the following questions: For QS 1-8, you must show your work on the sheet named "Part I Worksheet" to receive any credit. Q1. What is the beta of BMY? Use returns on S&P500 as market returns. Use the January 3, 2018 - December 31, 2018 period to estimate the beta (5 pts)