# EPS - Excel

Earnings per share in 2007 was $2.82, and in 2002 it was $1.65. The company's payout ratio is 30%, and the stock is currently valued at $41.50. Flotation costs for new equity will be 15%. Net income in 2008 is expected to be $15 million. The market-value weights of the firm's debt and equity are 40% and 60% respectively.

a. Based on the five-year track record, what is EPS growth rate? What will the dividend be in 2008?

b. Calculate the firm's cost of retained earnings, and the cost of new common equity.

c. Calculate the breakpoint associated with retained earnings.

d. If the after-tax cost of debt is 8%, what is the WACC with retained earnings? With new common equity?

https://brainmass.com/business/accounting/eps-excel-125869

#### Solution Preview

CAGR Growth= 11.31% ((Current year/Base year)^1/Duration

Thus EPS growth rate is 11.31%.

In 2008 assuming the above EPS growth rate , EPS for 2008 will be EPS 2007* (1+growth rate)=

Expected dividend per share = EPS * dividend payout ratio= $0.94

b. Calculate the firm's cost of retained earnings, and the cost of new common equity.

Cost of retained earnings

Cost of equity= Ks= (DIV1/Po)+g 13.58%

Div1= ...

#### Solution Summary

This solution answers 4 EPS questions, addressing growth rate, retained earnings, common equity and dividends.