Money Market Loan at Spot Rate - Alt

PURPOSE

To show illustration of money market loan at spot rate where there are two rates on month end date. This is identical to Money Market Loan at Spot Rate except for the use of Alternate Rate for month end revaluation of capital if this is provided.

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

28-Feb-03

3-Apr-03

SGD

1,000,000.00

5.1232%

Act/365

4,772.30

1,004,772.30

SUMMARY OF JOURNALS

ID	Date	Description
J1	28-Feb-03	Money Market Loan Start.
J2	28-Feb-03	Money Market Month End Accruals.
J3	1-Mar-03	Reversal Money Market Month End Accruals.
J4	31-Mar-03	Money Market Month End Accruals.
J5	1-Apr-03	Reversal Money Market Month End Accruals.
J6	3-Apr-03	Money Market Loan Maturity.

J1 Money Market Loan Start.

TradeID	PostDate	B/P	Account	Ccy	Ccy Amount	Exc Rate	Ccy	Base Amount	Line
MMK1001	28-Feb-03	B	Cash at Bank	SGD	1,000,000.00	0.568919	USD	568,918.83	J1a
MMK1001	28-Feb-03	B	MMK-Loan	SGD	-1,000,000.00	0.568919	USD	-568,918.83	J1b

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

J2 Money Market Month End Accruals.

TradeID	PostDate	B/P	Account	Ccy	Ccy Amount	Exc Rate	Ccy	Base Amount	Line
MMK1001	28-Feb-03	P	MMK- Loan Interest Expense	SGD	140.36	0.568919	USD	79.85	J2a
MMK1001	28-Feb-03	B	MMK- Loan Interest Payables	SGD	-140.36	0.568919	USD	-79.85	J2b
MMK1001	28-Feb-03	B	MMK - Loan	SGD	0.00		USD	3,227.98	J2c
MMK1001	28-Feb-03	P	FX - Unrealised Gains - Capital	SGD	0.00		USD	-3,227.98	J2d

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 date	28-Feb-03
Month End Date	28-Feb-03
Days (include 28-Feb)	1	=A

Start date	28-Feb-03
Maturity Date	3-Apr-03
Days (exclude 3-Apr)	34	=B

Total Interest	4,772.30	=C
Period Interest	140.36	=C*A/B

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

	SGD	Rate+	USD
At Closing Rate*	1,000,000.00	0.565691	565,690.85
At Start Date	1,000,000.00	0.568919	568,918.83
	Gain in exchange		3,227.98

* In order for system to revalue the loan using Alternate Rate on the month end date, both SGD and USD month end rates must be maintained on the month end date. See Exchange Rates below. If no Alternate Rate available for both currencies on the month end date, system will revalue the loan using the accounting rate maintained for the month end date or last available rate.

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

J3 Reversal Money Market Month End Accruals.

TradeID	PostDate	B/P	Account	Ccy	Ccy Amount	Exc Rate	Ccy	Base Amount	Line
MMK1001	1-Mar-03	P	MMK - Loan Interest Expense	SGD	-140.36	0.568919	USD	-79.85	J3a
MMK1001	1-Mar-03	B	MMK - Loan Interest Payables	SGD	140.36	0.568919	USD	79.85	J3b
MMK1001	1-Mar-03	B	MMK - Loan	SGD	0.00		USD	-3,227.98	J3c
MMK1001	1-Mar-03	P	FX - Unrealised Gains-Capital	SGD	0.00		USD	3,227.98	J3d

J4 Money Market Month End Accruals.

TradeID	PostDate	B/P	Account	Ccy	Ccy Amount	Exc Rate	Ccy	Base Amount	Line
MMK1001	31-Mar-03	P	MMK - Loan Interest Expense	SGD	4,491.58	0.577434	USD	2,593.59	J4a
MMK1001	31-Mar-03	B	MMK - Loan Interest Payables	SGD	-4,491.58	0.577434	USD	-2,593.59	J4b
MMK1001	31-Mar-03	B	MMK - Loan	SGD	0.00		USD	-4,837.56	J4c
MMK1001	31-Mar-03	P	FX - Unrealised Losses-Capital	SGD	0.00		USD	4,837.56	J4d

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 date	28-Feb-03
Month End Date	31-Mar-03
Days (include 31-Mar)	32	=A

Start date	28-Feb-03
Maturity Date	3-Apr-03
Days (exclude 3-Apr)	34	=B

Total Interest	4,772.30	=C
Period Interest	4,491.58	=C*A/B

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

	SGD	Rate+	USD
At Closing Rate*	1,000,000.00	0.573756	573,756.38
At Start Date	1,000,000.00	0.568919	568,918.83
	Loss in exchange		-4,837.56

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

J5 Reversal Money Market Month End Accruals

TradeID	PostDate	B/P	Account	Ccy	Ccy Amount	Exc Rate	Ccy	Base Amount	Line
MMK1001	1-Apr-03	P	MMK - Loan Interest Expense	SGD	-4,491.58	0.577434	USD	-2,593.59	J5a
MMK1001	1-Apr-03	B	MMK - Loan Interest Payables	SGD	4,491.58	0.577434	USD	2,593.59	J5b
MMK1001	1-Apr-03	B	MMK - Loan	SGD	0.00		USD	4,837.56	J5c
MMK1001	1-Apr-03	P	FX - Unrealised Losses - Capital	SGD	0.00		USD	-4,837.56	J5d

J6 Money Market Loan Maturity.

TradeID	PostDate	B/P	Account	Ccy	Ccy Amount	Exc Rate	Ccy	Base Amount	Line
MMK1001	3-Apr-03	P	MMK - Loan Interest Expense	SGD	4,772.30	0.581416	USD	2,774.69	J6a
MMK1001	3-Apr-03	B	MMK - Loan	SGD	1,000,000.00	0.568919	USD	568,918.83	J6b
MMK1001	3-Apr-03	B	Cash at Bank	SGD	-1,004,772.30	0.581416	USD	-584,190.32	J6c
MMK1001	3-Apr-03	P	FX - Realised Losses - Capital	SGD	0.00		USD	12,496.80	J6d

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:

	SGD	Rate+	USD
At Closing Rate	1,000,000.00	0.581416	581,415.63
At Start Date	1,000,000.00	0.568919	568,918.83
	Loss in exchange		-12,496.80

+ 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

Accounting Rate

Date	USD/SGD	SGD/USD*
28-Feb-03	1.757720	0.568919
31-Mar-03	1.731800	0.577434
3-Apr-03	1.719940	0.581416

Alternate Rate

Date	USD/SGD	SGD/USD*
28-Feb-03	1.767750	0.565691
31-Mar-03	1.742900	0.573756

Date	SGD/SGD
28-Feb-03	1.000000
31-Mar-03	1.000000

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

FREQUENTLY ASKED QUESTIONS

RELATED INFORMATION

CHANGE HISTORY

Date	By	Changes
12-May-2020	TS	Creation.
12-May-2020	LT	Re-formatting.

Money Market Loan at Spot Rate – Alt

Published by user on May 12, 2020May 12, 2020