How to Implement FX Impact Report

Summary:

We'd like to implement a report showing the impact of a change in the exchange rates.

Content (please ensure you mask any confidential information):

In our organization, we have companies having different base currencies.

As part of our budgeting process, we want to make projections of changes in the exchange rates and see the impact (delta between figures with current rates and same figures with past or futures rates).

What would be the best approach to implement this?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):