Term Loan with Interest Capitalisation

PURPOSE

To show illustration of term loan with interest capitalisation.

OVERVIEW

TRANSACTION DETAILS

Accounting Base Ccy
Trade ID
Transaction
Trade Date
Initial Draw Date
Maturity Date
Currency
Amount
Frequency
Accrual Method
SGD
TML1001
Borrow
28-Sep-11
28-Sep-11
1-Mar-12
USD
270,000,000.00
Monthly
Act/360

Repayment Schedule

From DateTo DateActivityRatePrincipalInt CapitalisedInterestOutstanding
28-Sep-1128-Sep-11Drawdown
5.638890%
270,000,000.00
0.000.00
270,000,000.00
28-Sep-111-Oct-11Capitalise Int
5.638890%
0.00
126,875.030.00
270,126,875.03
1-Oct-111-Nov-11Capitalise Int
5.640000%
0.00
1,311,916.190.00
271,438,791.22
1-Nov-111-Dec-11Capitalise Int
5.645280%
0.00
1,276,956,650.00
272,715,747.87
1-Dec-111-Jan-12Repay P + I
5.671440%
-2,715,747.87
0.001,331,872.81
270,000,000.00
1-Jan-121-Feb-12Repay P + Capitalise Int.
5.695300%
-3,324,157.25
1,324,157.250.00
268,000,000.00
1-Feb-1220-Feb-12Additional drawdown
5.695300%
10,000,000.00
0.00805,568.54
278,000,000.00
20-Feb-121-Mar-12Final Repay
5.695300%
-278,000,000.00
0.00439,803.72
0.00

SUMMARY OF JOURNALS

IDDateDescription
J128-Sep-11Settlement of Term Loan
J230-Sep-11Month End Term Loan Accruals.
J31-Oct-11Reversal Month End Term Loan Accruals.
J41-Oct-11Interest Capitalisation
J531-Oct-11Month End Term Loan Accruals.
J61-Nov-11Reversal Month End Term Loan Accruals.
J71-Nov-11Interest Capitalisation
J830-Nov-11Month End Term Loan Accruals.
J91-Dec-11Reversal Month End Term Loan Accruals.
J101-Dec-11Interest Capitalisation
J1131-Dec-11Month End Term Loan Accruals.
J121-Jan-12Reversal Month End Term Loan Accruals.
J131-Jan-12Principal and Interest Settlement of Term Loan
J1431-Jan-12Month End Term Loan Accruals.
J151-Feb-12Reversal Month End Term Loan Accruals.
J161-Feb-12Principal Settlement and Interest Capitalisation on Term Loan
J1720-Feb-12Additional drawdown and Interest Settlement on Term Loan
J1829-Feb-12Month End Term Loan Accruals.
J191-Mar-12Reversal Month End Term Loan Accruals.
J201-Mar-12Final Principal + Interest Settlement on Term Loan

J1                  Settlement of Term Loan

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/00128-Sep-11BCash at BankUSD270,000,000.001.234300SGD333,261,000.00J1a
TML1001/00128-Sep-11BTML -BorrowingUSD-270,000,000.001.234300SGD-333,261,000.00J1b

Note J1a:           The exchange rate on 28-Sep-2011 is 1.2343. See Exchange Rates below.

J2                  Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100130-Sep-11PTML - Borrowing - Interest ExpenseUSD126,875.031.234300SGD156,601.85J2a
TML100130-Sep-11BTML - Borrowing - Interest PayableUSD-126,875.031.234300SGD-156,601.85J2b
TML100130-Sep-11PFX - Unrealised Gains - RevenueUSD0.000.000000SGD0.00J2c
TML100130-Sep-11BTML - BorrowingUSD0.000.000000SGD0.00J2d
TML100130-Sep-11PFX - Unrealised Losses - CapitalUSD0.000.000000SGD0.00J2e

Note J2a:           The average multiplier rate between 28-Sep and 30-Sep is 1.2343. See Exchange Rates below.

Note J2b:           Calculation of Accrual in USD

Outstanding Principal270,000,000.00A
Interest Rate5.63889%B
Start Date28-Sep-11
Month End Date30-Sep-11
Days (include 30-Sep)3C
Accrual MethodAct/360D
Period Interest126,875.03E = A * B * C / D

