Stock Analysis on Net

Cisco Systems Inc. (NASDAQ:CSCO)

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
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
Selected Financial Data (US$ in millions)
Allowance for credit loss 87 85 83 109 143 136
Accounts receivable, gross 6,772 5,939 6,705 5,875 5,615 5,627
Financial Ratio
Allowance as a percentage of accounts receivable, gross1 1.28% 1.43% 1.24% 1.86% 2.55% 2.42%

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

1 2024 Calculation
Allowance as a percentage of accounts receivable, gross = 100 × Allowance for credit loss ÷ Accounts receivable, gross
= 100 × 87 ÷ 6,772 = 1.28%

Financial ratio Description The company
Allowance as a percentage of accounts receivable, gross Allowance for doubtful accounts divided by the gross accounts receivable. Cisco Systems Inc. allowance as a percentage of accounts receivable, gross increased from 2022 to 2023 but then slightly decreased from 2023 to 2024 not reaching 2022 level.

Allowance for Credit Losses

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
Selected Financial Data (US$ in millions)
Allowance for credit loss 65 72 126 127 138 126
Gross financing receivables less unearned income 6,712 6,837 7,964 9,288 10,780 10,037
Financial Ratio
Allowance as a percentage of gross financing receivables less unearned income1 0.97% 1.05% 1.58% 1.37% 1.28% 1.26%

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

1 2024 Calculation
Allowance as a percentage of gross financing receivables less unearned income = 100 × Allowance for credit loss ÷ Gross financing receivables less unearned income
= 100 × 65 ÷ 6,712 = 0.97%

Financial ratio Description The company
Allowance as a percentage of gross financing receivables less unearned income Allowance for credit losses divided by the gross financing receivable. Cisco Systems Inc. allowance as a percentage of gross financing receivables less unearned income decreased from 2022 to 2023 and from 2023 to 2024.