Currently, the firm is all equity funded with 1,000,000 shares valued at $9 per share and the required return on equity is 7.22%. Income tax rate is 35%. Your banker has indicated that the following leverage restructurings are possible:

Number of shares 850,000 700,000 550,000

Debt Leverage 15.00% 30.00% 45.00%

Interest 7.50% 8.00% 8.50%

ROE 11.00% 12.00% 13.00%

1) Estimate the share prices for the following debt restructures 15%, 30%, and, 45%, respectively:

A $6.07; $6.25; $5.96

B $5.96; $6.25; $6.07

C $6.25; $6.07; $5.96

D $5.96; $6.07; $6.25

E $6.07; $5.96; $6.25

2) Estimate which two debt restructures maximize firm value.

A 30%; 45%

B 15%; 30%

C 0%; 15%

D 45%; 0%

E 0%; 30%

Answer for # 1 is C

Answer for #2 is B

Please show calculation in Excel on how to get the answer and show the function page.