Foreign Currency Gains calculation

English
1

Greetings, -

Attached is the subject calculation. The 1st purchase is on 19-Aug-18 in EUR. It converts the $ amount to the equivalent EUR as on 17-Aug-18 (This EUR amount is incidentally higher than the actual EUR spend). The EUR so arrived at is then converted on the report date to calcute the fx gains.

I would have thought the original EUR spend on 19-Aug-18 would have been used to identify fx gains. What am I missing?

Many thanks

image
image759×354 77.8 KB

2

It’s a very theoretical, what-if style value. I wouldn’t pay it too much attention.

3

Thanks for your reply.

Noted. If its just theoretical and in my case very different from the actual fx gain, it would have been nice to have an option to hide the column.

Regards