Create Cause of Change analysis in excel for the company Northrop Grumman. Use the company's Consolidated Statements
Fantastic news! We've Found the answer you've been seeking!
Question:
Create Cause of Change analysis in excel for the company Northrop Grumman. Use the company's Consolidated Statements of Earnings and Comprehensive Income below. Please include the steps of the process.
Consolidated Statements of Earnings and Comprehensive Income - USD ($) shares in Millions, $ in Millions | 12 Months Ended | ||
Dec. 31, 2022 | Dec. 31, 2021 | Dec. 31, 2020 | |
Revenues | $ 36,602 | $ 35,667 | $ 36,799 |
Operating income | 3,601 | 5,651 | 4,065 |
Operating costs and expenses | |||
General and administrative expenses | 3,873 | 3,597 | 3,413 |
Total operating costs and expenses | 33,001 | 31,996 | 32,734 |
Gain on sale of business | 0 | 1,980 | 0 |
Operating income | 3,601 | 5,651 | 4,065 |
Other (expense) income | |||
Interest expense | (506) | (556) | (593) |
Non-operating FAS pension benefit | 1,505 | 1,469 | 1,198 |
Mark-to-market pension and OPB benefit (expense) | 1,232 | 2,355 | (1,034) |
Other, net | 4 | 19 | 92 |
Earnings before income taxes | 5,836 | 8,938 | 3,728 |
Federal and foreign income tax expense | 940 | 1,933 | 539 |
Net earnings | $ 4,896 | $ 7,005 | $ 3,189 |
Basic earnings per share | |||
Basic earnings per share | $ 31.61 | $ 43.70 | $ 19.08 |
Weighted-average common shares outstanding, in millions | 154.9 | 160.3 | 167.1 |
Diluted earnings per share | |||
Diluted earnings per share | $ 31.47 | $ 43.54 | $ 19.03 |
Weighted-average diluted shares outstanding, in millions | 155.6 | 160.9 | 167.6 |
Net earnings (from above) | $ 4,896 | $ 7,005 | $ 3,189 |
Other comprehensive loss, net of tax | |||
Change in unamortized prior service credit | (1) | (8) | (41) |
Change in cumulative translation adjustment and other, net | (9) | (7) | 10 |
Other comprehensive loss, net of tax | (10) | (15) | (31) |
Comprehensive income | 4,886 | 6,990 | 3,158 |
Product [Member] | |||
Cost of Goods and Services Sold | 22,761 | 22,309 | 21,559 |
Revenues | 28,522 | 27,868 | 27,015 |
Service [Member] | |||
Cost of Goods and Services Sold | 6,367 | 6,090 | 7,762 |
Revenues | $ 8,080 | $ 7,799 | $ 9,784 |
Posted Date: