Need to compute a comparative income statement-vertical analysis using an excel
ID: 2479391 • Letter: N
Question
Need to compute a comparative income statement-vertical analysis using an excel spreadsheet with the attached financial documents. 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 -basiExplanation / Answer
Tractor Supply Company Comparitive Income Statement - Vertical Analysis 2015 2014 2013 Amt. Percent Amt. Percent Amt. Percent Net Sales 6,226,507 100.00% 5,711,715 100% 5,164,784 100.00% Cost of merchandise sold 4,083,333 65.58% 3,761,300 65.85% 3,411,175 66.05% Gross Profit 2,143,174 34.42% 1,950,415 34.15% 1,753,609 33.95% Selling, general & admn. Exp. 1,369,097 21.99% 1,246,308 21.82% 1,138,934 22.05% depreciation & Amortization 123,569 1.98% 114,635 2.01% 100,025 1.94% Operating Income 650,508 10.45% 589,472 10.32% 514,650 9.96% Interest Exp., Net 2,891 0.05% 1,885 0.03% 557 0.01% Income before Income Tax 647,617 10.40% 587,587 10.29% 514,093 9.95% Income Tax Expense 237,222 3.81% 216,702 3.79% 185,859 3.60% Net Income 410,395 6.59% 370,885 6.49% 328,234 6.36%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.