Outright – Revaluation

On Batch operation (Accounting) menu, it is possible to launch “Outright revaluation…”.

This process calculates revaluation for all Outright transactions, booked and not booked. According to the currency rate at outright value date, gain or loss appears on the general ledger entry generated for revaluation.

Here are some examples (Capital Currency = EUR) :

CASE 1 : 

Currency (Buy) Transaction Date Rate Amount (Buy) Currency (Sell) Value Date Rate Amount (Sell) Gain (EUR)
EUR 01/01/2018 0,8 1000000 GBP 31/12/2018 0,7 800000 142856,80

Rates:
01/01/2018 — 1 EUR = 0,8 GBP / 1 GBP = 1,25 EUR
31/12/2018 — 1 EUR = 0,7 GBP / 1 GBP = 1,428571 EUR

Calculate:
(800000 GBP * 1,428571) – 1000000 EUR  = 1142856,8 EUR – 1000000 EUR
= 142856,80 EUR

 

CASE 2 :

Currency (Buy) Transaction Date Rate Amount (Buy) Currency (Sell) Value Date Rate Amount (Sell) Loss (EUR)
EUR 01/01/2018 1,2 1000000 USD 31/12/2018 1,3 1200000 76922.80

Rates:
01/01/2018 — 1 EUR = 1,2 USD / 1 USD = 0,833333 EUR
31/12/2018 — 1 EUR = 1,3 USD / 1 USD = 0,769231 EUR

Calculate:
(1200000 USD * 0,769231) – 1000000 EUR = 923077,20 EUR – 1000000 EUR
= – 76922,80 EUR

 

CASE 3 :

Currency (Buy) Transaction Date Rate Amount (Buy) Currency (Sell) Value Date Rate Amount (Sell) Loss (EUR)
GBP 01/01/2018 0,8 1000000 EUR 31/12/2018 0,7 1250000 178571

Rates:
01/01/2018 — 1 EUR = 0,8 GBP / 1 GBP = 1,25 EUR
31/12/2018 — 1 EUR = 0,7 GBP / 1 GBP = 1,428571 EUR

Calculate:
(1000000 GBP * 1,428571) – 1250000 EUR = 1142856,8 EUR – 1250000 EUR =
– 142856,80 EUR

 

CASE 4 :

Currency (Buy) Transaction Date Rate Amount (Buy) Currency (Sell) Value Date Rate Amount (Sell) Loss (EUR)
GBP 01/01/2018 0,615384 1000000 USD 31/12/2018 0,538461 1500000 835798.08

Rates:
01/01/2018 — 1 GBP = 1,5 USD / 1 USD = 0,666667 GBP
31/12/2018 — 1 GBP = 1,857143 USD / 1 USD = 0,538461 GBP

Calculate:
?

 

CASE 5 :

Currency (Buy) Transaction Date Rate Amount (Buy) Currency (Sell) Value Date Rate Amount (Sell) Gain (EUR)
USD 01/01/2018 1,2 1000000 EUR 31/12/2018 1,3 8333333.33 64102.56

Rates:
01/01/2018 — 1 EUR = 1,2 USD / 1 USD = 0,833333 EUR
31/12/2018 — 1 EUR = 1,3 USD / 1 USD = 0,769231 EUR

Calculate:
833333.33 EUR  – (1000000 USD * 0,769231) = 833333,33 EUR – 769231 EUR
= 64102,33 EUR

 

CASE 6 :

Currency (Buy) Transaction Date Rate Amount (Buy) Currency (Sell) Value Date Rate Amount (Sell) Loss (EUR)
USD 01/01/2018 0,615384 1000000 GBP 31/12/2018 0,538461 666666.67 1819727.84

Rates:
01/01/2018 — 1 GBP = 1,5 USD / 1 USD = 0,666667 GBP
31/12/2018 — 1 GBP = 1,857143 USD / 1 USD = 0,538461 GBP

Calculate:
?