Report 3104 : Term Loan Period Interest Analysis (W5)

This version is superseded. Click here to view the latest guide.

PURPOSE

To provide the details used by CS Lucas to show Term Loan Period Interest Analysis.

WHY IS THIS IMPORTANT?

Allow users to verify the details of Term Loan Period Interest Analysis.

QUERY

1. Navigate to Reporting > Standard > Report 3104: Term Loan Period Interest Analysis.

2. Fill in the mandatory parameter – Accounting Centre/ Group, From Date, To Date, Reporting Currency, Rate Type.

3. Click on the required format.

4. The report shows interests for term loan transactions for selected period. Column fields available on report are Accounting Centre, Portfolio, Trade ID, VDate, Counterparty ID, Currency, Interest Accrual in the Trade Currency as at the From Date, Interest Accrual in the Trade Currency as at the To Date, Interest Paid in the Trade Currency within the period, Period Charge in the Trade Currency, Exchange Rate on the From Date, Exchange Rate on the To Date, Reporting Currency, Interest Accrual in the Reporting Currency as at the From Date, Interest Accrual in the Reporting Currency as at the To Date, Interest Paid in the Reporting Currency within the period and Period Charge in the Reporting Currency.

For explanation of  button, please see link.

For explanation of  buttons, please see link.

DATA SOURCE

To view the following transaction,

Follow the steps as shown below:

1. Navigate to Transaction > Term Loan.

2. Select Acct Cntr* (From example: TFS-SG).

3. Key in MDate Fr* (From example: 1-Jun-2017).

4. Click Refresh.

5. A = Interest Accrual to 30-Jun-2017. To see how interest accruals is computed, see Accounting Treatment for Term Loan.

6. B = Interest Accrual to 31-Jul-2017. To see how interest accruals is computed, see Accounting Treatment for Term Loan.

7. C = Interest Paid in between the reporting period (from 30-Jun-2017 to 31-Jul-2017). There is no interest paid within this period. See Term Loan Repayment Schedule above.

8. D = B – A + C

FREQUENTLY ASKED QUESTIONS

RELATED INFORMATION

Accounting Treatment for Term Loan

CHANGE HISTORY