This version is superseded. Click here to view the latest guide.
PURPOSE
This document shows the detailed procedure of importing term loan transactions.
WHY IS THIS IMPORTANT?
This is important because this saves time for the user when there are a lot of trades that need to be inputted into the system quickly. The import feature allows also users to import Term Loan transactions with irregular repayment schedules that agreed with counterparty.
PROCEDURE
1. From the Term Loan menu, click New. The New Term Loan screen is displayed.
2. Click Import. The Import Term Loan screen is displayed.
3. Click Template to download the Load_TL_Template in Excel format to your computer.
4. After the import template is successfully downloaded, open the import template.
5. There are two tabs in the Load_TL_Template. They are “TL_Trades” and “TL_Structure”. If you wish to load the Term Loan transaction without a pre-set repayment schedule and wish the system to automatically generate the repayment schedule, fill in only the “TL_Trades” tab. If you wish to load Term Loan transactions with a specific repayment schedule, fill in both “TL_Trades” and “TL_Structure” tabs.
6. The followings explain the fields in the “TL_Trades” tab. Note that fields that marked with an asterisk (*) are mandatory.
Ref
This is reference for the transaction being inputted. The Excel file has two tabs, “TL_Trades” and “TL_Structure”, the reference lets the system know that the term loan trade is associated with the term loan repayment schedule on the other tab. In this example, TL_A will be the reference code.
Borrow/Lend*
Type either Borrow or Lend for the transaction.
Acct Cntr*
Type the accounting centre for this transaction. Make sure to type it in exactly as it was set up in the system. In this example, it will be ACO4.
FacilitySN*
Type the Facility short name as how it was set up. In this example, it will be ACO4<DBS-TL.
TDate*
This is the transaction date when the contract is made between parties. The date format can be any Excel dates format.
VDate*
This is the start date of the transaction. VDate cannot be earlier than TDate. The date format can be any Excel dates format.
MDate*
This is the maturity date of the transaction. MDate cannot be earlier than VDate. The date format can be any Excel dates format.
First Coupon
Non-mandatory. This is to adjust the first interest repayment date.
Ccy*
Type the transaction currency as it is set up in the system. In this example, SGD will be used.
Principal*
Type the amount of the transaction.
Reset Rate(%)*
Type in the fixed interest rate or the inception rate at the point the transaction is made for floating rate loan. The rate inputted must be the All-in-Rate.
Cap Rate
This is to set the cap rate. If the rate goes above the cap rate, system will set to the cap rate.
Floor Rate
This is to set the floor rate. If the rate goes below the floor rate, system will set to the floor rate.
Margin(%)*
Input 0 if there is no margin interest rate.
Float Basis*
Type the values according to what has been set up in the user definable menu, to know how to set this up, click here. In this example, one will use Sibor 6 mth.
For a fixed loan, input as “-FIXED-“.
Frequency*
Type in the repayment frequency: Annual, Daily, Monthly, Quarterly, Semi-Annual or Weekly.
Day Convention
Non-mandatory. To learn more about this, check the user guide Day Convention for Dates Generation.
Leave blank will default to No Adjustment.
Settle Convention
Non-mandatory. To learn more about this, check the user guide Day Convention for Dates Generation.
Leave blank will default to No Adjustment.
Reset Convention
Non-mandatory. To learn more about this, check the user guide Day Convention for Dates Generation.
Leave blank will default to No Adjustment.
Reset Days
Non-mandatory. This is to set the number of days before the next interest reset. Default is 0.
ActualDealerID*
This must be the user id set up in the system.
Accruals
Non-mandatory. Leave blank will default to default accrual method set up as per the currency. See Currency Set Up.
Repayment Style*
Bullet or Regular Principal. For bullet repayment, interest is repaid periodically and principal is repaid on maturity. With the regular principal basis, the size of the principal payment is the same for every payment. It is computed by dividing the amount of the original loan by the number of payments. Interest is computed on the amount of the unpaid balance of the loan at each payment period.
CtpyDealer
Non-mandatory. Type in the counterparty dealer’s name.
Portfolio
Non-mandatory. This is used for transaction tagging purposes. The value inputted must be same as set up in the Portfolio. See Portfolio set up.
Project
Non-mandatory. This is user-definable. See how to set this up here.
SubType
Non-mandatory. This is user-definable. See how to set this up here.
Narrative
Non-mandatory. Type in trade narrative if any.
AcctCntr Division
Non-mandatory. Fill in only if is required for accounting integration purposes.
Ctpy Division
Non-mandatory. Fill in only if is required for accounting integration purposes.
WHTType
Non-mandatory. Fill in only if is required for accounting integration purposes.
7. Next, to set the repayment schedules of your Term Loan trades, fill in the “TL_Strucure” tab. The followings explain the fields in this tab. Fields marked with asterisk (*) are mandatory.
Ref*
Type in the reference code, make sure it is the same as in the “TL_Trades” tab for system to link the Term Loan trade and its repayment schedule.
Principal Type*
Input whether it is a “Drawdown” or “Repayment”. The first item of each repayment schedule must be a “Drawdown”.
End Date*
Type in the End Date. End date is used for interest computation. There is no need to input start date because the start date is always the previous End Date.
VDate*
Type in the Value Date. This is the settlement date.
Interest Rate(%)*
Type in the interest rate/ reset rate.
Principal Amt*
Type in the principal amount if there is a drawdown or repayment of principal. Input 0 if there is no principal repayment.
Interest Amt*
Type in the interest amount if there is repayment of interest. Input 0 if no interest repayment.
Capitalise Amt*
Type in the interest amount to be capitalised in this field. Input 0 if there is no interest to be capitalised.
8. A sample of the Term Loan import template is as per below. Click here to retrieve the sample import file.
TL_Trade
TL_Structure
9. When completed, save the Term Loan import file.
10. In the CS Lucas system, tick the check box Read File. The screen will be displayed like below.
11. Click Browse to browse for the saved Term Loan import file.
12. Click Read File.
13. If there is error, the system will prompt with some explanations. Correct the errors in the Term Loan import file.
14. Once corrected, tick on the Read File checkbox to read the file again.
15. If no error detected, you will see the Load button in the Import screen.
16. Click Load to import the Term Loan trades. Click OK in the popup.
17. You will see the following confirmation message once loaded successfully.
18. Click Back Button to return to Term Loan screen.
19. From the Term Loan screen, select the appropriate Acct Cntr, MDate From and click Refresh. The transactions imported will be displayed.
20. Click on the TML100008.00, then click on Repayment. You will see the schedule generated automatically by the system for this trade. Amend from this screen if any changes need to be made after loading.
21. Click on the TML100013.00 which loaded with repayment schedule, you will see the repayment schedule is loaded as is from the import file you prepared. The interest amount will be locked in this case. This means system will not automatically recomputed the interest. Amend from this screen if any changes need to be made after loading.
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
Amend Term Loan and Repayments
Sample Term Loan Import Template
CHANGE HISTORY
0 Comments