Term Loan – Lend

Published by user on

Term Loan – Lend

PURPOSE

To show illustration of term loan lend.

OVERVIEW

TRANSACTION DETAILS

Accounting Base Ccy
Trade ID
Transaction
Trade Date
Initial Draw Date
Maturity Date
Currency
Amount
Frequency
Accrual Method
SGD
TML1001
Lend
8-Apr-16
8-Apr-16
8-Apr-19
USD
10,345,541.07
Semi-Annual
Act/360

Repayment Schedule

From DateTo DateActivityRate (%)PrincipalInt Cap.InterestOutstanding
8-Apr-168-Apr-16Lending
1.817200
-10,345,541.07
0.000.00
-10,345,541.07
8-Apr-165-May-16Additional Lending
1.817200
-4,433,803.32
0.000.00
-14,779,344.39
5-May-165-Jul-16Additional Lending
1.817200
-3,694,836.10
0.000.00
-18,474,180.49
5-Jul-165-Oct-16Additional Lending
1.817200
-3,694,836.09
0.000.00
-22,169,016.58
5-Oct-1611-Oct-16Redeem P + I
1.817200
7,000,000.00
0.00222,428.00
-15,169,016.58
11-Oct-1610-Apr-17Redeem P + I
1.817200
9,000,000.00
0.00138,591.38
-6,169,016.58
10-Apr-1710-Oct-17Redeem I
1.817200
0.00
0.0056,985.88
-6,169,016.58
10-Oct-179-Apr-18Redeem I
1.817200
0.00
0.0056,363.08
-6,169,016.58
9-Apr-189-Oct-18Redeem I
1.817200
0.00
0.0056,985.88
-6,169,016.58
9-Oct-188-Apr-19Final Redemption
1.817200
6,169,016.58
0.0056,363.08
0.00

SUMMARY OF JOURNALS

IDDateDescription
J18-Apr-16Settlement of Term Loan (Lending)
J230-Apr-16Month End Term Loan Accruals
J31-May-16Reversal Month End Term Loan Accruals
J45-May-16Settlement of Term Loan (Additional Lending)
J531-May-16Month End Term Loan Accruals
J61-Jun-16Reversal Month End Term Loan Accruals
J75-Jul-16Settlement of Term Loan (Additional Lending)
J831-Jul-16Month End Term Loan Accruals
J91-Aug-16Reversal Month End Term Loan Accruals
J105-Oct-16Settlement of Term Loan (Additional Lending)
J1111-Oct-16Principal and Interest Settlement of Term Loan (Redeem P+I)
J1231-Oct-16Month End Term Loan Accruals
J131-Nov-16Reversal Month End Term Loan Accruals
J1410-Apr-17Principal and Interest Settlement of Term Loan (Redeem P+I)
J1530-Apr-17Month End Term Loan Accruals
J161-May-17Reversal Month End Term Loan Accruals
J1710-Oct-17Interest Settlement of Term Loan (Redeem I)
J189-Apr-18Interest Settlement of Term Loan (Redeem I)
J1930-Jun-18Month End Term Loan Accruals
J201-Jul-18Reversal Month End Term Loan Accruals
J219-Oct-18Interest Settlement of Term Loan (Redeem I)
J228-Apr-19Principal and Interest Settlement of Term Loan (Final Redeem P+I)

J1                  Settlement of Term Loan (Lending)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0018-Apr-16BCash at BankUSD-10,345,541.071.392200SGD-14,403,062.28J1a
TML1001/0018-Apr-16BTML - LendingUSD10,345,541.071.392200SGD14,403,062.28J1b

Note J1a:           The exchange rate on 8-Apr-2016 is 1.392200 (last available rate on 1-Apr-2016). See Exchange Rates below.

J2                  Month End Term Loan Accruals

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100130-Apr-16PTML - Lending - Interest IncomeUSD-17,562.981.396470SGD-24,526.17J2a
TML100130-Apr-16BTML - Lending - Interest ReceivablesUSD17,562.981.398747SGD24,566.17J2b
TML100130-Apr-16PFX - Unrealised Gains - RevenueUSD0.000.000000SGD-40.00J2c
TML100130-Apr-16BTML - LendingUSD0.000.000000SGD67,732.26J2d
TML100130-Apr-16PFX - Unrealised Gains - CapitalUSD0.000.000000SGD-67,732.26J2e

