Need to compute a times interest earned (interest coverage) ratio using an excel

Question

Need to compute a times interest earned (interest coverage) ratio using an excel spreadsheet using the attached annual consolidated income statement for the most recent 2 years. Thanks!!

TRACTOR SUPPLY COMPANY CONSOLIDATED STATEMENTS OF INCOME (in thousands, except per share amounts) Fiscal Year 2015 2014 2013 S 6,226,507 S 5,711,715 5,164,784 4,083,333 3,761,300 3.411,175 1,753,609 1,369,097 1246,308 1,138,934 100,025 514,650 557 514,093 185,859 S 410,395 S 370,885 S 328,234 2.35 2.32 Net sales Cost ofmerchandise sold Gross profit 2,143,174 1,950,415 Selling, general and administrative expenses 123,569 650,508 2,891 647,617 237,222 114,635 589,472 1,885 587,587 216,702 Depreciation and amortization Operating income Interest expense, net Income beforeincome taxes Income tax expense Net income Net income per share -basi

Explanation / Answer

Times Interest Earned = Earnings before interest and tax / Interest Expense 2015 2014 Operating Income 650508 589472 Interest Expense 2891 1885 Times interest earned 225.01 312.72

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.