DFB, Inc. expects earnings next year of %4.79 per share, and it plans to pay a $3.11 dividend to shareholders (assume that is one year from now). DFB will retain $1.68 per share of its earnings to reinvest in new projects that have an expected return of 15.5% per year. Suppose DFB will maintain the same dividend payout rate, retention rate, and return on new investments in the future and will not change its number of outstanding shares. Assume next dividend is due in one year.

a. What growth rate of earnings would you forecast for DFB?

b. If DFB's equity cost of capital is 11.3%, what price would you estimate for DFB stock?

c. Suppose instead that DFB paid a dividend of $4.11 per share at the end of this year and retained only $0.68 per share in earnings. That is, it chose to pay a higher dividend instead of reinvesting in as many new projects. If DFB maintains this higher payout rate in the future, what stock price would you estimate for the firm now? Should DFB raise its dividend?

Can you please solve using excel formulas and add formula text so I can see the formulas used