Stock Analysis on Net

Medtronic PLC (NYSE:MDT)

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
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Selected Financial Data (US$ in millions)
Allowance for doubtful accounts 176 230 241 208 190 193
Accounts receivable, gross 6,174 5,781 5,703 4,853 6,412 6,180
Financial Ratio
Allowance as a percentage of accounts receivable, gross1 2.85% 3.98% 4.23% 4.29% 2.96% 3.12%

Based on: 10-K (reporting date: 2023-04-28), 10-K (reporting date: 2022-04-29), 10-K (reporting date: 2021-04-30), 10-K (reporting date: 2020-04-24), 10-K (reporting date: 2019-04-26), 10-K (reporting date: 2018-04-27).

1 2023 Calculation
Allowance as a percentage of accounts receivable, gross = 100 × Allowance for doubtful accounts ÷ Accounts receivable, gross
= 100 × 176 ÷ 6,174 = 2.85%

Financial ratio Description The company
Allowance as a percentage of accounts receivable, gross Allowance for doubtful accounts divided by the gross accounts receivable. Medtronic PLC allowance as a percentage of accounts receivable, gross decreased from 2021 to 2022 and from 2022 to 2023.