Open calculator ↗

Hedge coverage by invoice maturity · Calculation guide

Group same-direction invoices and hedges by currency and maturity.

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

InputValue
Maturity bucket number1

Invoice maturity buckets

Invoice exposureMatching hedge notional
100,00075,000
50,00060,000
ResultValue
Selected coverage (%)75%
Unhedged balance25,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Maturity bucket number12Selected coverage (%)75%120%
Invoice exposure (row 1)100,000110,000Selected coverage (%)75%68.181818%
Matching hedge notional (row 1)75,00082,500Selected coverage (%)75%82.5%
Hedge coverage by invoice maturity →

Sources