Calculation guide
Enter loss percentages after recoveries for each method.
saving = oaFee-dcFee+face*(oaLoss-dcLoss)/100
Inputs
Invoice amount
Example entry 100000.0 (in the selected currency).
Collection fees
Example entry 600.0 (in the selected currency).
Open-account fees
Example entry 100.0 (in the selected currency).
Collection expected loss (%)
Example entry 1.0 %. Allowed range 0 to 100.
Open-account expected loss (%)
Example entry 2.0 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Invoice amount | 100,000 |
| Collection fees | 600 |
| Open-account fees | 100 |
| Collection expected loss (%) | 1% |
| Open-account expected loss (%) | 2% |
| Result | Value |
|---|---|
| Expected saving from documentary collection | 500 |
Calculation steps
Expected saving from documentary collection = ((Open-account fees − Collection fees) + ((Invoice amount × (Open-account expected loss (%) − Collection expected loss (%))) ÷ 100))
((100 − 600) + ((100,000 × (2 − 1)) ÷ 100)) = 500
Interpreting the result
A positive saving favors documentary collection after both fees and expected loss.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Invoice amount | 100,000 | 110,000 | Expected saving from documentary collection | 500 | 600 |
| Collection fees | 600 | 660 | Expected saving from documentary collection | 500 | 440 |
| Open-account fees | 100 | 110 | Expected saving from documentary collection | 500 | 510 |
| Collection expected loss (%) | 1% | 2% | Expected saving from documentary collection | 500 | -500 |
| Open-account expected loss (%) | 2% | 3% | Expected saving from documentary collection | 500 | 1,500 |