Note J2c:           The unrealised foreign exchange gain/loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate126,875.031.234300
156,601.85
At Average Rate126,875.031.234300
156,601.85
Gain/Loss in exchange
0.00

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

Note J2e:           The unrealised gain/loss on the revaluation of the loan is analyzed as follows:

USDRate+
SGD
At Closing Date270,000,000.001.234300
333,261,000.00
At Start Date270,000,000.001.234300
333,261,000.00
Gain/Loss in exchange
0.00

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

J3                  Reversal Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML10011-Oct-11PTML - Borrowing - Interest ExpenseUSD-126,875.031.234300SGD-156,601.85J3a
TML10011-Oct-11BTML - Borrowing - Interest PayableUSD126,875.031.234300SGD156,601.85J3b
TML10011-Oct-11PFX - Unrealised Gains - RevenueUSD0.000.000000SGD0.00J3c
TML10011-Oct-11BTML - BorrowingUSD0.000.000000SGD0.00J3d
TML10011-Oct-11PFX - Unrealised Losses - CapitalUSD0.000.000000SGD0.00J3e

J4                  Interest Capitalisation

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0021-Oct-11BTML - BorrowingUSD-126,875.031.234300SGD-156,601.85J4a
TML1001/0021-Oct-11PTML - Borrowing - Interest ExpenseUSD126,875.031.234300SGD156,601.85J4b
TML1001/0021-Oct-11PFX - Realised Losses - RevenueUSD0.000.000000SGD0.00J4c

Note J4a:          The average multiplier rate between 28-Sep and 1-Oct is 1.2343. See Exchange Rates below.

Note J4c:          The realised foreign exchange gain/loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate126,875.031.234300
156,601.85
At Average Rate126,875.031.234300
156,601.85
Gain/Loss in exchange
0.00

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

J5                  Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100131-Oct-11PTML - Borrowing - Interest ExpenseUSD1,311,916.191.295335SGD1,699,371.59J5a
TML100131-Oct-11BTML - Borrowing - Interest PayableUSD-1,311,916.191.345600SGD-1,765,314.43J5b
TML100131-Oct-11PFX - Unrealised Losses - RevenueUSD0.000.000000SGD65,942.84J5c
TML100131-Oct-11BTML - BorrowingUSD0.000.000000SGD-30,065,121.19J5d
TML100131-Oct-11PFX - Unrealised Losses - CapitalUSD0.000.000000SGD30,065,121.19J5e

Note J5a:           The average multiplier rate between 1-Oct and 31-Oct is 1.295335. See Exchange Rates below.

Note J5b:           Calculation of Accrual in USD

                              Period Interest from 1-Oct to 31-Oct

Outstanding Principal270,126,875.03A
Interest Rate5.640000%B
Start Date1-Oct-11
To Date (Month End)31-Oct-11
Days (include 31-Oct)31C
Accrual MethodAct/360D
Period Interest1,311,916.19E = A * B * C / D

Note J5c:           The unrealised foreign exchange loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate1,311,916.191.345600
1,765,314.43
At Average Rate1,311,916.191.295335
1,699,371.59
Loss in exchange
-65,942.84

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

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

USDRate+
SGD
At Closing Rate270,126,875.031.345600
363,482,723.04
At Start Date126,875.031.234300
156,601.85
At Start Date270,000,000.001.234300
333,261,000.00
Loss in exchange
-30,065,121.19

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

J6                  Reversal Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML10011-Nov-11PTML - Borrowing - Interest ExpenseUSD-1,311,916.191.295335SGD-1,699,371.59J6a
TML10011-Nov-11BTML - Borrowing - Interest PayableUSD1,311,916.191.345600SGD1,765,314.43J6b
TML10011-Nov-11PFX - Unrealised Losses - RevenueUSD0.000.000000SGD-65,942.84J6c
TML10011-Nov-11BTML - BorrowingUSD0.000.000000SGD30,065,121.19J6d
TML10011-Nov-11PFX - Unrealised Losses - CapitalUSD0.000.000000SGD-30,065,121.19J6e

J7                  Interest Capitalisation

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0031-Nov-11BTML - BorrowingUSD-1,311,916.191.345600SGD-1,765,314.43J7a
TML1001/0031-Nov-11PTML - Borrowing - Interest ExpenseUSD1,311,916.191.295335SGD1,699,371.59J7b
TML1001/0031-Nov-11PFX - Realised Losses - RevenueUSD0.000.000000SGD65,942.84J7c

