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

  What is the afn for the coming year

Based on the AFN equation, what is the AFN for the coming year? Dollars are in millions.

  If the company uses a discount rate of 15 percent on its

present value of an ordinary annuity dynamics telecommunications corp. has made an investment in another company that

  What are the after-tax cash flows for the company

Assume a corporation has earnings before depreciation and taxes of $100,000, depreciation of $25,000, and that it has a 25 percent tax bracket. What are the after-tax cash flows for the company?

  What is after tax cost of debt

Mullineaux Corporation has a target capital structure of 63 percent common stock, 8 percent preferred stock, and 29 percent debt. Its cost of equity is 13.3 percent, the cost of preferred stock is 6.3 percent, and the cost of debt is 8.0 percent. ..

  What is the firm''s tax adjusted wacc?

Mustard Patch Doll Company needs to purchase new plastic moulding machines to meet the demand for its product. The cost of the equipment is $100,000. It is estimated that the firm will generate, after tax, operating cash flow (OCF) of $22,000 per yea..

  Determine the approximate cost of cash discount

XieCorp is analyzing credit terms of each of three suppliers, A, B, and C. Calculate the approximate cost of giving up the cash discount.

  Alan had saved up 252000 how much more must he save each

1. if you deposit 15000 today and earn 8 annual interest how much will you have in 9 years?2. tiffany will receive a

  What is the companys weighted average cost of capital

What is the company's weighted average cost of capital?

  Find the market value and cost of capital

The U Corporation and the L Corporation are identical in all aspects except that U Co. is all-equity financed while L Co. has $1,000 debt in 6% perpetual bonds outstanding.

  What is the current equilibrium price of the stock

what is the current equilibrium price of the stock?" please show work!

  What are the basic requirements for the project plans

This was quick and easy, but it has its shortcomings, and the Earned Value Management process is said to be better.

  How much will sarah payments be

She will make a 25% down payment and her friend will finance the balance with a mortgage calling for annual payments over 20 years at 8.5% per annum interest. How much will Sarah's payments be?

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