11.2.13 Weighted Average Perpetual

This method calculates the simple weighted average of the applicable balance based on maturity bands defined through a Behavior Pattern. In the following example, the end of period balance as of Jan 31 is split into Core and Volatile strips, and the relevant rates are applied to arrive at the weighted average Transfer Rate.

Table 11-8 BEHAVIORAL PATTERN: 20% 1 Month; 80% 3 Months

Run Date EOP Balance 1M Strip 3M Strip 1M Rate 3M Rate TP Rate
Jan 31 100000 20000 80000 3.10% 3.50% 3.42%
Feb 28 200000 40000 160000 3.25% 3.60% 3.53%
Mar 31 300000 60000 240000 3.20% 3.55% 3.48%
Transfer Rate = (20000*3.10% + 80000*3.50%) / 100000 = 3.42%
  • Behavior Pattern: Select the Behavior Pattern that is associated with the Product / Currency combination being defined.
  • Interest Rate Code: Select the Interest Rate Code, which you want to use as the transfer pricing yield curve.

Note:

The Weighted Average Perpetual method applies to both instrument balances and ledger balances.