Loading stock chart…

XCEL ENERGY INC (XELLL)

Historical prices through 2026-10-08Latest fiscal period 2025-12-31

Price & fundamentals

Export data/plot:

Timeframe

Compound Annual Growth Rate(CAGR)

—Drag a handle to resize, or the inner selected area to move all five windows—

Detailed metric definitions →

Historical valuation multiples

Export data/plot:

Timeframe

Show P/E 15× / 20× / 30× reference lines

Drag a handle to resize, or the inner selected area to move all five windows

Detailed metric definitions →

Ratio observations in the selected window

Price date	EPS fiscal end	Basic P/E (×)	Diluted P/E (×)	P/S (×)	P/FCF (×)

Profit margins

Export data/plot:

Timeframe

Drag a handle to resize, or the inner selected area to move all five windows

Calculation inputs, filings & unavailable observations

Detailed metric definitions →

Yield, cash conversion & capital returns

Export data/plot:

Timeframe

Drag a handle to resize, or the inner selected area to move all five windows

Calculation inputs, filings & unavailable observations

Detailed metric definitions →

Price & growth-based reference

Export data/plot:

Compound Annual Growth Rate (CAGR)—Selected window

Growth-based P/E—

Formula: min(60, 15 × ((1 + CAGR / 100) / 1.10)^{years × 0.6})

Timeframe

Drag a handle to resize, or the inner selected area to move all five windows

Detailed metric definitions →

Annual change in the selected reference metric

YEAR-OVER-YEAR

Annual metric change

Change from the previous reported fiscal year

Increase Decrease

Annual data and sources

XCEL ENERGY INC (XELLL) · Nasdaq · USD · Sector unavailable · CIK 0000072903

Annual coverage: 2007-12-31–2025-12-31 (19 periods). Financial snapshot built 2026-10-09.

XELLL annual financial history

All stored annual observations, independent of the chart window. Per-share amounts in USD. Unavailable values are not zero.

See the calculation and limitations.

Annual EPS, cash flow, dividends, and fiscal-year dividend yield for XCEL ENERGY INC
Fiscal year / end	Basic EPS	Diluted EPS	FCF / share	Dividends / share	Fiscal-year dividend yield	Filing sources
2025 2025-12-31	3.44	3.42	-11.59	2.28	9.12%	Basic EPS (2026-02-25) Diluted EPS (2026-02-25) Operating cash flow (2026-02-25) · Capex (2026-02-25) Dividend (2026-02-25)
2024 2024-12-31	3.44	3.44	-4.84	2.19	Unavailable	Basic EPS (2026-02-25) Diluted EPS (2026-02-25) Operating cash flow (2026-02-25) · Capex (2026-02-25) Dividend (2026-02-25)
2023 2023-12-31	3.21	3.21	-0.95	2.08	Unavailable	Basic EPS (2026-02-25) Diluted EPS (2026-02-25) Operating cash flow (2026-02-25) · Capex (2026-02-25) Dividend (2026-02-25)
2022 2022-12-31	3.18	3.17	-1.29	1.95	Unavailable	Basic EPS (2025-02-27) Diluted EPS (2025-02-27) Operating cash flow (2025-02-27) · Capex (2025-02-27) Dividend (2025-02-27)
2021 2021-12-31	2.96	2.96	-3.81	Unavailable	Unavailable	Basic EPS (2024-02-21) Diluted EPS (2024-02-21) Operating cash flow (2024-02-21) · Capex (2024-02-21)
2020 2020-12-31	2.79	2.79	-4.77	Unavailable	Unavailable	Basic EPS (2023-02-23) Diluted EPS (2023-02-23) Operating cash flow (2023-02-23) · Capex (2023-02-23)
2019 2019-12-31	2.64	2.64	-1.85	1.62	Unavailable	Basic EPS (2022-02-23) Diluted EPS (2022-02-23) Operating cash flow (2022-02-23) · Capex (2022-02-23) Dividend (2020-02-21)
2018 2018-12-31	2.47	2.47	-1.63	1.52	Unavailable	Basic EPS (2021-02-17) Diluted EPS (2021-02-17) Operating cash flow (2021-02-17) · Capex (2021-02-17) Dividend (2020-02-21)
2017 2017-12-31	2.26	2.25	-0.23	1.44	Unavailable	Basic EPS (2020-02-21) Diluted EPS (2020-02-21) Operating cash flow (2020-02-21) · Capex (2020-02-21) Dividend (2020-02-21)
2016 2016-12-31	2.21	2.21	-0.28	1.36	Unavailable	Basic EPS (2019-02-22) Diluted EPS (2019-02-22) Operating cash flow (2019-02-22) · Capex (2019-02-22) Dividend (2019-02-22)
2015 2015-12-31	1.94	1.94	-1.27	1.28	Unavailable	Basic EPS (2018-02-23) Diluted EPS (2018-02-23) Operating cash flow (2018-02-23) · Capex (2018-02-23) Dividend (2018-02-23)
2014 2014-12-31	2.03	2.03	-1.07	1.20	Unavailable	Basic EPS (2017-02-24) Diluted EPS (2017-02-24) Operating cash flow (2017-02-24) · Capex (2017-02-24) Dividend (2017-02-24)
2013 2013-12-31	1.91	1.91	-1.63	1.11	Unavailable	Basic EPS (2016-02-19) Diluted EPS (2016-02-19) Operating cash flow (2016-02-19) · Capex (2016-02-19) Dividend (2016-02-19)
2012 2012-12-31	1.86	1.85	4.10	1.07	Unavailable	Basic EPS (2015-02-20) Diluted EPS (2015-02-20) Operating cash flow (2015-02-20) · Capex (2013-02-22) Dividend (2015-02-20)
2011 2011-12-31	1.72	1.72	4.95	1.03	Unavailable	Basic EPS (2014-02-21) Diluted EPS (2014-02-21) Operating cash flow (2014-02-21) · Capex (2013-02-22) Dividend (2014-02-21)
2010 2010-12-31	1.63	1.62	2.51	1.00	Unavailable	Basic EPS (2013-02-22) Diluted EPS (2013-02-22) Operating cash flow (2013-02-22) · Capex (2013-02-22) Dividend (2013-02-22)
2009 2009-12-31	1.48	1.48	0.29	0.97	Unavailable	Basic EPS (2010-02-26) Diluted EPS (2010-02-26) Operating cash flow (2010-02-26) · Capex (2010-02-26) Dividend (2010-02-26)
2008 2008-12-31	1.47	1.46	3.82	0.94	Unavailable	Basic EPS (2011-02-28) Diluted EPS (2011-02-28) Operating cash flow (2011-02-28) · Capex (2011-02-28) Dividend (2011-02-28)
2007 2007-12-31	1.38	1.35	-1.07	0.91	Unavailable	Basic EPS (2010-02-26) Diluted EPS (2010-02-26) Operating cash flow (2010-02-26) · Capex (2010-02-26) Dividend (2010-02-26)

Annual per-share context (USD/share)

Complete annual history, independent of chart loading and range. Revenue/share is annual revenue per average diluted share. Debt/share is borrowings per year-end common share, excluding leases. Missing inputs remain unavailable. Metric definitions.

Fiscal end	Revenue / share	Total debt / share	Inputs & filing sources
2025-12-31	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation Source unavailable
2024-12-31	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation Source unavailable
2023-12-31	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation Source unavailable
2022-12-31	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation Source unavailable
2021-12-31	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation Source unavailable
2020-12-31	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation Source unavailable
2019-12-31	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation Source unavailable
2018-12-31	Unavailable	Unavailable	Inputs & filings revenue: 11537000000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2019-02-22)
2017-12-31	Unavailable	Unavailable	Inputs & filings revenue: 11404000000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2019-02-22)
2016-12-31	Unavailable	Unavailable	Inputs & filings revenue: 11107000000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2019-02-22)
2015-12-31	Unavailable	Unavailable	Inputs & filings revenue: 11024000000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2018-02-23)
2014-12-31	Unavailable	Unavailable	Inputs & filings revenue: 11686135000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2017-02-24)
2013-12-31	Unavailable	Unavailable	Inputs & filings revenue: 10914922000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2016-02-19)
2012-12-31	Unavailable	Unavailable	Inputs & filings revenue: 10128223000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2015-02-20)
2011-12-31	Unavailable	Unavailable	Inputs & filings revenue: 10654770000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2012-02-24)
2010-12-31	Unavailable	Unavailable	Inputs & filings revenue: 10310947000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2012-02-24)
2009-12-31	Unavailable	Unavailable	Inputs & filings revenue: 9644303000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2012-02-24)
2008-12-31	Unavailable	Unavailable	Inputs & filings revenue: 11203156000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2011-02-28)
2007-12-31	Unavailable	Unavailable	Inputs & filings revenue: 10034170000; averageDilutedShares: Ambiguous share-class allocation; totalDebt: No supported complete debt aggregate or non-overlapping borrowing components; leases excluded; periodEndShares: Ambiguous share-class allocation revenue (2010-02-26)

