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 months from to You are also given the S&P indexs corresponding monthly prices. Use the S&P to proxy for the market. You are also given the months treasury bills percentage return over the period. The Tbill return represents the riskfree 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 s 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
