Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Development Finance Innovations For Sustainable Growth

Authors: Nicholas Biekpe, Danny Cassimon, Andrew William Mullineux

1st Edition

331954165X, 978-3319541655

More Books

Students also viewed these Finance questions