LG 3, 4, 5, 6 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 taxed at a rate of 21%. P13-26 a. Create a spreadsheet like the one in Table 13.100 showing values of debt and equity 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 $ $ 1040,000,000 20 30 40 40,000,000 40,000,000 40,000,000 40,000,000 40,000,000t 50 60 b. Given the before-tax cost of debt at various levels of indebtedness, calculate the yearly interest expenses. b. Given the before-tax cost of debt at various levels of indebtedness caleulate the yearly interest expenses. % Debt S Total debt Before-tax cost of debt, re S Interest expense 096 0.0% 7.5 8.0 9.0 10 20 30 40 50 11.0 12.5 15.5 60 c. Using EBIT of $8,000,000, a 21% tax rate, and the information developed in parts a and b, calculate the most likely earnings per share for the firm at various levels of indebtedness. Mark the level of indebtedness th maximizes EPS. EBIT Interest EBT Taxes Net Number EPS Debt expense income of shares 0% $8,000,000 L L-L- L- 10 8,000,000 2011 10,000-0001111- - 30 8,000,000 408,000,000 50 8,000,000 60 8,000,000 - d. Using the EPS developed in part c, the estimates of required return, r, and Equation 13.120, estimate the value 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 Debt EPS 0% 10 20 30 40 10.0% 10.3 10.9 11.4 12.6 14.8 17.5 50 60 e. Prepare a recommendation to the board of directors of Morales Publishing that specifies the degree of indebtedness that will accomplish the firm's goal of optimizing shareholder wealth. Use your findings in partsa through d to justify your recommendation