Calculation guide
Measure one full year of unwinding with no payment before the end of that year.
Inputs
Expected settlement cash
Example entry 12100 (in the selected currency).
Annual discount rate (%)
Example entry 10.
Years remaining at opening
Example entry 2. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Expected settlement cash | 12,100 |
| Annual discount rate (%) | 10 |
| Years remaining at opening | 2 |
| Result | Value |
|---|---|
| Annual unwinding expense | 1,000 |
| Opening provision | 10,000 |
| Provision before settlement | 11,000 |
Calculation steps
Annual unwinding expense = (((Expected settlement cash ÷ ((1 + (Annual discount rate (%) ÷ 100)) ^ Years remaining at opening)) × Annual discount rate (%)) ÷ 100)
(((12,100 ÷ ((1 + (10 ÷ 100)) ^ 2)) × 10) ÷ 100) = 1,000
Opening provision = (Expected settlement cash ÷ ((1 + (Annual discount rate (%) ÷ 100)) ^ Years remaining at opening))
(12,100 ÷ ((1 + (10 ÷ 100)) ^ 2)) = 10,000
Provision before settlement = (Opening provision + Annual unwinding expense)
(10,000 + 1,000) = 11,000
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 |
|---|---|---|---|---|---|
| Expected settlement cash | 12,100 | 13,310 | Annual unwinding expense | 1,000 | 1,100 |
| Annual discount rate (%) | 10 | 11 | Annual unwinding expense | 1,000 | 1,080.269459 |
| Years remaining at opening | 2 | 3 | Annual unwinding expense | 1,000 | 909.090909 |