Note J2a:           The average multiplier rate between 8-Apr and 30-Apr is 1.396470. See Exchange Rates below.

Note J2b:           Calculation of Accrual in USD

Next Period Interest222,428.00A

                             Calculation on pro-rating the next interest payment amount between different periods as below:

In the event there is change in the outstanding principal, system will pro-rate the next interest payment amount between the different periods. Essentially the weight is based on outstanding principal, interest rate and the number of days in the period.

B
C
D
E
F
G
H = D * E * F
I = D * E * G
J = H / M * A
K
L
From DateTo Date
Outstanding P
Rate
Acc Days
Total Days
Acc Wt
Total Wt
Period Accrual (USD)
Avg Rate
Period Accrual (SGD)
8-Apr-165-May-16
10,345,541.07
1.8172
27
27
507,597,765.27
507,597,765.27
20,617.41
1.397415
28,811.07
5-May-165-Jul-16
14,779,344.39
1.8172
61
61
1,638,278,502.16
1,638,278,502.16
66,542.95
1.403223
93,374.57
5-Jul-165-Oct-16
18,474,180.49
1.8172
92
92
3,088,557,832.35
3,088,557,832.35
125,449.83
1.403365
176,051.94
5-Oct-1611-Oct-16
22,169,016.58
1.8172
6
6
241,713,221.58
241,713,221.58
9,817.81
1.397834
13,723.67
5,476,147,321.36
222,428.00
1.402527
311,961.25
M

                             Calculation of Accrual from 8-Apr to 30-Apr

Start Date8-Apr-16
Month End Date30-Apr-16
Days (include 30-Apr)23A
Start Date8-Apr-16
End Date5-May-16
Days (exclude 5-May)27B
Total Interest20,617.41C
Period Interest17,562.98D = C * A / B

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

USDRate+
SGD
At Closing Rate17,562.981.398747
24,566.17
At Average Rate17,562.981.396470
24,526.17
Gain in exchange
40.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 lending transaction is analyzed as follows:

USDRate+
SGD
At Closing Rate10,345,541.071.398747
14,470,794.54
At Start Date10,345,541.071.392200
14,403,062.28
Gain in exchange
67,732.26

+ 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-May-16PTML - Lending - Interest IncomeUSD17,562.981.396470SGD24,526.17J3a
TML10011-May-16BTML - Lending - Interest ReceivablesUSD-17,562.981.398747SGD-24,566.17J3b
TML10011-May-16PFX - Unrealised Gains - RevenueUSD0.000.000000SGD40.00J3c
TML10011-May-16BTML - LendingUSD0.000.000000SGD-67,732.26J3d
TML10011-May-16PFX - Unrealised Gains - CapitalUSD0.000.000000SGD67,732.26J3e

J4                  Settlement of Term Loan (Additional Lending)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0025-May-16BCash At BankUSD-4,433,803.321.402848SGD-6,219,952.12J4a
TML1001/0025-May-16BTML - LendingUSD4,433,803.321.402848SGD6,219,952.12J4b

Note J4a:          The exchange rate on 5-May-2016 is 1.402848 (last available rate on 1-May-2016). See Exchange Rates below.

J5                  Month End Term Loan Accruals

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100131-May-16PTML - Lending - Interest IncomeUSD-50,070.851.402324SGD-70,215.56J5a
TML100131-May-16BTML - Lending - Interest ReceivablesUSD50,070.851.401693SGD70,183.96J5b
TML100131-May-16PFX - Unrealised Losses - RevenueUSD0.000.000000SGD31.60J5c
TML100131-May-16BTML - LendingUSD0.000.000000SGD93,089.18J5d
TML100131-May-16PFX - Unrealised Gains - CapitalUSD0.000.000000SGD-93,089.18J5e

Note J5a:           The average multiplier rate between 8-Apr and 31-May is 1.402324. See calculation in J5c below.

Note J5b:           Calculation of Accrual in USD

Next Period Interest222,428.00A

                             Calculation on pro-rating the next interest payment amount between different periods as below:

In the event there is change in the outstanding principal, system will pro-rate the next interest payment amount between the different periods. Essentially the weight is based on outstanding principal, interest rate and the number of days in the period.

