Formula
Gross recovery rate = Cash recovered ÷ Charged-off balance.
Net cash recovered = Cash recovered − Collection agency fees − Legal and court costs; Net recovery rate = Net cash recovered ÷ Charged-off balance.
Present value of net recoveries = Net cash recovered ÷ (1 + Discount rate)^(Average months to recover ÷ 12); Present-value recovery rate = that figure ÷ Charged-off balance.
Loss given default = 1 − Present-value recovery rate. Collection cost as share of recoveries = (Collection agency fees + Legal and court costs) ÷ Cash recovered.
Worked examples
Example 1: default inputs, a 35 percent gross recovery that is worth 19 percent
Inputs: Charged-off balance $600,000, Cash recovered $210,000, Collection agency fees $52,000, Legal and court costs $28,000, Average months to recover 14, Discount rate 12%. Gross recovery rate = 210,000 ÷ 600,000 = 35.0%. Net cash recovered = 210,000 − 52,000 − 28,000 = $130,000; net recovery rate = 130,000 ÷ 600,000 = 21.7%. Present value: 14 months is 14 ÷ 12 = 1.1667 years; the discount factor is 1.12^1.1667 = 1.1414; present value = 130,000 ÷ 1.1414 = $113,900; present-value recovery rate = 113,900 ÷ 600,000 = 19.0%. Loss given default = 1 − 0.190 = 81.0%. Collection cost as share of recoveries = (52,000 + 28,000) ÷ 210,000 = 80,000 ÷ 210,000 = 38%. Reading across the three rates: the collection effort brought back 35 cents of every charged-off dollar, but 38 percent of that went to agencies and lawyers, and the remainder arrived more than a year late. A reserve using the gross figure would assume a 65 percent loss; the economically correct loss is 81 percent, a quarter larger.
Example 2: a fast agency recovery with no legal spend
Inputs: charged-off $150,000, recovered $45,000, collection fees $13,500, legal $0, 6 months to recover, discount rate 20%. Gross recovery rate = 45,000 ÷ 150,000 = 30.0%. Net cash = 45,000 − 13,500 − 0 = $31,500; net rate = 31,500 ÷ 150,000 = 21.0%. Present value: 6 ÷ 12 = 0.5 years; 1.20^0.5 = 1.0954; 31,500 ÷ 1.0954 = $28,755; present-value rate = 28,755 ÷ 150,000 = 19.2%. Loss given default = 80.8%. Collection cost share = 13,500 ÷ 45,000 = 30%, which is a typical contingency fee on first placement. The present-value recovery rate is almost identical to the default example's despite a lower gross recovery, because the money came back in six months rather than fourteen and no legal costs were incurred. Speed is worth as much as a few extra points of gross recovery, and the higher discount rate, reflecting an advance funder's cost of capital, barely dents a six-month recovery.
Example 3: a legal recovery on a large secured balance
Inputs: charged-off $1,000,000, recovered $500,000, collection fees $100,000, legal $90,000, 30 months to recover, discount rate 10%. Gross recovery rate = 50.0%. Net cash = 500,000 − 100,000 − 90,000 = $310,000; net rate = 31.0%. Present value: 30 ÷ 12 = 2.5 years; 1.10^2.5 = 1.2691; 310,000 ÷ 1.2691 = $244,276; present-value rate = 24.4%. Loss given default = 75.6%. Collection cost share = 190,000 ÷ 500,000 = 38%. Half the balance came back, which is a strong result for a defaulted small-business loan and reflects collateral or a guarantor with assets, but it took two and a half years and $190,000 of costs to get it. The present value is less than half the gross figure. This is the profile of a litigated recovery: higher gross, higher cost, much longer duration. Whether it beats a quick agency settlement at 30 percent gross depends on exactly the arithmetic the tool performs, and here the legal route still wins, 24.4 percent against about 19 percent, but by less than the gross figures suggest.