COUPON.NUM function

Category:Financial

Name in English:COUPNUM

That makes?

Returns the number of coupon payments between the settlement date and the due date.

Syntax

COUPON.NUM (settlement, expiration, frequency, [base])

  • Settlement (mandatory ): The settlement date of the security.
  • maturity (required ): The maturity date of the security.
  • frequency (required ): Number of coupon payments per year.
  • base (optional ): 0 = 360 days, 1 = actual, 2 = actual / 360, 3 = actual / 365

Examples

COUPON.NUM (“01/25/2010”, “11/25/2010”, 2, 1) = 2

Leave a Comment