Term Loan – Borrow

PURPOSE

To show illustration of term loan borrow.

OVERVIEW

TRANSACTION DETAILS

Accounting Base Ccy
Trade ID
Transaction
Trade Date
Initial Draw Date
Maturity Date
Currency
Amount
Frequency
Accrual Method
SGD
TML1001
Borrow
8-Apr-16
8-Apr-16
8-Apr-19
CLP
7,000,000,000.00
Semi-Annual
Act/360

Repayment Schedule

From DateTo DateActivityRate (%)PrincipalInt Cap.InterestOutstanding
8-Apr-168-Apr-16Drawdown
6.040000
7,000,000,000.00
0.000.00
7,000,000,000.00
8-Apr-165-May-16Additional drawdown
6.040000
3,000,000,000.00
0.000.00
10,000,000,000.00
5-May-165-Jul-16Additional drawdown
6.040000
2,500,000,000.00
0.000.00
12,500,000,000.00
5-Jul-165-Oct-16Additional drawdown
6.040000
2,500,000,000.00
0.000.00
15,000,000,000.00
5-Oct-1611-Oct-16Repay P + I
6.040000
-5,000,000,000.00
0.00-342,098,889.00
10,000,000,000.00
11-Oct-1610-Apr-17Repay P + I
6.040000
-6,000,000,000.00
0.00-303,677,778.00
4,000,000,000.00
10-Apr-1710-Oct-17Repay I
6.040000
0.00
0.00-122,813,333.00
4,000,000,000.00
10-Oct-179-Apr-18Repay I
6.040000
0.00
0.00-121,471,111.00
4,000,000,000.00
9-Apr-189-Oct-18Repay I
6.040000
0.00
0.00-122,813,333.00
4,000,000,000.00
9-Oct-188-Apr-19Final Repay
6.040000
-4,000,000,000.00
0.00-121,471,111.00
0.00

SUMMARY OF JOURNALS

