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 Action and select 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 Excel Raw export, 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: 30-Jun-2017).
4. Click Refresh.
5. Click the Edit button for trade TML100001.00.
6. Click on Repayment in Amend Term Loan Page.
7. A = Interest Accrual to 30-Jun-2017. To see how interest accruals is computed, see Accounting Treatment for Term Loan.
8. B = Interest Accrual to 31-Jul-2017. To see how interest accruals is computed, see Accounting Treatment for Term Loan.
9. 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.
10. D = B – A + C
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
Accounting Treatment for Term Loan
CHANGE HISTORY
0 Comments