please show in excel!

Firms HD and LD are identical except for their use of debt and the interest rates they pay HD has more debt and thus must pay a higher interest rate. Based on the data given below, calculate ROE, and ROEL Firm LD's Data Applicable to Both Firms Firm HD's Data Capital $3,000,000 wa EBIT $500,000 Int. rate Tax rate 35% 70% Wa 20% 10% 12% Int. rate Applicable to Both Firms Firm HD's Data Capital $3,000,000 debt weight EBIT $500,000 Int. rate Tax rate 35% debt capital Firm LD's Data debt weight Int. rate debt capital EBIT Interest EBT NI EBIT Interest EBT NI Equity ROE Equity ROE