Function SecurityPeriodicAccruedInterest(SettlementDate, MaturityDate, ParValue, Frequency, CouponRate, Basis)


The function SecurityPeriodicAccruedInterest returns the accrued interest from the begin of the coupon period until the settlement date for a security that pays interest at the end of each coupon period.

    SettlementDate,           ! (input) scalar string expression
    MaturityDate,             ! (input) scalar string expression
    ParValue,                 ! (input) numerical expression
    Frequency,                ! (input) numerical expression
    CouponRate,               ! (input) numerical expression
    [Basis]                   ! (optional) numerical expression



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


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


The starting value of the security at issue date. ParValue must be a positive real number.


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


The annual interest rate of the security as a percentage of the par value. CouponRate must be a nonnegative real number.


The day-count basis method to be used. The default is 1.

Return Value

The function SecurityPeriodicAccruedInterest returns the interest accrued from the begin of the coupon period until settlement date.


This function can be used in an objective function or constraint and the input parameters ParValue and CouponRate can be used as a variable.

See also

Day count basis methods. General equations for securities with multiple coupons.