Treasury Systems has full support to calculate compounded interest amount for the new risk free interest rates e.g. SONIA, €STR, SOFR. It works for all floating rate instrument such as Loan, Bank account interest, Interest rate swap, Caps and Floors.
Market data set up
- Open market data set up and add the new Fixing index
- Enter the number of days in Lookback. If you will have different Lookback days for different instruments you need to define one fixing index for each Lookback day. See print screen below.
- Interest form: How the market date is defined and imported. For compounded in arrears set Not set.
- Tick Compounded in arrears (to calculate the interest amount as compounded)
Lookback: How many business days prior to the interest period should the interest be fetched from (fixing date) usually 2D or 5D. The number of days to use as Lookback needs to be is defined in market data setup.
When entering the Loan the different defined Lookback days will be shown in Fixing index.
Observation shift: is the date period from when the interest rates has been set. If the interest amount should be calculated on the observation shift period then you need to tick observation shift when entering the loan. If the interest should be calculated on the normal interest period do not tick this box.
Spread add the counterparty spread and if applicable the CAS (Credit Adjustment Spread) and enter it in the spread field. The spread is not calculated as compounded in arrears.
The field ACR DECIMALS stands for Annualised Cumulative compounded RFR and default in TS is 6 decimals. If the counterparty is using more then you need to add the total number of decimals so the interest amount will be the same as the bank.
The rate showed
New report columns available
- Cumulative interest days
- Cumulative observation days
- Observation days
- Observation shift
- Observation start date
- Fixing rate (shows the fixing rate from interest rate table)
- Base interest shows the acual interest the amount is calculated on.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article