Report 1204: Cost of Funds Computation – Detail by Product

PURPOSE

To provide the details used by CS Lucas to show the Cost of Funds Computation – Detail by Product.

WHY IS THIS IMPORTANT?

Allow users to verify the details of Cost of Funds Computation – Detail by Product.

QUERY

1. Navigate to Reporting > Standard > Report 1204: Cost of Funds Computation – Detail 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 ST/LT, Ccy, Cost/Yield, Product, Acct Cntr, Ctpy, Trade ID, 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.

Money Market Computation

To view the following transaction,

Follow the steps as shown below:

1. Navigate to Transactions > Money Market.

2. Select the Acct Cntr* (Example: TFS-SG).

3. Key in MDate From* (Example: 01/01/2014).

4. Click Refresh.

Calculations for Average Principal (I)

One example using SGD Borrow/Loan transaction:

Calculations for Period Interest (J)

One example using SGD Borrow/Loan transaction:

Calculations for Rpt Ccy Period Interest (M)

Term Loan Computation

To view the following transaction,

Follow the steps as shown below:

1. Navigate to Reporting > Standards > Report 2201: Outstanding Term Loan.

2. Key in the fields as shown below:

3. Click on the required format. The results are as follows:

Calculations for Average Principal (I)

One example using SGD Borrow/Loan transaction:

Calculations for Period Interest (J)

One example using SGD Borrow/Loan transaction:

Calculations for Rpt Ccy Period Interest (M)

FREQUENTLY ASKED QUESTIONS

 

RELATED INFORMATION

 

CHANGE HISTORY