Need to compute a Return on Assets Ratio using an Excel Spreadsheet. Attached ar

Question

Need to compute a Return on Assets Ratio using an Excel Spreadsheet. Attached are the income statements, balance sheets, statement of cash flows, and statements of stockholders equity. 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

The formula to calculate return on assets is:

Annual net income = $410,395

Average total assets = 2,370,826 + 2,034,571 / 2

= 2,202,699

Return on asset = 410,395 / 2,202,699

=18.63%

ROA = Annual Net Income / Average Total Assets

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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