Stock Analysis on Net

Colgate-Palmolive Co. (NYSE:CL)

This company has been moved to the archive! The financial data has not been updated since July 28, 2023.

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Colgate-Palmolive Co., adjusted current assets

US$ in millions

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
As Reported
Current assets 5,113 4,397 4,338 4,179 3,793
Adjustments
Add: Allowance for doubtful accounts and estimated returns 70 78 89 76 82
Add: LIFO reserve1 146 60 65 62 63
After Adjustment
Adjusted current assets 5,329 4,535 4,492 4,317 3,938

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 LIFO reserve. See details »


Adjustments to Total Assets

Colgate-Palmolive Co., adjusted total assets

US$ in millions

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
As Reported
Total assets 15,731 15,040 15,920 15,034 12,161
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 620
Add: Allowance for doubtful accounts and estimated returns 70 78 89 76 82
Add: LIFO reserve2 146 60 65 62 63
Less: Deferred tax assets3 135 193 291 177 152
After Adjustment
Adjusted total assets 15,812 14,985 15,783 14,995 12,774

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 LIFO reserve. See details »

3 Deferred tax assets. See details »


Adjustments to Current Liabilities

Colgate-Palmolive Co., adjusted current liabilities

US$ in millions

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
As Reported
Current liabilities 4,004 4,051 4,404 4,038 3,341
Adjustments
Less: Current restructuring accrual 39 7 21 85 148
After Adjustment
Adjusted current liabilities 3,965 4,044 4,383 3,953 3,193

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).


Adjustments to Total Liabilities

Colgate-Palmolive Co., adjusted total liabilities

US$ in millions

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
As Reported
Total liabilities 14,925 14,069 14,819 14,476 11,964
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 620
Less: Deferred tax liabilities2 383 395 426 507 235
Less: Restructuring accrual 39 9 31 100 202
After Adjustment
Adjusted total liabilities 14,503 13,665 14,362 13,869 12,147

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Colgate-Palmolive Co., adjusted total Colgate-Palmolive Company shareholders’ equity

US$ in millions

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
As Reported
Total Colgate-Palmolive Company shareholders’ equity 401 609 743 117 (102)
Adjustments
Less: Net deferred income taxes1 (248) (202) (135) (330) (83)
Add: Allowance for doubtful accounts and estimated returns 70 78 89 76 82
Add: LIFO reserve2 146 60 65 62 63
Add: Restructuring accrual 39 9 31 100 202
Add: Noncontrolling interests 405 362 358 441 299
After Adjustment
Adjusted total equity 1,309 1,320 1,421 1,126 627

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 Net deferred income taxes. See details »

2 LIFO reserve. See details »


Adjustments to Capitalization Table

Colgate-Palmolive Co., adjusted capitalization table

US$ in millions

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
As Reported
Notes and loans payable 11 39 258 260 12
Current portion of long-term debt 14 12 9 254
Long-term debt, excluding current portion 8,741 7,194 7,334 7,333 6,354
Total reported debt 8,766 7,245 7,601 7,847 6,366
Total Colgate-Palmolive Company shareholders’ equity 401 609 743 117 (102)
Total reported capital 9,167 7,854 8,344 7,964 6,264
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 620
Add: Operating lease liabilities due in one year2 108 137 137 145
Add: Long-term operating lease liabilities3 397 451 476 491
Adjusted total debt 9,271 7,833 8,214 8,483 6,986
Adjustments to Equity
Less: Net deferred income taxes4 (248) (202) (135) (330) (83)
Add: Allowance for doubtful accounts and estimated returns 70 78 89 76 82
Add: LIFO reserve5 146 60 65 62 63
Add: Restructuring accrual 39 9 31 100 202
Add: Noncontrolling interests 405 362 358 441 299
Adjusted total equity 1,309 1,320 1,421 1,126 627
After Adjustment
Adjusted total capital 10,580 9,153 9,635 9,609 7,613

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Operating lease liabilities due in one year. See details »

3 Long-term operating lease liabilities. See details »

4 Net deferred income taxes. See details »

5 LIFO reserve. See details »


Adjustments to Reported Income

Colgate-Palmolive Co., adjusted net income attributable to Colgate-Palmolive Company

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
As Reported
Net income attributable to Colgate-Palmolive Company 1,785 2,166 2,695 2,367 2,400
Adjustments
Add: Deferred income tax expense (benefit)1 (163) (37) (143) 19 53
Add: Increase (decrease) in allowance for doubtful accounts and estimated returns (8) (11) 13 (6) 5
Add: Increase (decrease) in LIFO reserve2 86 (5) 3 (1)
Add: Increase (decrease) in restructuring accrual 30 (22) (69) (102) (32)
Add: Other comprehensive income (loss), net of tax 327 (43) (66) (87) (189)
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 178 170 171 158 139
After Adjustment
Adjusted net income including noncontrolling interests 2,235 2,218 2,604 2,348 2,376

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 Deferred income tax expense (benefit). See details »

2 Increase (decrease) in LIFO reserve. See details »