Calculation guide
Both rates are home units per foreign unit. Settle the hedged fraction at the forward rate and the balance at the entered maturity spot. Add the hedge fee in home currency.
Inputs
Foreign invoice units payable
Example entry 10000.
Percentage hedged
Example entry 60 %. Allowed range 0 to 100.
Agreed forward rate
Example entry 1.1.
Scenario spot rate at payment
Example entry 1.2.
Hedge execution fee
Example entry 20 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Foreign invoice units payable | 10,000 |
| Percentage hedged | 60% |
| Agreed forward rate | 1.1 |
| Scenario spot rate at payment | 1.2 |
| Hedge execution fee | 20 |
| Result | Value |
|---|---|
| Saving on payment with hedge | 580 |
| Hedged home-currency cost | 11,420 |
| Unhedged home-currency cost | 12,000 |
Calculation steps
Saving on payment with hedge = ((((Foreign invoice units payable × Percentage hedged) ÷ 100) × (Scenario spot rate at payment − Agreed forward rate)) − Hedge execution fee)
((((10,000 × 60) ÷ 100) × (1.2 − 1.1)) − 20) = 580
Hedged home-currency cost = ((Foreign invoice units payable × (((Percentage hedged ÷ 100) × Agreed forward rate) + ((1 − (Percentage hedged ÷ 100)) × Scenario spot rate at payment))) + Hedge execution fee)
((10,000 × (((60 ÷ 100) × 1.1) + ((1 − (60 ÷ 100)) × 1.2))) + 20) = 11,420
Unhedged home-currency cost = (Foreign invoice units payable × Scenario spot rate at payment)
(10,000 × 1.2) = 12,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 |
|---|---|---|---|---|---|
| Foreign invoice units payable | 10,000 | 11,000 | Saving on payment with hedge | 580 | 640 |
| Percentage hedged | 60% | 66% | Saving on payment with hedge | 580 | 640 |
| Agreed forward rate | 1.1 | 2.1 | Saving on payment with hedge | 580 | -5,420 |
| Scenario spot rate at payment | 1.2 | 2.2 | Saving on payment with hedge | 580 | 6,580 |
| Hedge execution fee | 20 | 22 | Saving on payment with hedge | 580 | 578 |
