Excel template Saved Sea File Home Insert Draw Page Layout Formulas Data 10 7 A Arial X fx 10 V B V A B C D LLI E ROE and ROIC 2 3 Net income $24,000 4 Interest expense $4,000 5 Tax rate 35.00% 5 Notes payable $23,000 7 Long-term debt $70,000 8 Common equity $240,000 Formulas 0 ROE #N/A 1 2 Partial Income Statement: 3 EBIT #N/A 14 Interest $4,000.00 5 EBT #N/A 6 Taxes #N/A 17 Net income $24,000.00 18 19 Capital Summary: 20 Notes payable $23,000.00 21 Long-term debt $70,000.00 22 Common equity $240,000.00 23 Total invested capital #N/A 24 25 ROIC #N/A 26 27 28 Sheet1 + Workbook Statistics Calculation Mode: Automatic