Interco Funding

PURPOSE

To show illustration of intercompany funding journals.

OVERVIEW

TRANSACTION DETAILS

Accounting Base Ccy
Principal Acct Cntr
Interco
Currency
USD
TFS-SG
TGL-SG
SGD
Trade IDTransactionVDate
Amount
Capitalise Int.
ADV1001Lend to Subsidiary3-Feb-03
700,000.00
-
ADV1002Lend to Subsidiary19-Feb-03
600,000.00
-
ADV1003Redeem Principal24-Feb-03
800,000.00
-
ADV1004Redeem Principal12-Mar-03
100,000.00
-
ADV1005Capitalise Interest25-Mar-03
-
2,743.06
ADV1006Redeem Principal + Capitalise Interest10-Apr-10
600,000.00
596.40
ADV1007Borrow from Subsidiary17-Apr-10
50,000.00
-
ADV1008Borrow from Subsidiary21-Apr-10
170,000.00
217.82

INTERCOMPANY RATES

Dates
Base Rate (%)
Lend Margin
Borrow Margin
All in Borrow (%)
1-Feb-03
3.000000
0.200000
3.200000
0.800000
3.800000
1-Mar-03
3.100000
0.200000
3.300000
0.800000
3.900000
15-Mar-03
3.100000
0.250000
3.350000
0.850000
3.950000
1-Apr-03
3.200000
0.200000
3.400000
0.850000
4.050000
1-May-03
3.300000
0.200000
3.500000
0.850000
4.150000

SUMMARY OF JOURNALS

IDDateDescription
J13-Feb-03Lend to Subsidiary
J219-Feb-03Lend to Subsidiary
J324-Feb-03Redeem Principal from Subsidiary
J428-Feb-03Interco Funding Month End Interest Accruals
J51-Mar-03Reversal of Interco Funding Interest Accruals
J612-Mar-03Redeem Principal from Subsidiary
J725-Mar-03Interco Funding Interest Capitalisation
J831-Mar-03Interco Funding Month End Interest Accruals
J91-Apr-03Reversal of Interco Funding Interest Accruals
J1010-Apr-03Redeem Principal + Interest Capitalisation (Reduce amount of lending by principal. Over repaid by subs leading to principal borrow from subs.)
J1117-Apr-03Borrow from Subsidiary (Principal now in payable position with subs)
J1221-Apr-03Borrow from Subsidiary (Principal now in payable position with subs)

J1                    Lend to Subsidiary

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
ADV10013-Feb-03BInterco AdvanceSGD700,000.000.567456USD397,219.46J1a
ADV10013-Feb-03BCash at BankSGD-700,000.000.567456USD-397,219.46J1b

J2                    Lend to Subsidiary

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
ADV100219-Feb-03BInterco AdvanceSGD600,000.000.555973USD333,583.52J2a
ADV100219-Feb-03BCash at BankSGD-600,000.000.555973USD-333,583.52J2b

J3                    Redeem Principal from Subsidiary

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
ADV100324-Feb-03BCash at BankSGD800,000.000.561344USD449,074.91J3a
ADV100324-Feb-03BInterco AdvanceSGD-800,000.000.566021USD-452,816.71J3b
ADV100324-Feb-03PFX - Realised Losses Capital-AdvancesSGDUSD3,741.80J3c

Note J3b:            The computation of interco funding cost is analyzed as follows:

                                Based on FIFO

DateSGDRate +
USD
3-Feb-10700,000.000.567456
397,219.46
19-Feb-10100,000.000.555973
55,597.25
800,000.00
452,816.71

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

Note J3c:            The unrealised foreign exchange loss on the interco funding is analyzed as follows:

SGDRate +
USD
At Closing Rate800,000.000.561344
449,074.91
At Historical Rate800,000.000.566021
452,816.71
Loss in exchange
-3,741.80

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

J4                    Interco Funding Month End Interest Accruals

PostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
28-Feb-03BInterco Advance Interest ReceivableSGD
1,770.97
0.568919USD
1,007.54
J4a
28-Feb-03PInterco Advance Interest IncomeSGD
-1,770.97
0.571766USD
-1,012.58
J4b
28-Feb-03PFX-Unrealised Losses Revenue-AdvancesSGDUSD
5.04
J4c

Note J4a:            See Appendix on Calculation of Interest Accrual in SGD.

Note J4b:            See Appendix on Calculation of Interest Accrual in USD.

Note J4c:            The unrealised foreign exchange loss on interest income is analyzed as follows:

SGDRate +
USD
At Closing Rate1,770.970.568919
1,007.54
At Historical Rate1,770.970.571766
1,012.58
Loss in exchange
-5.04

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

J5                    Reversal of Interco Funding Interest Accruals

PostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
1-Mar-03BInterco Advance Interest ReceivableSGD
-1,770.97
0.568919USD
-1,007.54
J5a
1-Mar-03PInterco Advance Interest IncomeSGD
1,770.97
0.571766USD
1,012.58
J5b
1-Mar-03PFX-Unrealised Losses Revenue-AdvancesSGDUSD
-5.04
J5c

J6                    Redeem Principal from Subsidiary

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
ADV100412-Mar-03BCash at BankSGD100,000.000.565528USD56,552.77J6a
ADV100412-Mar-03BInterco AdvanceSGD-100,000.000.555973USD-55,597.25J6b
ADV100412-Mar-03PFX - Realised Gain Capital-AdvancesSGDUSD-955.52J6c

Note J6b:            The computation of interco funding cost is analyzed as follows:

                                 Based on FIFO

DateSGDRate +
USD
19-Feb-10100,000.000.555973
55,597.25
100,000.00
55,597.25

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

Note J6c:            The unrealised foreign exchange gain on the interco funding is analyzed as follows:

SGDRate +
USD
At Closing Rate100,000.000.565528
56,552.77
At Historical Rate100,000.000.555973
55,597.25
Gain in exchange
955.52

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

J7                    Interco Funding Interest Capitalisation

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
ADV100525-Mar-03BInterco AdvanceSGD2,743.860.571331USD1,567.65J7a
ADV100525-Mar-03PInterco Advance Interest IncomeSGD-2,743.860.571520USD-1,568.17J7b
ADV100525-Mar-03PFX-Unrealised Losses Revenue-AdvancesSGDUSD0.52J7c

Note J7b:            See Appendix on Interest Calculation in USD on 24-Mar-10.

Note J7c:            The unrealised foreign exchange loss on the interest income is analyzed as follows:

SGDRate +
USD
At Closing Rate2,743.860.571331
1,567.65
At Historical Rate2,743.860.571520
1,568.17
Loss in exchange
-0.52

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

J8                    Interco Funding Month End Interest Accruals

PostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
31-Mar-03BInterco Advance Interest ReceivableSGD
258.72
0.577434USD
149.39
J8a
31-Mar-03PInterco Advance Interest IncomeSGD
-258.72
0.575448USD
-148.88
J8b
31-Mar-03PFX-Unrealised Gain Revenue-AdvancesSGDUSD
-0.51
J8c

Note J8a:            See Appendix on Calculation of Interest Accrual in SGD.

Note J8b:            See Appendix on Calculation of Interest Accrual in USD.

Note J8c:            The unrealised foreign exchange gain on the interest income is analyzed as follows:

SGDRate +
USD
At Closing Rate258.720.577434
149.39
At Historical Rate258.720.575448
148.88
Gain in exchange
0.51

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

J9                    Reversal of Interco Funding Interest Accruals

PostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
1-Apr-03BInterco Advance Interest ReceivableSGD
-258.72
0.577434USD
-149.39
J9a
1-Apr-03PInterco Advance Interest IncomeSGD
258.72
0.575448USD
148.88
J9b
1-Apr-03PFX-Unrealised Gain Revenue-AdvancesSGDUSD
0.51
J9c

