Suppose WalMart Credit Card has two aging categories for its accounts receivable
ID: 2777256 • Letter: S
Question
Suppose WalMart Credit Card has two aging categories for its accounts receivable: I. accounts that arc 0-30 days old. And 2. Accounts that are 31-90 days old. If any portion of an account receivable balance is over 90 days, I hat portion is written off as bad debt An analysis of accounting records leads to the following accounts receivable matrix (P): Predict the percentage of the 0-30 day accounts that will eventually end up in the paid oil-and the bad debt (written off) categories? What about those percentages for the 31 -90 day accounts? In other words, for each of these two accounts receivable categories, what are the percentages of money (outstanding balance) that will be deemed collectible and uncollectible in the future? Mathematically, we are calculating the NR matrix here Also estimate the allowance for doubtful accounts if WalMart has a total of $ I000M accounts receivable balance in the 0-30 day category and S2000M balance in the 31 -90 day category as of this time. In other words, w hat is the outstanding balance Walmart should expect to get paid back in the future? And, what is the default amount Walmart should expect to went off in the future? Mathematically, we are calculating the IlNR vector here.Explanation / Answer
0-30 days category
% paid = 60%
% unpaid = 1- 0.60 =40%
Uncollectible % = bad debt/ % unpaid
= 0%/40%
=0%
% collectible = 1- Uncollectible %
= 1-0%
=100%
31-90 days category
% paid = 40%
% unpaid = 1- 0.40 =60%
Uncollectible % = bad debt/ % unpaid
= 0.2/0.4
=50%
% collectible = 1- Uncollectible %
= 1-50%
=50%
Allowance for doubtful debt
0-30 days category = accounts receivables x uncollectible %
= 1000 M x0%
=0
31-90 days category = accounts receivables x uncollectible %
= 1000 M x50%
=500 Million
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.