B
C
D
E
F
G
H = D * E * F
I = D * E * G
J = H / M * A
K
L
From DateTo Date
Outstanding P
Rate
Acc Days
Total Days
Acc Wt
Total Wt
Period Accrual (USD)
Avg Rate
Period Accrual (SGD)
8-Apr-165-May-16
10,345,541.07
1.8172
27
27
507,597,765.27
507,597,765.27
20,617.41
1.397415
28,811.07
5-May-165-Jul-16
14,779,344.39
1.8172
61
61
1,638,278,502.16
1,638,278,502.16
66,542.95
1.403223
93,374.57
5-Jul-165-Oct-16
18,474,180.49
1.8172
92
92
3,088,557,832.35
3,088,557,832.35
125,449.83
1.403365
176,051.94
5-Oct-1611-Oct-16
22,169,016.58
1.8172
6
6
241,713,221.58
241,713,221.58
9,817.81
1.397834
13,723.67
5,476,147,321.36
222,428.00
1.402527
311,961.25
M

                             Calculation of Accrual from 5-May to 31-May

Start Date5-May-16
Month End Date31-May-16
Days (include 31-May)27A
Start Date5-May-16
End Date5-Jul-16
Days (exclude 5-Jul)61B
Total Interest66,542.95C
Period Interest29,453.44D = C * A / B

                             Calculation of Accrual from 8-Apr to 31-May

8-Apr to 5-May20,617.41
5-May to 31-May29,453.44
Total Interest50,070.85

Note J5c:          The unrealised foreign exchange gain/loss on interest income is analyzed as follows:

USDRate+
SGD
At Closing Rate50,070.851.401693
70,183.96
At Average Rate50,070.851.402324
70,215.56
Loss in exchange
-31.60

                             USD accrual conversion to SGD using average rate is analyzed as below:

USDRate+
SGD
8-Apr to 5-May20,617.411.397415
28,811.07
5-May to 31-May29,453.441.405761
41,404.49
50,070.851.402324
70,215.56

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

Note J5e:          The unrealised gain/loss on the revaluation of the lending transaction is analyzed as follows:

USDRate+
SGD
At Closing Rate14,779,344.391.401693
20,716,103.58
At Start Date10,345,541.071.392200
14,403,062.28
At Start Date4,433,803.321.402848
6,219,952.12
Gain in exchange
93,089.18

+ 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-Jun-16PTML - Lending - Interest IncomeUSD50,070.851.402324SGD70,215.56J6a
TML10011-Jun-16BTML - Lending - Interest ReceivablesUSD-50,070.851.401693SGD-70,183.96J6b
TML10011-Jun-16PFX - Unrealised Losses - RevenueUSD0.000.000000SGD-31.60J6c
TML10011-Jun-16BTML - LendingUSD0.000.000000SGD-93,089.18J6d
TML10011-Jun-16PFX - Unrealised Gains - CapitalUSD0.000.000000SGD93,089.18J6e

J7                  Settlement of Term Loan (Additional Lending)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0035-Jul-16BCash At BankUSD-3,694,836.101.402489SGD-5,181,966.99J7a
TML1001/0035-Jul-16BTML - LendingUSD3,694,836.101.402489SGD5,181,966.99J7b

Note J7a:          The exchange rate on 5-Jul-2016 is 1.402489 (last available rate on 30-Jun-2016). See Exchange Rates below.

J8                  Month End Term Loan Accruals

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100131-Jul-16PTML - Lending - Interest IncomeUSD-123,977.161.402184SGD-173,838.55J8a
TML100131-Jul-16BTML - Lending - Interest ReceivablesUSD123,977.161.404227SGD174,092.08J8b
TML100131-Jul-16PFX - Unrealised Gains - RevenueUSD0.000.000000SGD-253.53J8c
TML100131-Jul-16BTML - LendingUSD0.000.000000SGD136,961.66J8d
TML100131-Jul-16PFX - Unrealised Gains - CapitalUSD0.000.000000SGD-136,961.66J8e

Note J8a:           The average multiplier rate between 8-Apr and 31-Jul is 1.402184. See calculation in J8c below.

Note J8b:           Calculation of Accrual in USD

Next Period Interest222,428.00A

                             Calculation on pro-rating the next interest payment amount between different periods as below:

In the event there is change in the outstanding principal, system will pro-rate the next interest payment amount between the different periods. Essentially the weight is based on outstanding principal, interest rate and the number of days in the period.

B
C
D
E
F
G
H = D * E * F
I = D * E * G
J = H / M * A
K
L
From DateTo Date
Outstanding P
Rate
Acc Days
Total Days
Acc Wt
Total Wt
Period Accrual (USD)
Avg Rate
Period Accrual (SGD)
8-Apr-165-May-16
10,345,541.07
1.8172
27
27
507,597,765.27
507,597,765.27
20,617.41
1.397415
28,811.07
5-May-165-Jul-16
14,779,344.39
1.8172
61
61
1,638,278,502.16
1,638,278,502.16
66,542.95
1.403223
93,374.57
5-Jul-165-Oct-16
18,474,180.49
1.8172
92
92
3,088,557,832.35
3,088,557,832.35
125,449.83
1.403365
176,051.94
5-Oct-1611-Oct-16
22,169,016.58
1.8172
6
6
241,713,221.58
241,713,221.58
9,817.81
1.397834
13,723.67
5,476,147,321.36
222,428.00
1.402527
311,961.25
M

                             Calculation of Accrual from 5-Jul to 31-Jul

Start Date5-Jul-16
Month End Date31-Jul-16
Days (include 31-Jul)27A
Start Date5-Jul-16
End Date5-Oct-16
Days (exclude 5-Oct)92B
Total Interest125,449.83C
Period Interest36,816.80D = C * A / B

                             Calculation of Accrual from 8-Apr to 31-Jul

8-Apr to 5-May20,617.41
5-May to 5-Jul66,542.95
5-Jul to 31-Jul36,816.80
Total Interest123,977.16

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

USDRate+
SGD
At Closing Rate123,977.161.404227
174,092.08
At Average Rate123,977.161.402184
173,838.55
Gain in exchange
253.53

                             USD accrual conversion to SGD using average rate is analyzed as below:

USDRate+
SGD
8-Apr to 5-May20,617.411.397415
28,811.07
5-May to 5-Jul66,542.951.403223
93,374.57
5-Jul to 31-Jul36,816.801.402971
51,652.91
123,977.001.402184
173,838.55

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

Note J8e:           The unrealised gain/loss on the revaluation of the lending transaction is analyzed as follows:

USDRate+
SGD
At Closing Rate18,474,180.491.404227
25,941,943.05
At Start Date10,345,541.071.392200
14,403,062.28
At Start Date4,433,803.321.402848
6,219,952.12
At Start Date3,694,836.101.402489
5,181,966.99
Gain in exchange
136,961.66

+ 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-Aug-16PTML - Lending - Interest IncomeUSD123,977.161.402184SGD173,838.55J9a
TML10011-Aug-16BTML - Lending - Interest ReceivablesUSD-123,977.161.404227SGD-174,092.08J9b
TML10011-Aug-16PFX - Unrealised Gains - RevenueUSD0.000.000000SGD253.53J9c
TML10011-Aug-16BTML - LendingUSD0.000.000000SGD-136,961.66J9d
TML10011-Aug-16PFX - Unrealised Gains - CapitalUSD0.000.000000SGD136,961.66J9e

J10               Settlement of Term Loan (Additional Lending)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0045-Oct-16BCash At BankUSD-3,694,836.091.397834SGD-5,164,767.51J10a
TML1001/0045-Oct-16BTML - LendingUSD3,694,836.091.397834SGD5,164,767.51J10b

Note J10a:         The exchange rate on 5-Oct-2016 is 1.397834 (last available rate on 28-Sep-2016). See Exchange Rates below.

J11                 Principal and Interest Settlement of Term Loan (Redeem P+I)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/00511-Oct-16BTML - LendingUSD-7,000,000.001.392200SGD-9,745,400.00J11a
TML1001/00511-Oct-16PTML - Lending - Interest IncomeUSD-222,428.001.402527SGD-311,961.25J11b
TML1001/00511-Oct-16BCash at BankUSD7,222,428.001.397834SGD10,095,755.42J11c
TML1001/00511-Oct-16PFX - Realised Gains - CapitalUSD0.000.000000SGD-39,438.00J11d
TML1001/00511-Oct-16PFX - Realised Losses - RevenueUSD0.000.000000SGD1,043.83J11e

Note J11b:         The average multiplier rate between 8-Apr and 11-Oct is 1.402527. See calculation in J11e below.

Note J11d:         The realised gain/loss on the revaluation of the lending transaction is analyzed as follows:

USDRate+
SGD
At Closing Rate7,000,000.001.397834
9,784,838.00
At Start Date7,000,000.001.392200
9,745,400.00
Gain in exchange
39,438.00

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

Note J11e:         The realised foreign exchange gain/loss on interest income is analyzed as follows:

