Calculation guide
Coverage above 100% indicates an overhedge in the selected bucket.
coverage = 100 × hedge/invoices · open = invoices − hedge
Inputs
Maturity bucket number
Example entry 1.0. Minimum 1. Use whole numbers.
Invoice exposure
Example entry 100000.0 (in the selected currency). Minimum 1e-12.
Matching hedge notional
Example entry 75000.0 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Maturity bucket number | 1 |
Invoice maturity buckets
| Invoice exposure | Matching hedge notional |
|---|---|
| 100,000 | 75,000 |
| 50,000 | 60,000 |
| Result | Value |
|---|---|
| Selected coverage (%) | 75% |
| Unhedged balance | 25,000 |
Interpreting the result
A negative open balance identifies excess hedge notional in the selected maturity bucket.
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 |
|---|---|---|---|---|---|
| Maturity bucket number | 1 | 2 | Selected coverage (%) | 75% | 120% |
| Invoice exposure (row 1) | 100,000 | 110,000 | Selected coverage (%) | 75% | 68.181818% |
| Matching hedge notional (row 1) | 75,000 | 82,500 | Selected coverage (%) | 75% | 82.5% |
