PURPOSE
To provide the details used by CS Lucas to show the List of Outstanding Term Loan.
WHY IS THIS IMPORTANT?
Allow users to verify the details of Term Loan.
QUERY
1. Navigate to Report 2202: Outstanding Term Loan Listing.
2. Fill in mandatory parameters – Acct Cntr, As At and Rate Type.
3. Click Action and select the required format.
4. The report shows the Accounting Centre, Trade ID, Borrow/Lend, Counterparty, Portfolio ID, MDate, VDate, Rate Basis, Margin, Rate*, Currency, Principal (Transaction Amount), Balance, Accrued Interest, Accounting Centre’s Base Currency, Balance and Accrued Interest in Base Currency.
* If multiple rates apply within the repayment period, the latest available rate will be displayed in this report.
For explanation of Excel Raw export, please see link.
For explanation of buttons, please see link.
TERM LOAN DETAILS
1. Navigate to Transaction > Term Loan.
2. Key in MDate Fr* (From example: 30-Jun-2017).
3. Click Refresh. All Term Loan Trades maturing from 30-Jun-2017 are shown here.
TERM LOAN BALANCE
1. Click the Edit button for trade TML100001.00.
2. Click on Repayment in Amend Term Loan Page.
3. From the report, principal balance on 30-Jun-2017 (Input for Date As At* report parameter) is 300,000,000.00.
4. On the Amend Term Loan Repayment Page, look for the date before 30-Jun-2017. On 19-Jun-2017, the outstanding amount is 300,000,000.00.
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
CHANGE HISTORY
0 Comments