J10                 Redeem Principal + Interest Capitalisation (Reduce amount of lending by principal. Over repaid by subs leading to principal borrow from subs.)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
ADV100610-Apr-03BCash at BankSGD600,000.000.579774USD347,864.40J10a
ADV100610-Apr-03BInterco AdvanceSGD-600,000.000.563868USD-338,320.64J10b
ADV100610-Apr-03PFX - Realised Gain Capital-AdvancesSGDUSD-9,543.76J10c
ADV100610-Apr-03BInterco AdvanceSGD596.400.579774USD345.78J10d
ADV100610-Apr-03PInterco Advance Interest IncomeSGD-596.400.572351USD-341.35J10e
ADV100610-Apr-03PFX - Realised Gain Revenue-AdvancesSGDUSD-4.43J10f

Note J10b:         The computation of interco funding cost is analyzed as follows:

                                 Based on FIFO

DateSGDRate +
USD
19-Feb-10400,000.000.555973
222,389.01
25-Mar-032,743.860.571331
1,567.65
10-Apr-03596.400.579774
345.78
10-Apr-03196,659.740.579774
114,018.20
600,000.00
338,320.64

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

Note J10c:         The unrealised foreign exchange gain on the advances is analyzed as follows:

SGDRate +
USD
At Closing Rate600,000.000.579774
347,864.40
At Historical Rate600,000.000.563868
338,320.64
Gain in exchange
9,543.76

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

Note J10e:         See Appendix on Interest Calculation in USD on 9-Apr-10.

Note J10f:         The unrealised foreign exchange gain on the interest income is analyzed as follows:

SGDRate +
USD
At Closing Rate596.400.579774
345.78
At Historical Rate596.400.572351
341.35
Gain in exchange
4.43

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

J11                 Borrow from Subsidiary (Principal now in payable position with subs)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
ADV100717-Apr-03BInterco AdvanceSGD50,000.000.579774USD28,988.70J11a
ADV100717-Apr-03BCash at BankSGD-50,000.000.570112USD-28,505.62J11b
ADV100717-Apr-03PFX - Realised Gain Revenue-AdvancesSGDUSD-483.08J11c

Note J11a:         The computation of interco funding cost is analyzed as follows:

                                Based on FIFO

DateSGDRate +
USD
10-Apr-0350,000.000.579774
28,988.70
50,000.00
28,988.70

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

Note J11c:         The unrealised foreign exchange gain on the interest income is analyzed as follows:

SGDRate +
USD
At Historical Rate50,000.000.579774
28,988.70
At Closing Rate50,000.000.570112
28,505.62
Gain in exchange
483.08

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

J12                 Borrow from Subsidiary (Principal now in payable position with subs)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
ADV100821-Apr-03BInterco AdvanceSGD170,000.000.580038USD98,606.45J12a
ADV100821-Apr-03BCash at BankSGD-170,000.000.581696USD-98,888.38J12b
ADV100821-Apr-03PFX - Realised Losses Capital-AdvancesSGDUSD281.93J12c
ADV100821-Apr-03BInterco Advance Interest ExpensesSGD217.820.572537USD124.71J12d
ADV100821-Apr-03PInterco AdvanceSGD-217.820.581696USD-126.71J12e
ADV100821-Apr-03PFX - Realised Losses Revenue-AdvancesSGDUSD2.00J12f

Note J12a:         The computation of Interco funding cost is analyzed as follows:

                                Based on FIFO

DateSGDRate +
USD
10-Apr-03146,659.740.579774
85,029.50
21-Apr-03217.820.581696
126.71
21-Apr-0323,122.440.581696
13,450.24
170,000.00
98,606.45

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

Note J12c:         The unrealised foreign exchange loss on the interco funding is analyzed as follows:

SGDRate +
USD
At Historical Rate170,000.000.580038
98,606.45
At Closing Rate170,000.000.581696
98,888.38
Loss in exchange
-281.93

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

Note J12f:         The unrealised foreign exchange loss on the interest income is analyzed as follows:

SGDRate +
USD
At Historical Rate217.820.572537
124.71
At Closing Rate217.820.581696
126.71
Loss in exchange
-2.00

+ 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.

