Using the SEC 10-K financial statements, create a three year comparative income statement with summary line items
Fantastic news! We've Found the answer you've been seeking!
Question:
Using the SEC 10-K financial statements, create a three year comparative income statement with summary line items focusing on revenue through net income with key line items included but items of lower value approximately grouped as All Other Expenses. Revenue, Cost of Goods Sold, SG&A, and Income Tax Expense should be separate line items. Include a vertical analysis column for each of the three years presented. Include formulas.
HP Inc
Consolidated Statements of Earnings - USD ($) shares in Millions, $ in Millions | 12 Months Ended | ||
Oct. 31, 2018 | Oct. 31, 2017 | Oct. 31, 2016 | |
Net revenue | |||
Net revenue | $ 58,472 | $ 52,056 | $ 48,238 |
Costs and expenses: | |||
Cost of revenue | 47,803 | 42,478 | 39,240 |
Research and development | 1,404 | 1,190 | 1,209 |
Selling, general and administrative | 4,859 | 4,376 | 3,833 |
Restructuring and other charges | 132 | 362 | 205 |
Acquisition-related charges | 123 | 125 | 7 |
Amortization of intangible assets | 80 | 1 | 16 |
Defined benefit plan settlement charges | 7 | 5 | 179 |
Total costs and expenses | 54,408 | 48,537 | 44,689 |
Earnings from continuing operations | 4,064 | 3,519 | 3,549 |
Interest and other, net | (1,051) | (243) | 212 |
Earnings from continuing operations before taxes | 3,013 | 3,276 | 3,761 |
Benefit from (provision for) taxes | 2,314 | (750) | (1,095) |
Net earnings from continuing operations | 5,327 | 2,526 | 2,666 |
Net loss from discontinued operations | 0 | 0 | (170) |
Net earnings | $ 5,327 | $ 2,526 | $ 2,496 |
Basic | |||
Continuing operations (in dollars per share) | $ 3.30 | $ 1.50 | $ 1.54 |
Discontinued operations (in dollars per share) | 0 | 0 | (0.10) |
Total basic net earnings per share (in dollars per share) | 3.30 | 1.50 | 1.44 |
Diluted | |||
Continuing operations (in dollars per share) | 3.26 | 1.48 | 1.53 |
Discontinued operations (in dollars per share) | 0 | 0 | (0.10) |
Total diluted net earnings per share (in dollars per share) | $ 3.26 | $ 1.48 | $ 1.43 |
Weighted-average shares used to compute net earnings per share: | |||
Basic (in shares) | 1,615 | 1,688 | 1,730 |
Diluted (in shares) | 1,634 | 1,702 | 1,743 |
Related Book For
Auditing and Assurance Services A Systematic Approach
ISBN: 978-0077732509
10th edition
Authors: William Messier Jr, Steven Glover, Douglas Prawitt
Posted Date: