Stock Analysis on Net

Procter & Gamble Co. (NYSE:PG)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Total Assets

Procter & Gamble Co., adjusted total assets

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Total assets 120,829 117,208 119,307 120,700 115,095 118,310
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 1,143 1,253
Less: Deferred tax assets (included in Other noncurrent assets)2 1,831 1,612 2,214 2,191 2,446 1,971
After Adjustment
Adjusted total assets 118,998 115,596 117,093 118,509 113,792 117,592

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

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

2 Deferred tax assets (included in Other noncurrent assets). See details »


Adjustments to Current Liabilities

Procter & Gamble Co., adjusted current liabilities

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Current liabilities 35,756 33,081 33,132 32,976 30,011 28,237
Adjustments
Less: Current restructuring reserves 174 147 278 472 468 513
After Adjustment
Adjusted current liabilities 35,582 32,934 32,854 32,504 29,543 27,724

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).


Adjustments to Total Liabilities

Procter & Gamble Co., adjusted total liabilities

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Total liabilities 73,764 70,354 72,653 73,822 67,516 65,427
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 1,143 1,253
Less: Deferred tax liabilities2 6,478 6,809 6,153 6,199 6,899 6,163
Less: Restructuring reserves 174 147 278 472 468 513
After Adjustment
Adjusted total liabilities 67,112 63,398 66,222 67,151 61,292 60,004

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

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

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Procter & Gamble Co., adjusted shareholders’ equity attributable to Procter & Gamble

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Shareholders’ equity attributable to Procter & Gamble 46,777 46,589 46,378 46,521 47,194 52,293
Adjustments
Less: Deferred tax assets (liabilities), net1 (4,647) (5,197) (3,939) (4,008) (4,453) (4,192)
Add: Restructuring reserves 174 147 278 472 468 513
Add: Noncontrolling interest 288 265 276 357 385 590
After Adjustment
Adjusted total shareholders’ equity 51,886 52,198 50,871 51,358 52,500 57,588

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

1 Deferred tax assets (liabilities), net. See details »


Adjustments to Capitalization Table

Procter & Gamble Co., adjusted capitalization table

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Debt due within one year 10,229 8,645 8,889 11,183 9,697 10,423
Long-term debt, excluding due within one year 24,378 22,848 23,099 23,537 20,395 20,863
Total reported debt 34,607 31,493 31,988 34,720 30,092 31,286
Shareholders’ equity attributable to Procter & Gamble 46,777 46,589 46,378 46,521 47,194 52,293
Total reported capital 81,384 78,082 78,366 81,241 77,286 83,579
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 1,143 1,253
Add: Current operating lease liabilities2 222 205 219 239
Add: Noncurrent operating lease liabilities3 595 595 631 652
Adjusted total debt 35,424 32,293 32,838 35,611 31,235 32,539
Adjustments to Equity
Less: Deferred tax assets (liabilities), net4 (4,647) (5,197) (3,939) (4,008) (4,453) (4,192)
Add: Restructuring reserves 174 147 278 472 468 513
Add: Noncontrolling interest 288 265 276 357 385 590
Adjusted total shareholders’ equity 51,886 52,198 50,871 51,358 52,500 57,588
After Adjustment
Adjusted total capital 87,310 84,491 83,709 86,969 83,735 90,127

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

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

2 Current operating lease liabilities. See details »

3 Noncurrent operating lease liabilities. See details »

4 Deferred tax assets (liabilities), net. See details »


Adjustments to Reported Income

Procter & Gamble Co., adjusted net earnings attributable to Procter & Gamble (P&G)

US$ in millions

Microsoft Excel
12 months ended: Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Net earnings attributable to Procter & Gamble (P&G) 14,653 14,742 14,306 13,027 3,897 9,750
Adjustments
Add: Deferred income tax expense (benefit)1 (453) (402) (258) (596) (411) (1,844)
Add: Increase (decrease) in restructuring reserves 27 (131) (194) 4 (45) 236
Add: Other comprehensive income (loss), net of tax (38) 1,547 2,425 (1,245) 140 (119)
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 78 43 50 60 70 109
After Adjustment
Adjusted net earnings 14,267 15,799 16,329 11,250 3,651 8,132

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

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