DateSGD/USDUSD/SGD*
1-Feb-031.7908600.558391
2-Feb-031.7498600.571474
3-Feb-031.7622500.567456
4-Feb-031.7070500.585806
5-Feb-031.7486100.571883
6-Feb-031.7842800.560450
7-Feb-031.7148400.583145
8-Feb-031.7096300.584922
9-Feb-031.7898600.558703
10-Feb-031.7228900.580420
11-Feb-031.7781400.562385
12-Feb-031.7794600.561968
13-Feb-031.7133400.583655
14-Feb-031.7491200.571716
15-Feb-031.7417500.574135
16-Feb-031.7535700.570265
17-Feb-031.7147500.583175
18-Feb-031.7620700.567514
19-Feb-031.7986500.555973
20-Feb-031.7171700.582354
21-Feb-031.7452600.572981
22-Feb-031.7287600.578449
23-Feb-031.7634300.567077
24-Feb-031.7814400.561344
25-Feb-031.7772700.562661
26-Feb-031.7246700.579821
27-Feb-031.7730400.564003
28-Feb-031.7577200.568919
1-Mar-031.7716900.564433
2-Mar-031.7456800.572843
3-Mar-031.7142900.583332
4-Mar-031.7307900.577771
5-Mar-031.7595000.568343
6-Mar-031.7836300.560654
7-Mar-031.7372100.575636
8-Mar-031.7006400.588014
9-Mar-031.7766300.562863
10-Mar-031.7418400.574106
11-Mar-031.7492000.571690
12-Mar-031.7682600.565528
13-Mar-031.7311000.577667
14-Mar-031.7444200.573256
15-Mar-031.7584100.568696
16-Mar-031.7503800.571305
17-Mar-031.7864000.559785
18-Mar-031.7178400.582126
19-Mar-031.7696300.565090
20-Mar-031.7825100.561007
21-Mar-031.7052600.586421
22-Mar-031.7935900.557541
23-Mar-031.7588300.568560
24-Mar-031.7698700.565013
25-Mar-031.7503000.571331
26-Mar-031.7585200.568660
27-Mar-031.7171700.582354
28-Mar-031.7381500.575324
29-Mar-031.7211100.581020
30-Mar-031.7476100.572210
31-Mar-031.7318000.577434
1-Apr-031.7895100.558812
2-Apr-031.7545700.569940
3-Apr-031.7199400.581416
4-Apr-031.7835500.560680
5-Apr-031.7544900.569966
6-Apr-031.7117900.584184
7-Apr-031.7469900.572413
8-Apr-031.7795200.561949
9-Apr-031.7533500.570337
10-Apr-031.7248100.579774
11-Apr-031.7542700.570038
12-Apr-031.7190500.581717
13-Apr-031.7926900.557821
14-Apr-031.7883800.559165
15-Apr-031.7161500.582700
16-Apr-031.7837600.560614
17-Apr-031.7540400.570112
18-Apr-031.7051700.586452
19-Apr-031.7023500.587423
20-Apr-031.7616000.567666
21-Apr-031.7191100.581696
22-Apr-031.7225300.580541
23-Apr-031.7015400.587703
24-Apr-031.7258500.579425
25-Apr-031.7110300.584443
26-Apr-031.7276700.578814
27-Apr-031.7247300.579801
28-Apr-031.7144000.583294
29-Apr-031.7530300.570441
30-Apr-031.7803700.561681
1-May-031.7226600.580498
2-May-031.7150600.583070
3-May-031.7507700.571177
4-May-031.7534100.570317
5-May-031.7540000.570125
6-May-031.7320000.577367
7-May-031.7994000.555741
8-May-031.7750600.563361
9-May-031.7058700.586211
10-May-031.7652600.566489
11-May-031.7946100.557224
12-May-031.7959700.556802
13-May-031.7406300.574505
14-May-031.7976500.556282
15-May-031.7001600.588180
16-May-031.7749600.563393
17-May-031.7447400.573151
18-May-031.7374000.575573
19-May-031.7868500.559644
20-May-031.7298400.578088
21-May-031.7447100.573161
22-May-031.7024900.587375
23-May-031.7840600.560519
24-May-031.7179800.582079
25-May-031.7908500.558394
26-May-031.7500000.571429
27-May-031.7680400.565598
28-May-031.7083100.585374
29-May-031.7395900.574848
30-May-031.7799600.561810
31-May-031.7543600.570008
1-Jun-031.7440100.573391