Next Period Interest222,428.00A

                             Calculation on pro-rating the next interest payment amount between different periods as below:

In the event there is change in the outstanding principal, system will pro-rate the next interest payment amount between the different periods. Essentially the weight is based on outstanding principal, interest rate and the number of days in the period.

B
C
D
E
F
G
H = D * E * F
I = D * E * G
J = H / M * A
K
L
From DateTo Date
Outstanding P
Rate
Acc Days
Total Days
Acc Wt
Total Wt
Period Accrual (USD)
Avg Rate
Period Accrual (SGD)
8-Apr-165-May-16
10,345,541.07
1.8172
27
27
507,597,765.27
507,597,765.27
20,617.41
1.397415
28,811.07
5-May-165-Jul-16
14,779,344.39
1.8172
61
61
1,638,278,502.16
1,638,278,502.16
66,542.95
1.403223
93,374.57
5-Jul-165-Oct-16
18,474,180.49
1.8172
92
92
3,088,557,832.35
3,088,557,832.35
125,449.83
1.403365
176,051.94
5-Oct-1611-Oct-16
22,169,016.58
1.8172
6
6
241,713,221.58
241,713,221.58
9,817.81
1.397834
13,723.67
5,476,147,321.36
222,428.00
1.402527
311,961.25
M
USDRate+
SGD
At Closing Rate222,428.001.397834
310,917.42
At Average Rate222,428.001.402527
311,961.25
Loss in exchange
-1,043.83

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

J12                 Month End Term Loan Accruals

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100131-Oct-16PTML - Lending - Interest IncomeUSD-16,079.661.396276SGD-22,451.64J12a
TML100131-Oct-16BTML - Lending - Interest ReceivablesUSD16,079.661.398115SGD22,481.21J12b
TML100131-Oct-16PFX - Unrealised Gains - RevenueUSD0.000.000000SGD-29.57J12c
TML100131-Oct-16BTML - LendingUSD0.000.000000SGD-16,319.28J12d
TML100131-Oct-16PFX - Unrealised Losses - CapitalUSD0.000.000000SGD16,319.28J12e

Note J12a:          The average multiplier rate between 11-Oct and 31-Oct is 1.396276. See Exchange Rates below.

Note J12b:         Calculation of Accrual in USD

Outstanding Principal15,169,016.58A
Interest Rate1.81720%B
Start Date11-Oct-16C
Month End Date31-Oct-16D
End Date10-Apr-17E
Days to ME (include 31-Oct)21F = D - C + 1
Days To End Date (exclude 10-Apr)181G = E - C
Accrual MethodAct/360H
Total Interest138,591.38I
Period Interest16,079.66J = I / G * F

Note J12c:         The unrealised foreign exchange gain/loss on interest income is analyzed as follows:

USDRate+
SGD
At Closing Rate16,079.661.398115
22,481.21
At Average Rate16,079.661.396276
22,451.64
Gain in exchange
29.57

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

Note J12e:         The unrealised gain/loss on the revaluation of the lending transaction is analyzed as follows:

USDRate+
SGD
At Closing Rate15,169,016.581.398115
21,208,029.62
At Start Date3,345,541.071.392200
4,657,662.28
At Start Date4,433,803.321.402848
6,219,952.12
At Start Date3,694,836.101.402489
5,181,966.99
At Start Date3,694,836.091.397834
5,164,767.51
Loss in exchange
-16,319.28

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

J13                 Reversal Month End Term Loan Accruals

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML10011-Nov-16PTML - Lending - Interest IncomeUSD16,079.661.396276SGD22,451.64J13a
TML10011-Nov-16BTML - Lending - Interest ReceivablesUSD-16,079.661.398115SGD-22,481.21J13b
TML10011-Nov-16PFX - Unrealised Gains - RevenueUSD0.000.000000SGD29.57J13c
TML10011-Nov-16BTML - LendingUSD0.000.000000SGD16,319.28J13d
TML10011-Nov-16PFX - Unrealised Losses - CapitalUSD0.000.000000SGD-16,319.28J13e

J14                 Principal and Interest Settlement of Term Loan (Redeem P+I)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/00610-Apr-17BTML - LendingUSD-9,000,000.001.398841SGD-12,589,570.47J14a
TML1001/00610-Apr-17PTML - Lending - Interest IncomeUSD-138,591.381.403752SGD-194,547.91J14b
TML1001/00610-Apr-17BCash at BankUSD9,138,591.381.410603SGD12,890,924.42J14c
TML1001/00610-Apr-17PFX - Realised Gains - CapitalUSD0.000.000000SGD-105,856.53J14d
TML1001/00610-Apr-17PFX - Realised Gains - RevenueUSD0.000.000000SGD-949.51J14e

