Please use Excel and show the equations used to find the solutions. I really struggle with Excel, so I appreciate any tips you have. Thanks!

Integrative: Optimal capital structure Medallion Cooling Systems 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, ra 0% 8 9 12 Number of common stock shares 200,000 170,000 140,000 110,000 80,000 Required return, 12% 13 14 16 20 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