Please answer all three questions, show work in excel format please. I appreciate your help.

Hancock Corp has the following operating results and capital structure. The firm is contemplating a capital restructuring to 60% debt. Its stock is currently selling for book value at exist25 per share. The interest rate is 9%, and combined state and federal taxes are 42%. Show all of your calculation work and label all of your work so I can follow your calculation process. Complete current income statement and balance sheet and income statement under proposed capital structure. Calculate EPS under the current and proposed capital structures. Calculate the DFL under both structures