Open calculator ↗

Bad debt sales recovery target · Calculation guide

Use the contribution margin on replacement sales and the net unrecovered bad debt.

Calculation guide

Assume fixed costs stay constant and the new sales are collectible.

Required replacement sales = (Gross bad debt − Expected recovery) / (Contribution margin on sales / 100)

Inputs

Gross bad debt

Example entry 1000 (in the selected currency).

Expected recovery

Example entry 100 (in the selected currency).

Contribution margin on sales

Example entry 30 %. Allowed range 0 to 100.

Worked example

InputValue
Gross bad debt1,000
Expected recovery100
Contribution margin on sales30%
ResultValue
Required replacement sales3,000

Calculation steps

Required replacement sales = ((Gross bad debt − Expected recovery) ÷ (Contribution margin on sales ÷ 100))

((1,000 − 100) ÷ (30 ÷ 100)) = 3,000

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Gross bad debt1,0001,100Required replacement sales3,0003,333.333333
Expected recovery100110Required replacement sales3,0002,966.666667
Contribution margin on sales30%33%Required replacement sales3,0002,727.272727
Bad debt sales recovery target →

Sources