Exchange rate and duty scenario: what happens to margin
Shows how a higher exchange rate or duty changes cost and margin, the rate at which margin falls to the target, and how far the price must rise to keep it.
At a glance
- What question does it answer?
- What happens to cost and margin at another rate or duty and which rate is critical.
- What data is needed?
- Purchase in currency, current rate, duty, costs in your currency.
- How to read the result?
- Compare margin now, in the scenario and with a price rise. The “break-even rate” shows the safety margin: the closer it is to the current rate the riskier foreign-currency purchasing. Example on the default values: A purchase of $18 at a rate of 90 and 12% duty: cost RUB 2,194.40 and margin 55.2%. At a rate of 110 the cost is RUB 2,597.60, margin without a price rise 47.0% and, with half of the cost rise passed into the price, 49.1%. The price that keeps the current margin is RUB 5,800.33; margin falls to the 40% goal at a rate of about 127. If the rate at which margin falls to the goal is closer to the current one than you are comfortable with, hedge part of the purchase earlier or change the price. Next: “Landed cost of an imported item” and “Air or sea: does speeding up pay”.
Why and how to reason
Imports depend on the exchange rate twice: the foreign-currency purchase and the duty, which is computed on the value in roubles. So cost = purchase x rate x (1 + duty) + costs in roubles. Costs in roubles (sewing, warehouse) do not depend on the rate, so a rate rise hits only the foreign-currency part.
Margin = (price - cost) / price. If the rate rises while price stays, margin falls. To keep the previous margin, the price must rise to: new cost / (1 - previous margin). But the price cannot always be raised by the full amount, so there is a share of the cost increase built into the price.
Example. Purchase USD 18, rate 90, duty 12%, costs RUB 380: cost RUB 2,194, margin 55.2%. Rate 110: cost RUB 2,598, margin 47.0%. To keep 55.2% the price must be RUB 5,800 (18% above 4,900). Passing half of the increase into the price gives a margin of 49.1%. The rate at which margin falls to the 40% target is about 127.
When to use it
It is useful before ordering from a foreign supplier and when revising prices after a sharp rate move. It helps understand how much cushion the margin has and when a price adjustment is needed. Assumption: the price in the purchase currency does not change. If the supplier also revises the price, add it to the scenario. Demand may fall after a price rise, and the calculation does not capture this.
How to read the result
Look at the “critical rate”: while the rate stays below it, margin is above target. In the example the cushion runs from 90 to 127, almost 41%. Compare margin with a price rise by the set share and without a price change: the difference shows what you gain by passing the increase into the price. If the critical rate is close to the current one, you need to hedge in advance, change the supplier or build in a larger margin. Decision: define the rate threshold at which you revise prices and write it down as a rule. Set a rule in advance: at what rate you revisit prices and by what share.
Common mistakes
Assuming the duty is fixed in roubles; ignoring costs denominated in currency; taking the bank rate instead of the rate of actual payments; assuming the whole increase can be passed into price. Also: forgetting other items tied to the rate. Also: comparing margin across currency scenarios at different prices.
What data is needed?
- Purchase in currency, current rate, duty, costs in your currency.
- Selling price, target margin, scenario rate and duty and the share of the rise you pass on in price.
- Where to take it: the purchase price in currency from the contract and invoice; the current rate: the official Bank of Russia rate or your bank’s rate on the payment date; duty from the customs tariff rate for the goods code (check the current rate for the valuation date); rouble costs per item from costing; selling price from the price list excl. VAT. Set the scenario rate from a cautious forecast or stress test.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Supplier purchase, in purchase currency | per item | 18 | The purchase price of one unit in the purchase currency under the contract. |
| Current exchange rate | your currency per 1 purchase currency | 90 | The rate at which you buy currency now, including the bank conversion. |
| Customs duty | % | 12 | The duty rate as a percentage of the purchase price; depends on the commodity code, ask your broker. |
| Costs in your currency per item | ₽ | 380 | Delivery, warehouse, certification, local sewing: what does not depend on the rate. |
| Selling price excl. VAT | ₽ | 4,900 | Selling price per unit excl. VAT from which margin is calculated. |
| Target margin | % | 40 | The margin on price that suits you; the critical exchange rate is calculated from it. |
| Scenario exchange rate | your currency per 1 purchase currency | 110 | The rate you want to test, for example if the currency rises. |
| Scenario duty | % | 12 | The duty rate in the scenario, if it may change. |
| Share of the cost rise passed into price | % | 50 | 0 — price unchanged, 100 — the whole rise goes into price. |
| Price-list lag: months until the price catches up with the rate | months | 0 | 0: the price changes at once, as before. Above zero: for this many months we sell at the old price at the new cost. Take the term from your past price-list revisions. |
| Units sold per month | units | — | Optional. Needed to count the margin lost during the lag. Empty: not counted. |
How it is calculated
| Step | Formula |
|---|---|
| Cost | Purchase × rate × (1 + duty) + costs in your currency |
| Margin | (Price − cost) ÷ price |
| Price for the same margin | New cost ÷ (1 − old margin) |
| Break-even rate | (Price × (1 − goal) − costs) ÷ (purchase × (1 + duty)) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Cost now
- 2,194.4 ₽
- Cost in the scenario
- 2,597.6 ₽Up 18.4 %.
- Margin now
- 55.2 %
- Scenario margin, price unchanged
- 47 %
- Margin with a price rise
- 49.1 % · 5,101.6 ₽
- Price that keeps today’s margin
- 5,800.33 ₽A price rise of 18.4 %.
- Rate at which margin falls to the goal
- 126.98 ₽At the current duty and price.
Margin at different rates
| Rate change | Rate | Cost | Margin |
|---|---|---|---|
| −10 % | 81 ₽ | 2,012.96 ₽ | 58.9 % |
| 0 % | 90 ₽ | 2,194.4 ₽ | 55.2 % |
| +10 % | 99 ₽ | 2,375.84 ₽ | 51.5 % |
| +20 % | 108 ₽ | 2,557.28 ₽ | 47.8 % |
| +30 % | 117 ₽ | 2,738.72 ₽ | 44.1 % |
| +40 % | 126 ₽ | 2,920.16 ₽ | 40.4 % |
Even at a rate of 110 ₽ margin stays above the goal: 47 %.
Nuances and limits
- The calculation ignores the delay between purchase and sale and hedging.
- The delay between purchase and sale is not counted: payment is at one rate and sale at another.