Note J7b:          The average multiplier rate between 1-Oct and 1-Nov is 1.295335. See Exchange Rates below.

Note J7c:          The realised foreign exchange loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate1,311,916.191.345600
1,765,314.43
At Average Rate1,311,916.191.295335
1,699,371.59
Loss in exchange
-65,942.84

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

J8                  Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100130-Nov-11PTML - Borrowing - Interest ExpenseUSD1,276,956.651.227109SGD1,566,965.42J8a
TML100130-Nov-11BTML - Borrowing - Interest PayableUSD-1,276,956.651.123430SGD-1,434,571.41J8b
TML100130-Nov-11PFX - Unrealised Gains - RevenueUSD0.000.000000SGD-132,394.01J8c
TML100130-Nov-11BTML - BorrowingUSD0.000.000000SGD30,240,435.06J8d
TML100130-Nov-11PFX - Unrealised Gains - CapitalUSD0.000.000000SGD-30,240,435.06J8e

Note J8a:           The average multiplier rate between 1-Nov and 30-Nov is 1.227109. See Exchange Rates below.

Note J8b:           Calculation of Accrual in USD

                              Period Interest from 1-Nov to 30-Nov

Outstanding Principal271,438,791.22A
Interest Rate5.64528%B
Start Date1-Nov-11
To Date (Month End)30-Nov-11
Days (include 31-Nov)30C
Accrual MethodAct/360D
Period Interest1,276,956.65E = A * B * C / D

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

USDRate+
SGD
At Closing Rate1,276,956.651.123430
1,434,571.41
At Average Rate1,276,956.651.227109
1,566,965.42
Gain in exchange
132,394.01

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

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

USDRate+
SGD
At Closing Rate271,438,791.221.123430
304,942,481.22
At Start Date1,311,916.191.345600
1,765,314.43
At Start Date126,875.031.234300
156,601.85
At Start Date270,000,000.001.234300
333,261,000.00
Gain in exchange
30,240,435.06

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

J9                  Reversal Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML10011-Dec-11PTML - Borrowing - Interest ExpenseUSD-1,276,956.651.227109SGD-1,566,965.42J9a
TML10011-Dec-11BTML - Borrowing - Interest PayableUSD1,276,956.651.123430SGD1,434,571.41J9b
TML10011-Dec-11PFX - Unrealised Gains - RevenueUSD0.000.000000SGD132,394.01J9c
TML10011-Dec-11BTML - BorrowingUSD0.000.000000SGD-30,240,435.06J9d
TML10011-Dec-11PFX - Unrealised Gains - CapitalUSD0.000.000000SGD30,240,435.06J9e

J10                 Interest Capitalisation

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0041-Dec-11BTML - BorrowingUSD-1,276,956.651.123430SGD-1,434,571.41J10a
TML1001/0041-Dec-11PTML - Borrowing - Interest ExpenseUSD1,276,956.651.227109SGD1,566,965.42J10b
TML1001/0041-Dec-11PFX - Realised Gains - RevenueUSD0.000.000000SGD-132,394.01J10c

Note J10b:         The average multiplier rate between 1-Nov and 1-Dec is 1.227109. See Exchange Rates below.

Note J10c:         The realised foreign exchange gain on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate1,276,956.651.123430
1,434,571.41
At Average Rate1,276,956.651.227109
1,566,965.42
Gain in exchange
132,394.01

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

J11                 Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100131-Dec-11PTML - Borrowing - Interest ExpenseUSD1,331,872.811.184186SGD1,577,184.88J11a
TML100131-Dec-11BTML - Borrowing - Interest PayableUSD-1,331,872.811.234220SGD-1,643,824.06J11b
TML100131-Dec-11PFX - Unrealised Losses - RevenueUSD0.000.000000SGD66,639.18J11c
TML100131-Dec-11BTML - BorrowingUSD0.000.000000SGD26,257.35J11d
TML100131-Dec-11PFX - Unrealised Gains - CapitalUSD0.000.000000SGD-26,257.35J11e

Note J11a:          The average multiplier rate between 1-Dec and 31-Dec is 1.184186. See Exchange Rates below.

Note J11b:         Calculation of Accrual in USD

                              Period Interest from 1-Dec to 31-Dec

