Automated FX Calculation For Large Companies

Built-in automated Constant Currency Calculation for eliminating the FX fluctuations of the financial performance.

Utilizing Constant Currency Calculation

Companies that recognize revenues and costs in different currencies can realize that their performance distorted by the different currency movements over the period.

Analyzing results on a constant currency basis can be important to global companies whose results have been affected by swings in foreign-exchange rates. Such figures show what a company’s financials would have been if the company didn’t experience currency fluctuations.

Understanding FX effect

When reporting constant currency figures, provide transparency by disclosing the methodology and assumptions used in the calculations. This allows users of the financial information to understand how the constant currency figures were derived. 

Where Constant Currency Calculation is used

Although Constant Currency Calculation is not a measure of any generally accepted accounting principle, such analysis is very popular in the Management Reporting. Providing constant currency figures:

Where Constant Currency Calculation is used

Although Constant Currency Calculation is not a measure of any generally accepted accounting principle, such analysis is very popular in the Management Reporting. Providing constant currency figures:

Be careful with Constant Currency Calculation

High level and less accurate constant currency calculations increase the confusion.


Constant Currency Calculation

Typically, constant currency can be calculated in two ways, used the rate of the previous or current period.
  1. Convert Current Period numbers using the Previous Period’s FX Rate. This shows what financial result would have been if the exchange rate remained unchanged.

  2. Calculate Previous Period numbers using the Current Period’s FX Rate. This shows what the financial result would have been in the previous period with the current exchange rate.
  1. Calculate Actual numbers using Budget or Forecast FX Rate. This shows what Actual financial result would have been if the exchange rate turned out as planned.

  2. Calculate Budget or Forecast numbers using Actual FX Rates. This shows what Budget would have been if the actual exchange rate had been known

In Abylon Rapid Planner we use the first method where the Current Period is converted with Previous Period Rates and we calculate Actual numbers using Budget or Forecast FX Rate.

Improve your FP&A with Abylon Rapid Planner

Abylon Rapid Planner is an Excel-based FP&A solution, that utilizes database integrations, built-in automations, centralized master data management and ready-to-use templates to modernize and simplify corporate business planning, forecasting and what-if scenario creation.
Communicate with your data warehouses, write-back data, simplify business planning, forecasting and what-if-scenario creation!

Interested? Let's start a conversation and see how we can help you!

Please provide your name and email address to download the whitepaper

Please provide your basic info to view the Demo

Download Whitepaper on Rapid Smart Excel Add-In