How do you create common percent change, dollar change, and percent change on a excel income statement
Fantastic news! We've Found the answer you've been seeking!
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 ($) $ 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 |
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: