Question: 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
3.41 Rating (151 Votes )
There are 3 Steps involved in it
Statement of Comprehensive Income USD in Millions 12 ... View full answer
Get step-by-step solutions from verified subject matter experts
