Question: The excel spreadsheet provided gives you Amazon s monthly prices for 6 0 months from 1 2 / 0 1 / 2 0 1 4

The excel spreadsheet provided gives you Amazons monthly prices for 60 months from 12/01/2014 to 12/01/2019. You are also given the S&P 500 indexs corresponding monthly prices. Use the S&P 500 to proxy for the market. You are also given the 3 months treasury bills 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 stocks beta. Using Excel, perform a regression analysis that examines the relationship between the Amazon risk premium and the S&P 500s risk premium. Upload your spreadsheet and use your findings to answer the following:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!