IDDateDescription
J18-Apr-16Settlement of Term Loan (Drawdown)
J230-Apr-16Month End Term Loan Accruals
J31-May-16Reversal Month End Term Loan Accruals
J45-May-16Settlement of Term Loan (Additional Drawdown)
J531-May-16Month End Term Loan Accruals
J61-Jun-16Reversal Month End Term Loan Accruals
J75-Jul-16Settlement of Term Loan (Additional Drawdown)
J831-Jul-16Month End Term Loan Accruals
J91-Aug-16Reversal Month End Term Loan Accruals
J105-Oct-16Settlement of Term Loan (Additional Drawdown)
J1111-Oct-16Principal and Interest Settlement of Term Loan (Repay 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 (Repay P+I)
J1530-Apr-17Month End Term Loan Accruals
J161-May-17Reversal Month End Term Loan Accruals
J1710-Oct-17Interest Settlement of Term Loan (Repay I)
J189-Apr-18Interest Settlement of Term Loan (Repay I)
J1930-Jun-18Month End Term Loan Accruals
J201-Jul-18Reversal Month End Term Loan Accruals
J219-Oct-18Interest Settlement of Term Loan (Repay I)
J228-Apr-19Principal and Interest Settlement of Term Loan (Final Repay P+I)

J1                  Settlement of Term Loan (Drawdown)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0018-Apr-16BCash at BankCLP7,000,000,000.000.002495SGD17,465,000.00J1a
TML1001/0018-Apr-16BTML -BorrowingCLP-7,000,000,000.000.002495SGD-17,465,000.00J1b

Note J1a:           The exchange rate on 8-Apr-2016 is 0.002495 (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 - Borrowing - Interest ExpenseCLP27,012,222.000.002492SGD67,307.41J2a
TML100130-Apr-16BTML - Borrowing - Interest PayableCLP-27,012,222.000.002490SGD-67,260.43J2b
TML100130-Apr-16PFX - Unrealised Gains - RevenueCLP0.000.000000SGD-46.98J2c
TML100130-Apr-16BTML - BorrowingCLP0.000.000000SGD35,000.00J2d
TML100130-Apr-16PFX - Unrealised Gains - CapitalCLP0.000.000000SGD-35,000.00J2e

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

Note J2b:           Calculation of Accrual in CLP

Next Period Interest342,098,889.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 (CLP)
Avg Rate
Period Accrual (SGD)
8-Apr-165-May-16
7,000,000,000.00
6.04
27
27
1,141,560,000,000.00
1,141,560,000,000.00
31,710,000.00
0.002490
78,967.30
5-May-165-Jul-16
10,000,000,000.00
6.04
61
61
3,684,400,000,000.00
3,684,400,000,000.00
102,344,444.00
0.002482
253,985.35
5-Jul-165-Oct-16
12,500,000,000.00
6.04
92
92
6,946,000,000,000.00
6,946,000,000,000.00
192,944,445.00
0.002498
481,885.04
5-Oct-1611-Oct-16
15,000,000,000.00
6.04
6
6
543,600,000,000.00
543,600,000,000.00
15,100,000.00
0.002499
37,734.90
12,315,560,000,000.00
342,098,889.00
0.002492
852,572.59
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 Interest31,710,000.00C
Period Interest27,012,222.00D = C * A / B

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

CLPRate+
SGD
At Closing Rate27,012,222.000.002490
67,260.43
At Average Rate27,012,222.000.002492
67,307.41
Gain in exchange
46.98

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

CLPRate+
SGD
At Closing Rate7,000,000,000.000.002490
17,430,000.00
At Start Date7,000,000,000.000.002495
17,465,000.00
Gain in exchange
35,000.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-May-16PTML - Borrowing - Interest ExpenseCLP-27,012,222.000.002492SGD-67,307.41J3a
TML10011-May-16BTML - Borrowing - Interest PayableCLP27,012,222.000.002490SGD67,260.43J3b
TML10011-May-16PFX - Unrealised Gains - RevenueCLP0.000.000000SGD46.98J3c
TML10011-May-16BTML - BorrowingCLP0.000.000000SGD-35,000.00J3d
TML10011-May-16PFX - Unrealised Gains - CapitalCLP0.000.000000SGD35,000.00J3e

J4                  Settlement of Term Loan (Additional Drawdown)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0025-May-16BCash At BankCLP3,000,000,000.000.002482SGD7,446,000.00J4a
TML1001/0025-May-16BTML -BorrowingCLP-3,000,000,000.000.002482SGD-7,446,000.00J4b

Note J4a:          The exchange rate on 5-May-2016 is 0.002482 (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 - Borrowing - Interest ExpenseCLP77,010,000.000.002487SGD191,502.56J5a
TML100131-May-16BTML - Borrowing - Interest PayableCLP-77,010,000.000.002482SGD-191,138.82J5b
TML100131-May-16PFX - Unrealised Gains - RevenueCLP0.000.000000SGD-363.74J5c
TML100131-May-16BTML - BorrowingCLP0.000.000000SGD91,000.00J5d
TML100131-May-16PFX - Unrealised Gains - CapitalCLP0.000.000000SGD-91,000.00J5e

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

Note J5b:           Calculation of Accrual in CLP

Next Period Interest342,098,889.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 (CLP)
Avg Rate
Period Accrual (SGD)
8-Apr-165-May-16
7,000,000,000.00
6.04
27
27
1,141,560,000,000.00
1,141,560,000,000.00
31,710,000.00
0.002490
78,967.30
5-May-165-Jul-16
10,000,000,000.00
6.04
61
61
3,684,400,000,000.00
3,684,400,000,000.00
102,344,444.00
0.002482
253,985.35
5-Jul-165-Oct-16
12,500,000,000.00
6.04
92
92
6,946,000,000,000.00
6,946,000,000,000.00
192,944,445.00
0.002498
481,885.04
5-Oct-1611-Oct-16
15,000,000,000.00
6.04
6
6
543,600,000,000.00
543,600,000,000.00
15,100,000.00
0.002499
37,734.90
12,315,560,000,000.00
342,098,889.00
0.002492
852,572.59
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 Interest102,344,444.00C
Period Interest45,300,000.00D = C * A / B

                             Calculation of Accrual from 8-Apr to 31-May

8-Apr to 5-May31,710,000.00
5-May to 31-May45,300,000.00
Total Interest77,010,000.00

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

CLPRate+
SGD
At Closing Rate77,010,000.000.002482
191,138.82
At Average Rate77,010,000.000.002487
191,502.56
Gain in exchange
363.74

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

CLPRate+
SGD
8-Apr to 4-May31,710,000.000.002490
78,967.30
5-May to 31-May45,300,000.000.002484
112,535.27
77,010,000.000.002487
191,502.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 loan is analyzed as follows:

CLPRate+
SGD
At Closing Rate10,000,000,000.000.002482
24,820,000.00
At Start Date7,000,000,000.000.002495
17,465,000.00
At Start Date3,000,000,000.000.002482
7,446,000.00
Gain in exchange
91,000.00

+ 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 - Borrowing - Interest ExpenseCLP-77,010,000.000.002487SGD-191,502.56J6a
TML10011-Jun-16BTML - Borrowing - Interest PayableCLP77,010,000.000.002482SGD191,138.82J6b
TML10011-Jun-16PFX - Unrealised Gains - RevenueCLP0.000.000000SGD363.74J6c
TML10011-Jun-16BTML - BorrowingCLP0.000.000000SGD-91,000.00J6d
TML10011-Jun-16PFX - Unrealised Gains - CapitalCLP0.000.000000SGD91,000.00J6e

J7                  Settlement of Term Loan (Additional Drawdown)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0035-Jul-16BCash At BankCLP2,500,000,000.000.002487SGD6,217,500.00J7a
TML1001/0035-Jul-16BTML -BorrowingCLP-2,500,000,000.000.002487SGD-6,217,500.00J7b

Note J7a:          The exchange rate on 5-Jul-2016 is 0.002487 (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 - Borrowing - Interest ExpenseCLP190,679,444.000.002487SGD474,179.59J8a
TML100131-Jul-16BTML - Borrowing - Interest PayableCLP-190,679,444.000.002500SGD-476,698.61J8b
TML100131-Jul-16PFX - Unrealised Losses - RevenueCLP0.000.000000SGD2,519.02J8c
TML100131-Jul-16BTML - BorrowingCLP0.000.000000SGD-121,500.00J8d
TML100131-Jul-16PFX - Unrealised Losses - CapitalCLP0.000.000000SGD121,500.00J8e

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

Note J8b:           Calculation of Accrual in CLP

Next Period Interest342,098,889.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 (CLP)
Avg Rate
Period Accrual (SGD)
8-Apr-165-May-16
7,000,000,000.00
6.04
27
27
1,141,560,000,000.00
1,141,560,000,000.00
31,710,000.00
0.002490
78,967.30
5-May-165-Jul-16
10,000,000,000.00
6.04
61
61
3,684,400,000,000.00
3,684,400,000,000.00
102,344,444.00
0.002482
253,985.35
5-Jul-165-Oct-16
12,500,000,000.00
6.04
92
92
6,946,000,000,000.00
6,946,000,000,000.00
192,944,445.00
0.002498
481,885.04
5-Oct-1611-Oct-16
15,000,000,000.00
6.04
6
6
543,600,000,000.00
543,600,000,000.00
15,100,000.00
0.002499
37,734.90
12,315,560,000,000.00
342,098,889.00
0.002492
852,572.59
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 Interest192,944,445.00C
Period Interest56,625,000.00D = C * A / B

                             Calculation of Accrual from 8-Apr to 31-Jul

8-Apr to 5-May31,710,000.00
5-May to 5-Jul102,344,444.00
5-Jul to 31-Jul56,625,000.00
Total Interest190,679,444.00

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

CLPRate+
SGD
At Closing Rate190,679,444.000.002500
476,698.61
At Average Rate190,679,444.000.002487
474,179.59
Loss in exchange
-2,519.02

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

CLPRate+
SGD
8-Apr to 5-May31,710,000.000.002490
78,967.30
5-May to 5-Jul102,344,444.000.002482
253,985.35
5-Jul to 31-Jul56,625,000.000.002494
141,226.94
190,679,444.000.002487
474,179.59

+ 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 loan is analyzed as follows:

CLPRate+
SGD
At Closing Rate12,500,000,000.000.002500
31,250,000.00
At Start Date7,000,000,000.000.002495
17,465,000.00
At Start Date3,000,000,000.000.002482
7,446,000.00
At Start Date2,500,000,000.000.002487
6,217,500.00
Loss in exchange
-121,500.00

+ 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 - Borrowing - Interest ExpenseCLP-190,679,444.000.002487SGD-474,179.59J9a
TML10011-Aug-16BTML - Borrowing - Interest PayableCLP190,679,444.000.002500SGD476,698.61J9b
TML10011-Aug-16PFX - Unrealised Losses - RevenueCLP0.000.000000SGD-2,519.02J9c
TML10011-Aug-16BTML - BorrowingCLP0.000.000000SGD121,500.00J9d
TML10011-Aug-16PFX - Unrealised Losses - CapitalCLP0.000.000000SGD-121,500.00J9e

J10               Settlement of Term Loan (Additional Drawdown)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0045-Oct-16BCash at BankCLP2,500,000,000.000.002499SGD6,247,500.00J10a
TML1001/0045-Oct-16BTML -BorrowingCLP-2,500,000,000.000.002499SGD-6,247,500.00J10b

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

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

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/00511-Oct-16BTML - BorrowingCLP5,000,000,000.000.002495SGD12,475,000.00J11a
TML1001/00511-Oct-16PTML - Borrowing - Interest ExpenseCLP342,098,889.000.002492SGD852,572.59J11b
TML1001/00511-Oct-16BCash at BankCLP-5,342,098,889.000.002499SGD-13,349,905.12J11c
TML1001/00511-Oct-16PFX - Realised Losses - CapitalCLP0.000.000000SGD20,000.00J11d
TML1001/00511-Oct-16PFX - Realised Losses - RevenueCLP0.000.000000SGD2,332.53J11e

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

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

CLPRate+
SGD
At Closing Rate5,000,000,000.000.002499
12,495,000.00
At Start Date5,000,000,000.000.002495
12,475,000.00
Loss in exchange
-20,000.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 expense is analyzed as follows:

Next Period Interest342,098,889.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 (CLP)
Avg Rate
Period Accrual (SGD)
8-Apr-165-May-16
7,000,000,000.00
6.04
27
27
1,141,560,000,000.00
1,141,560,000,000.00
31,710,000.00
0.002490
78,967.30
5-May-165-Jul-16
10,000,000,000.00
6.04
61
61
3,684,400,000,000.00
3,684,400,000,000.00
102,344,444.00
0.002482
253,985.35
5-Jul-165-Oct-16
12,500,000,000.00
6.04
92
92
6,946,000,000,000.00
6,946,000,000,000.00
192,944,445.00
0.002498
481,885.04
5-Oct-1611-Oct-16
15,000,000,000.00
6.04
6
6
543,600,000,000.00
543,600,000,000.00
15,100,000.00
0.002499
37,734.90
12,315,560,000,000.00
342,098,889.00
0.002492
852,572.59
M
CLPRate+
SGD
At Closing Rate342,098,889.000.002499
854,905.12
At Average Rate342,098,889.000.002492
852,572.59
Loss in exchange
-2,332.53

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

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

CLPRate+
SGD
8-Apr to 5-May31,710,000.000.002490
78,967.30
5-May to 5-Jul102,344,444.000.002482
253,985.35
5-Jul to 5-Oct192,944,445.000.002498
481,885.04
5-Oct to 11-Oct15,100,000.000.002499
37,734.90
342,098,889.000.002492
852,572.59

J12                 Month End Term Loan Accruals

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML100131-Oct-16PTML - Borrowing - Interest ExpenseCLP35,233,333.000.002501SGD88,128.63J12a
TML100131-Oct-16BTML - Borrowing - Interest PayableCLP-35,233,333.000.002496SGD-87,942.40J12b
TML100131-Oct-16PFX - Unrealised Gains - RevenueCLP0.000.000000SGD-186.23J12c
TML100131-Oct-16BTML - BorrowingCLP0.000.000000SGD-59,000.00J12d
TML100131-Oct-16PFX - Unrealised Losses - CapitalCLP0.000.000000SGD59,000.00J12e

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

Note J12b:         Calculation of Accrual in CLP

Outstanding Principal10,000,000,000.00A
Interest Rate6.040000%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 Interest303,677,778.00I
Period Interest35,233,333.00J = I / G * F

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

CLPRate+
SGD
At Closing Rate35,233,333.000.002496
87,942.40
At Average Rate35,233,333.000.002501
88,128.63
Gain in exchange
186.23

+ 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 loan is analyzed as follows:

CLPRate+
SGD
At Closing Rate10,000,000,000.000.002496
24,960,000.00
At Start Date2,000,000,000.000.002495
4,990,000.00
At Start Date3,000,000,000.000.002482
7,446,000.00
At Start Date2,500,000,000.000.002487
6,217,500.00
At Start Date2,500,000,000.000.002499
6,247,500.00
Loss in exchange
-59,000.00

+ 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 - Borrowing - Interest ExpenseCLP-35,233,333.000.002501SGD-88,128.63J13a
TML10011-Nov-16BTML - Borrowing - Interest PayableCLP35,233,333.000.002496SGD87,942.40J13b
TML10011-Nov-16PFX - Unrealised Gains - RevenueCLP0.000.000000SGD186.23J13c
TML10011-Nov-16BTML - BorrowingCLP0.000.000000SGD59,000.00J13d
TML10011-Nov-16PFX - Unrealised Losses - CapitalCLP0.000.000000SGD-59,000.00J13e

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

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/00610-Apr-17BTML - BorrowingCLP6,000,000,000.000.002487SGD14,923,000.00J14a
TML1001/00610-Apr-17PTML - Borrowing - Interest ExpenseCLP303,677,778.000.002521SGD765,593.49J14b
TML1001/00610-Apr-17BCash at BankCLP-6,303,677,778.000.002554SGD-16,099,593.05J14c
TML1001/00610-Apr-17PFX - Realised Losses - CapitalCLP0.000.000000SGD401,000.00J14d
TML1001/00610-Apr-17PFX - Realised Losses - RevenueCLP0.000.000000SGD9,999.56J14e

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

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

CLPRate+
SGD
At Closing Rate6,000,000,000.000.002554
15,324,000.00
At Start Date6,000,000,000.000.002487
14,923,000.00
Loss in exchange
-401,000.00

                              Breakdown analysis of principal drawdown at different start date:

At Start Date2,000,000,000.000.002495
4,990,000.00
At Start Date3,000,000,000.000.002482
7,446,000.00
At Start Date1,000,000,000.000.002487
2,487,000.00
6,000,000,000.000.002487
14,923,000.00

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

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

CLPRate+
SGD
At Closing Rate303,677,778.000.002554
775,593.05
At Average Rate303,677,778.000.002521
765,593.49
Loss in exchange
-9,999.56

+ 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 - Borrowing - Interest ExpenseCLP14,093,333.000.002538SGD35,766.19J15a
TML100130-Apr-17BTML - Borrowing - Interest PayableCLP-14,093,333.000.002537SGD-35,754.79J15b
TML100130-Apr-17PFX - Unrealised Gains - RevenueCLP0.000.000000SGD-11.40J15c
TML100130-Apr-17BTML - BorrowingCLP0.000.000000SGD-170,000.00J15d
TML100130-Apr-17PFX - Unrealised Losses - CapitalCLP0.000.000000SGD170,000.00J15e

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

Note J15b:        Calculation of Accrual in CLP 

Outstanding Principal4,000,000,000.00A
Interest Rate6.040000%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 Interest122,813,333.00I
Period Interest14,093,333.00J = I / G * F

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

CLPRate+
SGD
At Closing Rate14,093,333.000.002537
35,754.79
At Average Rate14,093,333.000.002538
35,766.19
Gain in exchange
11.40

+ 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 loan is analyzed as follows:

CLPRate+
SGD
At Closing Rate4,000,000,000.000.002537
10,148,000.00
At Start Date1,500,000,000.000.002487
3,730,500.00
At Start Date2,500,000,000.000.002499
6,247,500.00
Loss in exchange
-170,000.00

+ 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 - Borrowing - Interest ExpenseCLP-14,093,333.000.002538SGD-35,766.19J16a
TML10011-May-17BTML - Borrowing - Interest PayableCLP14,093,333.000.002537SGD35,754.79J16b
TML10011-May-17PFX - Unrealised Gains - RevenueCLP0.000.000000SGD11.40J16c
TML10011-May-17BTML - BorrowingCLP0.000.000000SGD170,000.00J16d
TML10011-May-17PFX - Unrealised Losses - CapitalCLP0.000.000000SGD-170,000.00J16e

J17                 Interest Settlement of Term Loan (Repay I)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/00610-Oct-17PTML - Borrowing - Interest ExpenseCLP122,813,333.000.002529SGD310,630.49J17a
TML1001/00610-Oct-17BCash at BankCLP-122,813,333.000.002513SGD-308,629.91J17b
TML1001/00610-Oct-17PFX - Realised Gains - RevenueCLP0.000.000000SGD-2,000.58J17c

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

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

CLPRate+
SGD
At Closing Rate122,813,333.000.002513
308,629.91
At Average Rate122,813,333.000.002529
310,630.49
Gain in exchange
2,000.58

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

J18                 Interest Settlement of Term Loan (Repay I)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0079-Apr-18PTML - Borrowing - Interest ExpenseCLP121,471,111.000.002506SGD304,447.54J18a
TML1001/0079-Apr-18BCash at BankCLP-121,471,111.000.002501SGD-303,799.25J18b
TML1001/0079-Apr-18PFX - Realised Gains - RevenueCLP0.000.000000SGD-648.29J18c

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

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

CLPRate+
SGD
At Closing Rate121,471,111.000.002501
303,799.25
At Average Rate121,471,111.000.002506
304,447.54
Gain in exchange
648.29

+ 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 - Borrowing - Interest ExpenseCLP55,702,222.000.002507SGD139,646.81J19a
TML100130-Jun-18BTML - Borrowing - Interest PayableCLP-55,702,222.000.002511SGD-139,868.28J19b
TML100130-Jun-18PFX - Unrealised Losses - RevenueCLP0.000.000000SGD221.47J19c
TML100130-Jun-18BTML - BorrowingCLP0.000.000000SGD-66,000.00J19d
TML100130-Jun-18PFX - Unrealised Losses - CapitalCLP0.000.000000SGD66,000.00J19e

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

Note J19b:         Calculation of Accrual in CLP

Outstanding Principal4,000,000,000.00A
Interest Rate6.040000%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 Interest122,813,333.00I
Period Interest55,702,222.00J = I / G * F

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

CLPRate+
SGD
At Closing Rate55,702,222.000.002511
139,868.28
At Average Rate55,702,222.000.002507
139,646.81
Loss in exchange
-221.47

+ 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 loan is analyzed as follows:

CLPRate+
SGD
At Closing Rate4,000,000,000.000.002511
10,044,000.00
At Start Date1,500,000,000.000.002487
3,730,500.00
At Start Date2,500,000,000.000.002499
6,247,500.00
Loss in exchange
-66,000.00

+ 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 - Borrowing - Interest ExpenseCLP-55,702,222.000.002507SGD-139,646.81J20a
TML10011-Jul-18BTML - Borrowing - Interest PayableCLP55,702,222.000.002511SGD139,868.28J20b
TML10011-Jul-18PFX - Unrealised Losses - RevenueCLP0.000.000000SGD-221.47J20c
TML10011-Jul-18BTML - BorrowingCLP0.000.000000SGD66,000.00J20d
TML10011-Jul-18PFX - Unrealised Losses - CapitalCLP0.000.000000SGD-66,000.00J20e

J21                 Interest Settlement of Term Loan (Repay I)

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0089-Oct-18PTML - Borrowing - Interest ExpenseCLP122,813,333.000.002499SGD306,898.44J21a
TML1001/0089-Oct-18BCash at BankCLP-122,813,333.000.002482SGD-304,822.69J21b
TML1001/0089-Oct-18PFX - Realised Gains - RevenueCLP0.000.000000SGD-2,075.75J21c

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

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

CLPRate+
SGD
At Closing Rate122,813,333.000.002482
304,822.69
At Average Rate122,813,333.000.002499
306,898.44
Gain in exchange
2,075.75

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

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

TradeIDPostDateB/PAccountCcyCcy Amt D/(CR)RateBaseBase Amt D/(CR)Line
TML1001/0098-Apr-19BTML - BorrowingCLP4,000,000,000.000.002495SGD9,978,000.00J22a
TML1001/0098-Apr-19PTML - Borrowing - Interest ExpenseCLP121,471,111.000.002513SGD305,307.91J22b
TML1001/0098-Apr-19BCash at BankCLP-4,121,471,111.000.002523SGD-10,398,471.61J22c
TML1001/0098-Apr-19PFX - Realised Losses - CapitalCLP0.000.000000SGD114,000.00J22d
TML1001/0098-Apr-19PFX - Realised Losses - RevenueCLP0.000.000000SGD1,163.70J22e

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

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

CLPRate+
SGD
At Closing Rate4,000,000,000.000.002523
10,092,000.00
At Start Date4,000,000,000.000.002495
9,978,000.00
Loss in exchange
-114,000.00

                              Breakdown analysis of principal drawdown at different start date:

At Start Date1,500,000,000.000.002487
3,730,500.00
At Start Date2,500,000,000.000.002499
6,247,500.00
4,000,000,000.000.002495
9,978,000.00

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

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

CLPRate+
SGD
At Closing Rate121,471,111.000.002523
306,471.61
At Average Rate121,471,111.000.002513
305,307.91
Loss in exchange
-1,163.70

+ 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

DateCLP/SGD
1-Apr-160.002495
16-Apr-160.002490
1-May-160.002482
16-May-160.002486
31-May-160.002482
15-Jun-160.002475
30-Jun-160.002487
15-Jul-160.002498
30-Jul-160.002500
14-Aug-160.002508
29-Aug-160.002499
13-Sep-160.002489
28-Sep-160.002499
13-Oct-160.002503
28-Oct-160.002496
27-Nov-160.002511
12-Dec-160.002511
11-Jan-170.002525
10-Feb-170.002536
12-Mar-170.002554
11-Apr-170.002537
11-May-170.002542
10-Jun-170.002532
10-Jul-170.002520
9-Aug-170.002528
8-Sep-170.002517
8-Oct-170.002513
7-Nov-170.002510
7-Dec-170.002504
6-Jan-180.002499
5-Feb-180.002506
7-Mar-180.002507
6-Apr-180.002501
6-May-180.002509
5-Jun-180.002511
5-Jul-180.002496
4-Aug-180.002489
3-Sep-180.002491
3-Oct-180.002482
2-Nov-180.002492
2-Dec-180.002505
1-Jan-190.002520
31-Jan-190.002531
15-Feb-190.002541
2-Mar-190.002537
1-Apr-190.002523

Average

From DateTo DateCLP/SGD
8-Apr-1630-Apr-160.002492
8-Apr-165-May-160.002490
5-May-1631-May-160.002484
5-May-165-Jul-160.002482
5-Jul-1631-Jul-160.002494
5-Jul-165-Oct-160.002498
5-Oct-1611-Oct-160.002499
11-Oct-1631-Oct-160.002501
11-Oct-1610-Apr-170.002521
10-Apr-1730-Apr-170.002538
10-Apr-1710-Oct-170.002529
10-Oct-179-Apr-180.002506
9-Apr-1830-Jun-180.002507
9-Apr-189-Oct-180.002499
9-Oct-188-Apr-190.002513

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

FREQUENTLY ASKED QUESTIONS

RELATED INFORMATION

CHANGE HISTORY

DateByChanges
12-Jun-2017TSCreation.
07-May-2020LTRe-formatting.
Categories:

0 Comments

Leave a Reply

blank

Your email address will not be published.



    Close Bitnami banner
    Bitnami