# Mexico Peso FX Exposure Plant Cost Calculator

> Source: https://netray.co/tools/mexico-peso-fx-exposure-plant-cost-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Shows what a stronger or weaker peso does to the dollar cost of payroll and local spend at a Mexican plant, with a simple hedge ratio.

## Category

cost-finance

## Region

Mexico

## Industry

Nearshoring manufacturing

## Audience

- CFO
- Controller
- Plant manager
- FP&A analyst

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Monthly costs paid in pesos

**Key:** mxn_costs

**Type:** number

**Default:** 14000000

**Min:** 0

**Step:** 100000

**Unit:** MXN

**Help:** Payroll, local services, utilities, rent and local materials.

#### Monthly costs paid in dollars

**Key:** usd_costs

**Type:** number

**Default:** 650000

**Min:** 0

**Step:** 10000

**Unit:** USD

**Help:** Imported materials, freight and corporate charges.

#### Budget exchange rate

**Key:** budget_fx

**Type:** number

**Default:** 18.5

**Min:** 5

**Max:** 40

**Step:** 0.1

**Unit:** MXN per USD

#### Actual or scenario exchange rate

**Key:** fx_rate

**Type:** slider

**Default:** 17

**Min:** 14

**Max:** 24

**Step:** 0.1

**Unit:** MXN per USD

#### Share of peso costs hedged at budget rate

**Key:** hedge

**Type:** slider

**Default:** 50

**Min:** 0

**Max:** 100

**Step:** 5

**Unit:** %

**Outputs:**

#### Budgeted monthly cost in USD

**Key:** budget_total

**Expr:** mxn_costs / budget_fx + usd_costs

**Format:** currency

#### Monthly cost with no hedge

**Key:** unhedged_usd

**Expr:** mxn_costs / fx_rate + usd_costs

**Format:** currency

#### Monthly cost with hedge

**Key:** hedged_usd

**Expr:** mxn_costs * hedge / 100 / budget_fx + mxn_costs * (1 - hedge / 100) / fx_rate + usd_costs

**Format:** currency

**Primary:** true

#### Monthly variance vs budget

**Key:** variance

**Expr:** hedged_usd - budget_total

**Format:** currency

**Primary:** true

#### Annualised variance

**Key:** annual_variance

**Expr:** variance * 12

**Format:** currency

#### Variance as a share of budget

**Key:** variance_pct

**Expr:** if(gt(budget_total,0), variance / budget_total * 100, 0)

**Format:** percent

**Chart:**

#### Monthly USD cost vs USD/MXN rate

**Type:** line

**X:** fx_rate

**From:** 14

**To:** 24

**Steps:** 30

**Series:**

- unhedged_usd
- hedged_usd

**Disclaimer:** Simplified model with a static hedge at the budget rate. It ignores hedge cost, forward points, peso-linked pricing clauses and wage inflation. Not financial advice.

## Content

**Intro:** When the peso strengthens, a Mexican plant costs more in dollars even if nothing changes on the shop floor. This calculator shows how much, and how much a partial hedge would have saved or cost.

**Sections:**

#### How to use it

**Body:** Split your monthly plant spend into pesos and dollars. Set the exchange rate you budgeted and then move the scenario rate to test a stronger or weaker peso. Use the hedge slider for the share of peso costs covered by forwards or options at the budget rate. The result is the monthly dollar cost, the variance against budget and an annual figure you can take to the CFO.

**Bullets:**

- Include peso payroll, social charges, rent, energy and local suppliers.
- Keep dollar-priced imports in the dollar field.
- Run at least three rates: budget, plus and minus ten percent.

#### The math

**Body:** Dollar cost of peso spend equals peso amount divided by the exchange rate, so a lower MXN per USD figure means a stronger peso and a higher dollar bill. The hedged portion is converted at the budget rate and the rest at the scenario rate. Total cost adds dollar-denominated spend, which is not affected. The variance is the hedged total minus the budgeted total.

#### Worked example

**Body:** With 14 million pesos and 650,000 dollars of monthly spend and a budget of 18.5, the budget is about 1,406,757 dollars. If the peso moves to 17, an unhedged plant pays about 1,473,529 dollars, which is 66,772 more a month. A fifty percent hedge halves most of that exposure, leaving a variance of about 33,000 dollars, or roughly 400,000 dollars a year.

#### Common mistakes

**Body:** Common errors are treating all cost as peso cost, ignoring wage increases that follow a strong peso, assuming hedges are free and forgetting that your customers may reprice. Where the contract with your customer is in dollars and your cost base is in pesos, your margin is long the peso risk and short the strength. Review the contract currency before the hedge.

**Cta:** Netray can build a live view of cost by currency from your ERP ledger so exposure is tracked, not guessed.

**Faq:**

#### Which direction hurts a Mexican plant?

**Answer:** A stronger peso, meaning fewer pesos per dollar, raises the dollar cost of peso payroll and local spend. A weaker peso lowers it. The exposure is largest when most of your revenue is in dollars and most costs are in pesos.

#### Does a hedge always help?

**Answer:** No. A forward fixes the rate, so if the peso weakens you give up the benefit. Hedging reduces variance, not average cost, and has a carry cost that is not modelled here.

#### What budget rate should I use?

**Answer:** Use the rate in your approved budget or the forward rate for the period. Using spot only hides the budget miss that finance will later report.

#### Should I include inflation?

**Answer:** This tool is a snapshot. For multi-year plans add expected wage inflation in pesos separately, because it is a second force on dollar cost beside the exchange rate.

## Search terms

peso exchange rate manufacturing cost, USD MXN exposure calculator, Mexico plant cost FX sensitivity, nearshoring peso strength, maquiladora currency risk, FX hedge ratio calculator, super peso manufacturing cost

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