Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started