Need to compute an earnings per share ratio using an excel spreadsheet for the p
ID: 2479381 • Letter: N
Question
Need to compute an earnings per share ratio using an excel spreadsheet for the provided annual consolidated income statements for the most recent two 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 -basiExplanation / Answer
Answer to the Question
TRACTOR SUPPLY COMPANY Consolidated Income statement Particulars 2015 2014 Net Sales 6,226,507 5,711,715 Cost of Merchandise sold 4,083,333 3,761,300 Gross Profit 2,143,174 1,950,415 Selling,General and admin expenses 1,369,097 1,246,308 Depreciation and Amortization 123,569 114,635 Operating Income 650,508 589,472 Interest Expenses (net) 2,891 1,885 Income before Income tax 647,617 587,587 Income tax expenses 237,222 216,702 Net Income available for Common share holders (A) 410,395 370,885 Weighted average number of common stock Basic (B) 135,582 137,769 Diluted © 136,845 139,435 Basic EPS ratio (D)=(A)/(B) 3.03 2.69 Diluted EPS ratio €=(A)/© 3.00 2.66Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.