Outstanding Principal272,715,747.87A
Interest Rate5.67144%B
Start Date1-Dec-11
To Date (Month End)31-Dec-11
Days (include 31-Dec)31C
Accrual MethodAct/360D
Period Interest1,331,872.81E = A * B * C / D

Note J11c:         The unrealised foreign exchange loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate1,331,872.811.234220
1,643,824.06
At Average Rate1,331,872.811.184186
1,577,184.88
Loss in exchange
-66,639.18

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

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

USDRate+
SGD
At Closing Rate272,715,747.871.234220
336,591,230.34
At Start Date1,276,956.651.123430
1,434,571.41
At Start Date1,311,916.191.345600
1,765,314.43
At Start Date126,875.031.234300
156,601.85
At Start Date270,000,000.001.234300
333,261,000.00
Gain in exchange
26,257.35

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

J12                 Reversal Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML10011-Jan-12PTML - Borrowing - Interest ExpenseUSD-1,331,872.811.184186SGD-1,577,184.88J12a
TML10011-Jan-12BTML - Borrowing - Interest PayableUSD1,331,872.811.234220SGD1,643,824.06J12b
TML10011-Jan-12PFX - Unrealised Losses - RevenueUSD0.000.000000SGD-66,639.18J12c
TML10011-Jan-12BTML - BorrowingUSD0.000.000000SGD-26,257.35J12d
TML10011-Jan-12PFX - Unrealised Gains - CapitalUSD0.000.000000SGD26,257.35J12e

J13                 Principal and Interest Settlement of Term Loan

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0051-Jan-12BTML - BorrowingUSD2,715,747.871.235935SGD3,356,487.69J13a
TML1001/0051-Jan-12PTML - Borrowing - Interest ExpenseUSD1,331,872.811.184186SGD1,577,184.88J13b
TML1001/0051-Jan-12BCash at BankUSD-4,047,620.681.234220SGD-4,995,654.40J13c
TML1001/0051-Jan-12PFX - Realised Gain - CapitalUSD0.000.000000SGD-4,657.35J13d
TML1001/0051-Jan-12PFX - Realised Losses - RevenueUSD0.000.000000SGD66,639.18J13e

Note J13b:         The average multiplier rate between 1-Dec and 1-Jan is 1.184186. See Exchange Rates below.

Note J13d:         The realised gain on the revaluation of the loan is analyzed as follows:

USDRate+
SGD
At Closing Rate2,715,747.871.234220
3,351,830.34
At Start Date1,276,956.651.123430
1,434,571.41
At Start Date1,311,916.191.345600
1,765,314.43
At Start Date126,875.031.234300
156,601.85
Gain in exchange
4,657.35

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

Note J13e:         The realised foreign exchange loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate1,331,872.811.234220
1,643,824.06
At Average Rate1,331,872.811.184186
1,577,184.88
Loss in exchange
-66,639.18

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

J14                 Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100131-Jan-12PTML - Borrowing - Interest ExpenseUSD1,324,157.251.204541SGD1,595,002.08J14a
TML100131-Jan-12BTML - Borrowing - Interest PayableUSD-1,324,157.251.192400SGD-1,578,925.10J14b
TML100131-Jan-12PFX - Unrealised Gains - RevenueUSD0.000.000000SGD-16,076.98J14c
TML100131-Jan-12BTML - BorrowingUSD0.000.000000SGD11,313,000.00J14d
TML100131-Jan-12PFX - Unrealised Gains - CapitalUSD0.000.000000SGD-11,313,000.00J14e

Note J14a:          The average multiplier rate between 1-Jan and 31-Jan is 1.204541. See Exchange Rates below.

Note J14b:         Calculation of Accrual in USD

                              Period Interest from 1-Jan to 31-Jan

Outstanding Principal270,000,000.00A
Interest Rate5.69530%B
Start Date1-Jan-12
To Date (Month End)31-Jan-12
Days (include 31-Jan)31C
Accrual MethodAct/360D
Period Interest1,324,157.25E = A * B * C / D

Note J14c:         The unrealised foreign exchange gain on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate1,324,157.251.192400
1,578,925.10
At Average Rate1,324,157.251.204541
1,595,002.08
Gain in exchange
16,076.98

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

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