* round to 6 dp. Full precision used for calculation of average rates

APPENDIX

The movement of the intercompany advance activities and the accumulated interest is analyzed as follows:

Intercompany Funding Activities

                                                                                                        SGD                                                                                                     USD              

Date
Lend(+)/Repaid(-)
Cap Int
Balance
Rate (%)
Interest
Cumulation
Exc Rate
Interest
Cumulation
3-Feb-03
700,000.00
700,000.00
3.200000
61.37
61.37
0.567456
34.82
34.82
4-Feb-03
700,000.00
3.200000
61.37
122.74
0.585806
35.95
70.77
5-Feb-03
700,000.00
3.200000
61.37
184.11
0.571883
35.10
105.87
6-Feb-03
700,000.00
3.200000
61.37
245.48
0.560450
34.39
140.26
7-Feb-03
700,000.00
3.200000
61.37
306.85
0.583145
35.79
176.05
8-Feb-03
700,000.00
3.200000
61.37
368.22
0.584922
35.90
211.95
9-Feb-03
700,000.00
3.200000
61.37
429.59
0.558703
34.29
246.24
10-Feb-03
700,000.00
3.200000
61.37
490.96
0.580420
35.62
281.86
11-Feb-03
700,000.00
3.200000
61.37
552.33
0.562385
34.51
316.37
12-Feb-03
700,000.00
3.200000
61.37
613.70
0.561968
34.49
350.86
13-Feb-03
700,000.00
3.200000
61.37
675.07
0.583655
35.82
386.68
14-Feb-03
700,000.00
3.200000
61.37
736.44
0.571716
35.09
421.77
15-Feb-03
700,000.00
3.200000
61.37
797.81
0.574135
35.23
457.00
16-Feb-03
700,000.00
3.200000
61.37
859.18
0.570265
35.00
492.00
17-Feb-03
700,000.00
3.200000
61.37
920.55
0.583175
35.79
527.79
18-Feb-03
700,000.00
3.200000
61.37
981.92
0.567514
34.83
562.62
19-Feb-03
600,000.00
1,300,000.00
3.200000
113.97
1,095.89
0.555973
63.36
625.98
20-Feb-03
1,300,000.00
3.200000
113.97
1,209.86
0.582354
66.37
692.35
21-Feb-03
1,300,000.00
3.200000
113.97
1,323.83
0.572981
65.30
757.65
22-Feb-03
1,300,000.00
3.200000
113.97
1,437.80
0.578449
65.93
823.58
23-Feb-03
1,300,000.00
3.200000
113.97
1,551.77
0.567077
64.63
888.21
24-Feb-03
(800,000.00)
500,000.00
3.200000
43.84
1,595.61
0.561344
24.61
912.82
25-Feb-03
500,000.00
3.200000
43.84
1,639.45
0.562661
24.67
937.49
26-Feb-03
500,000.00
3.200000
43.84
1,683.29
0.579821
25.42
962.91
27-Feb-03
500,000.00
3.200000
43.84
1,727.13
0.564003
24.73
987.64
28-Feb-03
500,000.00
3.200000
43.84
1,770.97
0.568919
24.94
1,012.58
1-Mar-03
500,000.00
3.300000
45.21
1,816.18
0.564433
25.52
1,038.10
2-Mar-03
500,000.00
3.300000
45.21
1,861.39
0.572843
25.90
1,064.00
3-Mar-03
500,000.00
3.300000
45.21
1,906.60
0.583332
26.37
1,090.37
4-Mar-03
500,000.00
3.300000
45.21
1,951.81
0.577771
26.12
1,116.49
5-Mar-03
500,000.00
3.300000
45.21
1,997.02
0.568343
25.69
1,142.18
6-Mar-03
500,000.00
3.300000
45.21
2,042.23
0.560654
25.35
1,167.53
7-Mar-03
500,000.00
3.300000
45.21
2,087.44
0.575636
26.02
1,193.55
8-Mar-03
500,000.00
3.300000
45.21
2,132.65
0.588014
26.58
1,220.13
9-Mar-03
500,000.00
3.300000
45.21
2,177.86
0.562863
25.45
1,245.58
10-Mar-03
500,000.00
3.300000
45.21
2,223.07
0.574106
25.96
1,271.54
11-Mar-03
500,000.00
3.300000
45.21
2,268.28
0.571690
25.85
1,297.39
12-Mar-03
(100,000.00)
400,000.00
3.300000
36.16
2,304.44
0.565528
20.45
1,317.84
13-Mar-03
400,000.00
3.300000
36.16
2,340.60
0.577667
20.89
1,338.73
14-Mar-03
400,000.00
3.300000
36.16
2,376.76
0.573256
20.73
1,359.46
15-Mar-03
400,000.00
3.350000
36.71
2,413.47
0.568696
20.88
1,380.34
16-Mar-03
400,000.00
3.350000
36.71
2,450.18
0.571305
20.97
1,401.31
17-Mar-03
400,000.00
3.350000
36.71
2,486.89
0.559785
20.55
1,421.86
18-Mar-03
400,000.00
3.350000
36.71
2,523.60
0.582126
21.37
1,443.23
19-Mar-03
400,000.00
3.350000
36.71
2,560.31
0.565090
20.74
1,463.97
20-Mar-03
400,000.00
3.350000
36.71
2,597.02
0.561007
20.59
1,484.56
21-Mar-03
400,000.00
3.350000
36.71
2,633.73
0.586421
21.53
1,506.09
22-Mar-03
400,000.00
3.350000
36.71
2,670.44
0.557541
20.47
1,526.56
23-Mar-03
400,000.00
3.350000
36.71
2,707.15
0.568560
20.87
1,547.43
24-Mar-03
400,000.00
3.350000
36.71
2,743.86
0.565013
20.74
1,568.17
25-Mar-03
2,743.86
402,743.86
3.350000
36.96
36.96
0.571331
21.12
21.12
26-Mar-03
402,743.86
3.350000
36.96
73.92
0.568660
21.02
42.14
27-Mar-03
402,743.86
3.350000
36.96
110.88
0.582354
21.52
63.66
28-Mar-03
402,743.86
3.350000
36.96
147.84
0.575324
21.26
84.92
29-Mar-03
402,743.86
3.350000
36.96
184.80
0.581020
21.47
106.39
30-Mar-03
402,743.86
3.350000
36.96
221.76
0.572210
21.15
127.54
31-Mar-03
402,743.86
3.350000
36.96
258.72
0.577434
21.34
148.88
1-Apr-03
402,743.86
3.400000
37.52
296.24
0.558812
20.97
169.85
2-Apr-03
402,743.86
3.400000
37.52
333.76
0.569940
21.38
191.23
3-Apr-03
402,743.86
3.400000
37.52
371.28
0.581416
21.81
213.04
4-Apr-03
402,743.86
3.400000
37.52
408.80
0.560680
21.04
234.08
5-Apr-03
402,743.86
3.400000
37.52
446.32
0.569966
21.39
255.47
6-Apr-03
402,743.86
3.400000
37.52
483.84
0.584184
21.92
277.39
7-Apr-03
402,743.86
3.400000
37.52
521.36
0.572413
21.48
298.87
8-Apr-03
402,743.86
3.400000
37.52
558.88
0.561949
21.08
319.95
9-Apr-03
402,743.86
3.400000
37.52
596.40
0.570337
21.40
341.35
10-Apr-03
(600,000.00)
596.40
(196,659.74)
4.050000
(21.82)
(21.82)
0.579774
(12.65)
(12.65)
11-Apr-03
(196,659.74)
4.050000
(21.82)
(43.64)
0.570038
(12.44)
(25.09)
12-Apr-03
(196,659.74)
4.050000
(21.82)
(65.46)
0.581717
(12.69)
(37.78)
13-Apr-03
(196,659.74)
4.050000
(21.82)
(87.28)
0.557821
(12.17)
(49.95)
14-Apr-03
(196,659.74)
4.050000
(21.82)
(109.10)
0.559165
(12.20)
(62.15)
15-Apr-03
(196,659.74)
4.050000
(21.82)
(130.92)
0.582700
(12.71)
(74.86)
16-Apr-03
(196,659.74)
4.050000
(21.82)
(152.74)
0.560614
(12.23)
(87.09)
17-Apr-03
50,000.00
(146,659.74)
4.050000
(16.27)
(169.01)
0.570112
(9.28)
(96.37)
18-Apr-03
(146,659.74)
4.050000
(16.27)
(185.28)
0.586452
(9.54)
(105.91)
19-Apr-03
(146,659.74)
4.050000
(16.27)
(201.55)
0.587423
(9.56)
(115.47)
20-Apr-03
(146,659.74)
4.050000
(16.27)
(217.82)
0.567666
(9.24)
(124.71)
21-Apr-03
170,000.00
(217.82)
23,122.44
3.400000
2.15
2.15
0.581696
1.25
1.25
22-Apr-03
23,122.44
3.400000
2.15
4.30
0.580541
1.25
2.50
23-Apr-03
23,122.44
3.400000
2.15
6.45
0.587703
1.26
3.76
24-Apr-03
23,122.44
3.400000
2.15
8.60
0.579425
1.25
5.01
25-Apr-03
23,122.44
3.400000
2.15
10.75
0.584443
1.26
6.27
26-Apr-03
23,122.44
3.400000
2.15
12.90
0.578814
1.24
7.51
27-Apr-03
23,122.44
3.400000
2.15
15.05
0.579801
1.25
8.76
28-Apr-03
23,122.44
3.400000
2.15
17.20
0.583294
1.25
10.01
29-Apr-03
23,122.44
3.400000
2.15
19.35
0.570441
1.23
11.24
30-Apr-03
23,122.44
3.400000
2.15
21.50
0.561681
1.21
12.45

