Open calculator ↗

Commodity hedge effectiveness against input costs · Calculation guide

Measure dollar offset for an observed input-cost change.

Calculation guide

Enter a hedge gain as positive and a hedge loss as negative. A value of 100% offsets the change fully.

effect = 100*gain/(qty*(after-before)) · net = qty*(after-before)-gain

Inputs

Physical units purchased

Example entry 10000.0. Minimum 1e-12.

Initial input unit cost

Example entry 5.0 (in the selected currency).

Final input unit cost

Example entry 6.0 (in the selected currency).

Realized hedge gain or loss

Example entry 8000.0 (in the selected currency).

Worked example

InputValue
Physical units purchased10,000
Initial input unit cost5
Final input unit cost6
Realized hedge gain or loss8,000
ResultValue
Dollar-offset ratio (%)80%
Residual cost change2,000

Calculation steps

Dollar-offset ratio (%) = ((100 × Realized hedge gain or loss) ÷ (Physical units purchased × (Final input unit cost − Initial input unit cost)))

((100 × 8,000) ÷ (10,000 × (6 − 5))) = 80%

Residual cost change = ((Physical units purchased × (Final input unit cost − Initial input unit cost)) − Realized hedge gain or loss)

((10,000 × (6 − 5)) − 8,000) = 2,000

Interpreting the result

A ratio above 100% means the hedge more than offsets the measured cost movement.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Physical units purchased10,00011,000Dollar-offset ratio (%)80%72.727273%
Initial input unit cost54Dollar-offset ratio (%)80%40%
Final input unit cost67Dollar-offset ratio (%)80%40%
Realized hedge gain or loss8,0008,800Dollar-offset ratio (%)80%88%
Commodity hedge effectiveness against input costs →

Sources