Risk and Resilience

Foreign Exchange Exposure Calculator

Measure net foreign-currency exposure and translate it under current and scenario exchange rates.

Inputs5 editable fields
ScopeUser-entered business case
ModelRisk and Resilience
Business calculator

Enter your numbers

Replace the sample values with figures from one consistent business period or proposal.

Calculations run in this browser and do not transmit your entries.

$
Your estimate will appear here

Change the sample inputs to match your records.

The assignment behind the metric

The boundary around foreign exchange exposure matters because measure net foreign-currency exposure and translate it under current and scenario exchange rates. The worksheet is useful when the exposures, losses, and reserves must be reduced to one reproducible relationship.

During reconciliation of foreign exchange exposure, the result is ready for interpretation only after the source totals and exclusions reconcile.

The practical reading of foreign exchange exposure begins here: use the Bad Debt Allowance Calculator to resolve bad debt allowance, not to add decorative numbers.

The purpose of foreign exchange exposure should be specific enough to reject irrelevant data. That discipline keeps the exposures, losses, and reserves coherent and prevents extra fields from obscuring Foreign-currency receivables and Foreign units already hedged.

Calculation logic and control totals

Net foreign exposure subtracts foreign-currency payables from receivables; translated change applies the scenario-rate difference.

Net foreign exposure subtracts foreign-currency payables from receivables; translated change applies the scenario-rate difference. An unexpected result should trigger a check of scale, cutoff, denominator, and sign.

Preserve reported Foreign-currency receivables when management also needs an adjusted case involving Foreign units already hedged.

Reconcile the entries to source

Risk exposure register: Confirm partial-period treatment for Foreign-currency receivables. Label foreign-currency receivables as actual or forecast. Reconcile Foreign-currency receivables units beside Foreign-currency payables.

Risk exposure register: Tie Foreign-currency payables to the selected exposures, losses, and reserves. Mark preliminary foreign-currency payables clearly. Separate the Foreign-currency payables approval trail from Current home-currency rate.

Before approving foreign exchange exposure, risk exposure register: Record the system identifier for Current home-currency rate. Document exclusions affecting current home-currency rate. Assign different owners to estimated Current home-currency rate and Scenario home-currency rate.

Risk exposure register: Do not infer Scenario home-currency rate from another field. Document exclusions affecting scenario home-currency rate. Apply one rounding policy to Scenario home-currency rate and Foreign units already hedged.

Risk exposure register: Separate committed Foreign units already hedged from estimated Foreign units already hedged. Keep foreign units already hedged on one currency basis. Treat Foreign units already hedged outliers consistently with Foreign-currency receivables.

The accountable owner of foreign exchange exposure should remember that preserve this case when opening the Business Interruption Loss Calculator for business interruption loss.

The sample case and its purpose

The demonstration dataset is Foreign-currency receivables = 1.25e+06 foreign units; Foreign-currency payables = 780000 foreign units; Current home-currency rate = 0.92 home/foreign; Scenario home-currency rate = 0.86 home/foreign; Foreign units already hedged = 180000 foreign units. It contains no recommendation about an appropriate result.

For this foreign exchange exposure period, if the output moves sharply, check field scale and unit conventions before attributing an operating cause.

Against the selected foreign exchange exposure population, the Degree of Operating Leverage Calculator can extend the file if degree of operating leverage remains unresolved.

What remains outside the model

An alternative foreign exchange exposure case may change Foreign-currency receivables, but it still cannot establish future loss probability.

For this foreign exchange exposure period, estimated fields need an assumption owner and a date for refresh.

Separate scale, rate, and mix

Use foreign exchange exposure to locate the next evidence question rather than to finish the investigation automatically.

The evidence for foreign exchange exposure indicates that the same numerical change can have different importance across decisions and operating units.

A reliable interpretation of foreign exchange exposure cites the supporting row that changed. It also states whether the movement in Foreign-currency receivables or Foreign units already hedged was observed, approved, forecast, or assumed.

Save foreign exchange exposure with its owner, cutoff, source reference, and a conclusion tied to the resilience review.

A saved foreign exchange exposure scenario demonstrates that cite the Business Contingency Reserve Calculator and its source date when reviewers request business contingency reserve.

The source trail behind foreign exchange exposure means keep downstream assumptions outside this ledger until their own calculation has an owner and source.

A superseded foreign exchange exposure case remains part of the audit trail. Mark why Foreign-currency receivables or Foreign units already hedged changed and direct reviewers to the replacement calculation.

Clarifications before approval

Can management edit a reported figure?

Inside the foreign exchange exposure working paper, keep the reported value and place approved management adjustments in another case.

Where is the calculation purpose stored?

Keep the foreign exchange exposure purpose beside its inputs, source reference, and approval record.

Can two currencies share one rate?

In the reconciled foreign exchange exposure output, no. Apply the rate matching each currency, direction, date, and transaction purpose.