# FX Exposure Calculator for European Manufacturers

> Source: https://netray.co/tools/multi-currency-fx-exposure-calculator-eu-manufacturer
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Estimate how a currency move hits gross margin when part of your purchases are in a foreign currency, and compare it with the cost of a forward hedge.

## Category

cost-finance

## Region

Europe

## Audience

- Controller
- Treasurer
- Purchasing manager

## Tool

**Kind:** calculator

**Currency:** EUR 

**Inputs:**

#### Annual revenue

**Key:** revenue

**Type:** number

**Default:** 24000000

**Min:** 0

**Step:** 500000

**Unit:** EUR

#### Gross margin

**Key:** gm

**Type:** number

**Default:** 28

**Min:** 0

**Max:** 80

**Step:** 0.5

**Unit:** %

#### Annual purchases in foreign currency (EUR equivalent)

**Key:** fx_purch

**Type:** number

**Default:** 3600000

**Min:** 0

**Step:** 100000

**Unit:** EUR

**Help:** For example components bought in USD, converted at today's rate.

#### Share hedged with forwards

**Key:** hedge

**Type:** slider

**Default:** 50

**Min:** 0

**Max:** 100

**Step:** 5

**Unit:** %

#### Adverse currency move

**Key:** move

**Type:** slider

**Default:** 8

**Min:** 0

**Max:** 25

**Step:** 0.5

**Unit:** %

**Help:** Foreign currency strengthening against EUR.

#### Hedge cost (forward points and fees)

**Key:** fwd_cost

**Type:** number

**Default:** 0.7

**Min:** 0

**Max:** 5

**Step:** 0.1

**Unit:** %

**Help:** Annualised cost of the hedged notional.

#### Share passed to customers via price

**Key:** pass

**Type:** number

**Default:** 20

**Min:** 0

**Max:** 100

**Step:** 5

**Unit:** %

**Help:** Currency clauses or price rises that offset the cost.

**Outputs:**

#### Gross profit

**Key:** gp

**Expr:** revenue * gm / 100

**Format:** currency

#### Unhedged purchases

**Key:** unhedged

**Expr:** fx_purch * (1 - hedge / 100)

**Format:** currency

#### Cost increase on unhedged part

**Key:** gross_hit

**Expr:** unhedged * move / 100

**Format:** currency

#### Net impact after price pass-through

**Key:** net_hit

**Expr:** gross_hit * (1 - pass / 100)

**Format:** currency

**Primary:** true

#### Hedging cost per year

**Key:** hedge_cost

**Expr:** fx_purch * hedge / 100 * fwd_cost / 100

**Format:** currency

#### Gross margin lost

**Key:** margin_pts

**Expr:** if(gt(revenue,0), net_hit / revenue * 100, 0)

**Format:** percent

**Description:** In percentage points of revenue.

#### Share of gross profit lost

**Key:** gp_share

**Expr:** if(gt(gp,0), net_hit / gp * 100, 0)

**Format:** percent

**Primary:** true

**Chart:**

#### Net FX impact vs adverse currency move

**Type:** line

**X:** move

**From:** 0

**To:** 25

**Steps:** 25

**Series:**

- net_hit
- hedge_cost

**Disclaimer:** Simplified exposure model with a single currency and a flat move. Not treasury advice. Real hedge accounting, timing of payments and option structures need your treasury team or bank.

## Content

**Intro:** A European manufacturer buying components in US dollars or Swiss francs can lose a surprising share of gross profit from a single currency swing. This calculator shows the exposure, the effect of a hedge ratio and what hedging costs, so purchasing and finance can agree a policy.

**Sections:**

#### How to use it

**Body:** Pull annual foreign-currency purchases from your ERP open and historical purchase orders, converted to euros at the budget rate. Enter revenue and gross margin, the hedge ratio you use today and an adverse move you want to test. The pass-through field captures price clauses that let you recover part of the cost from customers.

**Bullets:**

- Use purchase orders, not invoices, for forward exposure
- Test 5, 10 and 15 percent moves
- Include currency clauses in customer contracts
- Compare hedge cost with the loss it prevents

#### The calculation

**Body:** Unhedged purchases equal foreign purchases times one minus the hedge ratio. The gross hit is unhedged purchases times the adverse move, and the net impact removes the share passed to customers. Hedging cost is foreign purchases times hedge ratio times the annualised forward cost. Margin lost is net impact divided by revenue, and the share of gross profit lost shows how severe it is.

#### Reading the chart

**Body:** The chart plots net impact against hedging cost for different moves. Where the impact line stays below the hedge cost for small moves, hedging is insurance you pay for in quiet years. Many mid-market firms hedge 50 to 80 percent of firm orders and leave the forecast portion open. Match the ratio to how quickly you can reprice.

#### Common mistakes

**Body:** Companies hedge purchases but forget the matching sales in the same currency, which is a natural hedge. Another error is ignoring the lag between purchase order, receipt and payment. In the ERP, check the exchange-rate type used for valuation, because standard-cost items may mask the effect until variances post.

**Cta:** Netray can build a read-only exposure report from your ERP purchase orders by currency and due date, so the numbers feeding this tool are always current.

**Faq:**

#### What hedge ratio should I choose?

**Answer:** There is no single answer. Many firms hedge most of firm purchase orders and a smaller part of forecast demand. Your policy should reflect how fast you can adjust prices.

#### Does it handle several currencies?

**Answer:** Run it once per currency and add the net impact lines. Correlation between currencies is ignored here, so the sum is a conservative view.

#### Where do I find exposure in the ERP?

**Answer:** Open purchase order lines by currency and expected payment date, plus open supplier invoices. Most ERPs can export this to Excel as a currency ladder.

#### Is this treasury advice?

**Answer:** No. It is a planning aid. Hedge instruments, accounting treatment and counterparty limits should be agreed with your treasury advisor or bank.

## Search terms

fx exposure calculator, currency risk calculator manufacturing, hedge ratio calculator, eur usd purchase currency risk, forward contract cost calculator, multi currency erp exposure, currency impact on gross margin

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json