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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started