Paying users zone. Data is covered by hidden.

  • Get to Home Depot Inc. for $19.99, or

  • get to entire website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc


Analysis of Bad Debts

Difficulty: Advanced

Allowance for doubtful accounts receivable (bad debts) is a contra account which reduce the balance of the company’s 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 LibreOffice Calc
Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014 Feb 3, 2013
Selected Financial Data (USD $ in millions)
Valuation reserve related to accounts receivable hidden hidden hidden hidden hidden hidden
Receivables due from customers, gross hidden hidden hidden hidden hidden hidden
Ratio
Allowance as a percentage of receivables due from customers, gross1 hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27), 10-K (filing date: 2013-03-28).

2018 Calculations

1 Allowance as a percentage of receivables due from customers, gross = 100 × Valuation reserve related to accounts receivable ÷ Receivables due from customers, gross
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Allowance as a percentage of receivables due from customers, gross Allowance for doubtful accounts divided by the gross accounts receivable.