(Estimating Credit Card Payoff and Default)
Suppose Walmart Credit has two aging categories for its accounts receivable: 1. Accounts that are 0-30 days 1, and 2, accounts that are 31-90 days old. If any portion of an account receivable balance is over 90 days, that portion is written off as bad debt. An analysis of accounting records leads to the following accounts receivables matrix (P):
|
|
Paid
|
Bad Debt
|
0-30 Days
|
31-90 Days
|
|
Paid
|
1.0
|
0.0
|
0.0
|
0.0
|
|
Bad Debt
|
0.0
|
1.0
|
0.0
|
0.0
|
|
0-30 Days
|
0.6
|
0.0
|
0.3
|
0.1
|
|
31-90 Days
|
0.4
|
0.2
|
0.3
|
0.1
|
Predict the percentages of the 0-30 day accounts that will eventually end up in the paid off 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 collectable and uncollectable in the future? Mathematically, we are calculating the NR matrix here.
Also estimate the allowance for doubtful accounts if Walmart has a total of $1000M accounts receivable balance in the 0-30 day category and $2000M balance in the 31-90 day category as of this time. In other words, what is the outstanding balance Walmart has should expect to get paid back in the future? And, what is the default amount Wlamert should expect to write off in the future? Mathematically, we are calculating the BNR vector here.