Estimate the intercept alpha and beta for walgreens stock

Assignment Help Finance Basics
Reference no: EM13569206

EXCEL Below is nine months" return data for Walgreens and the S&P 500.

  1. Estimate the intercept (alpha) and beta for Walgreens stock using spreadsheet functions.
  2. Interpret what the slope estimate means to a stock analyst.
  3. Compute the R-squared of the regression using Excel"s RSQ function. What does the R-squared tell us about the relation- ship between Walgreens" returns and those of the market?

MONTH

WALGREENS RETURN

S&P500 RETURN

1

2.0%

7.5%

2

- 5.9%

1.8%

3

0.2%

8.2%

4

2.0%

- 6.4%

5

-2.2%

-1.1%

6

- 14.3%

- 2.5%

7

-6.0%

0.5%

8

4.9%

7.7%

9

- 7.9%

- 6.4%

Reference no: EM13569206

Questions Cloud

A firms stockholders equity totals 9 million and the firm : a firms stockholders equity totals 9 million and the firm has issued 600500 shares of common stock. calculate the
The following information is available for the current year : capital city corporation uses the conventional retail inventory method to determine its ending inventory at cost. the
What is the internal rate of return that turnbull can earn : turnbull corp. is in the process of constructing a new plant at a cost of 30 million. it expects the project to
Explain the concept of family life cycle and its use in : explain the concept of family life cycle and its use in marketing. choose one stage and give 4 products that might be
Estimate the intercept alpha and beta for walgreens stock : excel below is nine months return data for walgreens and the sampp 500.estimate the intercept alpha and beta for
Occasionally after a volatile incident between police and a : occasionally after a volatile incident between police and a suspect the community may rally to protest the actions of
What tools can be used for financial statement analysis : what tools can be used for financial statement analysis? what do these tools tell you about financial performance? what
What is the fasb codification system what is the purpose of : what is the fasb codification system? what is the purpose of the fasb codification system? how can it be used to make
Glide ride pays a selling commission equal to 5 of the : glide ride tire and rubber company has capacity to produce 170000 tires. glide ride presently produces and sells 130000

Reviews

Write a Review

Finance Basics Questions & Answers

  You sold a stock short for 50 and maintained the position

1.you sold a stock short for 50 and maintained the position for two years dur- ing which the stock paid an annual

  General hospital has a current ratio of 05 which of the

general hospital has a current ratio of 0.5. which of the following actions would improve increase this ratiogt 1. use

  What is the cross rate between francs and pounds

Suppose the exchange rate between U.S. dollars and the Swiss franc is SFr1.4 = $1, and the exchange rate between the dollar and the British pound is £1 = $1.70. What then is the cross rate between francs and pounds? Round your answer to two decima..

  Explain what is meant by the signaling effects of dividend

explain what is meant by the signaling effects of dividend

  Should new york company proceed with this purchase

Should New York Company proceed with this purchase? Calculate the NPV and the PAYBACK period to make your decision.

  Has a valid inter vivos gift taken place to either of you

A week later she passes away, the watch is found in her desk and you discover that she made the same promise to your brother. Has a valid inter vivos gift taken place to either of you?

  Assume that portfolios a and b are well diversified and

assume that portfolios a and b are well diversified and that their expected rates of return are at 0.13 and 0.09

  Explanation of mergers and acquisitions

What objectives do you think companies aim to accomplish in M&A deals? What are the success factors?

  What was the annualized rate of return to the swiss investor

Today, at maturity, the exchange rate is 1.324 Swiss Francs per dollar. What was the annualized rate of return to the Swiss investor?

  What is the nal

If there is a positive Net Advantage to Leasing the firm will lease the equipment. Otherwise, it will buy it. What is the NAL?

  Partida inc has provided the following data concerning a

partida inc. has provided the following data concerning a proposed investment projectinitial investment861000annual

  An increase in the domestic interest rate causes the demand

1 an increase in the domestic interest rate causes the demand for domestic assets to and the domestic currency to

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd