Determine Floating Rate Resets

Owned by Nancy Cohn (Deactivated)
Last updated: Jan 23, 2024
3 min read

Eagle Accounting begins using the Dated Date Rate of the underlying index plus any applicable index offset, from the period from Dated Date to the First Rate Reset. Floating Rates and Inverse Floating Rate securities do not automatically change to a new rate when the rate becomes available based on the underlying security's security alias in the Variable Rate table. Instead, rate changes are based on dates in the rate reset array, which are created using First Rate Reset Date, Reset Frequency, Business Calendar field, and the Business Day Convention.

Contrary to the coupon reference data used to build the regular coupon array, there is no last rate reset date available.

The Business Calendar field is implemented for all securities, not just Inverse Floaters/Floating Rates, and is required when you select a Business Day Convention or Day of Month Override field based on Business day.

You need to enter the interest rate for the underlying Index every day in order for correct floating rate calculations.

For floating rate securities established with any one of the following attributes: rate reset caps, rate reset floors, rate reset change caps, rate reset change floors, or eligible for OID processing, you must populate the interest rate of the underlying index from the earliest date between dated date and issue date. The reason for this is two-fold: Eagle Accounting needs to be able to calculate the coupon rate, and Eagle Accounting needs to be able to calculate an adjusted issue price.

Rate Reset Values

In addition, the rate reset array logic incorporates Look Back Days, the Rate Reset Cap, Rate Reset Floor, Rate Reset Change Cap, and Rate Reset Change Floor when setting the rate value for a given date. Note that the Rate Reset Change Cap and Floor values are a relative change from the last rate, while the Rate Reset Cap and Floor values are an absolute cap/floor. At each new date in the array, the earnings code checks the coupon value for the following:

  1. The new rate does not break the Rate Reset Change Cap/Floor rule. For example, if Current Rate is 4% and Rate Reset Change Cap is 1, a New Rate of 5.25% is not allowed, and instead the New Rate is 5%. Similarly, if Current Rate is 4%, Rate Reset Change Floor is 1.2 and New Rate from variable rate table is 2.5%, New Reset Rate is set at 2.8% (4 minus 1.2).

  2. The new rate does not go above or below the Rate Reset Cap or Floor. For example, if the Rate Reset Cap is 6% and the rate available from the Variable Rate Table is 6.2%, the New Rate is set at 6%.

  3. Both of the above tests must pass. For example, Current Rate is 5, Rate Reset Change Cap value is 1, and Rate Reset Cap value is 5.5; If the New Rate in variable rate table is 5.75, the rate in the Reset Array is set to 5.5.

Identify the Fixing Date

The coupon rate fixing date is the date for which the system selects a rate/price for use on the reset date. When you set the Reset Look back Days Type (tag 5075) field to Business Days, the system uses the fixing date business calendar specifies in the Fixing Date Business Center field to determine the fixing date. Eagle Accounting can use a fixing date calendar for a floating rate or inverse floating security that differs from the security's business calendar. The Earnings process uses the fixing date business calendar to determine the fixing date in order to use the correct rate/price in the calculation of income.

If you do not specify a fixing date business calendar for a security, the Earnings process uses the security's business calendar. If the business calendar is not available, the Earnings process uses the calendar associated with the security's issue country to derive the valid business day in the interest rate fixing process.

Eagle Accounting Earnings

When calculating the amortization yield of either a floating rate or a variable rate security, Eagle Accounting uses the most recent coupon rate, and projects that rate forward for the calculation of future cash flows. Whenever the coupon rate of the security changes in the current coupon period, Eagle Accounting automatically recalculates the yield using the new coupon rate, and uses the new coupon rate in the projection of future cash flows.

Â