Module 5 Mini-Case Assignment The excel spreadsheet provided gives you Amazon's monthly prices for 60 months from 12/01/2014 to 12/01/2019. You are also given the S&P 500 index's corresponding monthly prices. Use the S&P 500 to proxy for the market. You are also given the 3 month's treasury bill's percentage return over the period. The T-bill return represents the risk-free rate. You want to know how Amazon moves compared to the market. To do so, you need to estimate the stock's beta. Using Excel, perform a regression analysis that examines the relationship between the Amazon risk premium and the S&P 500's risk premium. Upload your spreadsheet and use your findings to answer the following:

1) What is Amazon's return on 12/01/2019?

a. -4.87%

b. 6.67%

c. 2.61%

d. 4.05%

2) What is the S&P 500's return on 12/01/2019?

a. 2.85%

b. -1.80%

c. 8.59%

d. 7.86%

3) What is Amazon's return on 01/01/2015?

a. 13.35%

b. 14.23%

c. 7.76%

d. 5.48%

4) What is the S&P 500's return on 01/01/2015?

a. -6.25%

b. 8.29%

c. -3.10%

d. -5.70%

5) What is Amazon's risk premium on 12/01/2019?

a. 0.69%

b. 1.07%

c. 6.19%

d. 11.2%

6) What is the S&P's 500 risk premium on 12/01/2019?

a. 0.58%

b. 0.39%

c. -1.7%

d. 1.32%

7) What is Amazon's risk premium on 01/01/2015?

a. 14.20%

b. 12.63%

c. 23.84%

d. 17.89

8) What is the S&P 500's risk premium on 01/01/2015?

a. 1.03%

b. -6.33%

c. -3.13%

d. 0.83%

9) What is Amazon's beta?

a. 2.667

b. 1.56

c. 0.79

d. 2.33

10) Is Amazon riskier than the market?

a. Yes, Amazon seems to be riskier than the market

b. No, Amazon seems less risky than the market