please do in excel format and formulas display

Integrative: Optimal capital structure The board of directors of Morales Publishing Inc., has commissioned a capital structure study. The company has total assets of $40,000,000. It has earnings before interest and taxes of $8,000,000 and is taxeda a rate of 40%. a. Create a spreadsheet like the one in Table 13.10 showing values of debt and eq- P13-26 uity as well as the total number of shares, assuming a book value of $25 per share. % Debt Total assets $ Debt $ Equity Number of shares @ $25 0% $40,000,000 $ 10 40,000,000 20 40,000,000 40,000,000 40,000,000 50 40,000,000 40,000,000 30 40 60 b. G iven the before-tax cost of debt at various levels of indebtedness, calculate the yearly interest expenses. Integrative: Optimal capital structure The board of directors of Morales Publishing Inc., has commissioned a capital structure study. The company has total assets of $40,000,000. It has earnings before interest and taxes of $8,000,000 and is taxeda a rate of 40%. a. Create a spreadsheet like the one in Table 13.10 showing values of debt and eq- P13-26 uity as well as the total number of shares, assuming a book value of $25 per share. % Debt Total assets $ Debt $ Equity Number of shares @ $25 0% $40,000,000 $ 10 40,000,000 20 40,000,000 40,000,000 40,000,000 50 40,000,000 40,000,000 30 40 60 b. G iven the before-tax cost of debt at various levels of indebtedness, calculate the yearly interest expenses