Stock Analysis on Net

Activision Blizzard Inc. (NASDAQ:ATVI)

$22.49

This company has been moved to the archive! The financial data has not been updated since July 31, 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.

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Allowance for Doubtful Accounts Receivable

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Allowances for sales returns and price protection and other allowances
Accounts receivable, gross
Financial Ratio
Allowance as a percentage of accounts receivable, gross1

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Allowance as a percentage of accounts receivable, gross = 100 × Allowances for sales returns and price protection and other allowances ÷ Accounts receivable, gross
= 100 × ÷ =


Allowances for sales returns and price protection and other allowances

The allowances for sales returns, price protection, and other related allowances experienced a significant downward trend over the five-year period. Starting at 186 million US dollars in 2018, the value dropped sharply to 118 million in 2019 and continued declining to 63 million in 2020. By 2021 and 2022, the figures further decreased to 17 million and 16 million respectively, indicating a notable reduction in these allowances.

Accounts receivable, gross

Gross accounts receivable exhibited some fluctuations but generally maintained a stable range. Beginning at 1,221 million US dollars in 2018, it decreased to 966 million in 2019, then rose again to 1,115 million in 2020. Afterwards, it declined to 989 million in 2021, followed by an increase to 1,220 million in 2022. Overall, the levels of accounts receivable gross stayed within a roughly consistent bandwidth.

Allowance as a percentage of accounts receivable, gross

The allowance as a percentage of gross accounts receivable showed a marked decrease throughout the period. Starting at a relatively high 15.23% in 2018, the ratio declined steadily each year, reaching 12.22% in 2019, then falling more sharply to 5.65% in 2020. The downward trend accelerated, with the percentage dropping to 1.72% in 2021 and further to 1.31% in 2022. This reduction suggests improved quality of receivables or more conservative allowances being recorded against accounts receivable over time.

Summary

Overall, the data reveals a consistent decline in allowances related to sales returns and price protections, paralleled by a decrease in the allowance ratio relative to gross accounts receivable. Despite some fluctuations in gross accounts receivable values, the allowance metrics indicate improved receivable positions and possibly enhanced collection or credit management practices during the period analyzed.