Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Goodwill and Intangible Assets

Microsoft Excel

Goodwill and Intangible Asset Disclosure

PepsiCo Inc., balance sheet: goodwill and intangible assets

US$ in millions

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Acquired franchise rights 821 840 837 976 976
Customer relationships 565 560 571 623 642
Brands 1,051 1,093 1,097 1,151 1,348
Other identifiable intangibles 420 449 447 451 474
Amortizable intangible assets, gross 2,857 2,942 2,952 3,201 3,440
Accumulated amortization (1,755) (1,743) (1,675) (1,663) (1,737)
Amortizable intangible assets, net 1,102 1,199 1,277 1,538 1,703
Goodwill 17,534 17,728 18,202 18,381 18,757
Reacquired franchise rights 7,437 7,533 7,482 7,548 7,603
Acquired franchise rights 1,858 1,891 1,906 1,696 1,708
Brands 4,404 4,306 4,921 7,883 8,301
Other indefinite-lived intangible assets 13,699 13,730 14,309 17,127 17,612
Indefinite-lived intangible assets 31,233 31,458 32,511 35,508 36,369
Intangible assets 32,335 32,657 33,788 37,046 38,072

Based on: 10-K (reporting date: 2024-12-28), 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).

Item Description The company
Goodwill Amount after accumulated impairment loss of an asset representing future economic benefits arising from other assets acquired in a business combination that are not individually identified and separately recognized. PepsiCo Inc. goodwill decreased from 2022 to 2023 and from 2023 to 2024.
Intangible assets Sum of the carrying amounts of all intangible assets, including goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. PepsiCo Inc. intangible assets decreased from 2022 to 2023 and from 2023 to 2024.

Adjustments to Financial Statements: Removal of Goodwill

PepsiCo Inc., adjustments to financial statements

US$ in millions

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Adjustment to Total Assets
Total assets (as reported) 99,467 100,495 92,187 92,377 92,918
Less: Goodwill 17,534 17,728 18,202 18,381 18,757
Total assets (adjusted) 81,933 82,767 73,985 73,996 74,161
Adjustment to Total PepsiCo Common Shareholders’ Equity
Total PepsiCo common shareholders’ equity (as reported) 18,041 18,503 17,149 16,043 13,454
Less: Goodwill 17,534 17,728 18,202 18,381 18,757
Total PepsiCo common shareholders’ equity (adjusted) 507 775 (1,053) (2,338) (5,303)
Adjustment to Net Income Attributable To PepsiCo
Net income attributable to PepsiCo (as reported) 9,578 9,074 8,910 7,618 7,120
Add: Goodwill impairment charges 290
Net income attributable to PepsiCo (adjusted) 9,578 9,364 8,910 7,618 7,120

Based on: 10-K (reporting date: 2024-12-28), 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).


PepsiCo Inc., Financial Data: Reported vs. Adjusted


Adjusted Financial Ratios: Removal of Goodwill (Summary)

PepsiCo Inc., adjusted financial ratios

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Net Profit Margin
Reported net profit margin 10.43% 9.92% 10.31% 9.59% 10.12%
Adjusted net profit margin 10.43% 10.24% 10.31% 9.59% 10.12%
Total Asset Turnover
Reported total asset turnover 0.92 0.91 0.94 0.86 0.76
Adjusted total asset turnover 1.12 1.11 1.17 1.07 0.95
Financial Leverage
Reported financial leverage 5.51 5.43 5.38 5.76 6.91
Adjusted financial leverage 161.60 106.80
Return on Equity (ROE)
Reported ROE 53.09% 49.04% 51.96% 47.48% 52.92%
Adjusted ROE 1,889.15% 1,208.26%
Return on Assets (ROA)
Reported ROA 9.63% 9.03% 9.67% 8.25% 7.66%
Adjusted ROA 11.69% 11.31% 12.04% 10.30% 9.60%

Based on: 10-K (reporting date: 2024-12-28), 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).

Financial ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. PepsiCo Inc. adjusted net profit margin ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. PepsiCo Inc. adjusted total asset turnover ratio deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by adjusted total assets. PepsiCo Inc. adjusted ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 not reaching 2022 level.

PepsiCo Inc., Financial Ratios: Reported vs. Adjusted


Adjusted Net Profit Margin

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to PepsiCo 9,578 9,074 8,910 7,618 7,120
Net revenue 91,854 91,471 86,392 79,474 70,372
Profitability Ratio
Net profit margin1 10.43% 9.92% 10.31% 9.59% 10.12%
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Adjusted net income attributable to PepsiCo 9,578 9,364 8,910 7,618 7,120
Net revenue 91,854 91,471 86,392 79,474 70,372
Profitability Ratio
Adjusted net profit margin2 10.43% 10.24% 10.31% 9.59% 10.12%

