Please see attached Please copy and paste data from text area below.Selected delimiter: TabYear2001200220032004200520062007200820092010Dividend0.850.961.011.141.201.261.421.491.681.90 Excellence Inc.'s annual dividends are indicated below. Find the required rate of return for this stock, assuming the future dividend growth rate will remain the same and the company has aninfinite horizon. Assume the January 1, 2011 price of the stock was $46.00. What was the required return for Excellence Inc.'s stock?Year2001200220032004200520062007200820092010Dividend$0.85$0.96$1.01$1.14$1.20$1.26$1.42$1.49$1.68$1.90What was the estimated annual required return for Excellence Inc.'s stock?% (Round to two decimal places.)

The required return on stock can be calculated using the following equation:- P = D2010(1+g)/r-g…

Answered: What was the estimated annual required…

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter8: Basic Stock Valuation

Section: Chapter Questions

Problem 4P

See similar textbooks

Similar questions

CALCULATING THE WACC Here is the condensed 2019 balance sheet for Skye Computer Company (in thousands of dollars): Skyes earnings per share last year were 3.20. The common stock sells for 55.00. last years dividend (D0) was 2.10, and a flotation cost of 10% would be required to sell new common stock. Security analysts are projecting that the common dividend will grow at an annual rate of 9%. Skyes preferred stock pays a dividend of 3.30 per share, and its preferred stock sells for 30.00 per share. The firms before-lax cost of debt is 10%, and its marginal tax rate is 25%. The firms currently outstanding 10% annual coupon rate, long-term debt sells at par value. The market risk premium is 5%, the risk-free rate is 6%, and Skyes beta is 1.516. The firms total debt, which is the sum of the companys short-term debt and long-term debt, equals 1.2 million. a. Calculate the cost of each capital component, that is, the after-tax cost of debt, the cost of preferred stock, the cost of equity from retained earnings, and the cost of newly issued common stock. Use the DCF method to find the cost of common equity. b. Now calculate the cost of common equity from retained earnings, using the CAPM method. c. What is the cost of new common stock based on the CAPM? (Hint: Find the difference between r1 and rs as determined by the DCF method, and add that differential to the CAPM value for rs.) d. If Skye continues to use the same market-value capital structure, what is the firms WACC assuming that (1) it uses only retained earnings for equity and (2) if it expands so rapidly that it must issue new common stock?
The Castle Company recently reported net profits after taxes of $15.8 million. It has 2.5 million shares of common stock outstanding and pays preferred dividends of $1 million a year. The company’s stock currently trades at $60 per share. Compute the stock’s earnings per share (EPS). What is the stock’s P/E ratio? Determine what the stock’s dividend yield would be if it paid $1.75 per share to common stockholders.
Using the Value Line Investment Survey report in Exhibit 11.5, find the following information for Apple. What was the amount of revenues (i.e., sales) generated by the company in 2017? What were the latest annual dividends per share and dividend yield? What is the earnings per share (EPS) projection for 2019? How many shares of common stock were outstanding? What were the book value per share and EPS in 2017? How much long-term debt did the company have in the third quarter of 2018?

Recommended textbooks for you

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

Financial Reporting, Financial Statement Analysis…

Finance

ISBN:

9781285190907

Author:

James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS