Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do you create common percent change, dollar change, and percent change on a excel income statement and. STATEMENTS OF CONSOLIDATED COMPREHENSIVE INCOME - USD

How do you create common percent change, dollar change, and percent change on a excel income statement and.

STATEMENTS OF CONSOLIDATED COMPREHENSIVE INCOME - USD ($) $ in Millions 12 Months Ended
Dec. 31, 2019 Dec. 31, 2018 Dec. 31, 2017
Statement of Comprehensive Income [Abstract]
Net Income $4,440 $4,791 $4,905
Change in foreign currency translation adjustment, net of tax 48 -149 86
Change in unrealized gain (loss) on marketable securities, net of tax 6 0 -1
Change in unrealized gain (loss) on cash flow hedges, net of tax 72 485 -321
Change in unrecognized pension and postretirement benefit costs, net of tax -1,129 272 -148
Comprehensive Income (Loss) $3,437 $5,399 $4,521

Comparative Data

STATEMENTS OF CONSOLIDATED COMPREHENSIVE INCOME - USD ($) $ in Millions 12 Months Ended
Dec. 31, 2018 Dec. 31, 2017 Dec. 31, 2016
Statement of Comprehensive Income [Abstract]
Net Income $ 4,791 $ 4,905 $ 3,422
Change in foreign currency translation adjustment, net of tax (149) 86 (119)
Change in unrealized gain (loss) on marketable securities, net of tax 0 (1) 0
Change in unrealized gain (loss) on cash flow hedges, net of tax 485 (321) (112)
Change in unrecognized pension and postretirement benefit costs, net of tax 272 (148) (712)
Comprehensive Income (Loss) $ 5,399 $ 4,521 $ 2,479

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

Step: 3

blur-text-image

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

Sound Investing, Chapter 23 - Internal Control

Authors: Kate Mooney

1st Edition

0071719458, 9780071719452

More Books

Students also viewed these Accounting questions

Question

Briefly explain the qualities of an able supervisor

Answered: 1 week ago

Question

Define policy making?

Answered: 1 week ago

Question

Define co-ordination?

Answered: 1 week ago

Question

What are the role of supervisors ?

Answered: 1 week ago