I have provided the format but the correct numbers to use are in the first photo.

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,400,000. It has earnings before interest and taxes of $7,920,000 and is taxed at a rate of 24%. a. Create a spreadsheet 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 $7,920,000, a 24% 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 that maximizes EPS. d. Using the EPS developed in part (c), the estimates of required return, rs and the equation Po=EPS /rs, 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, Po 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 parts (a) through (d) to justify your recommendation. 60% $ 24,240,000 15.9% $ 3,854,160 c. Using EBIT of $7,920,000, a 24% 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. Calculate the most likely earnings per share: (Round to the nearest dollar. Round the number of shares to the nearest integer. Round the EPS to the nearest cent.) Interest Taxes Expense # of Shares EPS % Debt 0% @24% Net Income 1,900,800 $ 6,019,200 $ 0 $ 7,920,000 $ 1,616,000 $ 3.72 (Round to the nearest dollar. Round the number of shares to the nearest integer. Round the EPS to the nearest cent.) S Debt SEquity Number of shares $25 % Dube 0% 10 20 Total assets $11.900 NO 4 OK.010 MO 40 SO 60 .00h b. Given the before-tax cost of debt at various levels of indebtedness, calculate the yearly interest expenses. S Interest expense % Debt $ Total debt 0% 10 20 30 Before tax cost of debt, 14 0.0% 7.5 8.0 9.0 11.0 12.5 15.5 40 50 60 c. Using EBIT of Sco, a 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 that maximizes EPS. Number of Taxes Net income shares Interest expense % Debt EBIT FBT EPS S 0% 10 20 30 40 50 60 $8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 d. Using the EPS developed in part e, the estimates of required return, Ys, and Equa- tion 13.12, 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 Po $. 0% 10 20 30 40 50 60 10.0% 10.3 10.9 11.4 12.6 14.8 17.5 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 opti- mizing shareholder wealth. Use your findings in parts a through d to justify your recommendation, 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,400,000. It has earnings before interest and taxes of $7,920,000 and is taxed at a rate of 24%. a. Create a spreadsheet 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 $7,920,000, a 24% 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 that maximizes EPS. d. Using the EPS developed in part (c), the estimates of required return, rs and the equation Po=EPS /rs, 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, Po 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 parts (a) through (d) to justify your recommendation. 60% $ 24,240,000 15.9% $ 3,854,160 c. Using EBIT of $7,920,000, a 24% 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. Calculate the most likely earnings per share: (Round to the nearest dollar. Round the number of shares to the nearest integer. Round the EPS to the nearest cent.) Interest Taxes Expense # of Shares EPS % Debt 0% @24% Net Income 1,900,800 $ 6,019,200 $ 0 $ 7,920,000 $ 1,616,000 $ 3.72 (Round to the nearest dollar. Round the number of shares to the nearest integer. Round the EPS to the nearest cent.) S Debt SEquity Number of shares $25 % Dube 0% 10 20 Total assets $11.900 NO 4 OK.010 MO 40 SO 60 .00h b. Given the before-tax cost of debt at various levels of indebtedness, calculate the yearly interest expenses. S Interest expense % Debt $ Total debt 0% 10 20 30 Before tax cost of debt, 14 0.0% 7.5 8.0 9.0 11.0 12.5 15.5 40 50 60 c. Using EBIT of Sco, a 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 that maximizes EPS. Number of Taxes Net income shares Interest expense % Debt EBIT FBT EPS S 0% 10 20 30 40 50 60 $8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 d. Using the EPS developed in part e, the estimates of required return, Ys, and Equa- tion 13.12, 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 Po $. 0% 10 20 30 40 50 60 10.0% 10.3 10.9 11.4 12.6 14.8 17.5 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 opti- mizing shareholder wealth. Use your findings in parts a through d to justify your recommendation