Annual returns and cash generation (%)

Complete annual history, independent of chart loading and range. FCF margin and FCF / net income use matching annual totals. ROCE uses positive exact opening and closing capital-employed bases. Inputs, scopes and unavailable reasons are disclosed below. Missing inputs remain unavailable. Metric definitions.

Fiscal end	FCF margin (%)	FCF / net income (%)	ROCE (%)	Inputs & filing sources
2025-12-31	Unavailable	-338.21	3.75	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-6825000000,"capex":{"accession":"0000072903-26-000009","end":"2025-12-31","filed":"2026-02-25","form":"10-K","start":"2025-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-26-000009","end":"2025-12-31","filed":"2026-02-25","form":"10-K","start":"2025-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"netIncome":{"value":2018000000,"tag":"NetIncomeLoss","unit":"USD","start":"2025-01-01","end":"2025-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"operatingIncome":{"value":2583000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2025-01-01","end":"2025-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"openingAssets":{"value":70035000000,"tag":"Assets","unit":"USD","start":null,"end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"openingCurrentLiabilities":{"value":6459000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"openingCapitalEmployed":{"value":63576000000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":19522000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"openingTotalEquity":{"value":19522000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"openingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2024-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":81371000000,"tag":"Assets","unit":"USD","start":null,"end":"2025-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"closingCurrentLiabilities":{"value":7089000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2025-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"closingCapitalEmployed":{"value":74282000000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":23609000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2025-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"closingTotalEquity":{"value":23609000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2025-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"closingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2025-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"parentNetIncome":{"value":2018000000,"tag":"NetIncomeLoss","unit":"USD","start":"2025-01-01","end":"2025-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"preferredDividends":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"incomeTaxExpense":{"value":-245000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2025-01-01","end":"2025-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"pretaxIncome":{"value":1773000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2025-01-01","end":"2025-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":68929000000,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: No unambiguous matching annual USD fact; cashConversion: -338.2061446977205; roce: 3.74733421346603 fcfMargin component 1 (2026-02-25) · fcfMargin component 2 (2026-02-25) cashConversion component 1 (2026-02-25) · cashConversion component 2 (2026-02-25) · cashConversion component 3 (2026-02-25) roce component 1 (2026-02-25) · roce component 2 (2026-02-25) · roce component 3 (2026-02-25) · roce component 4 (2026-02-25) · roce component 5 (2026-02-25)
2024-12-31	Unavailable	-140.65	3.91	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-2723000000,"capex":{"accession":"0000072903-26-000009","end":"2024-12-31","filed":"2026-02-25","form":"10-K","start":"2024-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-26-000009","end":"2024-12-31","filed":"2026-02-25","form":"10-K","start":"2024-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"netIncome":{"value":1936000000,"tag":"NetIncomeLoss","unit":"USD","start":"2024-01-01","end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"operatingIncome":{"value":2386000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2024-01-01","end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"openingAssets":{"value":64079000000,"tag":"Assets","unit":"USD","start":null,"end":"2023-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"openingCurrentLiabilities":{"value":5652000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2023-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"openingCapitalEmployed":{"value":58427000000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":17616000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2023-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"openingTotalEquity":{"value":17616000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2023-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"openingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2023-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":70035000000,"tag":"Assets","unit":"USD","start":null,"end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"closingCurrentLiabilities":{"value":6459000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"closingCapitalEmployed":{"value":63576000000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":19522000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"closingTotalEquity":{"value":19522000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"closingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2024-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"parentNetIncome":{"value":1936000000,"tag":"NetIncomeLoss","unit":"USD","start":"2024-01-01","end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"preferredDividends":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"incomeTaxExpense":{"value":-402000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2024-01-01","end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"pretaxIncome":{"value":1534000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2024-01-01","end":"2024-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":61001500000,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: No unambiguous matching annual USD fact; cashConversion: -140.650826446281; roce: 3.91137922837963 fcfMargin component 1 (2026-02-25) · fcfMargin component 2 (2026-02-25) cashConversion component 1 (2026-02-25) · cashConversion component 2 (2026-02-25) · cashConversion component 3 (2026-02-25) roce component 1 (2026-02-25) · roce component 2 (2025-02-27) · roce component 3 (2025-02-27) · roce component 4 (2026-02-25) · roce component 5 (2026-02-25)
2023-12-31	Unavailable	-29.76	4.37	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-527000000,"capex":{"accession":"0000072903-26-000009","end":"2023-12-31","filed":"2026-02-25","form":"10-K","start":"2023-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-26-000009","end":"2023-12-31","filed":"2026-02-25","form":"10-K","start":"2023-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"netIncome":{"value":1771000000,"tag":"NetIncomeLoss","unit":"USD","start":"2023-01-01","end":"2023-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"operatingIncome":{"value":2481000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2023-01-01","end":"2023-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"openingAssets":{"value":61188000000,"tag":"Assets","unit":"USD","start":null,"end":"2022-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"openingCurrentLiabilities":{"value":6078000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2022-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"openingCapitalEmployed":{"value":55110000000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":16675000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2022-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"openingTotalEquity":{"value":16675000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2022-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"openingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2022-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":64079000000,"tag":"Assets","unit":"USD","start":null,"end":"2023-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"closingCurrentLiabilities":{"value":5652000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2023-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"closingCapitalEmployed":{"value":58427000000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":17616000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2023-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"closingTotalEquity":{"value":17616000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2023-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"closingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2023-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"parentNetIncome":{"value":1771000000,"tag":"NetIncomeLoss","unit":"USD","start":"2023-01-01","end":"2023-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"preferredDividends":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"incomeTaxExpense":{"value":-146000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2023-01-01","end":"2023-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"pretaxIncome":{"value":1625000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2023-01-01","end":"2023-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":56768500000,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: No unambiguous matching annual USD fact; cashConversion: -29.757199322416717; roce: 4.370381461549979 fcfMargin component 1 (2026-02-25) · fcfMargin component 2 (2026-02-25) cashConversion component 1 (2026-02-25) · cashConversion component 2 (2026-02-25) · cashConversion component 3 (2026-02-25) roce component 1 (2026-02-25) · roce component 2 (2024-02-21) · roce component 3 (2024-02-21) · roce component 4 (2025-02-27) · roce component 5 (2025-02-27)
2022-12-31	Unavailable	-40.67	4.50	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-706000000,"capex":{"accession":"0000072903-25-000029","end":"2022-12-31","filed":"2025-02-27","form":"10-K","start":"2022-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-25-000029","end":"2022-12-31","filed":"2025-02-27","form":"10-K","start":"2022-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"netIncome":{"value":1736000000,"tag":"NetIncomeLoss","unit":"USD","start":"2022-01-01","end":"2022-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"operatingIncome":{"value":2428000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2022-01-01","end":"2022-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"openingAssets":{"value":57851000000,"tag":"Assets","unit":"USD","start":null,"end":"2021-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"openingCurrentLiabilities":{"value":5046000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2021-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"openingCapitalEmployed":{"value":52805000000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":15612000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2021-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"openingTotalEquity":{"value":15612000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2021-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"openingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2021-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":61188000000,"tag":"Assets","unit":"USD","start":null,"end":"2022-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"closingCurrentLiabilities":{"value":6078000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2022-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"closingCapitalEmployed":{"value":55110000000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":16675000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2022-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"closingTotalEquity":{"value":16675000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2022-12-31","filed":"2026-02-25","accession":"0000072903-26-000009","form":"10-K"},"closingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2022-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"parentNetIncome":{"value":1736000000,"tag":"NetIncomeLoss","unit":"USD","start":"2022-01-01","end":"2022-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"preferredDividends":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"incomeTaxExpense":{"value":-135000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2022-01-01","end":"2022-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"pretaxIncome":{"value":1601000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2022-01-01","end":"2022-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":53957500000,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: No unambiguous matching annual USD fact; cashConversion: -40.668202764976954; roce: 4.499837835333365 fcfMargin component 1 (2025-02-27) · fcfMargin component 2 (2025-02-27) cashConversion component 1 (2025-02-27) · cashConversion component 2 (2025-02-27) · cashConversion component 3 (2025-02-27) roce component 1 (2025-02-27) · roce component 2 (2023-02-23) · roce component 3 (2023-02-23) · roce component 4 (2024-02-21) · roce component 5 (2024-02-21)
2021-12-31	Unavailable	-128.68	4.30	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-2055000000,"capex":{"accession":"0000072903-24-000034","end":"2021-12-31","filed":"2024-02-21","form":"10-K","start":"2021-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-24-000034","end":"2021-12-31","filed":"2024-02-21","form":"10-K","start":"2021-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"netIncome":{"value":1597000000,"tag":"NetIncomeLoss","unit":"USD","start":"2021-01-01","end":"2021-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"operatingIncome":{"value":2203000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2021-01-01","end":"2021-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"openingAssets":{"value":53957000000,"tag":"Assets","unit":"USD","start":null,"end":"2020-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"openingCurrentLiabilities":{"value":4239000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2020-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"openingCapitalEmployed":{"value":49718000000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":14575000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2020-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"openingTotalEquity":{"value":14575000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2020-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"openingCash":{"value":129000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2020-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2020-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":57851000000,"tag":"Assets","unit":"USD","start":null,"end":"2021-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"closingCurrentLiabilities":{"value":5046000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2021-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"closingCapitalEmployed":{"value":52805000000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":15612000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2021-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"closingTotalEquity":{"value":15612000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2021-12-31","filed":"2025-02-27","accession":"0000072903-25-000029","form":"10-K"},"closingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2021-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"parentNetIncome":{"value":1597000000,"tag":"NetIncomeLoss","unit":"USD","start":"2021-01-01","end":"2021-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"preferredDividends":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"incomeTaxExpense":{"value":-70000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2021-01-01","end":"2021-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"pretaxIncome":{"value":1527000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2021-01-01","end":"2021-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":51261500000,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: No unambiguous matching annual USD fact; cashConversion: -128.67877269881026; roce: 4.297572252080021 fcfMargin component 1 (2024-02-21) · fcfMargin component 2 (2024-02-21) cashConversion component 1 (2024-02-21) · cashConversion component 2 (2024-02-21) · cashConversion component 3 (2024-02-21) roce component 1 (2024-02-21) · roce component 2 (2022-02-23) · roce component 3 (2022-02-23) · roce component 4 (2023-02-23) · roce component 5 (2023-02-23)
2020-12-31	Unavailable	-171.15	4.43	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-2521000000,"capex":{"accession":"0000072903-23-000007","end":"2020-12-31","filed":"2023-02-23","form":"10-K","start":"2020-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-23-000007","end":"2020-12-31","filed":"2023-02-23","form":"10-K","start":"2020-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"netIncome":{"value":1473000000,"tag":"NetIncomeLoss","unit":"USD","start":"2020-01-01","end":"2020-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"operatingIncome":{"value":2116000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2020-01-01","end":"2020-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"openingAssets":{"value":50448000000,"tag":"Assets","unit":"USD","start":null,"end":"2019-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"openingCurrentLiabilities":{"value":4568000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2019-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"openingCapitalEmployed":{"value":45880000000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":13239000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2019-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"openingTotalEquity":{"value":13239000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2019-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"openingCash":{"value":248000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2019-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2019-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":53957000000,"tag":"Assets","unit":"USD","start":null,"end":"2020-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"closingCurrentLiabilities":{"value":4239000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2020-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"closingCapitalEmployed":{"value":49718000000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":14575000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2020-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"closingTotalEquity":{"value":14575000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2020-12-31","filed":"2024-02-21","accession":"0000072903-24-000034","form":"10-K"},"closingCash":{"value":129000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2020-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2020-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"parentNetIncome":{"value":1473000000,"tag":"NetIncomeLoss","unit":"USD","start":"2020-01-01","end":"2020-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"preferredDividends":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"incomeTaxExpense":{"value":-6000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2020-01-01","end":"2020-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"pretaxIncome":{"value":1467000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2020-01-01","end":"2020-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Effective tax rate outside 0–100% or nonfinite; no clamping"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":47799000000,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: No unambiguous matching annual USD fact; cashConversion: -171.14731839782755; roce: 4.426870855038809 fcfMargin component 1 (2023-02-23) · fcfMargin component 2 (2023-02-23) cashConversion component 1 (2023-02-23) · cashConversion component 2 (2023-02-23) · cashConversion component 3 (2023-02-23) roce component 1 (2023-02-23) · roce component 2 (2021-02-17) · roce component 3 (2021-02-17) · roce component 4 (2022-02-23) · roce component 5 (2022-02-23)
2019-12-31	Unavailable	-70.12	4.81	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-962000000,"capex":{"accession":"0000072903-22-000010","end":"2019-12-31","filed":"2022-02-23","form":"10-K","start":"2019-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-22-000010","end":"2019-12-31","filed":"2022-02-23","form":"10-K","start":"2019-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"netIncome":{"value":1372000000,"tag":"NetIncomeLoss","unit":"USD","start":"2019-01-01","end":"2019-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"operatingIncome":{"value":2104000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2019-01-01","end":"2019-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"openingAssets":{"value":45987000000,"tag":"Assets","unit":"USD","start":null,"end":"2018-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"openingCurrentLiabilities":{"value":4460000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2018-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"openingCapitalEmployed":{"value":41527000000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":12222000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2018-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"openingTotalEquity":{"value":12222000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2018-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"openingCash":{"value":147000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2018-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2018-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":0,"tag":"PreferredStockSharesOutstanding","unit":"shares","start":null,"end":"2018-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":50448000000,"tag":"Assets","unit":"USD","start":null,"end":"2019-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"closingCurrentLiabilities":{"value":4568000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2019-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"closingCapitalEmployed":{"value":45880000000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":13239000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2019-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"closingTotalEquity":{"value":13239000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2019-12-31","filed":"2023-02-23","accession":"0000072903-23-000007","form":"10-K"},"closingCash":{"value":248000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2019-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2019-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"parentNetIncome":{"value":1372000000,"tag":"NetIncomeLoss","unit":"USD","start":"2019-01-01","end":"2019-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"preferredDividends":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"incomeTaxExpense":{"value":128000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2019-01-01","end":"2019-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"pretaxIncome":{"value":1500000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2019-01-01","end":"2019-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"effectiveTaxRate":{"value":0.08533333333333333,"inputNames":["incomeTaxExpense","pretaxIncome"]},"nopat":{"value":1924458666.6666665,"inputNames":["operatingIncome","effectiveTaxRate"]},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":43703500000,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: No unambiguous matching annual USD fact; cashConversion: -70.11661807580175; roce: 4.814259727481781 fcfMargin component 1 (2022-02-23) · fcfMargin component 2 (2022-02-23) cashConversion component 1 (2022-02-23) · cashConversion component 2 (2022-02-23) · cashConversion component 3 (2022-02-23) roce component 1 (2022-02-23) · roce component 2 (2020-02-21) · roce component 3 (2020-02-21) · roce component 4 (2021-02-17) · roce component 5 (2021-02-17)
2018-12-31	-7.24	-66.22	4.88	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-835000000,"capex":{"accession":"0000072903-21-000012","end":"2018-12-31","filed":"2021-02-17","form":"10-K","start":"2018-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-21-000012","end":"2018-12-31","filed":"2021-02-17","form":"10-K","start":"2018-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":11537000000,"tag":"Revenues","unit":"USD","start":"2018-01-01","end":"2018-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"netIncome":{"value":1261000000,"tag":"NetIncomeLoss","unit":"USD","start":"2018-01-01","end":"2018-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"operatingIncome":{"value":1965000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2018-01-01","end":"2018-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"openingAssets":{"value":43030000000,"tag":"Assets","unit":"USD","start":null,"end":"2017-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"openingCurrentLiabilities":{"value":4088000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2017-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"openingCapitalEmployed":{"value":38942000000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":11455000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2017-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"openingTotalEquity":{"value":11455000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2017-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"openingCash":{"value":83000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2017-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2017-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":45987000000,"tag":"Assets","unit":"USD","start":null,"end":"2018-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"closingCurrentLiabilities":{"value":4460000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2018-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"closingCapitalEmployed":{"value":41527000000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":12222000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2018-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"closingTotalEquity":{"value":12222000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2018-12-31","filed":"2022-02-23","accession":"0000072903-22-000010","form":"10-K"},"closingCash":{"value":147000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2018-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2018-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":0,"tag":"PreferredStockSharesOutstanding","unit":"shares","start":null,"end":"2018-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"parentNetIncome":{"value":1261000000,"tag":"NetIncomeLoss","unit":"USD","start":"2018-01-01","end":"2018-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"preferredDividends":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"incomeTaxExpense":{"value":181000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2018-01-01","end":"2018-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"pretaxIncome":{"value":1442000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2018-01-01","end":"2018-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"effectiveTaxRate":{"value":0.12552011095700416,"inputNames":["incomeTaxExpense","pretaxIncome"]},"nopat":{"value":1718352981.969487,"inputNames":["operatingIncome","effectiveTaxRate"]},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":40234500000,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{"fcfMargin":{"fcfTotal":{"value":-835000000,"ocf":{"tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD","start":"2018-01-01","end":"2018-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"capex":{"tag":"PaymentsToAcquireProductiveAssets","unit":"USD","start":"2018-01-01","end":"2018-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"}},"revenue":{"value":11537000000,"tag":"Revenues","unit":"USD","start":"2018-01-01","end":"2018-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"}}}}; fcfMargin: -7.237583427234116; cashConversion: -66.2172878667724; roce: 4.883868321962495 fcfMargin component 1 (2019-02-22) · fcfMargin component 2 (2019-02-22) · fcfMargin component 3 (2019-02-22) cashConversion component 1 (2021-02-17) · cashConversion component 2 (2021-02-17) · cashConversion component 3 (2021-02-17) roce component 1 (2021-02-17) · roce component 2 (2019-02-22) · roce component 3 (2019-02-22) · roce component 4 (2020-02-21) · roce component 5 (2020-02-21)
2017-12-31	-1.03	-10.28	5.79	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-118000000,"capex":{"accession":"0000072903-20-000011","end":"2017-12-31","filed":"2020-02-21","form":"10-K","start":"2017-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-20-000011","end":"2017-12-31","filed":"2020-02-21","form":"10-K","start":"2017-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":11404000000,"tag":"Revenues","unit":"USD","start":"2017-01-01","end":"2017-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"netIncome":{"value":1148000000,"tag":"NetIncomeLoss","unit":"USD","start":"2017-01-01","end":"2017-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"operatingIncome":{"value":2223000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2017-01-01","end":"2017-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"openingAssets":{"value":41155000000,"tag":"Assets","unit":"USD","start":null,"end":"2016-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"openingCurrentLiabilities":{"value":3247000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2016-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"openingCapitalEmployed":{"value":37908000000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":11021000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2016-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"openingTotalEquity":{"value":11021000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2016-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"openingCash":{"value":85000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2016-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2016-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":43030000000,"tag":"Assets","unit":"USD","start":null,"end":"2017-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"closingCurrentLiabilities":{"value":4088000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2017-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"closingCapitalEmployed":{"value":38942000000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":11455000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2017-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"closingTotalEquity":{"value":11455000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2017-12-31","filed":"2021-02-17","accession":"0000072903-21-000012","form":"10-K"},"closingCash":{"value":83000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2017-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2017-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":1148000000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2017-01-01","end":"2017-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"incomeTaxExpense":{"value":542000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2017-01-01","end":"2017-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"pretaxIncome":{"value":1690000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2017-01-01","end":"2017-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"effectiveTaxRate":{"value":0.3207100591715976,"inputNames":["incomeTaxExpense","pretaxIncome"]},"nopat":{"value":1510061538.4615383,"inputNames":["operatingIncome","effectiveTaxRate"]},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":38425000000,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{"fcfMargin":{"fcfTotal":{"value":-118000000,"ocf":{"tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD","start":"2017-01-01","end":"2017-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"capex":{"tag":"PaymentsToAcquireProductiveAssets","unit":"USD","start":"2017-01-01","end":"2017-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"}},"revenue":{"value":11404000000,"tag":"Revenues","unit":"USD","start":"2017-01-01","end":"2017-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"}}}}; fcfMargin: -1.0347246580147316; cashConversion: -10.278745644599303; roce: 5.785296031229668 fcfMargin component 1 (2019-02-22) · fcfMargin component 2 (2019-02-22) · fcfMargin component 3 (2019-02-22) cashConversion component 1 (2020-02-21) · cashConversion component 2 (2020-02-21) · cashConversion component 3 (2020-02-21) roce component 1 (2020-02-21) · roce component 2 (2018-02-23) · roce component 3 (2018-02-23) · roce component 4 (2019-02-22) · roce component 5 (2019-02-22)
2016-12-31	-1.29	-12.73	6.16	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-143000000,"capex":{"accession":"0000072903-19-000010","end":"2016-12-31","filed":"2019-02-22","form":"10-K","start":"2016-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-19-000010","end":"2016-12-31","filed":"2019-02-22","form":"10-K","start":"2016-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":11107000000,"tag":"Revenues","unit":"USD","start":"2016-01-01","end":"2016-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"netIncome":{"value":1123000000,"tag":"NetIncomeLoss","unit":"USD","start":"2016-01-01","end":"2016-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"operatingIncome":{"value":2240000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2016-01-01","end":"2016-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"openingAssets":{"value":38821477000,"tag":"Assets","unit":"USD","start":null,"end":"2015-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"openingCurrentLiabilities":{"value":4058297000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2015-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"openingCapitalEmployed":{"value":34763180000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":10600920000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2015-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"openingTotalEquity":{"value":10601000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2015-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"openingCash":{"value":85000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2015-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2015-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":41155000000,"tag":"Assets","unit":"USD","start":null,"end":"2016-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"closingCurrentLiabilities":{"value":3247000000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2016-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"closingCapitalEmployed":{"value":37908000000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":11021000000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2016-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"closingTotalEquity":{"value":11021000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2016-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"closingCash":{"value":85000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2016-12-31","filed":"2020-02-21","accession":"0000072903-20-000011","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2016-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":1123000000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2016-01-01","end":"2016-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"incomeTaxExpense":{"value":581000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2016-01-01","end":"2016-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"pretaxIncome":{"value":1704000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2016-01-01","end":"2016-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"effectiveTaxRate":{"value":0.340962441314554,"inputNames":["incomeTaxExpense","pretaxIncome"]},"nopat":{"value":1476244131.455399,"inputNames":["operatingIncome","effectiveTaxRate"]},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":36335590000,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: -1.2874763662555144; cashConversion: -12.733748886910062; roce: 6.164754721197592 fcfMargin component 1 (2019-02-22) · fcfMargin component 2 (2019-02-22) · fcfMargin component 3 (2019-02-22) cashConversion component 1 (2019-02-22) · cashConversion component 2 (2019-02-22) · cashConversion component 3 (2019-02-22) roce component 1 (2019-02-22) · roce component 2 (2017-02-24) · roce component 3 (2017-02-24) · roce component 4 (2018-02-23) · roce component 5 (2018-02-23)
2015-12-31	-5.85	-65.55	5.91	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-645000000,"capex":{"accession":"0000072903-18-000009","end":"2015-12-31","filed":"2018-02-23","form":"10-K","start":"2015-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-18-000009","end":"2015-12-31","filed":"2018-02-23","form":"10-K","start":"2015-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":11024000000,"tag":"Revenues","unit":"USD","start":"2015-01-01","end":"2015-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"netIncome":{"value":984000000,"tag":"NetIncomeLoss","unit":"USD","start":"2015-01-01","end":"2015-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"operatingIncome":{"value":2000000000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2015-01-01","end":"2015-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"openingAssets":{"value":36957884000,"tag":"Assets","unit":"USD","start":null,"end":"2014-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"openingCurrentLiabilities":{"value":4064583000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2014-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"openingCapitalEmployed":{"value":32893301000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":10214482000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2014-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"openingTotalEquity":{"value":10214000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2014-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"openingCash":{"value":80000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2014-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2014-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":38821477000,"tag":"Assets","unit":"USD","start":null,"end":"2015-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"closingCurrentLiabilities":{"value":4058297000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2015-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"closingCapitalEmployed":{"value":34763180000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":10600920000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2015-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"closingTotalEquity":{"value":10601000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2015-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"closingCash":{"value":85000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2015-12-31","filed":"2019-02-22","accession":"0000072903-19-000010","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2015-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":984000000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2015-01-01","end":"2015-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"incomeTaxExpense":{"value":543000000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2015-01-01","end":"2015-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"pretaxIncome":{"value":1527000000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2015-01-01","end":"2015-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"effectiveTaxRate":{"value":0.3555992141453831,"inputNames":["incomeTaxExpense","pretaxIncome"]},"nopat":{"value":1288801571.7092338,"inputNames":["operatingIncome","effectiveTaxRate"]},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":33828240500,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: -5.850870827285921; cashConversion: -65.54878048780488; roce: 5.912219998554167 fcfMargin component 1 (2018-02-23) · fcfMargin component 2 (2018-02-23) · fcfMargin component 3 (2018-02-23) cashConversion component 1 (2018-02-23) · cashConversion component 2 (2018-02-23) · cashConversion component 3 (2018-02-23) roce component 1 (2018-02-23) · roce component 2 (2016-02-19) · roce component 3 (2016-02-19) · roce component 4 (2017-02-24) · roce component 5 (2017-02-24)
2014-12-31	-4.62	-52.90	6.17	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-540305000,"capex":{"accession":"0000072903-17-000008","end":"2014-12-31","filed":"2017-02-24","form":"10-K","start":"2014-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-17-000008","end":"2014-12-31","filed":"2017-02-24","form":"10-K","start":"2014-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":11686135000,"tag":"Revenues","unit":"USD","start":"2014-01-01","end":"2014-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"netIncome":{"value":1021306000,"tag":"NetIncomeLoss","unit":"USD","start":"2014-01-01","end":"2014-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"operatingIncome":{"value":1948130000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2014-01-01","end":"2014-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"openingAssets":{"value":33907490000,"tag":"Assets","unit":"USD","start":null,"end":"2013-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"openingCurrentLiabilities":{"value":3654498000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2013-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"openingCapitalEmployed":{"value":30252992000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":9565950000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2013-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"openingTotalEquity":{"value":9565950000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2013-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"openingCash":{"value":107144000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2013-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2013-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":36957884000,"tag":"Assets","unit":"USD","start":null,"end":"2014-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"closingCurrentLiabilities":{"value":4064583000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2014-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"closingCapitalEmployed":{"value":32893301000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":10214482000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2014-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"closingTotalEquity":{"value":10214000000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2014-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"closingCash":{"value":80000000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2014-12-31","filed":"2018-02-23","accession":"0000072903-18-000009","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2014-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":1021306000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2014-01-01","end":"2014-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"incomeTaxExpense":{"value":523815000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2014-01-01","end":"2014-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"pretaxIncome":{"value":1545121000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2014-01-01","end":"2014-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"effectiveTaxRate":{"value":0.33901228447480813,"inputNames":["incomeTaxExpense","pretaxIncome"]},"nopat":{"value":1287689998.246092,"inputNames":["operatingIncome","effectiveTaxRate"]},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":31573146500,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: -4.623470463074404; cashConversion: -52.90334140796197; roce: 6.170211765241707 fcfMargin component 1 (2017-02-24) · fcfMargin component 2 (2017-02-24) · fcfMargin component 3 (2017-02-24) cashConversion component 1 (2017-02-24) · cashConversion component 2 (2017-02-24) · cashConversion component 3 (2017-02-24) roce component 1 (2017-02-24) · roce component 2 (2015-02-20) · roce component 3 (2015-02-20) · roce component 4 (2016-02-19) · roce component 5 (2016-02-19)
2013-12-31	-7.43	-85.56	6.32	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-811289000,"capex":{"accession":"0000072903-16-000123","end":"2013-12-31","filed":"2016-02-19","form":"10-K","start":"2013-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0000072903-16-000123","end":"2013-12-31","filed":"2016-02-19","form":"10-K","start":"2013-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":10914922000,"tag":"Revenues","unit":"USD","start":"2013-01-01","end":"2013-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"netIncome":{"value":948234000,"tag":"NetIncomeLoss","unit":"USD","start":"2013-01-01","end":"2013-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"operatingIncome":{"value":1847555000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2013-01-01","end":"2013-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"openingAssets":{"value":31140686000,"tag":"Assets","unit":"USD","start":null,"end":"2012-12-31","filed":"2014-02-21","accession":"0000072903-14-000009","form":"10-K"},"openingCurrentLiabilities":{"value":2937073000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2012-12-31","filed":"2014-02-21","accession":"0000072903-14-000009","form":"10-K"},"openingCapitalEmployed":{"value":28203613000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":8874077000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2012-12-31","filed":"2014-02-21","accession":"0000072903-14-000009","form":"10-K"},"openingTotalEquity":{"value":8874077000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2012-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"openingCash":{"value":82323000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2012-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2012-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":0,"tag":"PreferredStockSharesOutstanding","unit":"shares","start":null,"end":"2012-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":33907490000,"tag":"Assets","unit":"USD","start":null,"end":"2013-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"closingCurrentLiabilities":{"value":3654498000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2013-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"closingCapitalEmployed":{"value":30252992000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":9565950000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2013-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"closingTotalEquity":{"value":9565950000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2013-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"closingCash":{"value":107144000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2013-12-31","filed":"2017-02-24","accession":"0000072903-17-000008","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2013-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":948234000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2013-01-01","end":"2013-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"incomeTaxExpense":{"value":483976000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2013-01-01","end":"2013-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"pretaxIncome":{"value":1432210000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2013-01-01","end":"2013-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"effectiveTaxRate":{"value":0.337922511363557,"inputNames":["incomeTaxExpense","pretaxIncome"]},"nopat":{"value":1223224574.5177035,"inputNames":["operatingIncome","effectiveTaxRate"]},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":29228302500,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: -7.43284285494665; cashConversion: -85.55788971920433; roce: 6.321116322099102 fcfMargin component 1 (2016-02-19) · fcfMargin component 2 (2016-02-19) · fcfMargin component 3 (2016-02-19) cashConversion component 1 (2016-02-19) · cashConversion component 2 (2016-02-19) · cashConversion component 3 (2016-02-19) roce component 1 (2016-02-19) · roce component 2 (2014-02-21) · roce component 3 (2014-02-21) · roce component 4 (2015-02-20) · roce component 5 (2015-02-20)
2012-12-31	19.79	221.46	6.74	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":2004756000,"capex":{"accession":"0001140361-13-008903","end":"2012-12-31","filed":"2013-02-22","form":"10-K","start":"2012-01-01","tag":"PaymentsToAcquirePropertyPlantAndEquipment","unit":"USD"},"ocf":{"accession":"0000072903-15-000011","end":"2012-12-31","filed":"2015-02-20","form":"10-K","start":"2012-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":10128223000,"tag":"Revenues","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"netIncome":{"value":905229000,"tag":"NetIncomeLoss","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"operatingIncome":{"value":1822683000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"openingAssets":{"value":29497267000,"tag":"Assets","unit":"USD","start":null,"end":"2011-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"openingCurrentLiabilities":{"value":3588639000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2011-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"openingCapitalEmployed":{"value":25908628000,"inputNames":["openingAssets","openingCurrentLiabilities"]},"openingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingTotalEquity":{"value":8482198000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2011-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"openingCash":{"value":60684000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2011-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2011-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":0,"tag":"PreferredStockSharesOutstanding","unit":"shares","start":null,"end":"2011-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":31140686000,"tag":"Assets","unit":"USD","start":null,"end":"2012-12-31","filed":"2014-02-21","accession":"0000072903-14-000009","form":"10-K"},"closingCurrentLiabilities":{"value":2937073000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2012-12-31","filed":"2014-02-21","accession":"0000072903-14-000009","form":"10-K"},"closingCapitalEmployed":{"value":28203613000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":8874077000,"tag":"StockholdersEquity","unit":"USD","start":null,"end":"2012-12-31","filed":"2014-02-21","accession":"0000072903-14-000009","form":"10-K"},"closingTotalEquity":{"value":8874077000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2012-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"closingCash":{"value":82323000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2012-12-31","filed":"2016-02-19","accession":"0000072903-16-000123","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2012-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":0,"tag":"PreferredStockSharesOutstanding","unit":"shares","start":null,"end":"2012-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":905229000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"incomeTaxExpense":{"value":450203000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"pretaxIncome":{"value":1355432000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"effectiveTaxRate":{"value":0.3321472416174327,"inputNames":["incomeTaxExpense","pretaxIncome"]},"nopat":{"value":1217283869.207013,"inputNames":["operatingIncome","effectiveTaxRate"]},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":27056120500,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{"roe":{"commonNetIncome":{"value":905229000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K","sourceContainers":[{"container":"current_sec_archive","file":"CIK0000072903.json"},{"container":"original_companyfacts","file":"CIK0000072903.json","sha256":"98f5a6613b1dcb9fb6c0690489bd37010fe437f60aab58f2d3b1fadeead3babd"}]},"averageCommonEquity":{"value":8678137500,"inputNames":["openingCommonEquity","closingCommonEquity"]},"openingCommonEquity":{"value":8482198000,"tag":"CommonStockholdersEquity","unit":"USD","start":null,"end":"2011-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K","sourceContainers":[{"container":"current_sec_archive","file":"CIK0000072903.json"},{"container":"original_companyfacts","file":"CIK0000072903.json","sha256":"98f5a6613b1dcb9fb6c0690489bd37010fe437f60aab58f2d3b1fadeead3babd"}]},"closingCommonEquity":{"value":8874077000,"tag":"CommonStockholdersEquity","unit":"USD","start":null,"end":"2012-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K","sourceContainers":[{"container":"current_sec_archive","file":"CIK0000072903.json"},{"container":"original_companyfacts","file":"CIK0000072903.json","sha256":"98f5a6613b1dcb9fb6c0690489bd37010fe437f60aab58f2d3b1fadeead3babd"}]}},"fcfMargin":{"fcfTotal":{"value":2004756000,"ocf":{"tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"capex":{"tag":"PaymentsToAcquirePropertyPlantAndEquipment","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"}},"revenue":{"value":10128223000,"tag":"Revenues","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"}},"cashConversion":{"fcfTotal":{"value":2004756000,"ocf":{"tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"capex":{"tag":"PaymentsToAcquirePropertyPlantAndEquipment","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"}},"netIncome":{"value":905229000,"tag":"NetIncomeLoss","unit":"USD","start":"2012-01-01","end":"2012-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"}}}}; fcfMargin: 19.79375849050717; cashConversion: 221.46396105294906; roce: 6.736675348559302 fcfMargin component 1 (2013-02-22) · fcfMargin component 2 (2013-02-22) · fcfMargin component 3 (2013-02-22) cashConversion component 1 (2013-02-22) · cashConversion component 2 (2013-02-22) · cashConversion component 3 (2013-02-22) roce component 1 (2015-02-20) · roce component 2 (2013-02-22) · roce component 3 (2013-02-22) · roce component 4 (2014-02-21) · roce component 5 (2014-02-21)
2011-12-31	Unavailable	Unavailable	Unavailable	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"revenue":{"value":10654770000,"tag":"Revenues","unit":"USD","start":"2010-12-31","end":"2011-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"netIncome":{"value":841172000,"tag":"NetIncomeLoss","unit":"USD","start":"2010-12-31","end":"2011-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"operatingIncome":{"value":1781602000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2010-12-31","end":"2011-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"openingAssets":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCurrentLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCapitalEmployed":{"value":null,"inputNames":["openingAssets","openingCurrentLiabilities"],"reason":"Exact assets/current-liabilities balance missing, conflicting or from different filings at 2010-12-30"},"openingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingTotalEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingNoncontrollingEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2010-12-30"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":29497267000,"tag":"Assets","unit":"USD","start":null,"end":"2011-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"closingCurrentLiabilities":{"value":3588639000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2011-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"closingCapitalEmployed":{"value":25908628000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingTotalEquity":{"value":8482198000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2011-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"closingCash":{"value":60684000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2011-12-31","filed":"2015-02-20","accession":"0000072903-15-000011","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2011-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":0,"tag":"PreferredStockSharesOutstanding","unit":"shares","start":null,"end":"2011-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":834378000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2010-12-31","end":"2011-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"incomeTaxExpense":{"value":468316000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2010-12-31","end":"2011-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"pretaxIncome":{"value":1309690000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2010-12-31","end":"2011-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Pretax income less tax does not reconcile to consolidated net income; accounting scopes differ"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Pretax income less tax does not reconcile to consolidated net income; accounting scopes differ"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":null,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: Stored FCF total has no matching annual OCF/capex duration; cashConversion: Stored FCF total has no matching annual OCF/capex duration; roce: matching numerator and positive exact opening/closing CapitalEmployed required; ambiguous scopes remain unavailable; unavailable: openingCapitalEmployed; Exact assets/current-liabilities balance missing, conflicting or from different filings at 2010-12-30 fcfMargin component 1 (2012-02-24) cashConversion component 1 (2012-02-24) roce component 1 (2012-02-24) · roce component 2 (2013-02-22) · roce component 3 (2013-02-22)
2010-12-31	Unavailable	Unavailable	Unavailable	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"revenue":{"value":10310947000,"tag":"Revenues","unit":"USD","start":"2009-12-31","end":"2010-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"netIncome":{"value":755834000,"tag":"ProfitLoss","unit":"USD","start":"2009-12-31","end":"2010-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"operatingIncome":{"value":1619969000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2009-12-31","end":"2010-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"openingAssets":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCurrentLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCapitalEmployed":{"value":null,"inputNames":["openingAssets","openingCurrentLiabilities"],"reason":"Exact assets/current-liabilities balance missing, conflicting or from different filings at 2009-12-30"},"openingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingTotalEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingNoncontrollingEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2009-12-30"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":27387690000,"tag":"Assets","unit":"USD","start":null,"end":"2010-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"closingCurrentLiabilities":{"value":2536533000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2010-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"closingCapitalEmployed":{"value":24851157000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingTotalEquity":{"value":8083519000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2010-12-31","filed":"2014-02-21","accession":"0000072903-14-000009","form":"10-K"},"closingCash":{"value":108437000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2010-12-31","filed":"2014-02-21","accession":"0000072903-14-000009","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2010-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":1049800,"tag":"PreferredStockSharesOutstanding","unit":"shares","start":null,"end":"2010-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":751593000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2009-12-31","end":"2010-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"incomeTaxExpense":{"value":436635000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2009-12-31","end":"2010-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"pretaxIncome":{"value":1188591000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2009-12-31","end":"2010-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Tax/pretax/operating/net-income inputs do not share a filing"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Tax/pretax/operating/net-income inputs do not share a filing"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":null,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: Stored FCF total has no matching annual OCF/capex duration; cashConversion: Stored FCF total has no matching annual OCF/capex duration; roce: matching numerator and positive exact opening/closing CapitalEmployed required; ambiguous scopes remain unavailable; unavailable: openingCapitalEmployed; Exact assets/current-liabilities balance missing, conflicting or from different filings at 2009-12-30 fcfMargin component 1 (2012-02-24) cashConversion component 1 (2011-02-28) roce component 1 (2012-02-24) · roce component 2 (2012-02-24) · roce component 3 (2012-02-24)
2009-12-31	Unavailable	Unavailable	Unavailable	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"revenue":{"value":9644303000,"tag":"Revenues","unit":"USD","start":"2008-12-31","end":"2009-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"netIncome":{"value":680887000,"tag":"ProfitLoss","unit":"USD","start":"2008-12-31","end":"2009-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"operatingIncome":{"value":1468572000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2008-12-31","end":"2009-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"openingAssets":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCurrentLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCapitalEmployed":{"value":null,"inputNames":["openingAssets","openingCurrentLiabilities"],"reason":"Exact assets/current-liabilities balance missing, conflicting or from different filings at 2008-12-30"},"openingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingTotalEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingNoncontrollingEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCash":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2008-12-30"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":25305961000,"tag":"Assets","unit":"USD","start":null,"end":"2009-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"closingCurrentLiabilities":{"value":3089999000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2009-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"closingCapitalEmployed":{"value":22215962000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingTotalEquity":{"value":7283245000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2009-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"closingCash":{"value":115648000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2009-12-31","filed":"2013-02-22","accession":"0001140361-13-008903","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2009-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":1049800,"tag":"PreferredStockSharesOutstanding","unit":"shares","start":null,"end":"2009-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":676646000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2008-12-31","end":"2009-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"incomeTaxExpense":{"value":371314000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2008-12-31","end":"2009-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"pretaxIncome":{"value":1056838000,"tag":"IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest","unit":"USD","start":"2008-12-31","end":"2009-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Tax/pretax/operating/net-income inputs do not share a filing"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Tax/pretax/operating/net-income inputs do not share a filing"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":null,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: Stored FCF total has no matching annual OCF/capex duration; cashConversion: Stored FCF total has no matching annual OCF/capex duration; roce: matching numerator and positive exact opening/closing CapitalEmployed required; ambiguous scopes remain unavailable; unavailable: openingCapitalEmployed; Exact assets/current-liabilities balance missing, conflicting or from different filings at 2008-12-30 fcfMargin component 1 (2012-02-24) cashConversion component 1 (2011-02-28) roce component 1 (2012-02-24) · roce component 2 (2011-02-28) · roce component 3 (2011-02-28)
2008-12-31	15.06	261.42	Unavailable	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":1687606000,"capex":{"accession":"0001140361-11-012444","end":"2008-12-31","filed":"2011-02-28","form":"10-K","start":"2008-01-01","tag":"PaymentsToAcquirePropertyPlantAndEquipment","unit":"USD"},"ocf":{"accession":"0001140361-11-012444","end":"2008-12-31","filed":"2011-02-28","form":"10-K","start":"2008-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":11203156000,"tag":"Revenues","unit":"USD","start":"2008-01-01","end":"2008-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"netIncome":{"value":645554000,"tag":"ProfitLoss","unit":"USD","start":"2008-01-01","end":"2008-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"operatingIncome":{"value":1390791000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2008-01-01","end":"2008-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"openingAssets":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCurrentLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCapitalEmployed":{"value":null,"inputNames":["openingAssets","openingCurrentLiabilities"],"reason":"Exact assets/current-liabilities balance missing, conflicting or from different filings at 2007-12-31"},"openingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingTotalEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingNoncontrollingEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCash":{"value":57911000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2007-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2007-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":24958495000,"tag":"Assets","unit":"USD","start":null,"end":"2008-12-31","filed":"2010-02-26","accession":"0001047469-10-001536","form":"10-K"},"closingCurrentLiabilities":{"value":3046245000,"tag":"LiabilitiesCurrent","unit":"USD","start":null,"end":"2008-12-31","filed":"2010-02-26","accession":"0001047469-10-001536","form":"10-K"},"closingCapitalEmployed":{"value":21912250000,"inputNames":["closingAssets","closingCurrentLiabilities"]},"closingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingTotalEquity":{"value":6963741000,"tag":"StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest","unit":"USD","start":null,"end":"2008-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"closingCash":{"value":259842000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2008-12-31","filed":"2012-02-24","accession":"0001140361-12-010717","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2008-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":1049800,"tag":"PreferredStockSharesOutstanding","unit":"shares","start":null,"end":"2008-12-31","filed":"2010-02-26","accession":"0001047469-10-001536","form":"10-K"},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":641313000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2008-01-01","end":"2008-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"incomeTaxExpense":{"value":338686000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2008-01-01","end":"2008-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"pretaxIncome":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Matching annual income-tax expense or supported pretax income unavailable"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Matching annual income-tax expense or supported pretax income unavailable"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":null,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: 15.063665988405411; cashConversion: 261.41980376544797; roce: matching numerator and positive exact opening/closing CapitalEmployed required; ambiguous scopes remain unavailable; unavailable: openingCapitalEmployed; Exact assets/current-liabilities balance missing, conflicting or from different filings at 2007-12-31 fcfMargin component 1 (2011-02-28) · fcfMargin component 2 (2011-02-28) · fcfMargin component 3 (2011-02-28) cashConversion component 1 (2011-02-28) · cashConversion component 2 (2011-02-28) · cashConversion component 3 (2011-02-28) roce component 1 (2011-02-28) · roce component 2 (2010-02-26) · roce component 3 (2010-02-26)
2007-12-31	-4.64	-80.60	Unavailable	Inputs & filings Calculation inputs: {"original":{"fcfTotal":{"value":-465323000,"capex":{"accession":"0001047469-10-001536","end":"2007-12-31","filed":"2010-02-26","form":"10-K","start":"2007-01-01","tag":"PaymentsToAcquireProductiveAssets","unit":"USD"},"ocf":{"accession":"0001047469-10-001536","end":"2007-12-31","filed":"2010-02-26","form":"10-K","start":"2007-01-01","tag":"NetCashProvidedByUsedInOperatingActivities","unit":"USD"}},"revenue":{"value":10034170000,"tag":"Revenues","unit":"USD","start":"2007-01-01","end":"2007-12-31","filed":"2010-02-26","accession":"0001047469-10-001536","form":"10-K"},"netIncome":{"value":577348000,"tag":"ProfitLoss","unit":"USD","start":"2007-01-01","end":"2007-12-31","filed":"2010-02-26","accession":"0001047469-10-001536","form":"10-K"},"operatingIncome":{"value":1351073000,"tag":"OperatingIncomeLoss","unit":"USD","start":"2007-01-01","end":"2007-12-31","filed":"2010-02-26","accession":"0001047469-10-001536","form":"10-K"},"openingAssets":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCurrentLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCapitalEmployed":{"value":null,"inputNames":["openingAssets","openingCurrentLiabilities"],"reason":"Exact assets/current-liabilities balance missing, conflicting or from different filings at 2006-12-31"},"openingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingTotalEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingNoncontrollingEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCash":{"value":37458000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2006-12-31","filed":"2010-02-26","accession":"0001047469-10-001536","form":"10-K"},"openingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"openingInvestedCapital":{"value":null,"inputNames":["openingBorrowings","openingTotalEquity","openingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2006-12-31"},"openingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"openingCommonEquity":{"value":null,"inputNames":["openingParentEquity","openingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"closingAssets":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCurrentLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCapitalEmployed":{"value":null,"inputNames":["closingAssets","closingCurrentLiabilities"],"reason":"Exact assets/current-liabilities balance missing, conflicting or from different filings at 2007-12-31"},"closingParentEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingTotalEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingNoncontrollingEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingLiabilities":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCash":{"value":57911000,"tag":"CashAndCashEquivalentsAtCarryingValue","unit":"USD","start":null,"end":"2007-12-31","filed":"2011-02-28","accession":"0001140361-11-012444","form":"10-K"},"closingBorrowings":{"value":null,"reason":"No supported complete debt aggregate or non-overlapping borrowing components; leases excluded"},"closingInvestedCapital":{"value":null,"inputNames":["closingBorrowings","closingTotalEquity","closingCash"],"reason":"Exact complete borrowings, consolidated equity and cash missing, ambiguous or from different filings at 2007-12-31"},"closingPreferredEquity":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingPreferredShares":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"closingCommonEquity":{"value":null,"inputNames":["closingParentEquity","closingPreferredShares"],"reason":"Common equity scope requires explicit preferred carrying value or zero preferred shares; absence is not zero"},"commonNetIncome":{"value":573107000,"tag":"NetIncomeLossAvailableToCommonStockholdersBasic","unit":"USD","start":"2007-01-01","end":"2007-12-31","filed":"2010-02-26","accession":"0001047469-10-001536","form":"10-K"},"incomeTaxExpense":{"value":294484000,"tag":"IncomeTaxExpenseBenefit","unit":"USD","start":"2007-01-01","end":"2007-12-31","filed":"2010-02-26","accession":"0001047469-10-001536","form":"10-K"},"pretaxIncome":{"value":null,"reason":"Missing or conflicting matching SEC fact","conflict":false},"effectiveTaxRate":{"value":null,"inputNames":["incomeTaxExpense","pretaxIncome"],"reason":"Matching annual income-tax expense or supported pretax income unavailable"},"nopat":{"value":null,"inputNames":["operatingIncome","effectiveTaxRate"],"reason":"Matching annual income-tax expense or supported pretax income unavailable"},"averageInvestedCapital":{"value":null,"inputNames":["openingInvestedCapital","closingInvestedCapital"]},"averageCapitalEmployed":{"value":null,"inputNames":["openingCapitalEmployed","closingCapitalEmployed"]},"averageCommonEquity":{"value":null,"inputNames":["openingCommonEquity","closingCommonEquity"]}},"recovered":{}}; fcfMargin: -4.63738405867152; cashConversion: -80.59662456611957; roce: matching numerator and positive exact opening/closing CapitalEmployed required; ambiguous scopes remain unavailable; unavailable: openingCapitalEmployed, closingCapitalEmployed; Exact assets/current-liabilities balance missing, conflicting or from different filings at 2006-12-31; Exact assets/current-liabilities balance missing, conflicting or from different filings at 2007-12-31 fcfMargin component 1 (2010-02-26) · fcfMargin component 2 (2010-02-26) · fcfMargin component 3 (2010-02-26) cashConversion component 1 (2010-02-26) · cashConversion component 2 (2010-02-26) · cashConversion component 3 (2010-02-26) roce component 1 (2010-02-26)

Annual operating facts

Complete annual history, independent of chart loading and range. Operating margin is operating profit as a percentage of revenue; net margin is consolidated net profit as a percentage of revenue. Negative margins show losses. Missing inputs remain unavailable. Metric definitions.

Fiscal end	Revenue (USD)	Operating margin (%)	Net margin (%)	Inputs & filing sources
2025-12-31	Unavailable	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; operatingIncome: 2583000000; netIncome: 2018000000 operatingIncome (2026-02-25) netIncome (2026-02-25)
2024-12-31	Unavailable	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; operatingIncome: 2386000000; netIncome: 1936000000 operatingIncome (2026-02-25) netIncome (2026-02-25)
2023-12-31	Unavailable	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; operatingIncome: 2481000000; netIncome: 1771000000 operatingIncome (2026-02-25) netIncome (2026-02-25)
2022-12-31	Unavailable	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; operatingIncome: 2428000000; netIncome: 1736000000 operatingIncome (2025-02-27) netIncome (2025-02-27)
2021-12-31	Unavailable	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; operatingIncome: 2203000000; netIncome: 1597000000 operatingIncome (2024-02-21) netIncome (2024-02-21)
2020-12-31	Unavailable	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; operatingIncome: 2116000000; netIncome: 1473000000 operatingIncome (2023-02-23) netIncome (2023-02-23)
2019-12-31	Unavailable	Unavailable	Unavailable	Inputs & filings revenue: No unambiguous matching annual USD fact; operatingIncome: 2104000000; netIncome: 1372000000 operatingIncome (2022-02-23) netIncome (2022-02-23)
2018-12-31	11,537,000,000.00	17.03	10.93	Inputs & filings revenue: 11537000000; operatingIncome: 1965000000; netIncome: 1261000000 revenue (2019-02-22) operatingIncome (2021-02-17) netIncome (2021-02-17)
2017-12-31	11,404,000,000.00	19.49	10.07	Inputs & filings revenue: 11404000000; operatingIncome: 2223000000; netIncome: 1148000000 revenue (2019-02-22) operatingIncome (2020-02-21) netIncome (2020-02-21)
2016-12-31	11,107,000,000.00	20.17	10.11	Inputs & filings revenue: 11107000000; operatingIncome: 2240000000; netIncome: 1123000000 revenue (2019-02-22) operatingIncome (2019-02-22) netIncome (2019-02-22)
2015-12-31	11,024,000,000.00	18.14	8.93	Inputs & filings revenue: 11024000000; operatingIncome: 2000000000; netIncome: 984000000 revenue (2018-02-23) operatingIncome (2018-02-23) netIncome (2018-02-23)
2014-12-31	11,686,135,000.00	16.67	8.74	Inputs & filings revenue: 11686135000; operatingIncome: 1948130000; netIncome: 1021306000 revenue (2017-02-24) operatingIncome (2017-02-24) netIncome (2017-02-24)
2013-12-31	10,914,922,000.00	16.93	8.69	Inputs & filings revenue: 10914922000; operatingIncome: 1847555000; netIncome: 948234000 revenue (2016-02-19) operatingIncome (2016-02-19) netIncome (2016-02-19)
2012-12-31	10,128,223,000.00	18.00	8.94	Inputs & filings revenue: 10128223000; operatingIncome: 1822683000; netIncome: 905229000 revenue (2015-02-20) operatingIncome (2015-02-20) netIncome (2015-02-20)
2011-12-31	10,654,770,000.00	16.72	7.89	Inputs & filings revenue: 10654770000; operatingIncome: 1781602000; netIncome: 841172000 revenue (2012-02-24) operatingIncome (2012-02-24) netIncome (2012-02-24)
2010-12-31	10,310,947,000.00	15.71	7.33	Inputs & filings revenue: 10310947000; operatingIncome: 1619969000; netIncome: 755834000 revenue (2012-02-24) operatingIncome (2012-02-24) netIncome (2011-02-28)
2009-12-31	9,644,303,000.00	15.23	7.06	Inputs & filings revenue: 9644303000; operatingIncome: 1468572000; netIncome: 680887000 revenue (2012-02-24) operatingIncome (2012-02-24) netIncome (2011-02-28)
2008-12-31	11,203,156,000.00	12.41	5.76	Inputs & filings revenue: 11203156000; operatingIncome: 1390791000; netIncome: 645554000 revenue (2011-02-28) operatingIncome (2011-02-28) netIncome (2011-02-28)
2007-12-31	10,034,170,000.00	13.46	5.75	Inputs & filings revenue: 10034170000; operatingIncome: 1351073000; netIncome: 577348000 revenue (2010-02-26) operatingIncome (2010-02-26) netIncome (2010-02-26)

XCEL ENERGY INC (XELLL) P/E ratio history

The interactive P/E chart contains all 53 stored weekly price points (2025-10-10–2026-10-08); 53 have an eligible basic or diluted ratio. Annual EPS is carried forward from its fiscal end. Use the P/E range bar or any other chart range bar to change all five chart windows.

Fiscal-year-end snapshots

1 eligible fiscal-year-end observations span 2025-12-31–2025-12-31. Latest eligible diluted P/E: 7.31×; basic P/E: 7.27×, for fiscal end 2025-12-31, using the close on 2025-12-26.

Annual P/E = eligible fiscal-year-end close ÷ reported annual EPS. This is retrospective annual P/E, not TTM or forward P/E. Why we use annual data. Missing or non-positive EPS and missing eligible prices produce unavailable ratios.

Explore the P/E chart and optional reference lines · How P/E history is calculated.

Complete annual P/E history (19 fiscal periods)

Full stored fiscal-year-end P/E history, independent of the selected chart window. Ratios in ×; prices in USD.
Fiscal end	Price date	Close	Price basis	Basic P/E	Diluted P/E	EPS filings
2025-12-31	2025-12-26	25.00	Adjusted close	7.27	7.31	Basic EPS (2026-02-25) Diluted EPS (2026-02-25)
2024-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2026-02-25) Diluted EPS (2026-02-25)
2023-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2026-02-25) Diluted EPS (2026-02-25)
2022-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2025-02-27) Diluted EPS (2025-02-27)
2021-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2024-02-21) Diluted EPS (2024-02-21)
2020-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2023-02-23) Diluted EPS (2023-02-23)
2019-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2022-02-23) Diluted EPS (2022-02-23)
2018-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2021-02-17) Diluted EPS (2021-02-17)
2017-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2020-02-21) Diluted EPS (2020-02-21)
2016-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2019-02-22) Diluted EPS (2019-02-22)
2015-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2018-02-23) Diluted EPS (2018-02-23)
2014-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2017-02-24) Diluted EPS (2017-02-24)
2013-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2016-02-19) Diluted EPS (2016-02-19)
2012-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2015-02-20) Diluted EPS (2015-02-20)
2011-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2014-02-21) Diluted EPS (2014-02-21)
2010-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2013-02-22) Diluted EPS (2013-02-22)
2009-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2010-02-26) Diluted EPS (2010-02-26)
2008-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2011-02-28) Diluted EPS (2011-02-28)
2007-12-31	Unavailable	Unavailable	Unavailable	Unavailable	Unavailable	Basic EPS (2010-02-26) Diluted EPS (2010-02-26)

Did this research save you time?

I build and maintain Stock Value Lens independently. If you found it useful, a coffee helps me maintain the tools and improve data updates.

Buy me a coffee · €5