Collection FX risk: cost in a foreign currency, payment horizon, hedge
By payment stages to the factory calculates the cost of the collection in roubles at the current rate and with a hedge, the effect of a rate shift on the open part (up and down) on cost and margin, the critical rate down to the target margin and the price rise needed to keep margin in roubles.
At a glance
- What question does it answer?
- How the exchange rate affects the cost and margin of the collection and how much of the purchase to cover with a hedge.
- What data is needed?
- The collection cost in the foreign currency, the rate at the calculation date and planned revenue.
- How to read the result?
- On the default data (2,400,000 currency units, rate 12.5, revenue 62,000,000) the cost at the current rate is 30,000,000, with a hedge on 50% of cost 30,207,123 (premium 207,123). The open position is 1,200,000 currency units, the average time to payment 78 days. Planned margin 51.3%. At a rate of +10% on the open part the cost is 31,707,123, margin 48.9% (minus 2.4 pp); at −10% margin is 53.7%. To keep margin in money the price must rise by 2.4%. The critical rate down to the 45% target is 15.74, headroom 26.0%. Example on the default values: Cost at the current rate, unhedged: RUB 30 million; Planned cost with the hedge: RUB 30.2 million; Cost of the hedge (forward premium): RUB 207,123; Hedged share of cost: 50%. The figures are illustrative: enter your own to see your result.
Why and how to reason
The factory takes money in currency while your revenue is in roubles, so the rate between the order and the last payment turns into a hidden cost item. Payments come in stages: a prepayment at order, a payment before shipment, a balance after acceptance. The further out the payment, the longer the rate can move. A hedge (forward) fixes the rate in advance at a price, and that price is a premium growing with the number of days. For a collection of 2.4 million units of currency at 12.5 the cost is 30 million. We hedge 30% × 100% + 40% × 50% = 50% of the amount, leaving an open position of 1.2 million units. The hedge cost is 207 thousand, cost with hedge 30.2 million, margin 51.3%. If the rate on the open part rises 10%, the cost rises to 31.7 million and margin falls to 48.9%.
When to use it
Use it when ordering a collection in currency: to decide what part to hedge and to see the critical rate. Do not use it as a promise: hedging conditions and the availability of instruments depend on the bank and rules, so check them separately. Assumptions: the payment schedule is known, the rate moves by the given share, the forward premium is linear in time, revenue does not depend on the rate.
How to read the result
Look at the loss of margin when the rate rises (2.4 points) and the price rise needed (2.4%): it shows how much to raise the retail price to restore margin in roubles. The critical rate (15.74) is the rate at which margin falls to the target, and the headroom of 26% says how far away it is. If headroom is small, hedge more. Compare the cost of the hedge (0.7% of cost) with the possible loss: a hedge is insurance, and it is justified when the loss is noticeably bigger than the premium. It is worth keeping the calculation with the date and the rate: when the rate changes, compare plan with actual and see what the protection gave.
Common mistakes
The usual mistakes: taking the rate at the calculation date and treating it as constant, ignoring the forward premium, confusing a stage share with a hedge share, not entering the term of each payment, assuming a hedge removes the risk completely (the open part remains). Check that the stage shares sum to 100%.
What data is needed?
- The collection cost in the foreign currency, the rate at the calculation date and planned revenue.
- Payment stages: the share of cost, days to payment and the hedged share.
- The forward premium, the rate shift for the test and optionally the target margin.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Collection cost in the foreign currency | currency units | 2,400,000 | The sum of contracts with the factory in the contract currency. The example value is illustrative. |
| Rate at the calculation date | roubles per unit | 12.5 | The rate at which you actually buy the currency, including the spread of your bank or agent. The example value is illustrative: take your own rate at the calculation date. |
| Planned revenue of the collection excl. VAT | ₽ | 62,000,000 | The revenue the collection price is based on. The example value is illustrative. |
| Target margin of the collection | % | 45 | Your target margin in revenue: the critical rate is calculated down to it. Empty: the critical rate is not calculated. The example value is illustrative. |
| Forward premium | % a year | 14 | By how many percent a year the forward rate exceeds the current one: from your bank’s quote (it reflects the rate differential). The example value is illustrative. |
| Rate shift for the test | % | 10 | By how many percent up and down the rate of the open part is shifted. 10 means ±10%. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Payments by stage | amount in currency × stage share; hedged part × hedged share |
| Forward rate | rate × (1 + annual premium × days ÷ 365) |
| Cost | hedged part × forward + open × rate × (1 ± shift) |
| Margin and critical rate | (revenue − cost) ÷ revenue; the rate at which margin equals the target |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Cost at the current rate, unhedged
- 30 m ₽
- Planned cost with the hedge
- 30.2 m ₽The hedged part at the forward rate, the open part at the current rate.
- Cost of the hedge (forward premium)
- 207,123 ₽
- Hedged share of cost
- 50 %
- Open position in the currency
- 1,200,000
- Average time to payment
- 78 daysWeighted by the stage amounts.
- Planned margin with the hedge
- 51.3 %
- Cost at a rate +10 % on the open part
- 31.7 m ₽
- Margin at a rate +10 %
- 48.9 %
- Margin at a rate −10 %
- 53.7 %
- Margin loss when the rate rises, p.p.
- 2.4
- Price rise needed to keep margin in money when the rate rises
- 2.4 %Without loss of volume: in fact demand reacts to a price rise.
- Critical rate down to the target margin
- 15.74 ₽
- Rate headroom to the critical rate
- 26 %
Payments by stage
| Stage | Amount in currency | In days | Hedged share | Forward rate | Cost in roubles | At +10 % | At −10 % |
|---|---|---|---|---|---|---|---|
| Prepayment at order | 720,000 | 10 | 100 % | 12.548 | 9.03 m ₽ | 9.03 m ₽ | 9.03 m ₽ |
| Before dispatch | 960,000 | 75 | 50 % | 12.86 | 12.2 m ₽ | 12.8 m ₽ | 11.6 m ₽ |
| After receipt | 720,000 | 150 | 0 % | 13.219 | 9 m ₽ | 9.9 m ₽ | 8.1 m ₽ |
The cost in roubles is 30 m ₽ at the current rate; with a hedge on 50 % of cost 30.2 m ₽, premium 207,123 ₽. If the rate of the open part rises by 10 %, cost becomes 31.7 m ₽, margin 48.9 % instead of 51.3 %.
The calculation is not a rate forecast: it is a sensitivity. The terms of a forward, the dates and the admissibility of the operations, as well as currency control under the contract, are to be agreed with the bank and a lawyer. The forward premium and rate are illustrative. Amounts excl. VAT.
Nuances and limits
- The calculation is not a rate forecast but a sensitivity: see what part of margin is vulnerable.
- Take your own rate, including the spread of your bank or agent, not the official one.
- Agree the terms of a forward, the admissibility of the operations and currency control under the contract with your bank and a lawyer.
- A price rise equal to the rate move keeps margin in money only if demand does not fall.