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

\fCOMEX + CC K C Bb Bb Bb Bb Bb . * in PQ y! C File | /Users/christinemabry/Downloads/CH.pdf mod 5 2 / 2 100% + 8/1/15 512.890015 8/1/15 1972.18 8/1/15 0.07 7/1/15 536.150024 7/1/15 2103.84 7/1/15 0.03 6/1/15 434.089996 6/1/15 2063.11 6/1/15 0.02 5/1/15 429.230011 5/1/15 2107.39 5/1/15 0.02 4/1/15 421.779999 4/1/15 2085.51 4/1/15 0.02 3/1/15 372.100006 3/1/15 2067.89 3/1/15 0.03 2/1/15 380.160004 2/1/15 2104.5 2/1/15 0.02 1/1/15 354.529999 1/1/15 1994.99 1/1/15 0.03 2/1/14 310.350006 2/1/14 2058.9 12/1/14 0.03 184672.9711 131480.1765 1.404568932 SUMMARY OUTPUT Beta (investopedia formula)= 1.404568932 Regression Statistics Multiple R 0.657612112 R Square 0.43245369 Adjusted R 0.422668409 Standard Error 6.391194008 Observations 60 ANOVA df MS Significance F Regression 1805.220672 1805.220672 44.19430374 Residual 1.14E-08 58 2369.146929 40.84736085 Total 4174.367602 Coefficients Standard Error t Stat Intercept 2.666442622 0.827143494 3.223675991 P.value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 0.002079164 1.010735029 X Variable 1 1.562877771 0.235094174 6.647879642 4.322150215 1.010735 1.14E-08 1.092285653 2.033469888 1.092286 2.03347 8 A esc F1 19. F2 30 F3 880 F4 F6 FS F7 FB @ 2 3 4 5 Q W E R T Y U S D G H K Z X C V