Cash Flow: Average Life

6.3.4.1.1 Cash Flow: Average Life

The Average Life Method determines the average life of the instrument by calculating the Effective Term required to repay half of the principal or nominal amount of the instrument. The Transfer Pricing Rate is equivalent to the rate on the associated Interest Rate Curve corresponding to the calculated term.

Figure 6-52 Cash Flow: Average Life

Figure 6-53 Cash Flow: Average Life Formula

This illustration shows the formula to calculate Cash Flow: Average Life.

Oracle Funds Transfer Pricing Cloud Service derives the Average Life based on the Cash Flows of an instrument as determined by the characteristics specified in the Instrument Table and using your specified Prepayment Rate, if applicable. The average life formula calculates a single term, that is, a point on the yield curve used to transfer the price of the instrument being analyzed. The Average Life Calculation does not differentiate between fixed-rate and adjustable-rate instruments. It applies the same calculation logic to both. It computes the Average Life of the Loan (to maturity).

Note:

The Average Life method includes a checkbox that writes the calculated Average Life result back to the source Instrument table in the TP_AVERAGE_LIFE column. This option is available for both Transfer Rate and Add-On Rate calculations, enabling the calculated value to be retained with the instrument record for review, validation, and subsequent use in configured processing.

If this checkbox is selected, the calculated Average Life value is populated in the TP_AVERAGE_LIFE column and is used as-is without regenerating cash flows if same account is processed via Average Life method again. To perform a fresh Average Life calculation, ensure that TP_AVERAGE_LIFE is not already populated in the source data records.

Users also have the choice to populate the TP_AVERAGE_LIFE column directly with a value computed outside of Oracle Funds Transfer Pricing Cloud Service. If this value is populated, the Funds Transfer Pricing Cloud Service Engine reads the TP_AVERAGE_LIFE and will look up the Funds Transfer Pricing Rate for the given term. In this case, the Transfer Pricing Engine does not generate Cash Flows and will not re-compute the Average Life. It simply uses the value that is provided and lookup the appropriate Funds Transfer Pricing Rate from the specified TP Interest Rate Curve.