Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

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
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Allowance for doubtful accounts 650 633 751 788 411 377
Accounts receivable, gross 49,338 44,894 38,794 32,799 29,935 26,858
Financial Ratio
Allowance as a percentage of accounts receivable, gross1 1.32% 1.41% 1.94% 2.40% 1.37% 1.40%

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

1 2023 Calculation
Allowance as a percentage of accounts receivable, gross = 100 × Allowance for doubtful accounts ÷ Accounts receivable, gross
= 100 × 650 ÷ 49,338 = 1.32%

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