USDRate+
SGD
At Closing Rate270,000,000.001.192400
321,948,000.00
At Start Date270,000,000.001.234300
333,261,000.00
Gain in exchange
11,313,000.00

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

J15                 Reversal Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML10011-Feb-12PTML - Borrowing - Interest ExpenseUSD-1,324,157.251.204541SGD-1,595,002.08J15a
TML10011-Feb-12BTML - Borrowing - Interest PayableUSD1,324,157.251.192400SGD1,578,925.10J15b
TML10011-Feb-12PFX - Unrealised Gains - RevenueUSD0.000.000000SGD16,076.98J15c
TML10011-Feb-12BTML - BorrowingUSD0.000.000000SGD-11,313,000.00J15d
TML10011-Feb-12PFX - Unrealised Gains - CapitalUSD0.000.000000SGD11,313,000.00J15e

J16                 Principal Settlement and Interest Capitalisation on Term Loan

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0061-Feb-12BTML - BorrowingUSD-1,324,157.251.192400SGD-1,578,925.10J16a
TML1001/0061-Feb-12PTML - Borrowing - Interest ExpenseUSD1,324,157.251.204541SGD1,595,002.08J16b
TML1001/0061-Feb-12PFX - Realised Gains - RevenueUSD0.000.000000SGD-16,076.98J16c
TML1001/0061-Feb-12PFX - Realised Gains - CapitalUSD0.000.000000SGD-83,800.00J16d
TML1001/0061-Feb-12BTML -BorrowingUSD3,324,157.251.217609SGD4,047,525.10J16e
TML1001/0061-Feb-12BCash at BankUSD-3,324,157.251.192400SGD-3,963,725.10J16f

Note J16b:         The average multiplier rate between 1-Jan and 1-Feb is 1.204541. See Exchange Rates below.

Note J16c:         The realised foreign exchange gain on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate1,324,157.251.192400
1,578,925.10
At Average Rate1,324,157.251.204541
1,595,002.08
Gain in exchange
16,076.98

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

Note J16d:         The realised gain on the revaluation of the loan is analyzed as follows:

USDRate+
SGD
At Closing Rate3,324,157.251.192400
3,963,725.10
At Start Date1,324,157.251.192400
1,578,925.10
At Start Date2,000,000.001.234300
2,468,600.00
Gain in exchange
83,800.00

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

J17                 Additional drawdown and Interest Settlement on Term Loan

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/00720-Feb-12BCash at BankUSD9,194,431.461.432300SGD13,169,184.18J17a
TML1001/00720-Feb-12BTML - BorrowingUSD-10,000,000.001.432300SGD-14,323,000.00J17b
TML1001/00720-Feb-12PTML - Borrowing -Interest ExpenseUSD805,568.541.230279SGD991,074.02J17c
TML1001/00720-Feb-12PFX - Realised Losses - RevenueUSD0.000.000000SGD162,741.80J17d

Note J17a:         The exchange rate on 20-Feb is 1.4323. See Exchange Rates below.

Note J17c:         The average multiplier rate between 1-Feb and 20-Feb is 1.230279. See Exchange Rates below.

Note J17d:         The realised foreign exchange loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate805,568.541.432300
1,153,815.82
At Average Rate805,568.541.230279
991,074.02
Loss in exchange
-162,741.80

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

J18                 Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100129-Feb-12PTML - Borrowing - Interest ExpenseUSD439,803.721.434340SGD630,828.07J18a
TML100129-Feb-12BTML - Borrowing - Interest PayableUSD-439,803.721.452700SGD-638,902.86J18b
TML100129-Feb-12PFX - Unrealised Losses - RevenueUSD0.000.000000SGD8,074.79J18c
TML100129-Feb-12BTML - BorrowingUSD0.000.000000SGD-58,735,200.00J18d
TML100129-Feb-12PFX - Unrealised Losses - CapitalUSD0.000.000000SGD58,735,200.00J18e

Note J18a:          The average multiplier rate between 20-Feb and 29-Feb is 1.43434. See Exchange Rates below.

Note J18b:         Calculation of Accrual in USD

                              Period Interest from 20-Feb to 29-Feb

Outstanding Principal278,000,000.00A
Interest Rate5.69530%B
Start Date20-Feb-12
To Date (Month End)29-Feb-12
Days (include 29-Feb)10C
Accrual MethodAct/360D
Period Interest439,803.72E = A * B * C / D

