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 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: life time caps, life time floors, periodic caps, periodic 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 Lifetime Cap, Lifetime Floor, Periodic Cap, and Periodic Floor when setting the rate value for a given date. Note that the Period Cap and Floor values are a relative change from the last rate, while the Lifetime 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:
- The new rate does not break the Period Cap/Floor rule. For example, if Current Rate is 4% and Periodic 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%, Periodic 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).
- The new rate does not go above or below the Lifetime Cap or Floor. For example, if the Lifetime Cap is 6% and the rate available from the Variable Rate Table is 6.2%, the New Rate is set at 6%.
- Both of the above tests must pass. For example, Current Rate is 5, Periodic Cap value is 1, and Lifetime 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.
Add Comment