Retained earnings versus new common stock Using the data for a firm shown in the following table, calculate the cost of retained earnings and the cost of new common stock using the constant-growth valuation model. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Current market price per share $36.00 a. The cost of retained earnings is %. (Round to two decimal places.) Dividend growth rate 9% Projected dividend per share next year $1.08 G Underpricing Flotation cost per share per share $2.50 $2.00

son.2

*Please solve using excel and explain formulas. Question: Here are forecasts for next year for two stocks:   Stock A Stock B Return on equity   17 %   14 % Earnings per share $ 3.00   $ 2.50   Dividends per share $ 2.00   $ 2.00     a. What are the dividend payout ratios for each firm?  b. What are the expected dividend growth rates for each stock? Assume dividend has a steady growth for both stocks. c. If investors require a return of 17% on each stock, what are their values?

You've collected the following information from your favorite financial website. 52-Week Price Dividend Hi Lo Stock (Dividend) Yield % PE Ratio Close Price Net Change 77.40 10.43 Acevedo .36 2.6 6 13.90 -.24 55.96 33.57 Georgette, Incorporated 1.69 4.2 10 40.58 -.01 130.93 69.50 YBM 2.00 2.2 10 88.97 3.07 50.24 35.00 13.95 Manta Energy .80 5.2 15.43 -.26 20.74 winter sports .32 1.5 28 ?? .18 Find the quote for the Georgette, Incorporated. Assume that the dividend is constant. a. What was the highest dividend yield over the past year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. b. What was the lowest dividend yield over the past year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. a. Highest dividend yield b. Lowest dividend yield -7.54% 3.96 %

Use the Constant Dividend Growth Model to determine the expected annual growth rate of the dividend for ELO stock. The firm is expected to pay an annual divided of $8.9 per share in one year. ELO shares are currently trading for $144.48 on the NYSE, and the expected annual rate of return for ELO shares is 12.86%. Answer as a % to 2 decimal places (e.g., 12.34% as 12.34).

use EXCEL and provide Cell References for Calculations.

You've collected the following information from your favorite financial website. 52-Week Price Dividend Hi 78.20 Lo Stock (Dividend) Yield % PE Ratio Close Price Net Change 10.51 Acevedo .44 3.0 6 14.70 -.24 55.81 33.42 Georgette, Incorporated 1.54 3.8 10 40.43 -.01 130.93 69.50 YBM 2.00 2.2 10 88.97 3.07 50.24 13.95 Manta Energy .80 5.2 6 15.43 -.26 35.00 20.74 Winter Sports .32 1.5 28 ?? .18 According to analysts, the growth rate in dividends for Acevedo for the previous 10 years has been 3.5 percent. If investors feel this growth rate will continue, what is the required return for the company's stock? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. Required return 6.86 %

Rahu

You've collected the following information from your favorite financial website. 52-Week Price Dividend Hi 77.40 Lo Stock (Dividend) Yield % PE Ratio Close Price Net Change 10.43 Acevedo .36 2.6 6 13.90 -.24 55.81 33.42 Georgette, Incorporated 1.54 3.8 10 40.43 -.01 131.10 50.24 35.00 70.35 YBM 2.85 3.2 10 89.14 3.07 13.95 Manta Energy .80 5.2 6 20.74 Winter Sports .32 1.5 28 15.43 ?? -.26 .18 According to analysts, the growth rate in dividends for YBM for the next five years is expected to be 20 percent. Suppose YBM meets this growth rate in dividends for the next five years and then the dividend growth rate falls to 5.25 percent, indefinitely. Assume investors require a return of 13 percent on YBM stock. According to the dividend growth model, what should the stock price be today? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. Current stock price

Using the constant dividend growth model, determine the percentage price change in a share when the required rate of return decreases from 19 to 17 per cent combined with a decrease in the dividend growth rate from 11 to 9 per cent. Select one: A. fall less than 2% B. rise more than 2%. C. rise less than 3% D. fall more than 2%