Calculate Coupon Dates Processing Notes

Owned by Jawann Swislow, created
Last updated: Aug 25, 2024
1 min read

First Coupon Date (473) and Last Coupon Date (474) are required fields for all securities that leverage the fixed income code. These fields have different names for some swaps:

  • First Payment Date and Last Payment Date

  • First Payment/Valuation Date and Last Payment/Valuation Date

When using a Business Day Convention (1536) that adjusts the length of the accrual period if ends on a non-business day, Eagle Accounting requires that adjusted/actual First Coupon Date and Last Coupon Date be entered on the security master file (SMF). Other date conventions that may adjust the length of the accrual period are Day of Month Override (1533) and Interest Payment Timing (1523).

If the adjusted dates are not available during SMF setup, Eagle Accounting has functionality to calculate them based on the date-related reference data. This is used most often for swaps because they typically have a Business Day Convention of Modified Following - Ajdusted. The unadjusted First Coupon Date must be provided, which will then be adjusted and the Last Coupon Date will be populated. The fields below drive the calculation.

  • Business Day Convention (1536), Day of Month Override (1533), or Interest Payment Timing (1523)

    • Coupon Day of Month (10551) if Business Day Convention is used

  • Business Calendar (1480)

  • Coupon Delay Days (4908) if Coupon Delay Days Type (3999) = B (Business)

  • Dated Date (1183): the adjusted/actual date must be provided, it cannot be calculated

  • First Coupon Date (473): enter the unadjusted date

  • Last Coupon Date (474): leave null

  • Maturity Date (38): the adjusted/actual date must be provided, it cannot be calculated

  • Calculate First/Last Coupon Dates (2301): after populating all other date-related details, set to Y in your message or select Calculate First/Last Coupon Dates

    • The field name is Calculate First/Last Payment Dates for TRS

    • The field is hidden in some screens

See attached credit default index swap (CDX) loader for an example: . It should not be populated for multi-leg swap contracts.

Calculate/Validate Last Coupon Date (2337) can be used instead if the adjusted First Coupon Date is available and you only need to calculate the Last Coupon Date. Set it to Y in your message or select Calculate Last Coupon Date instead of populating Calculate First/Last Coupon Dates.