Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

PepsiCo Inc., adjusted current assets

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
As Reported
Current assets 26,950 21,539 21,783 23,001 17,645
Adjustments
Add: Allowance 175 150 147 201 105
After Adjustment
Adjusted current assets 27,125 21,689 21,930 23,202 17,750

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).


Adjustments to Total Assets

PepsiCo Inc., adjusted total assets

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
As Reported
Total assets 100,495 92,187 92,377 92,918 78,547
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowance 175 150 147 201 105
Less: Deferred tax assets2 4,474 4,204 4,310 4,372 4,359
After Adjustment
Adjusted total assets 96,196 88,133 88,214 88,747 74,293

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).

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

2 Deferred tax assets. See details »


Adjustments to Total Liabilities

PepsiCo Inc., adjusted total liabilities

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
As Reported
Total liabilities 81,858 74,914 76,226 79,366 63,679
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Deferred tax liabilities2 3,895 4,133 4,826 4,284 4,091
Less: Restructuring liability 197 196 71 127 149
After Adjustment
Adjusted total liabilities 77,766 70,585 71,329 74,955 59,439

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).

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

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

PepsiCo Inc., adjusted total PepsiCo common shareholders’ equity

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
As Reported
Total PepsiCo common shareholders’ equity 18,503 17,149 16,043 13,454 14,786
Adjustments
Less: Net deferred tax assets (liabilities)1 579 71 (516) 88 268
Add: Allowance 175 150 147 201 105
Add: Restructuring liability 197 196 71 127 149
Add: Noncontrolling interests 134 124 108 98 82
After Adjustment
Adjusted total equity 18,430 17,548 16,885 13,792 14,854

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).

1 Net deferred tax assets (liabilities). See details »


Adjustments to Capitalization Table

PepsiCo Inc., adjusted capitalization table

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
As Reported
Short-term debt obligations 6,510 3,414 4,308 3,780 2,920
Long-term debt obligations, excluding current maturities 37,595 35,657 36,026 40,370 29,148
Total reported debt 44,105 39,071 40,334 44,150 32,068
Total PepsiCo common shareholders’ equity 18,503 17,149 16,043 13,454 14,786
Total reported capital 62,608 56,220 56,377 57,604 46,854
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Current operating lease liabilities2 556 483 446 460 442
Add: Non-current operating lease liabilities (classified in Other liabilities)3 2,400 1,933 1,598 1,233 1,118
Adjusted total debt 47,061 41,487 42,378 45,843 33,628
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4 579 71 (516) 88 268
Add: Allowance 175 150 147 201 105
Add: Restructuring liability 197 196 71 127 149
Add: Noncontrolling interests 134 124 108 98 82
Adjusted total equity 18,430 17,548 16,885 13,792 14,854
After Adjustment
Adjusted total capital 65,491 59,035 59,263 59,635 48,482

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).

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

2 Current operating lease liabilities. See details »

3 Non-current operating lease liabilities (classified in Other liabilities). See details »

4 Net deferred tax assets (liabilities). See details »


Adjustments to Reported Income

PepsiCo Inc., adjusted net income attributable to PepsiCo

US$ in millions

Microsoft Excel
12 months ended: Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
As Reported
Net income attributable to PepsiCo 9,074 8,910 7,618 7,120 7,314
Adjustments
Add: Deferred income tax expense (benefit)1 (381) (683) 441 137 304
Add: Increase (decrease) in allowance 25 3 (54) 96 4
Add: Increase (decrease) in restructuring liability 1 125 (56) (22) (71)
Add: Other comprehensive income (loss), net of taxes (232) (408) 578 (1,176) 819
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 81 64 61 55 39
After Adjustment
Adjusted net income 8,568 8,011 8,588 6,210 8,409

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).

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