Stock Analysis on Net

Estée Lauder Cos. Inc. (NYSE:EL)

This company has been moved to the archive! The financial data has not been updated since August 18, 2023.

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 credit losses 16 10 20 63 32 29
Accounts receivable, gross 1,468 1,639 1,722 1,257 1,863 1,516
Financial Ratio
Allowance as a percentage of accounts receivable, gross1 1.09% 0.61% 1.16% 5.01% 1.72% 1.91%

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 credit losses ÷ Accounts receivable, gross
= 100 × 16 ÷ 1,468 = 1.09%

Financial ratio Description The company
Allowance as a percentage of accounts receivable, gross Allowance for doubtful accounts divided by the gross accounts receivable. Estée Lauder Cos. Inc. allowance as a percentage of accounts receivable, gross decreased from 2021 to 2022 but then increased from 2022 to 2023 not reaching 2021 level.