Calculation guide
Enter a hedge gain as positive and a hedge loss as negative. A value of 100% offsets the change fully.
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
| Input | Value |
|---|---|
| Physical units purchased | 10,000 |
| Initial input unit cost | 5 |
| Final input unit cost | 6 |
| Realized hedge gain or loss | 8,000 |
| Result | Value |
|---|---|
| Dollar-offset ratio (%) | 80% |
| Residual cost change | 2,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Physical units purchased | 10,000 | 11,000 | Dollar-offset ratio (%) | 80% | 72.727273% |
| Initial input unit cost | 5 | 4 | Dollar-offset ratio (%) | 80% | 40% |
| Final input unit cost | 6 | 7 | Dollar-offset ratio (%) | 80% | 40% |
| Realized hedge gain or loss | 8,000 | 8,800 | Dollar-offset ratio (%) | 80% | 88% |
