Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Bad Debts

Microsoft Excel

Allowance for doubtful accounts receivable (bad debts) is a contra account which reduce the balance of the company gross accounts receivable. The relationship between the allowance and the balance in receivables should be relatively constant unless there is a change in the economy overall or a change in customer base.


Allowance for Doubtful Accounts Receivable

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Selected Financial Data (US$ in millions)
Allowance 356 175 150 147 201
Accounts and notes receivable, gross 10,689 10,990 10,313 8,827 8,605
Financial Ratio
Allowance as a percentage of accounts and notes receivable, gross1 3.33% 1.59% 1.45% 1.67% 2.34%

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).

1 2024 Calculation
Allowance as a percentage of accounts and notes receivable, gross = 100 × Allowance ÷ Accounts and notes receivable, gross
= 100 × 356 ÷ 10,689 = 3.33%

Financial ratio Description The company
Allowance as a percentage of accounts and notes receivable, gross Allowance for doubtful accounts divided by the gross accounts receivable. PepsiCo Inc. allowance as a percentage of accounts and notes receivable, gross increased from 2022 to 2023 and from 2023 to 2024.