please do not answer in an excel file. Please explain how to calculate the problem so that i am learning and not just copying.

P13-24 Integrative: Optimal capital structure Medallion Cooling Systems Inc. has total assets of $10,000,000, EBIT of $2,000,000, and preferred dividends of $200,000 and is taxed at a rate of 40%. In an effort to determine the optimal capital structure, the firm has assembled data on the cost of debt, the number of shares of common stock for various levels of indebtedness, and the overall required return on investment: Capital structure debt ratio 0% 15 30 45 60 Cost of debt, a 0% 8 Number of common stock shares 200,000 170,000 140,000 110,000 80,000 Required return, 12% 13 14 16 20 9 12 15 a. Calculate earnings per share for each level of indebtedness. b. Use Equation 13.12 and the earnings per share calculated in part a to calculate a price per share for each level of indebtedness. c. Choose the optimal capital structure. Justify your choice. P13-24 Integrative: Optimal capital structure Medallion Cooling Systems Inc. has total assets of $10,000,000, EBIT of $2,000,000, and preferred dividends of $200,000 and is taxed at a rate of 40%. In an effort to determine the optimal capital structure, the firm has assembled data on the cost of debt, the number of shares of common stock for various levels of indebtedness, and the overall required return on investment: Capital structure debt ratio 0% 15 30 45 60 Cost of debt, a 0% 8 Number of common stock shares 200,000 170,000 140,000 110,000 80,000 Required return, 12% 13 14 16 20 9 12 15 a. Calculate earnings per share for each level of indebtedness. b. Use Equation 13.12 and the earnings per share calculated in part a to calculate a price per share for each level of indebtedness. c. Choose the optimal capital structure. Justify your choice