Mexico Peso FX Exposure Plant Cost Calculator
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.
Your numbers
Payroll, local services, utilities, rent and local materials.
Imported materials, freight and corporate charges.
Your results
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.
Monthly USD cost vs USD/MXN rate
Sweeps Actual or scenario exchange rate from 14 to 24, holding your other inputs fixed.
Currency exposure from your ledger
Optional: see how exposure by currency can be reported from your ERP.
Optional. The tool and every export work without this. No spam.
How to use it
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.
- 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
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
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
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.
Frequently Asked Questions
Which direction hurts a Mexican plant?
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?
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?
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?
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.
Netray can build a live view of cost by currency from your ERP ledger so exposure is tracked, not guessed.
Related Tools
Mexico Fully Loaded Labor Cost Per Hour Calculator
Turns a daily wage in pesos into the all-in annual and hourly cost per operator, including aguinaldo, vacation premium, employer social security and other burden.
Costing & FinanceNearshoring Break-Even Volume and Payback Calculator
Compares your current landed cost per unit with a nearshore cost, adds one-time transfer cost and extra fixed overhead, and returns break-even volume and payback months.
Country & TaxMexico IMMEX IVA Certification Cash Flow Calculator
Sizes the cash tied up in import IVA on temporary imports and the yearly cost of financing it, so you can judge whether IVA and IEPS certification is worth pursuing.
Supply Chain & InventoryNearshore vs Asia Pipeline Inventory Carrying Cost Calculator
Prices the inventory sitting in transit and in safety stock on a nearshore lane versus an Asian lane, using transit time, demand variability and carrying rate.
More Costing & Finance tools
See all- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template
- Distributor Customer Credit Application Template
- Distributor Customer Profitability Worksheet
- Distributor GMROI and Inventory Turns Calculator
- Vendor Early Pay Discount Worksheet
- SyteLine Cost Rollup Variance Calculator