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
Eli Lilly & Co. pages available for free this week:
- Balance Sheet: Liabilities and Stockholders’ Equity
- Common-Size Income Statement
- Analysis of Profitability Ratios
- Capital Asset Pricing Model (CAPM)
- Dividend Discount Model (DDM)
- Selected Financial Data since 2005
- Return on Equity (ROE) since 2005
- Total Asset Turnover 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 Eli Lilly & Co. for $24.99.
This is a one-time payment. There is no automatic renewal.
We accept:
Allowance for Doubtful Accounts Receivable
Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).
1 2024 Calculation
Allowance as a percentage of accounts receivable, gross = 100 × Allowances ÷ Accounts receivable, gross
= 100 × ÷ =
- Allowance for Doubtful Accounts
- The allowance for doubtful accounts has shown a consistent decline from 25,900 thousand US dollars in 2020 to 14,800 thousand US dollars in 2023, with a slight increase to 14,900 thousand US dollars in 2024. This overall downward trend suggests improved credit quality or more effective collection processes over the years.
- Accounts Receivable, Gross
- The gross accounts receivable have steadily increased each year, starting at 5,901,200 thousand US dollars in 2020 and rising significantly to 11,020,600 thousand US dollars by 2024. This doubling over the five-year span indicates expanding sales or revenue on credit terms.
- Allowance as a Percentage of Accounts Receivable, Gross
- This ratio declines markedly from 0.44% in 2020 down to 0.14% in 2024. The decreasing allowance relative to gross accounts receivable implies a lower estimated risk of uncollectible receivables, reflecting positively on the quality of the receivables portfolio or changes in estimation policies.