Foreign-currency invoice hedge versus spot · Calculation guide

Compare an importer’s partially hedged payable with buying all currency at settlement.

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.

saving = invoice*share/100*(spot-forward)-fee · hedged = invoice*(share/100*forward+(1-share/100)*spot)+fee · openpay = invoice*spot

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

InputValue
Foreign invoice units payable10,000
Percentage hedged60%
Agreed forward rate1.1
Scenario spot rate at payment1.2
Hedge execution fee20
ResultValue
Saving on payment with hedge580
Hedged home-currency cost11,420
Unhedged home-currency cost12,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Foreign invoice units payable10,00011,000Saving on payment with hedge580640
Percentage hedged60%66%Saving on payment with hedge580640
Agreed forward rate1.12.1Saving on payment with hedge580-5,420
Scenario spot rate at payment1.22.2Saving on payment with hedge5806,580
Hedge execution fee2022Saving on payment with hedge580578
Foreign-currency invoice hedge versus spot →