Explore BrainMass
Share

Explore BrainMass

    EPS - Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com October 9, 2019, 7:41 pm ad1c9bdddf
    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.

    $2.19