Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting And Analysis

Authors: Lawrence Revsine, Daniel Collins, Bruce Johnson, Fred Mittelstaedt, Leonard Soffer

8th Edition

1260247848, 978-1260247848

More Books

Students also viewed these Accounting questions

Question

What would you do about the verbal homophobic insults?

Answered: 1 week ago

Question

Using Exhibit 3-8, explain how a culture is formed and maintained.

Answered: 1 week ago