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

Based on: 10-K (reporting date: 2024-06-30), 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).

1 2024 Calculation
Allowance as a percentage of accounts receivable, gross = 100 × Allowance for doubtful accounts ÷ Accounts receivable, gross
= 100 × 830 ÷ 57,754 = 1.44%

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 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.