Stock Analysis on Net

ConocoPhillips (NYSE:COP)

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 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Allowance 3 2 2 4 13
Accounts and notes receivable, gross 5,464 7,077 6,545 2,638 3,280
Financial Ratio
Allowance as a percentage of accounts and notes receivable, gross1 0.05% 0.03% 0.03% 0.15% 0.40%

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

1 2023 Calculation
Allowance as a percentage of accounts and notes receivable, gross = 100 × Allowance ÷ Accounts and notes receivable, gross
= 100 × 3 ÷ 5,464 = 0.05%

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. ConocoPhillips allowance as a percentage of accounts and notes receivable, gross decreased from 2021 to 2022 but then increased from 2022 to 2023 exceeding 2021 level.