Please answer all parts in excel and show work

3 of 80 Score: 0 of 1 pt 13-22 (similar to) EBITEPS and capital structure Data-Check is considering two capital structures. The key information is shown in the following table. Assume a 21% tax rate. Source of capital Structure A Structure B Long-term debt $91,000 at 15.2% coupon rate $182,000 at 16.2% coupon rate Common stock 4,000 shares 2,000 shares a. Calculate two EBIT-EPS coordinates for each of the structures by selecting any two EBIT values and finding their associated EPS values b. Plot the two capital structures on a set of EBIT-EPS axes. c. Indicate over what EBIT range, if any, each structure is preferred. d. Discuss the leverage and risk aspects of each structure. e. the firm is fairly certain that its EBIT will exceed $77,000, which structure would you recommend? Why? What if the tax rate was higher, say 40%? a. Calculate two EBIT-EPS coordinates for each of the structures by selecting any two EBIT values and finding their associated EPS values Complete the tables below using $50,000 and $60,000 EBIT: (Round to the nearest dollar. Round the EPS to the nearest cent) Structure A EBIT $ 50,000 Less interest $ Net profits before taxes $ Enter any number in the edit fields and then click Check Answer Check Answer Clear All 9 parts remaining 3 of 80 Score: 0 of 1 pt 13-22 (similar to) EBITEPS and capital structure Data-Check is considering two capital structures. The key information is shown in the following table. Assume a 21% tax rate. Source of capital Structure A Structure B Long-term debt $91,000 at 15.2% coupon rate $182,000 at 16.2% coupon rate Common stock 4,000 shares 2,000 shares a. Calculate two EBIT-EPS coordinates for each of the structures by selecting any two EBIT values and finding their associated EPS values b. Plot the two capital structures on a set of EBIT-EPS axes. c. Indicate over what EBIT range, if any, each structure is preferred. d. Discuss the leverage and risk aspects of each structure. e. the firm is fairly certain that its EBIT will exceed $77,000, which structure would you recommend? Why? What if the tax rate was higher, say 40%? a. Calculate two EBIT-EPS coordinates for each of the structures by selecting any two EBIT values and finding their associated EPS values Complete the tables below using $50,000 and $60,000 EBIT: (Round to the nearest dollar. Round the EPS to the nearest cent) Structure A EBIT $ 50,000 Less interest $ Net profits before taxes $ Enter any number in the edit fields and then click Check Answer Check Answer Clear All 9 parts remaining