Please show work on excel.

Aant investments inc. cutrently has $3.5 million in debt outstanding, bearing in interest rate of 12.3% it wishes to finance a $5 million expansion program and is considering five alternatives. The preferred stock dividend will be 12% and the price of common stock will be $18 per share. The company currently has 750,000 shares of common stock outstanding and is in 40% tax bracket. a. If the earnings before interest and taxes are 51.5 milion, what would be earning per share for five alternatives, assuming no immediase incrasse in the operating prott. b. Compute the deeree of financial leverase (DFL) for each alternatives at the expected EBIT level of $1.5 million. c. Which alternative do you prefer and whty