Question: Please answer this question, it is the second time I post this question but they didn't give me answer? Compute the Beta of AMZN stock

Please answer this question, it is the second time I post this question but they didn't give me answer?

Compute the Beta of AMZN stock compare to the benchmark represented by the S&P500 index over 61 months.

a. Compute the monthly log returns of AMZN.

b. Compute the excess returns of AMZN by subtracting to a) the monthly return of the 10-year US Government Bond yield.

c. Compute the log returns of the S&P500 index.

d. Compute the excess returns of the S&P500 index by subtracting to c) the monthly return of the 10-year US Government Bond yield.

e. Apply an OLS by using the toolbox of Excel (Data/ Data Analysis/Regression) b) (dependent variable) versus d) (independent variable).

f. Is Bta significant ? Why ?

g. Adjust Bta, making the hypothesis that the standard error of Bta population is equal to 0.30. What is the value of Adjusted Bta ?

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!

Q:

Hi Ruchi, I need help with the attached assignment. It's due in about a week. Thanks 1) The paper should be written in APA style Research Paper format. This is the link that explains the research...

Q:

Defense Cross Examination of Corey Hyde 1. D: \"Mr. Hyde, is it true when you originally acquired your position as Avery Bancroft's assistant at the Black Bear Casino, you were not thrilled at the...

Q:

CLOSING ARGUMENTS A Closing Argument should: 1. Repeat your theory and theme of the case 2. Summarize the evidence that preceded it 3. Relate the evidence to the law and the legal issues (i.e....

Q:

Once you have read the article ?Comparing the Accuracy and Explainability of Dividend, Free Cash Flow, and Abnormal Earnings Equity Value Estimates?, review and complete the questions below. Use the...

Q:

Opening Statement for Defense The 1948 U.S. Presidential election was a hard fight for Harry Truman. No one thought he had a shot and the folks at the Chicago Daily Tribune didn't think so either. At...

Q:

CLOSING ARGUMENTS A Closing Argument should: 1. Repeat your theory and theme of the case 2. Summarize the evidence that preceded it 3. Relate the evidence to the law and the legal issues (i.e....

Q:

subject: Discrete structu Project Goal: The main goal of the project is to let students use their prior knowledge, try to use the skills they have learnt to solve real world problems. Using this...

Q:

Please answer this question: Are plant-based meat substitute products just a fad? Also, how likely is it that a large percentage of the worlds population will switch from eating animal meats to...

Q:

Part II - Supply and Demand (18 points - 3 points each) There are six separate questions below. Each question begins with a news headline. After you read the headline in bold, please answer the...

Q:

please answer these question and finish them in 3 hours, give the detail andexplanation of the every step to me , thank you ! Examination Cover Page Examination Period: Academic Institution: Academic...

Q:

In the course of the audit of Brand Drug Limited (BDL), the CA, while reviewing the draft financial statements for the year ended August 31, 20X6, noticed that BDLs investment in National...

Q:

Question Assumption Total Fixed Cost $3,150 Sale Volume 175 units 180 units 195 units 200 units : Calculate the Operating Income 225 units 320 units Contribution Margin per unit $27 $27 $27 $27 $27...

Q:

Which of these is not a goal for a bank when implementing loan covenants on a commercial relationship? a . Protect the bank b . Provide advance - warning signs of difficulty c . Identify key risks to...

Q:

WHAT IS the cash flow statement BBINFIT ,AND HOW WE CAN ANALAYSES

Q:

=+p. A1). That same day, the interest rate on 30-year U.S. government bonds rose from 6.46

Q:

=+ d. The war makes U.S. consumers uncertain about the future, and the consumers save more in response.

Q:

=+ a. The U.S. government, fearing it may need to enter the war, increases its purchases of military equipment.