Oracle Hyperion Financial Management Tips And Techniques

FX Calculations

So how should you do foreign exchange calculations and calculate the cumulative currency adjustment? You have two choices: you can calculate each piece or back into the number. (Please note I do not say plug, which doesn’t mean that it isn’t a plug.)

So if you wanted to calculate each piece of CTA, you would need to calculate two parts for each account on the balance sheet. For the foreign exchange impact in a roll forward, it is basically the same calculation.

Effect due to change in rate on opening balance:

Prior period balance ...