Problem 12-1 Calculating Cost of Equity [LO 1] The Tribiani Company just issued a dividend of $2.40 per share on its common stock. The company is expected to maintain a constant 8 percent growth rate in its dividends indefinitely. If the stock sells for $44.20 a share, what is the company’s cost of equity? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.

How can I calculate using excel? (see screenshot)

1 02:44:38 Redan, Inc., is expected to maintain a constant 6.1 percent growth rate in its dividends, indefinitely. If the company has a dividend yield of 4.6 percent, what is the required return on the company's stock? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Required return %

15

Problem 7-21 Dividend Yield [LO 3] You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Dividend) Dividend Yield % PE Ratio Close Price Net Change Hi Lo 77.40 10.43 Acevedo .36 2.6 6 13.90 −.24 56.31 33.92 Georgette, Incorporated 2.04 5.0 10 40.93 −.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 Find the quote for the Georgette, Incorporated. Assume that the dividend is constant. 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. 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.

Nikul

Q17 A firm does not pay a dividend. It is expected to pay its first dividend of $0.20 per share in three years. This dividend will grow at 11 percent indefinitely. Use a 12 percent discount rate.Compute the value of this stock. (Round your answer to 2 decimal places.) STOCK VALUE

Problem 4: Ordinary Shares, no growth rate: The expected rate of return of the shareholders is 18%. The expected dividend to be received one year from now is P27. What should the value of each share be?

When overhead is overapplied, is the balance of Cost of Goods Sold, before adjustment, too low ortoo high? Why?

pls need help answering in Excel.