earnings before interest and taxes of $7,940,000 and is taxed at a rate of 29%. a. Create a spreadsheet showing values of debt and equity as well as the total number of shares assuming a book value of b. Given the before-tax cost of debt at various levels of indebtedness, calculate the yearly interest expenses. level of indebtedness that maximizes EPS. indebtedness in the following table that results in the maximum price per share, P0. findings in parts (a) through (d) to justify your recommendation. 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. earnings before interest and taxes of $7,940,000 and is taxed at a rate of 29%. a. Create a spreadsheet showing values of debt and equity as well as the total number of shares assuming a book value of b. Given the before-tax cost of debt at various levels of indebtedness, calculate the yearly interest expenses. level of indebtedness that maximizes EPS. indebtedness in the following table that results in the maximum price per share, P0. findings in parts (a) through (d) to justify your recommendation. 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