Based on: 10-K (reporting date: 2024-12-28), 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).

2024 Calculations

1 Net profit margin = 100 × Net income attributable to PepsiCo ÷ Net revenue
= 100 × 9,578 ÷ 91,854 = 10.43%

2 Adjusted net profit margin = 100 × Adjusted net income attributable to PepsiCo ÷ Net revenue
= 100 × 9,578 ÷ 91,854 = 10.43%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. PepsiCo Inc. adjusted net profit margin ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Adjusted Total Asset Turnover

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
As Reported
Selected Financial Data (US$ in millions)
Net revenue 91,854 91,471 86,392 79,474 70,372
Total assets 99,467 100,495 92,187 92,377 92,918
Activity Ratio
Total asset turnover1 0.92 0.91 0.94 0.86 0.76
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Net revenue 91,854 91,471 86,392 79,474 70,372
Adjusted total assets 81,933 82,767 73,985 73,996 74,161
Activity Ratio
Adjusted total asset turnover2 1.12 1.11 1.17 1.07 0.95

Based on: 10-K (reporting date: 2024-12-28), 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).

2024 Calculations

1 Total asset turnover = Net revenue ÷ Total assets
= 91,854 ÷ 99,467 = 0.92

2 Adjusted total asset turnover = Net revenue ÷ Adjusted total assets
= 91,854 ÷ 81,933 = 1.12

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. PepsiCo Inc. adjusted total asset turnover ratio deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Adjusted Financial Leverage

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
As Reported
Selected Financial Data (US$ in millions)
Total assets 99,467 100,495 92,187 92,377 92,918
Total PepsiCo common shareholders’ equity 18,041 18,503 17,149 16,043 13,454
Solvency Ratio
Financial leverage1 5.51 5.43 5.38 5.76 6.91
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Adjusted total assets 81,933 82,767 73,985 73,996 74,161
Adjusted total PepsiCo common shareholders’ equity 507 775 (1,053) (2,338) (5,303)
Solvency Ratio
Adjusted financial leverage2 161.60 106.80

Based on: 10-K (reporting date: 2024-12-28), 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).

2024 Calculations

1 Financial leverage = Total assets ÷ Total PepsiCo common shareholders’ equity
= 99,467 ÷ 18,041 = 5.51

2 Adjusted financial leverage = Adjusted total assets ÷ Adjusted total PepsiCo common shareholders’ equity
= 81,933 ÷ 507 = 161.60


Adjusted Return on Equity (ROE)

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to PepsiCo 9,578 9,074 8,910 7,618 7,120
Total PepsiCo common shareholders’ equity 18,041 18,503 17,149 16,043 13,454
Profitability Ratio
ROE1 53.09% 49.04% 51.96% 47.48% 52.92%
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Adjusted net income attributable to PepsiCo 9,578 9,364 8,910 7,618 7,120
Adjusted total PepsiCo common shareholders’ equity 507 775 (1,053) (2,338) (5,303)
Profitability Ratio
Adjusted ROE2 1,889.15% 1,208.26%

Based on: 10-K (reporting date: 2024-12-28), 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).

2024 Calculations

1 ROE = 100 × Net income attributable to PepsiCo ÷ Total PepsiCo common shareholders’ equity
= 100 × 9,578 ÷ 18,041 = 53.09%

2 Adjusted ROE = 100 × Adjusted net income attributable to PepsiCo ÷ Adjusted total PepsiCo common shareholders’ equity
= 100 × 9,578 ÷ 507 = 1,889.15%


Adjusted Return on Assets (ROA)

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to PepsiCo 9,578 9,074 8,910 7,618 7,120
Total assets 99,467 100,495 92,187 92,377 92,918
Profitability Ratio
ROA1 9.63% 9.03% 9.67% 8.25% 7.66%
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Adjusted net income attributable to PepsiCo 9,578 9,364 8,910 7,618 7,120
Adjusted total assets 81,933 82,767 73,985 73,996 74,161
Profitability Ratio
Adjusted ROA2 11.69% 11.31% 12.04% 10.30% 9.60%

Based on: 10-K (reporting date: 2024-12-28), 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).

2024 Calculations

1 ROA = 100 × Net income attributable to PepsiCo ÷ Total assets
= 100 × 9,578 ÷ 99,467 = 9.63%

2 Adjusted ROA = 100 × Adjusted net income attributable to PepsiCo ÷ Adjusted total assets
= 100 × 9,578 ÷ 81,933 = 11.69%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by adjusted total assets. PepsiCo Inc. adjusted ROA deteriorated from 2022 to 2023 but then improved from 2023 to 2024 not reaching 2022 level.