Foreign Transaction Fee Total Cost Percent Calculator

Reconcile already converted home-currency purchase with caller foreign-transaction rate and separately observed conversion spread cost; no market FX/DCC spread invention, double-counting of fees already in base or zero-denominator percentage.

Description

Foreign-transaction cost can include a percentage fee plus independently observed conversion spread cost.

Foreign-transaction cost can include a percentage fee plus independently observed conversion spread cost. The converted purchase base must exclude those extra costs.1

The returned values include Foreign transaction fee minor, Total observed and modeled fx extra cost minor, Effective fx extra cost percent, Total home currency cost minor. The How section below explains the calculation, input rules and interpretation.

When to use Foreign Transaction Fee Total Cost Percent Calculator

Use Foreign Transaction Fee Total Cost Percent Calculator when you need to evaluate the supplied records under the calculation and evidence rules below. No market FX/DCC spread, current fee table or correction for double-counted base costs is inferred.

Prepare observed financial records and verified caller terms. Use one currency for integer minor-unit money and preserve leading zeros in identifier text. One basis point is 0.01 percentage points. Resolve dates, local clocks, counting rules and evidence flags as specified.

How to use Foreign Transaction Fee Total Cost Percent Calculator and understand its results

  1. Prepare observed financial records and verified caller terms. Use one currency for integer minor-unit money and preserve leading zeros in identifier text. One basis point is 0.01 percentage points. Resolve dates, local clocks, counting rules and evidence flags as specified.
  2. Enter homeCurrencyConvertedPurchaseMinor, callerForeignTransactionFeeBasisPoints, observedAdditionalConversionCostMinor using the field table and calculation rules, then run the tool.
  3. Read foreignTransactionFeeMinor, totalObservedAndModeledFxExtraCostMinor, effectiveFxExtraCostPercent, totalHomeCurrencyCostMinor. The explanation below defines the units, signs, ordering and any flags or placeholder values.
  4. If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
Input fieldMeaningValue type; see rules belowRequirement
homeCurrencyConvertedPurchaseMinorHome currency converted purchase minornumberRequired
callerForeignTransactionFeeBasisPointsCaller foreign transaction fee basis pointsnumberRequired
observedAdditionalConversionCostMinorObserved additional conversion cost minornumberRequired

Enter positive safe-integer converted home-currency purchase, nonnegative safe-integer additional conversion cost and integer fee basis points 0–10000. Return fee, combined extra cost, extra-cost percent and total cost with checked sums.

fee=roundMinor(base×bps/10000); extra=fee+conversionCost; percent=100extra/base

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output fieldMeaningValue type
foreignTransactionFeeMinorForeign transaction fee minornumber
totalObservedAndModeledFxExtraCostMinorTotal observed and modeled fx extra cost minornumber
effectiveFxExtraCostPercentEffective fx extra cost percentnumber
totalHomeCurrencyCostMinorTotal home currency cost minornumber
json
{
  "input": {
    "homeCurrencyConvertedPurchaseMinor": 10000,
    "callerForeignTransactionFeeBasisPoints": 300,
    "observedAdditionalConversionCostMinor": 100
  },
  "output": {
    "foreignTransactionFeeMinor": 300,
    "totalObservedAndModeledFxExtraCostMinor": 400,
    "effectiveFxExtraCostPercent": 4,
    "totalHomeCurrencyCostMinor": 10400
  }
}

Limitations and assumptions

No market FX/DCC spread, current fee table or correction for double-counted base costs is inferred.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Cross Rate Triangular Computation Tool: A triangular cross quote multiplies two legs with the same bridge orientation. An observed direct quote exposes a signed discrepancy. For a complementary task, use Rewards Effective Value Percent Calculator: Realized reward value must be compared with observed eligible spend after allocated fees. Net reward value can be negative.

References

  1. Foreign Transaction Fee Total Cost Percent Calculator — tool.io

Similar or alternative tools

Don't forget to set a bookmark for tool.io!
Privacy | Imprint | Cookies