AI Tokens
Stock Analysis on Net

CSX Corp. (NASDAQ:CSX)

This company has been moved to the archive! The financial data has not been updated since April 20, 2023.

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, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Allowance for credit losses 33 28 28 30 26
Accounts receivable, gross 1,346 1,176 940 1,016 1,036
Financial Ratio
Allowance as a percentage of accounts receivable, gross1 2.45% 2.38% 2.98% 2.95% 2.51%

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

1 2022 Calculation
Allowance as a percentage of accounts receivable, gross = 100 × Allowance for credit losses ÷ Accounts receivable, gross
= 100 × 33 ÷ 1,346 = 2.45%


An analysis of the credit loss provisions from 2018 to 2022 indicates a period of moderate volatility followed by an expansion in the total volume of outstanding receivables. While the nominal allowance for credit losses has increased over the five-year period, the proportional risk assessment relative to gross receivables has remained within a narrow range.

Gross Accounts Receivable Trends
Gross receivables experienced a gradual contraction between 2018 and 2020, reaching a period low of $940 million. This was followed by a significant upward trajectory, with balances increasing to $1,176 million in 2021 and $1,346 million by the end of 2022, representing a substantial increase in the total credit extended to customers.
Allowance for Credit Losses
The nominal allowance for credit losses grew from $26 million in 2018 to $33 million in 2022. The value remained relatively stagnant between 2019 and 2021, fluctuating between $28 million and $30 million, before seeing its most significant annual increase in 2022.
Allowance as a Percentage of Gross Receivables
The allowance ratio peaked at 2.98% in 2020, which coincided with the lowest level of gross receivables. This indicates a more conservative provisioning approach or an increase in perceived credit risk during that period. However, the ratio declined to 2.38% in 2021 and 2.45% in 2022, suggesting that the growth in the total receivables balance outpaced the increase in the credit loss allowance, which may point to improved credit quality or enhanced collection efficiency.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?