Note J14b:         The average multiplier rate between 11-Oct and 10-Apr is 1.403752. See Exchange Rates below.

Note J14d:         The realised gain/loss on the revaluation of the lending transaction is analyzed as follows:

USDRate+
SGD
At Closing Rate9,000,000.001.410603
12,695,427.00
At Start Date9,000,000.001.398841
12,589,570.47
Gain in exchange
105,856.53

                              Breakdown analysis of principal lending at different start date:

At Start Date3,345,541.071.392200
4,657,662.28
At Start Date4,433,803.321.402848
6,219,952.12
At Start Date1,220,655.611.402489
1,711,956.07
9,000,000.001.398841
12,589,570.47

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

Note J14e:         The realised foreign exchange gain/loss on interest income is analyzed as follows:

USDRate+
SGD
At Closing Rate138,591.381.410603
195,497.42
At Average Rate138,591.381.403752
194,547.91
Gain in exchange
949.51

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

J15                 Month End Term Loan Accruals

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100130-Apr-17PTML - Lending - Interest IncomeUSD-6,539.361.416485SGD-9,262.90J15a
TML100130-Apr-17BTML - Lending - Interest ReceivablesUSD6,539.361.416779SGD9,264.83J15b
TML100130-Apr-17PFX - Unrealised Gains - RevenueUSD0.000.000000SGD-1.93J15c
TML100130-Apr-17BTML - LendingUSD0.000.000000SGD105,354.71J15d
TML100130-Apr-17PFX - Unrealised Gains - CapitalUSD0.000.000000SGD-105,354.71J15e

Note J15a:         The average multiplier rate between 10-Apr and 30-Apr is 1.416485. See Exchange Rates below.

Note J15b:        Calculation of Accrual in USD 

Outstanding Principal6,169,016.58A
Interest Rate1.81720%B
Start Date10-Apr-17C
Month End Date30-Apr-17D
End Date10-Oct-17E
Days to ME (include 30-Apr)21F = D - C + 1
Days To End Date (exclude 10-Oct)183G = E - C
Accrual MethodAct/360H
Total Interest56,985.88I
Period Interest6,539.36J = I / G * F

Note J15c:         The unrealised foreign exchange gain/loss on interest income is analyzed as follows:

USDRate+
SGD
At Closing Rate6,539.361.416779
9,264.83
At Average Rate6,539.361.416485
9,262.90
Gain in exchange
1.93

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

Note J15e:         The unrealised gain/loss on the revaluation of the lending transaction is analyzed as follows:

USDRate+
SGD
At Closing Rate6,169,016.581.416779
8,740,133.14
At Start Date2,474,180.491.402489
3,470,010.92
At Start Date3,694,836.091.397834
5,164,767.51
Gain in exchange
105,354.71

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

J16                 Reversal Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML10011-May-17PTML - Lending - Interest IncomeUSD6,539.361.416485SGD9,262.90J16a
TML10011-May-17BTML - Lending - Interest ReceivablesUSD-6,539.361.416779SGD-9,264.83J16b
TML10011-May-17PFX - Unrealised Gains - RevenueUSD0.000.000000SGD1.93J16c
TML10011-May-17BTML - LendingUSD0.000.000000SGD-105,354.71J16d
TML10011-May-17PFX - Unrealised Gains - CapitalUSD0.000.000000SGD105,354.71J16e

J17                 Interest Settlement of Term Loan (Redeem I)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/00610-Oct-17PTML - Lending - Interest IncomeUSD-56,985.881.414348SGD-80,597.89J17a
TML1001/00610-Oct-17BCash at BankUSD56,985.881.415832SGD80,682.43J17b
TML1001/00610-Oct-17PFX - Realised Gains - RevenueUSD0.000.000000SGD-84.54J17c

Note J17a:         The average multiplier rate between 10-Apr and 10-Oct is 1.414348. See Exchange Rates below.

Note J17c:         The realised foreign exchange gain/loss on interest income is analyzed as follows:

USDRate+
SGD
At Closing Rate56,985.881.415832
80,682.43
At Average Rate56,985.881.414348
80,597.89
Gain in exchange
84.54

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

