# Question

As any credit-granting agency knows, there are always some customers who default on credit charges. Typically, customers are grouped into relatively homogeneous categories, so that customers within any category have approximately the same chance of defaulting on their credit charges. Here we will look at one particular group of customers. We assume each of these customers has (1) probability 0.07 of defaulting on his or her current credit charges, and (2) total credit charges that are normally distributed with mean $350 and standard deviation $100. We also assume that if a customer defaults, 20% of his or her charges can be recovered. The other 80% are written off as bad debt.

a. What is the probability that a typical customer in this group will default and produce a write-off of more than $250 in bad debt?

b. If there are 500 customers in this group, what are the mean and standard deviation of the number of customers who will meet the description in part a?

c. Again assuming there are 500 customers in this group, what is the probability that at least 25 of them will meet the description in part a?

d. Suppose now that nothing is recovered from a default—the whole amount is written off as bad debt. Show how to simulate the total amount of bad debt from 500 customers in just two cells, one with a binomial calculation, the other with a normal calculation.

a. What is the probability that a typical customer in this group will default and produce a write-off of more than $250 in bad debt?

b. If there are 500 customers in this group, what are the mean and standard deviation of the number of customers who will meet the description in part a?

c. Again assuming there are 500 customers in this group, what is the probability that at least 25 of them will meet the description in part a?

d. Suppose now that nothing is recovered from a default—the whole amount is written off as bad debt. Show how to simulate the total amount of bad debt from 500 customers in just two cells, one with a binomial calculation, the other with a normal calculation.

## Answer to relevant Questions

The Excel functions discussed in this chapter are useful for solving a lot of probability problems, but there are other problems that, even though they are similar to normal or binomial problems, cannot be solved with these ...An element X has five major isotopes, which are listed below along with their abundances. Calculate the average atomic mass, and identify the element. How many atoms of nitrogen are present in 5.00 g of each of the following? a. Glycine, C2H5O2N c. Calcium nitrate b. Magnesium nitride d. Dinitrogen tetroxide In 1987 the first substance to act as a superconductor at a temperature above that of liquid nitrogen (77 K) was discovered. The approximate formula of this substance is YBa2Cu3O7. Calculate the percent composition by mass ...The element silver (Ag) has two naturally occurring isotopes: 109Ag and 107Ag with a mass of 106.905 amu. Silver consists of 51.82% 107Ag and has an average atomic mass of 107.868 amu. Calculate the mass of 109Ag.Post your question

0