Analysis of Bad Debts
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.
Paying user area
Try for free
Ulta Beauty Inc. pages available for free this week:
- Balance Sheet: Liabilities and Stockholders’ Equity
- Common-Size Balance Sheet: Liabilities and Stockholders’ Equity
- Analysis of Solvency Ratios
- Enterprise Value to FCFF (EV/FCFF)
- Dividend Discount Model (DDM)
- Current Ratio since 2008
- Debt to Equity since 2008
- Total Asset Turnover since 2008
- Price to Earnings (P/E) since 2008
- Aggregate Accruals
The data is hidden behind: . Unhide it.
Get full access to the entire website from $10.42/mo, or
get 1-month access to Ulta Beauty Inc. for $22.49.
This is a one-time payment. There is no automatic renewal.
We accept:
Allowance for Doubtful Accounts Receivable
Based on: 10-K (reporting date: 2023-01-28), 10-K (reporting date: 2022-01-29), 10-K (reporting date: 2021-01-30), 10-K (reporting date: 2020-02-01), 10-K (reporting date: 2019-02-02), 10-K (reporting date: 2018-02-03).
1 2023 Calculation
Allowance as a percentage of receivables, gross = 100 × Allowance for doubtful accounts ÷ Receivables, gross
= 100 × ÷ =
- Allowance for doubtful accounts
- The allowance for doubtful accounts exhibited fluctuations over the analyzed periods. Starting at 1,371 thousand USD in 2018, it declined significantly in 2019 to 651 thousand USD, followed by an increase to 1,363 thousand USD in 2020. Subsequently, the allowance decreased to 768 thousand USD in 2021 but then rose gradually to 1,005 thousand USD in 2022 and 1,076 thousand USD in 2023.
- Receivables, gross
- Gross receivables showed a general upward trend from 101,090 thousand USD in 2018 to a peak of 234,687 thousand USD in 2022. Notably, the receivables grew steadily each year except for a decline in 2023, decreasing to 200,498 thousand USD, indicating a potential reduction in sales or changes in credit policies.
- Allowance as a percentage of gross receivables
- This ratio demonstrated a downward trend between 2018 and 2021, dropping from 1.36% to a low of 0.40%. Thereafter, it increased slightly to 0.43% in 2022 and further to 0.54% in 2023. This pattern suggests an initial improvement in credit risk management or collection efficiency up to 2021, followed by a moderate increase in estimated credit losses relative to gross receivables in the recent years.