Function SecurityCouponNextDate(SettlementDate, MaturityDate, Frequency, NextDate)

SecurityCouponNextDate

The function SecurityCouponNextDate returns the first coupon-date next to settlement date of a security that pays interest at the end of each coupon period.

SecurityCouponNextDate(
    SettlementDate,           ! (input) scalar string expression
    MaturityDate,             ! (input) scalar string expression
    Frequency                 ! (input) numerical expression
    NextDate                  ! (output) string parameter
    )

Arguments

SettlementDate

The date of settlement of the security. SettlementDate must be in date format.

MaturityDate

The date of maturity of the security. MaturityDate must also be in date format and must be a date after SettlementDate.

Frequency

The number of coupon payments in one year. Frequency must be 1 (annual), 2 (semi-annual) or 4 (quarterly).

NextDate

The date on which the coupon period ends and on which the next coupon period starts.

Note

The function SecurityCouponNextDate is similar to the Excel function COUPNCD.

See also

General equations for securities with multiple coupons.