Please show how to work problem out thank you.
Integrative Optimal capital structure The board of directors of Morales Publish, Inc, has commissioned a capital structure study. The company has total assets of $40,000. It has earnings before interest and taxes of $8,000,000 and is taxed at a rate of 40%. a. Create a spreadsheet like the one is Table 13.10 showing values of debt and equity as well as the total number of shares, assuming a book value of $25 per share. b. Given the before-tax cost of debt at various levels of indebtedness, calculate the yearly interest expenses. c. using EBIT of $8,000,000, a 40% tax rate, and the information developed in parts a and b, calculate the most likely earnings per share for the firm at various level of indebtedness. Mark the level of indebtedness that maximizes EPS. d. Using the EPS developed in part c, the estimates of required return, r_0, and Equation 13.12, estimate the value of per share at various levels of indebtedness. Mark the level of indebtedness in the following table that results in the maximum price per share, P_0. Integrative Optimal capital structure The board of directors of Morales Publish, Inc, has commissioned a capital structure study. The company has total assets of $40,000. It has earnings before interest and taxes of $8,000,000 and is taxed at a rate of 40%. a. Create a spreadsheet like the one is Table 13.10 showing values of debt and equity as well as the total number of shares, assuming a book value of $25 per share. b. Given the before-tax cost of debt at various levels of indebtedness, calculate the yearly interest expenses. c. using EBIT of $8,000,000, a 40% tax rate, and the information developed in parts a and b, calculate the most likely earnings per share for the firm at various level of indebtedness. Mark the level of indebtedness that maximizes EPS. d. Using the EPS developed in part c, the estimates of required return, r_0, and Equation 13.12, estimate the value of per share at various levels of indebtedness. Mark the level of indebtedness in the following table that results in the maximum price per share, P_0