Fill out the columns below for the proposed debt and equity scenarios, which include completing information on the company's capital structure, shares, income statement, EPS, ROE, and Times Interest Earned (to facilitate computation, first copy the information below into Excel: second, complete the table in Excel; third, paste it from Excel into the text box below).. Debt Equity Shares Financing Scenarios Current Debt Equity 20,000,000 25,000,000 500,000 Operating profit Interest expense Earnings before tax Income tax @ 30% Net income EPS $10,000,000 1,600,000 8,400,000 2,520,000 5,880,000 $11.76 EPS ROE Times Interest Earned Fill out the columns below for the proposed debt and equity scenarios, which include completing information on the company's capital structure, shares, income statement, EPS, ROE, and Times Interest Earned (to facilitate computation, first copy the information below into Excel: second, complete the table in Excel; third, paste it from Excel into the text box below).. Debt Equity Shares Financing Scenarios Current Debt Equity 20,000,000 25,000,000 500,000 Operating profit Interest expense Earnings before tax Income tax @ 30% Net income EPS $10,000,000 1,600,000 8,400,000 2,520,000 5,880,000 $11.76 EPS ROE Times Interest Earned