Hello!

I need help! Im working on this home work problem and need to format it excel. I know it has to do with cost of equity?

EBIT and Leverage. Kaelea, Inc., has no debt outstanding and a total market value of $125,000. Earnings before interest and taxes, EBIT, are projected to be $10,400 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 20 percent higher. If there is a recession, then EBIT will be 35 percent lower. Kaelea is considering a $42,000 debt issue with a 6 percent interest rate. The proceeds will be used to repurchase shares of stock. There are currently 6,250 shares outstanding. Ignore taxes for this problem.

a.Calculate earnings per share, EPS, under each of the three economic scenarios before any debt is issued. Also, calculate the percentage changes in EPS when the economy expands or enters a recession.

b.Repeat part (a) assuming that Kaelea goes through with recapitalization. What do you observe?