Note J18c:         The unrealised foreign exchange loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate439,803.721.452700
638,902.86
At Average Rate439,803.721.434340
630,828,07
Loss in exchange
-8,074.79

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

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

USDRate+
SGD
At Closing Rate278,000,000.001.452700
403,850,600.00
At Start Date10,000,000.001.432300
14,323,000.00
At Start Date268,000,000.001.234300
330,792,400.00
Loss in exchange
-58,735,200.00

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

J19                 Reversal Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML10011-Mar-12PTML - Borrowing - Interest ExpenseUSD-439,803.721.434340SGD-630,828.07J19a
TML10011-Mar-12BTML - Borrowing - Interest PayableUSD439,803.721.452700SGD638,902.86J19b
TML10011-Mar-12PFX - Unrealised Losses - RevenueUSD0.000.000000SGD-8,074.79J19c
TML10011-Mar-12BTML - BorrowingUSD0.000.000000SGD58,735,200.00J19d
TML10011-Mar-12PFX - Unrealised Losses - CapitalUSD0.000.000000SGD-58,735,200.00J19e

J20                 Final Principal + Interest Settlement on Term Loan

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0081-Mar-12BTML - BorrowingUSD278,000,000.001.241422SGD345,115,400.00J20a
TML1001/0081-Mar-12PTML - Borrowing - Interest ExpenseUSD439,803.721.434340SGD630,828.07J20b
TML1001/0081-Mar-12BCash at BankUSD-278,439,803.721.452700SGD-404,489,502.86J20c
TML1001/0081-Mar-12PFX - Realised Losses - CapitalUSD0.000.000000SGD58,735,200.00J20d
TML1001/0081-Mar-12PFX - Realised Losses - RevenueUSD0.000.000000SGD8,074.79J20e

Note J20b:         The average multiplier rate between 20-Feb and 1-Mar is 1.43434. See Exchange Rates below.

Note J20d:         The realised loss on the revaluation of the loan is analyzed as follows:

USDRate+
SGD
At Closing Rate278,000,000.001.452700
403,850,600.00
At Start Date10,000,000.001.432300
14,323,000.00
At Start Date268,000,000.001.234300
330,792,400.00
Loss in exchange
-58,735,200.00

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

Note J20e:         The realised foreign exchange loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate439,803.721.452700
638,902.86
At Average Rate439,803.721.434340
630,828.07
Loss in exchange
-8,074.79

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

Average rates are computed by using the multiplier rate from trade/transaction currency to the base currency each day and averaging this over the relevant period.

The following rates were used for this illustration.

Spot Rate

DateUSD/SGD
28-Sep-111.234300
30-Sep-111.234300
1-Oct-111.234300
31-Oct-111.345600
1-Nov-111.345600
30-Nov-111.123430
1-Dec-111.123430
31-Dec-111.234220
1-Jan-121.234220
31-Jan-121.192400
1-Feb-121.192400
20-Feb-121.432300
29-Feb-121.452700
1-Mar-121.452700

Average

From DateTo DateUSD/SGD
28-Sep-1130-Sep-111.234300
28-Sep-111-Oct-111.234300
30-Sep-1131-Oct-111.295335
1-Nov-1130-Nov-111.227109
1-Dec-1131-Dec-111.184186
1-Jan-1231-Jan-121.204541
1-Feb-1219-Feb-121.230279
20-Feb-1229-Feb-121.434340

APPENDIX

IDDateDescription
J211-Jan-12Interest Settlement on Term Loan (Alternative to J13)
J221-Jan-12Principal Settlement on Term Loan (Alternative to J3)

J21                 Interest Settlement on Term Loan (Alternative to J13)

Note J21:           Alternatively 1 – Repay Interest only (if only interest is paid, just FX Realised Revenue)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0051-Jan-12BTML - BorrowingUSD0.000.000000SGD0.00J21a
TML1001/0051-Jan-12PTML - Borrowing - Interest ExpenseUSD1,331,872.811.184186SGD1,577,184.88J21b
TML1001/0051-Jan-12BCash at BankUSD-1,331,872.811.234220SGD-1,643,824.06J21c
TML1001/0051-Jan-12PFX - Realised Gains - CapitalUSD0.000.000000SGD0.00J21d
TML1001/0051-Jan-12PFX - Realised Losses - RevenueUSD0.000.000000SGD66,639.18J21e

