Estimating credit card payoff and default

Assignment Help Business Management

Reference no: EM13971722

(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.

Reference no: EM13971722

Questions Cloud

Why they are important in business intranets and extranets. : Why is it increasing most important for a CIO or IT executive who oversees geographically distributed enterprise networks to be business literate?

What is your expected rate of return on the stock : There is a 15% probability of a boom, a 75% chance of a normal economy, and a 10% chance of a recession. What is your expected rate of return on this stock?

Use the methods learned in class so far to analyze the data : Use the methods learned in class so far to analyze the data. Prepare a report for the PGA Tour commissioner that summarizes your analysis, including key statistical results, conclusions, and recommendations.

What is the ideal composition of curriculum evaluation team : What is the ideal composition of a curriculum evaluation team? What are some rules that will help an online curriculum evaluation team stay on track

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..

Research the benefits of information systems : Write a one paragraph recommendation in which you recommend the computer you would purchase based on your research. This is in addition to the summary.

Discuss the central economic problem facing survivor group : Discuss the central economic problem facing survivor group

Find the optimal control of the plant : Find the optimal control of the plant - which minimize the performance index

How does a hostile work environment effect the employees : How does a hostile work environment effect the employees? What are the risk that an organization take with a hostile work environment? Conclussion summary of a hostile work environment.

User Account

All Pages