J18                 Interest Settlement of Term Loan (Redeem I)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0079-Apr-18PTML - Lending - Interest IncomeUSD-56,363.081.416925SGD-79,862.24J18a
TML1001/0079-Apr-18BCash at BankUSD56,363.081.423450SGD80,230.03J18b
TML1001/0079-Apr-18PFX - Realised Gains - RevenueUSD0.000.000000SGD-367.79J18c

Note J18a:         The average multiplier rate between 10-Oct and 9-Apr is 1.416925. See Exchange Rates below.

Note J18c:         The realised foreign exchange gain/loss on interest income is analyzed as follows:

USDRate+
SGD
At Closing Rate56,363.081.423450
80,230.03
At Average Rate56,363.081.416925
79,862.24
Gain in exchange
367.79

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

J19                 Month End Term Loan Accruals

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100130-Jun-18PTML - Lending - Interest IncomeUSD-25,846.051.420163SGD-36,705.59J19a
TML100130-Jun-18BTML - Lending - Interest ReceivablesUSD25,846.051.418425SGD36,660.68J19b
TML100130-Jun-18PFX - Unrealised Losses - RevenueUSD0.000.000000SGD44.91J19c
TML100130-Jun-18BTML - LendingUSD0.000.000000SGD115,508.91J19d
TML100130-Jun-18PFX - Unrealised Gains - CapitalUSD0.000.000000SGD-115,508.91J19e

Note J19a:          The average multiplier rate between 9-Apr and 30-Jun is 1.420163. See Exchange Rates below.

Note J19b:         Calculation of Accrual in USD

Outstanding Principal6,169,016.58A
Interest Rate1.81720%B
Start Date9-Apr-18C
Month End Date30-Jun-18D
End Date9-Oct-18E
Days to ME (include 30-Jun)83F = D - C + 1
Days To End Date (exclude 9-Oct)183G = E - C
Accrual MethodAct/360H
Total Interest56,985.88I
Period Interest25,846.05J = I / G * F

Note J19c:         The unrealised foreign exchange gain/loss on interest income is analyzed as follows:

USDRate+
SGD
At Closing Rate25,846.051.418425
36,660.68
At Average Rate25,846.051.420163
36,705.59
Loss in exchange
-44.91

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

Note J19e:         The unrealised gain/loss on the revaluation of the lending transaction is analyzed as follows:

USDRate+
SGD
At Closing Rate6,169,016.581.418425
8,750,287.34
At Start Date2,474,180.491.402489
3,470,010.92
At Start Date3,694,836.091.397834
5,164,767.51
Gain in exchange
115,508.91

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

J20                 Reversal Month End Term Loan Accruals.

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML10011-Jul-18PTML - Lending - Interest IncomeUSD25,846.051.420163SGD36,705.59J20a
TML10011-Jul-18BTML - Lending - Interest ReceivablesUSD-25,846.051.418425SGD-36,660.68J20b
TML10011-Jul-18PFX - Unrealised Losses - RevenueUSD0.000.000000SGD-44.91J20c
TML10011-Jul-18BTML - LendingUSD0.000.000000SGD-115,508.91J20d
TML10011-Jul-18PFX - Unrealised Gains - CapitalUSD0.000.000000SGD115,508.91J20e

J21                 Interest Settlement of Term Loan (Redeem I)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0089-Oct-18PTML - Lending - Interest IncomeUSD-56,985.881.418957SGD-80,860.49J21a
TML1001/0089-Oct-18BCash at BankUSD56,985.881.416491SGD80,719.99J21b
TML1001/0089-Oct-18PFX - Realised Losses - RevenueUSD0.000.000000SGD140.50J21c

Note J21a:         The average multiplier rate between 9-Apr and 9-Oct is 1.418957. See Exchange Rates below.

Note J21c:         The realised foreign exchange gain/loss on interest income is analyzed as follows:

USDRate+
SGD
At Closing Rate56,985.881.416491
80,719.99
At Average Rate56,985.881.418957
80,860.49
Loss in exchange
-140.50

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