FREQUENTLY ASKED QUESTIONS

FAQ01. Why does the system continue to generate interest accruals even though the intercompany transaction has ceased?

The system will generate interest accruals if there is still outstanding principal or interest that has not been repaid or redeemed.

Please check to determine if there have been any rate changes under Basis Rate Maintenance (Prices > Interest Rate > Basis Rates) after the transaction has been booked. It’s important to note that any rate changes after the booking of interest capitalization or interest paid or redeemed transactions would affect interest computation.

For instance, consider a scenario where the final interest capitalization and principal repayment were recorded for value on 20 September 2017. The user inputted an interest amount of 3,530.29 for capitalization and repaid the total outstanding balance of 568,030.29 (outstanding principal + interest capitalization amount).

blank

Note that the outstanding interest payable balance is computed based on the interest rates maintained under Basis Rate Maintenance at the booking point, as illustrated below.

blank

Once booked, there should be no outstanding principal or interest amounts to repay, as indicated by Principal O/S and Interest O/S both showing as 0.00 in the Cumulative view.

blank

However, if there’s a rate change/update after the transaction’s booking, for instance, a rate update effective from 1 September 2017, this would affect interest computations for transactions booked thereafter due to the altered interest rate.

blank

If you examine the transaction for value on 20 September 2017, you may notice that the outstanding interest payable amount is no longer 3,530.29 but has changed to 3,602.22.

blank

The Interest O/S is no longer showing 0.00 in the Cumulative view.

blank

In such instances, it’s necessary to adjust the interest capitalization/ repayments or principal repayments accordingly to accommodate the rate adjustment.

Kindly ensure that the full principal and interest amounts are repaid or redeemed to eliminate any outstanding balances and to prevent the system from generating further interest accruals going forward.

RELATED INFORMATION

CHANGE HISTORY

DateByChanges
14-Oct-2008CSCreation.
14-Jun-2016RJReformatted.
6-Mar-2017TSUpdated.
11-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