Analysis of Bad Debts
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
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 receivables, gross = 100 × Allowances for doubtful receivables ÷ Receivables, gross
= 100 × 69 ÷ 15,670 = 0.44%
| Financial ratio | Description | The company |
|---|---|---|
| Allowance as a percentage of receivables, gross | Allowance for doubtful accounts divided by the gross accounts receivable. | Ford Motor Co. allowance as a percentage of receivables, gross increased from 2021 to 2022 but then slightly decreased from 2022 to 2023 not reaching 2021 level. |
Allowance for Credit Losses
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 recorded investment in finance receivables = 100 × Allowance for credit losses ÷ Recorded investment in finance receivables
= 100 × 882 ÷ 102,957 = 0.86%
| Financial ratio | Description | The company |
|---|---|---|
| Allowance as a percentage of recorded investment in finance receivables | Allowance for credit losses divided by the gross financing receivable. | Ford Motor Co. allowance as a percentage of recorded investment in finance receivables decreased from 2021 to 2022 and from 2022 to 2023. |