J22                 Principal and Interest Settlement of Term Loan (Final Redeem P+I)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0098-Apr-19BTML - LendingUSD-6,169,016.581.399701SGD-8,634,778.43J22a
TML1001/0098-Apr-19PTML - Lending - Interest IncomeUSD-56,363.081.412023SGD-79,585.96J22b
TML1001/0098-Apr-19BCash at BankUSD6,225,379.661.412868SGD8,795,639.71J22c
TML1001/0098-Apr-19PFX - Realised Gains - CapitalUSD0.000.000000SGD-81,227.69J22d
TML1001/0098-Apr-19PFX - Realised Gains - RevenueUSD0.000.000000SGD-47.63J22e

Note J22b:         The average multiplier rate between 9-Oct and 8-Apr is 1.412023. See Exchange Rates below.

Note J22d:         The realised gain/loss on the revaluation of the lending transaction is analyzed as follows:

USDRate+
SGD
At Closing Rate6,169,016.581.412868
8,716,006.12
At Start Date6,169,016.581.399701
8,634,778.43
Gain in exchange
81,227.69

                              Breakdown analysis of principal drawdown at different start date:

At Start Date2,474,180.491.402489
3,470,010.92
At Start Date3,694,836.091.397834
5,164,767.51
6,169,016.581.399701
8,634,778.43

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

Note J22e:         The realised foreign exchange gain/loss on interest income is analyzed as follows:

USDRate+
SGD
At Closing Rate56,363.081.412868
79,633.59
At Average Rate56,363.081.412023
79,585.96
Gain in exchange
47.63

+ 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
1-Apr-161.392200
16-Apr-161.398747
1-May-161.402848
16-May-161.408168
31-May-161.401693
15-Jun-161.400326
30-Jun-161.402489
15-Jul-161.403125
30-Jul-161.404227
14-Aug-161.402070
29-Aug-161.406607
13-Sep-161.403963
28-Sep-161.397834
13-Oct-161.395578
28-Oct-161.398115
27-Nov-161.405050
12-Dec-161.407127
11-Jan-171.401762
10-Feb-171.405213
12-Mar-171.410603
11-Apr-171.416779
11-May-171.411454
10-Jun-171.412959
10-Jul-171.418213
9-Aug-171.413823
8-Sep-171.412888
8-Oct-171.415832
7-Nov-171.420300
7-Dec-171.414934
6-Jan-181.416366
5-Feb-181.410692
7-Mar-181.422699
6-Apr-181.423450
6-May-181.418710
5-Jun-181.418425
5-Jul-181.424807
4-Aug-181.416726
3-Sep-181.412564
3-Oct-181.416491
2-Nov-181.415001
2-Dec-181.408515
1-Jan-191.411206
31-Jan-191.411963
15-Feb-191.409089
2-Mar-191.411095
1-Apr-191.412868

Average

From DateTo DateUSD/SGD
8-Apr-1630-Apr-161.396470
8-Apr-165-May-161.397415
5-May-1631-May-161.405761
5-May-165-Jul-161.403223
5-Jul-1631-Jul-161.402971
5-Jul-165-Oct-161.403365
5-Oct-1611-Oct-161.397834
11-Oct-1631-Oct-161.396276
11-Oct-1610-Apr-171.403752
10-Apr-1730-Apr-171.416485
10-Apr-1710-Oct-171.414348
10-Oct-179-Apr-181.416925
9-Apr-1830-Jun-181.420163
9-Apr-189-Oct-181.418957
9-Oct-188-Apr-191.412023

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

FREQUENTLY ASKED QUESTIONS

RELATED INFORMATION

CHANGE HISTORY

DateByChanges
14-Jun-2017TSCreation.
08-May-2020LTRe-formatting.
Categories:

0 Comments

Leave a Reply

blank

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



    Related Posts

    blank

    Bank Reconciliation: ERP vs. CS Lucas TMS

    Bank reconciliation is a crucial process that ensures the accuracy of a company’s financial records against the bank’s account statements. A reconciliation statement serves to validate that payments have been processed and deposits correctly recorded. Read more…

    blank

    The Future of Syndicated Lending Demands Specialized Technology

    Syndicated lending has grown rapidly over the past decade to become an essential source of financing for large corporations and institutions. Under a syndicated loan structure, a group of banks join together to provide credit Read more…

    blank

    Webinar: Managing Term Loans, Money Market, Investments & Forex

    In todays day and age, restructuring your treasury functions through modernization, flexibility and preparation can allow for real time up-to-date reports that allow for improved short and long term decision making. In this webinar, Zohain Read more…

    ABOUT US

    FUNCTIONALITY

    INDUSTRY SOLUTIONS

    PARTNERSHIP

    Close Bitnami banner
    Bitnami