Stock Analysis on Net

Comcast Corp. (NASDAQ:CMCSA)

$24.99

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.

Paying user area


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Allowance for Doubtful Accounts Receivable

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Allowance for credit losses
Receivables, gross
Financial Ratio
Allowance as a percentage of receivables, gross1

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

1 2024 Calculation
Allowance as a percentage of receivables, gross = 100 × Allowance for credit losses ÷ Receivables, gross
= 100 × ÷ =


Allowance for credit losses
The allowance for credit losses demonstrates variability over the observed periods. Beginning at 807 million US dollars in 2020, it decreased to 658 million in 2021, followed by an increase to 735 million in 2022. The allowance slightly declined again to 698 million in 2023 before rising moderately to 738 million in 2024. Overall, this indicates an adaptive approach to anticipated credit losses, reflecting changing credit risk evaluations.
Receivables, gross
Gross receivables show a consistent upward trend through the years presented. Starting at 12,273 million US dollars in 2020, the balance steadily increased each year, reaching a peak of 14,511 million in 2023 before experiencing a slight decrease to 14,399 million in 2024. This pattern suggests general growth in credit sales or outstanding amounts receivable, with a minor contraction in the final year of the series.
Allowance as a percentage of receivables, gross
The allowance relative to gross receivables exhibits a declining trend from 6.58% in 2020 to 4.81% in 2023, indicating a reduction in the proportion of estimated credit losses compared to total receivables. In 2024, there is a moderate increase to 5.13%, which may signify increased caution or recognition of higher credit risk. The initial downward trend combined with the slight uptick at the end suggests improved credit quality or collection efficiency during most years, with a recent reevaluation upwards of risk levels.