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

Answer 1

Statement of Comprehensive Income
USD ($) $ in Millions
	12 Months Ended Dec. 31, 2018 (A)	12 Months Ended   Dec. 31, 2019 (B)	Dollar Change (B-A)	Percentage Change
Net Income	$4,791	$4,440	($351)	-7%
Change in foreign currency translation adjustment, net of tax	($149)	$48	$197	-132%
Change in unrealized gain (loss) on marketable securities, net of tax	$0	$6	$6	-
Change in unrealized gain (loss) on cash flow hedges, net of tax	$485	$72	($413)	-85%
Change in unrecognized pension and postretirement benefit costs, net of tax	$272	($1,129)	($1,401)	-515%
Comprehensive Income (Loss)	$5,399	$3,437	($1,962)	-36%

For you reference use the below formulas in excel -