Collections decision automation calculator
Enter accounts treated and cured for each treatment by bucket. See cure rates and value after cost, then find the best treatment for each bucket in a minute.
Value per month
The best treatments are 1-29: Call, 30-59: Call, 60-89: Agency. Together, they are worth €1,324,313 a month, which is €525,113 more than taking no action.
Value by treatment
Bars show value per account after cost. The solid bar is each bucket’s best, orange when it is not clearly ahead, and the thin lines show the range from the cure rate’s 95% interval.
Treatment results
| Bucket | Treatment | Cure rate | 95% interval | Value per account | Value per month | Verdict |
|---|---|---|---|---|---|---|
| 1-29 | Call | 64.0% | 61.0% – 66.9% | €147.60 | €738,000 | Best, test more |
| SMS | 59.0% | 56.8% – 61.1% | €141.30 | €706,500 | ||
| No action | 45.0% | 42.8% – 47.2% | €108.00 | €540,000 | ||
| 30-59 | Call | 42.5% | 39.1% – 46.0% | €278.88 | €418,313 | Best, clearly ahead |
| SMS | 28.7% | 25.7% – 32.0% | €193.76 | €290,644 | ||
| No action | 20.0% | 17.4% – 22.9% | €135.00 | €202,500 | ||
| 60-89 | Agency | 25.0% | 20.4% – 30.2% | €280.00 | €168,000 | Best, test more |
| Call | 20.0% | 16.4% – 24.2% | €242.00 | €145,200 | ||
| No action | 7.5% | 5.3% – 10.5% | €94.50 | €56,700 |
The copied table pastes into a decision table as two columns, with the bucket as the condition and the treatment as the result.
Email me the result
Use this bucket-to-treatment table as the collections decision on every account, with a challenger treatment run beside it. Start free
See the formulas
Cure rate = Accounts cured ÷ Accounts treated (95% interval: Wilson, 95%) Value of cure = Average balance × Balance lost if not cured Value per account = Cure rate × Value of cure − Cost per account Value per month = Entering per month × Value per account Best, clearly ahead: Its value at the low end of its interval beats the runner-up’s at the high end
A cure counts as you count it, and its value is the balance not lost. Later re-default and the timing of payments are left out.
Collections cure rate calculator
A collections cure rate is the share of treated accounts that cure. Enter accounts treated and cured for each treatment and bucket to compare cure rates and their 95% intervals.
Treatment cost and the balance lost when an account does not cure affect what each cure is worth. Use the results to compare treatments by bucket and see the monthly value of the best treatment in each.
Collections cure rate questions
How do I calculate a collections cure rate?
Divide the accounts cured by the accounts treated. This calculator works out that rate for each treatment and bucket.
How do I compare collections treatments by cost?
The value per account is the cure rate multiplied by the value of a cure, minus the cost per account. Compare that value across treatments in each bucket.
Why compare a treatment with no action?
A no-action row shows what accounts do on their own. Comparing against it shows the difference in monthly value between the best treatments and no action.
Which treatment should I use for each delinquency bucket?
The calculator selects the treatment with the highest value per account in each bucket. The table shows that treatment and its value a month if the whole bucket got it.
How can I tell if one treatment beats another?
The calculator marks the best treatment clearly ahead when its value at the low end of its interval beats the runner-up’s value at the high end. Otherwise, the result shows that the best is not clearly ahead.