Calculation guide
Cap the modeled loss between zero and the exposure.
Inputs
Exposure at default
Example entry 100000.0 (in the selected currency). Minimum 1e-12.
Gross recovery
Example entry 66000.0 (in the selected currency).
Workout cost
Example entry 11000.0 (in the selected currency).
Annual discount rate (%)
Example entry 10.0 %. Allowed range 0 to 100.
Years until recovery
Example entry 1.0.
Worked example
| Input | Value |
|---|---|
| Exposure at default | 100,000 |
| Gross recovery | 66,000 |
| Workout cost | 11,000 |
| Annual discount rate (%) | 10% |
| Years until recovery | 1 |
| Result | Value |
|---|---|
| Net loss given default (%) | 50% |
Calculation steps
Net loss given default (%) = (100 × min(1, max(0, (1 − (((Gross recovery − Workout cost) ÷ ((1 + (Annual discount rate (%) ÷ 100)) ^ Years until recovery)) ÷ Exposure at default)))))
(100 × min(1, max(0, (1 − (((66,000 − 11,000) ÷ ((1 + (10 ÷ 100)) ^ 1)) ÷ 100,000))))) = 50%
Interpreting the result
A 50% loss rate means half of the exposure is unrecovered on a present-value basis.
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 |
|---|---|---|---|---|---|
| Exposure at default | 100,000 | 110,000 | Net loss given default (%) | 50% | 54.545455% |
| Gross recovery | 66,000 | 72,600 | Net loss given default (%) | 50% | 44% |
| Workout cost | 11,000 | 12,100 | Net loss given default (%) | 50% | 51% |
| Annual discount rate (%) | 10% | 11% | Net loss given default (%) | 50% | 50.45045% |
| Years until recovery | 1 | 2 | Net loss given default (%) | 50% | 54.545455% |
