Money Market Loan at Spot Rate

PURPOSE

To show illustration of money market loan at spot rate.

OVERVIEW

i. Loan revalued at month end using accounting rate.

ii.  Expense are reported at spot rate. No revaluation on interest.

iii. Gain and loss arising from foreign exchange movement are analyzed into capital component.

TRANSACTION DETAILS

Accounting Base Ccy
Trade ID
Trade Date
Value Date
Maturity Date
Currency
Amount
Rate
Accrual Method
Total Interest
Maturity Amount
USD
MMK1001
3-Feb-03
3-Feb-03
3-Apr-03
SGD
1,000,000.00
5.1232%
Act/365
8,281.34
1,008,281.34

SUMMARY OF JOURNALS

IDDateDescription
J13-Feb-03Money Market Loan Start.
J228-Feb-03Money Market Month End Accruals.
J31-Mar-03Reversal Money Market Month End Accruals.
J431-Mar-03Money Market Month End Accruals.
J51-Apr-03Reversal Money Market Month End Accruals.
J63-Apr-03Money Market Loan Maturity.

J1                    Money Market Loan Start.

TradeIDPostDateB/PAccountCcyCcy AmountExc RateCcyBase AmountLine
MMK10013-Feb-03BCash at BankSGD1,000,000.000.567456USD567,456.38J1a
MMK10013-Feb-03BMMK-LoanSGD-1,000,000.000.567456USD-567,456.38J1b

Note J1a :          The booking rate on 3-Feb 2003 is 1.76225 (multiplier 0.567456).The rate is rounded to 6dp for display. Full precision is used in calculation.

J2                     Money Market Month End Accruals.

TradeIDPostDateB/PAccountCcyCcy AmountExc RateCcyBase AmountLine
MMK100128-Feb-03PMMK- Loan Interest ExpenseSGD3,649.400.568919USD2,076.21J2a
MMK100128-Feb-03BMMK- Loan Interest PayablesSGD-3,649.400.568919USD-2,076.21J2b
MMK100128-Feb-03BMMK - LoanSGD0.00USD-1,462.45J2c
MMK100128-Feb-03PFX - Unrealised Losses - CapitalSGD0.00USD1,462.45J2d

Note J2a :          The spot rate on 28-Feb is 0.568919. See Exchange Rates below. The rate is rounded to 6dp for display. Full precision is used in calculation.

Note J2b :          Calculation of Accrual in SGD

Start date3-Feb-03
Month End Date28-Feb-03
Days (include 28-Feb)26=A
Start date3-Feb-03
Maturity Date3-Apr-03
Days (exclude 3-Apr)59=B
Total Interest8,281.34=C
Period Interest3,649.40=C*A/B

Note J2d :          The unrealised loss on the revaluation of the loan is analyzed as follows:

SGDRate+
USD
At Closing Rate1,000,000.000.568919
568,918.83
At Start Date1,000,000.000.567456
567,456.38
Loss in exchange
-1,462.45

+ Rates used for calculation are in full precision. Illustrated rates are rounded to 6dp.

J3                       Reversal Money Market Month End Accruals.

TradeIDPostDateB/PAccountCcyCcy AmountExc RateCcyBase AmountLine
MMK10011-Mar-03PMMK - Loan Interest ExpenseSGD-3,649.400.568919USD-2,076.21J3a
MMK10011-Mar-03BMMK - Loan Interest PayablesSGD3,649.400.568919USD2,076.21J3b
MMK10011-Mar-03BMMK - LoanSGD0.00USD1,462.45J3c
MMK10011-Mar-03PFX - Unrealised Losses-CapitalSGD0.00USD-1,462.45J3d

J4                       Money Market Month End Accruals.

TradeIDPostDateB/PAccountCcyCcy AmountExc RateCcyBase AmountLine
MMK100131-Mar-03PMMK - Loan Interest ExpenseSGD8,000.620.577434USD4,619.83J4a
MMK100131-Mar-03BMMK - Loan Interest PayablesSGD-8,000.620.577434USD-4,619.83J4b
MMK100131-Mar-03BMMK - LoanSGD0.00USD-9,977.50J4c
MMK100131-Mar-03PFX - Unrealised Losses-CapitalSGD0.00USD9,977.50J4d

Note J4a :          The spot rate on 31-Mar is 0.577434. See Exchange Rates below. The rate is rounded to 6dp for display. Full precision is used in calculation.

Note J4b :          Calculation of Accrual in SGD

Start date3-Feb-03
Month End Date31-Mar-03
Days (include 31-Mar)57=A
Start date3-Feb-03
Maturity Date3-Apr-03
Days (exclude 3-Apr)59=B
Total Interest8,281.34=C
Period Interest8,000.62=C*A/B

Note J4d :          The unrealised loss on the revaluation of the loan is analyzed as follows:

SGDRate+
USD
At Closing Rate1,000,000.000.577434
577,433.88
At Start Date1,000,000.000.567456
567,456.38
Loss in exchange
-9,977.50

+ Rates used for calculation are in full precision. Illustrated rates are rounded to 6dp.

J5                      Reversal Money Market Month End Accruals

TradeIDPostDateB/PAccountCcyCcy AmountExc RateCcyBase AmountLine
MMK10011-Apr-03PMMK - Loan Interest ExpenseSGD-8,000.620.577434USD-4,619.83J5a
MMK10011-Apr-03BMMK - Loan Interest PayablesSGD8,000.620.577434USD4,619.83J5b
MMK10011-Apr-03BMMK - LoanSGD0.00USD9,977.50J5c
MMK10011-Apr-03PFX - Unrealised Losses - CapitalSGD0.00USD-9,977.50J5d

J6                      Money Market Loan Maturity. 

TradeIDPostDateB/PAccountCcyCcy AmountExc RateCcyBase AmountLine
MMK10013-Apr-03PMMK - Loan Interest ExpenseSGD8,281.340.581416USD4,814.90J6a
MMK10013-Apr-03BMMK - LoanSGD1,000,000.000.567456USD567,456.38J6b
MMK10013-Apr-03BCash at BankSGD-1,008,281.340.581416USD-586,230.53J6c
MMK10013-Apr-03PFX - Realised Losses - CapitalSGD0.00USD13,959.25J6d

Note J6a :          The spot rate on 3-Apr is 0.581416. See Exchange Rates below. The rate is rounded to 6dp for display. Full precision is used in calculation.

Note J6d :          The realised loss on the loan is analyzed as follows:

SGDRate+
USD
At Closing Rate1,000,000.000.581416
581,415.63
At Start Date1,000,000.000.567456
567,456.38
Loss in exchange
-13,959.25

+ Rates used for calculation are in full precision. Illustrated rates are rounded to 6dp.

EXCHANGE RATES

Our illustration assumes the company uses different daily exchange rates for accounting.

The following rates were used for this illustration.

Spot Rate

DateUSD/SGDSGD/USD*
3-Feb-031.7622500.567456
28-Feb-031.7577200.568919
31-Mar-031.7318000.577434
3-Apr-031.7199400.581416

*Rates used for calculation are in full precision. Illustrated rates are rounded to 6dp.

FREQUENTLY ASKED QUESTIONS

RELATED INFORMATION

CHANGE HISTORY

DateByChanges
6-May-2020TSCreation.
6-May-2020LTRe-formatting.
Categories:

0 Comments

Leave a Reply

blank

Your email address will not be published. Required fields are marked *



    Close Bitnami banner
    Bitnami