PURPOSE
To provide the details used by CS Lucas to show the Cost of Funds Computation – Summary by Product.
WHY IS THIS IMPORTANT?
Allow users to verify the details of Cost of Funds Computation – Summary by Product.
QUERY
1. Navigate to Reporting > Standards > Report 1203: Cost of Funds Computation – Summary by Product.
2. Fill in mandatory parameters – Acct Cntr, From Date, To Date, and Report Ccy. The rest are optional parameters.
3. Click on the required format.
4. The report shows the Product, Ccy, Total Principal, Average Principal, Period Interest, Avg IntRate%, Avg ExcRate, and Rpt Ccy Period Interest.
For explanation of button, please see link.
For explanation of buttons, please see link.
DATA SOURCE
To view the following transaction,
*Cost: Borrow/Loan, Money Market
Follow the steps as shown below:
1. Navigate to Reporting > Standards > Report 2008: Money Market Trade By Type.
2. Key in the fields as shown below:
3. Click on the required format. The results are as follows:
Calculations for Average Principal (D)
One example using SGD Borrow/Loan transactions:
For the first transaction,
For the second transaction,
For the total average principal,
Calculations for Period Interest (E)
One example using SGD Borrow/Loan transactions:
For the first transaction,
For the second transaction,
For the total period interest,
Calculations for Rpt Ccy Period Interest (H)
FREQUENTLY ASKED QUESTIONS
RELATED INFORMATION
CHANGE HISTORY
0 Comments