Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If I wanted this to be an income statement in an excel file would I utilize and have the lay out exactly as written?? Only
If I wanted this to be an income statement in an excel file would I utilize and have the lay out exactly as written?? Only year 2019!
INCOME STATEMENTS
(In millions, except per share amounts) | |||||
Year Ended June 30, | 2019 | 2018 | 2017 | ||
Revenue: | |||||
Product | $66,069 | $64,497 | $63,811 | ||
Service and other | 59,774 | 45,863 | 32,760 | ||
Total revenue | 125,843 | 110,360 | 96,571 | ||
Cost of revenue: | |||||
Product | 16,273 | 15,420 | 15,175 | ||
Service and other | 26,637 | 22,933 | 19,086 | ||
Total cost of revenue | 42,910 | 38,353 | 34,261 | ||
Gross margin | 82,933 | 72,007 | 62,310 | ||
Research and development | 16,876 | 14,726 | 13,037 | ||
Sales and marketing | 18,213 | 17,469 | 15,461 | ||
General and administrative | 4,885 | 4,754 | 4,481 | ||
Restructuring | 0 | 0 | 306 | ||
Operating income | 42,959 | 35,058 | 29,025 | ||
Other income, net | 729 | 1,416 | 876 | ||
Income before income taxes | 43,688 | 36,474 | 29,901 | ||
Provision for income taxes | 4,448 | 19,903 | 4,412 | ||
Net income | $39,240 | $16,571 | $25,489 | ||
Earnings per share: | |||||
Basic | $5.11 | $2.15 | $3.29 | ||
Diluted | $5.06 | $2.13 | $3.25 | ||
Weighted average shares outstanding: | |||||
Basic | 7,673 | 7,700 | 7,746 | ||
Diluted | 7,753 | 7,794 | 7,832 |
Refer to accompanying notes.
COMPREHENSIVE INCOME STATEMENTS
(In millions) | |||||
Year Ended June 30, | 2019 | 2018 | 2017 | ||
Net income | $39,240 | $16,571 | $25,489 | ||
Other comprehensive income (loss), net of tax: | |||||
Net change related to derivatives | (173) | 39 | (218) | ||
Net change related to investments | 2,405 | (2,717) | (1,116) | ||
Translation adjustments and other | (318) | (178) | 167 | ||
Other comprehensive income (loss) | 1,914 | (2,856) | (1,167) | ||
Comprehensive income | $41,154 | $13,715 | $24,322 |
Refer to accompanying notes. Refer to Note 18 Accumulated Other Comprehensive Income (Loss) for further information.
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