Note J21b:        The average multiplier rate between 1-Dec and 1-Jan is 1.184186 See Exchange Rates below.

Note J21e:         The realised foreign exchange loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate1,331,872.811.234220
1,643,824.06
At Average Rate1,331,872.811.184186
1,577,184.88
Loss in exchange
-66,639.18

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

J22                 Principal Settlement on Term Loan (Alternative to J3)

Note J22:            Alternatively 2 – Repay Principal only (if only principal is paid, just FX Realised Capital)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0051-Jan-12BTML - BorrowingUSD2,715,747.871.235935SGD3,356,487.69J22a
TML1001/0051-Jan-12PTML - Borrowing - Interest ExpenseUSD0.001.184186SGD0.00J22b
TML1001/0051-Jan-12BCash at BankUSD-2,715,747.871.234220SGD-3,351,830.34J22c
TML1001/0051-Jan-12PFX - Realised Gains - CapitalUSD0.000.000000SGD-4,657.35J22d
TML1001/0051-Jan-12PFX - Realised Losses - RevenueUSD0.000.000000SGD0.00J22e

Note J22d:         The realised gain on the revaluation of the loan is analyzed as follows:

USDRate+
SGD
At Closing Rate2,715,747.871.234220
3,351,830.34
At Start Date1,276,956.651.123430
1,434,571.41
At Start Date1,311,916.191.345600
1,765,314.43
At Start Date126,875.031.234300
156,601.85
Gain in exchange
4,657.35

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

In the event there is a change in the outstanding principal, the system will pro-rate the next interest payment amount (1,246,000) between the different period. Below is the calculation how the prorating is done. Essentially the weight is based on outstanding principal, interest rate and the number of days in the period. See J23, J24 and J25 for example.

Repayment Schedule

From DateTo DateActivityRatePrincipalInt CapitalisedInterestOutstanding
28-Sep-1128-Sep-11Drawdown
5.638890%
270,000,000.00
0.000.00
270,000,000.00
28-Sep-111-Oct-11Capitalise Int
5.638890%
0.00
126,875.030.00
270,126,875.03
1-Oct-111-Nov-11Capitalise Int
5.640000%
0.00
1,311,916.190.00
271,438,791.22
1-Nov-111-Dec-11Capitalise Int
5.645280%
0.00
1,276,956,650.00
272,715,747.87
1-Dec-111-Jan-12Repay P + I
5.671440%
-2,715,747.87
0.001,331,872.81
270,000,000.00
1-Jan-121-Feb-12Repay P + Capitalise Int.
5.695300%
-3,324,157.25
1,324,157.250.00
268,000,000.00
1-Feb-1220-Feb-12Additional drawdown
5.695300%
10,000,000.00
0.000.00
278,000,000.00
20-Feb-121-Mar-12Final Repay
5.695300%
-278,000,000.00
0.002,460,000.00
0.00

J23                 Additional drawdown on Term Loan (Alternative to J17)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/00720-Feb-12BCash at BankUSD10,000,000.001.432300SGD14,323,000.00J23a
TML1001/00720-Feb-12BTML - BorrowingUSD-10,000,000.001.432300SGD-14,323,000.00J23b

Note J23a:         The exchange rate on 20-Feb is 1.4323. See Exchange Rates below.

J24                 Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100129-Feb-12PTML - Borrowing - Interest ExpenseUSD1,246,000.001.302343SGD1,622,719.62J24a
TML100129-Feb-12BTML - Borrowing - Interest PayableUSD-1,246,000.001.452700SGD-1,810,064.20J24b
TML100129-Feb-12PFX - Unrealised Losses - RevenueUSD0.000.000000SGD187,344.58J24c
TML100129-Feb-12BTML - BorrowingUSD0.000.000000SGD-58,735,200.00J24d
TML100129-Feb-12PFX - Unrealised Losses - CapitalUSD0.000.000000SGD58,735,200.00J24e

Note J24a:         The average multiplier rate between 1-Feb and 29-Feb is 1.302343. See analysis below.

                               Calculation on prorating is analyzed as below

