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
Celgene Corp. pages available for free this week:
- Cash Flow Statement
- Common-Size Income Statement
- Common-Size Balance Sheet: Liabilities and Stockholders’ Equity
- Analysis of Solvency Ratios
- Analysis of Geographic Areas
- Net Profit Margin since 2005
- Return on Assets (ROA) since 2005
- Price to Operating Profit (P/OP) since 2005
- Price to Book Value (P/BV) since 2005
- Analysis of Debt
The data is hidden behind: . Unhide it.
Get full access to the entire website from $10.42/mo, or
get 1-month access to Celgene Corp. 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: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).
1 2018 Calculation
Allowance as a percentage of accounts receivable, gross = 100 × Allowance for doubtful accounts ÷ Accounts receivable, gross
= 100 × ÷ =
- Allowance for doubtful accounts
- The allowance for doubtful accounts showed a decreasing trend from 2014 to 2016, declining from 21 million US dollars to 15 million US dollars. It then stabilized around 16 million US dollars in the following two years, 2017 and 2018.
- Accounts receivable, gross
- There was a consistent and significant increase in gross accounts receivable over the five-year period. The value rose steadily year over year, starting at 1,187 million US dollars in 2014 and reaching 2,082 million US dollars by the end of 2018.
- Allowance as a percentage of accounts receivable, gross
- This ratio exhibited a clear downward trend throughout the time frame. It decreased from 1.74% in 2014 to 0.77% in 2018, indicating a declining proportion of doubtful accounts relative to the growing accounts receivable balance.
- Overall analysis
- The data suggests an improvement in the quality of accounts receivable over the period analyzed. Despite the gross accounts receivable nearly doubling, the allowance for doubtful accounts did not increase but slightly decreased and then stabilized. Consequently, the allowance as a percentage of gross accounts receivable declined markedly, which could reflect enhanced credit management, reduced credit risk, or changes in the estimation methodology for doubtful accounts. The steady rise in accounts receivable signals expanding sales or operations, while the decreasing allowance percentage implies greater confidence in collectibility.