Import Term Loan

See previous W5 version 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 screen, click on Action and select New. The New Term Loan screen is displayed.

blank

2. Click Import. The Import Term Loan screen is displayed.

blank

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.

blank

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

blank

TL_Structure

blank

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.

blank

11. Click Browse to browse for the saved Term Loan import file.

blank

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.

blank

16. Click Load to import the Term Loan trades. Click Yes in the popup.

blank

17. You will see the following confirmation message once loaded successfully.

blank

18. Click Cancel 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. You may filter transactions by other non-mandatory fields that are available for selections.

blank

20. Click on the Edit button of TML100014.00, then click on Repayment. You will see the repayment schedule generated automatically by the system for this trade. Amend from this screen if any changes needed to be made after loading.

blank

21. Click on the TML100019.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 needed to be made after loading.

blank

FREQUENTLY ASKED QUESTIONS

 

RELATED INFORMATION

Create Term Loan

Amend Term Loan and Repayments

Sample Term Loan Import Template

CHANGE HISTORY

blank

Categories:

0 Comments

Leave a Reply

blank

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



    Close Bitnami banner
    Bitnami