Next Period Interest1,246,000.00A
B
C
D
E
F
G
H = D * E * F
I = D * E * G
J = H / M * A
K
L
From DateTo Date
Notional P
Rate
Acc Days
Total Days
Acc Wt
Total Wt
Period Accrual (USD)
Avg Rate
Period Accrual (SGD)
1-Feb-1220-Feb-12
268,000,000.00
0.056953
19
19
290,004,676.00
290,004,676.00
805,974.59
1.230279
991,573.57
20-Feb-121-Mar-12
278,000,000.00
0.056953
10
10
158,329,340.00
158,329,340.00
440,025.41
1.434340
631,146.05
448,334,016.00
1,246,000.00
1.302343
1,622,719.62
M

Note J24c:         The unrealised foreign exchange loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate1,246,000.001.452700
1,810,064.20
At Average Rate1,246,000.001.302343
1,622,719.62
Loss in exchange
-187,344.58

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

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

USDRate+
SGD
At Closing Rate278,000,000.001.452700
403,850,600.00
At Start Date10,000,000.001.432300
14,323,000.00
At Start Date268,000,000.001.234300
330,792,400.00
Loss in exchange
-58,735,200.00

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

J25                 Final Principal + Interest (Fixed) Settlement on Term Loan (Alternative to J20)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0081-Mar-12BTML - BorrowingUSD278,000,000.001.241422SGD345,115,400.00J25a
TML1001/0081-Mar-12PTML - Borrowing - Interest ExpenseUSD1,246,000.001.302343SGD1,622,719.62J25b
TML1001/0081-Mar-12BCash at BankUSD-279,246,000.001.452700SGD-405,660,664.20J25c
TML1001/0081-Mar-12PFX - Realised Losses - CapitalUSD0.000.000000SGD58,735,200.00J25d
TML1001/0081-Mar-12PFX - Realised Losses - RevenueUSD0.000.000000SGD187,344.58J25e

Note J25b:         The average multiplier rate between 1-Feb and1-Mar is 1.302343. See Exchange Rates below.

                               Calculation on prorating is analyzed as below

Next Period Interest1,246,000.00A
B
C
D
E
F
G
H = D * E * F
I = D * E * G
J = H / M * A
K
L
From DateTo Date
Notional P
Rate
Acc Days
Total Days
Acc Wt
Total Wt
Period Accrual (USD)
Avg Rate
Period Accrual (SGD)
1-Feb-1220-Feb-12
268,000,000.00
0.056953
19
19
290,004,676.00
290,004,676.00
805,974.59
1.230279
991,573.57
20-Feb-121-Mar-12
278,000,000.00
0.056953
10
10
158,329,340.00
158,329,340.00
440,025.41
1.434340
631,146.05
448,334,016.00
1,246,000.00
1.302343
1,622,719.62
M

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

USDRate+
SGD
At Closing Rate278,000,000.001.452700
403,850,600.00
At Start Date10,000,000.001.432300
14,323,000.00
At Start Date268,000,000.001.234300
330,792,400.00
Loss in exchange
-58,735,200.00

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

Note J25e:         The unrealised foreign exchange loss on interest expense is analyzed as follows:

USDRate+
SGD
At Closing Rate1,246,000.001.452700
1,810,064.20
At Average Rate1,246,000.001.302343
1,622,719.62
Loss in exchange
-187,344.58

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

FREQUENTLY ASKED QUESTIONS

FAQ01.                How does the system handle interest accruals at month end?

Interest accruals in CS Lucas system is reversing in nature. The interest computation at month end is always from the beginning of the trade or last interest payment date till to date. Interest accruals at month end is then reversed on the first day of the next open period.

CS Lucas system also does not have the concept of partial interest repayment. When interest is paid, all of it has to be paid. We view that if there is a partial payment of interest, then the unpaid amount must be capitalised. This follows general lending practice where all interest must be paid before repaying principal. What this means is that so long as an interest amount is paid (even 0.01), system would deem that ALL the interest to date is paid. Accrual will restart from 0 again. But if no interest is paid, when principal is paid, then the system will continue the accrual going forward.

RELATED INFORMATION

CHANGE HISTORY

DateByChanges
31-Jul-2008CSCreation.
14-Dec-2015TSRewritten. Reformatted.
16-Jun-2016RJReformatted.
25-Oct-2017TSUpdated FAQ01.
27-Apr-2020LTRe-formatting.
Categories:

0 Comments

Leave a Reply

blank

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



    Close Bitnami banner
    Bitnami